Tips and Tricks
ExcelJet shows you how to use the little known CHOOSE function in Excel.
Spreadsheets Made Easy shows you how to assign a Macro to a Button in Excel.
Leila Gharani shows you how to return multiple results with an Index lookup, by using the AGGREGATE function.
Brad Edgar gives you 5 great tips that will really make your Excel skills stand out!
Ever wonder if you can conditionally format worksheet tabs? Excel Unplugged shows you how.
Excel Guru shares the results of a Power Query challenge to find the top values including ties.
Chandoo issues a challenge: Figure out how many employees used all of their sick leave!
The Smallman shares some VBA code to select and print different worksheets in Excel.