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.
- How to VLOOKUP then multiply in Excel tables?
- How to use VLOOKUP to create a unique list from table in Excel?
- How to separate email addresses to username and domain in Excel?
- How to reverse search last word in a string with formula in Excel?
- How to lookup a value in 3D table in Excel?
- How to join data from two cells(columns) into one cell in Excel?
- How to import and connect a website in Excel?
- How to expand all collapsed columns or rows in Excel?
- How to concatenate rows into one cell based on group in Excel?
- How to collect data from multiple sheets to a master sheet in Excel?