Excel Percentage Hacks You Wish You Learned Sooner (+Cheat Sheet)
Microsoft Excel Tips and Tricks Excel Percentage Hacks You Wish You Learned Sooner (+Cheat Sheet) Credit MyOnlineTrainingHub
Read more
Tag: Excel
How to use Dynamic Arrays in Excel and other Advanced Formulas
Microsoft Excel Tips and Tricks How to use Dynamic Arrays in Excel and other Advanced Formulas Credit Simon Sez IT
Read more
Avoid Reporting Embarrassment with 11 Excel Data Cleaning Fixes
Microsoft Excel Tips and Tricks Avoid Reporting Embarrassment with 11 Excel Data Cleaning Fixes Credit MyOnlineTrainingHub
Read more
Fix Cross-Tabular Data in Excel with Power Query
Microsoft Excel Tips and Tricks Have you ever encountered messy Excel data that looks correct until you dig deeper? In[…]
Read more
Get “ALL” Option in Excel Data Validation with this Crazy Trick
Microsoft Excel Tips and Tricks Recently, I had to show “ALL” as an option in my data validation dropdowns. I[…]
Read more