How-tos - Sharing Tips and Tutorials for Microsoft Office
Here we share the tips and tricks we know about Microsoft Office. It's sharing all those things that we learn and experience along the way of developing Office add-ins and using Microsoft Office.
- VLOOKUP function with some basic and advanced examples in Excel
- Compare two columns for matches and differences in Excel
- Excel drop down list: create, edit, remove and more advanced operations
- Find, highlight, filter, count, and delete duplicates in Excel
- Use formula or defined function to auto fill text based on the cell filled color in Excel
- Quickly create a positive negative bar chart in Excel
- How to split the total payment across months in Excel?
- Generate random number with the given specific length in Excel
- Compare two columns and add missing values in Excel
- How to merge two or more tables into one based on key columns?