Month: September 2018
Cycle Font Colors in Excel
Contextures shows you a secret button in Excel that can cycle font colors.
4 Ways to Remove Unwanted Space Characters in Excel
How to Excel shows you how to get rid of those pesky extra spaces that mess up your lookups!
Evaluation Contexts in DAX
ExceleratorBI shares a presentation on Evaluation Contexts in DAX
Why Doesn’t This Formula Work?
Reddit to the rescue again! u/rnelsonee helps troubleshot a formula.
Excel IF-OR Tutorial
Able Bits shares a great tutorial on using the IF-OR functions in Excel.
How to use the CHOOSE function in Excel
ExcelJet shows you how to use the little known CHOOSE function in Excel.
Excel Plus AI? 4 New Features Announced
Microsoft shares some news about great new features coming to Excel!
Assign a Macro to a Button in Excel
Spreadsheets Made Easy shows you how to assign a Macro to a Button in Excel.
SORT Formula in Excel
Mr Excel shows you the new SORT formula coming to Excel!
Excel Guru Power Query Recipes
Excel Guru releases some new Power Query recipes to help you master your data!
Return Multiple Match Results using the AGGREGATE Function.
Leila Gharani shows you how to return multiple results with an Index lookup, by using the AGGREGATE function.
5 Little-Known Excel Tips to Help You Stand Out
Brad Edgar gives you 5 great tips that will really make your Excel skills stand out!