Dynamic GETPIVOTDATA Formulas for Power Pivot – the PROPER way!
Microsoft Excel Tips and Tricks The GETPIVOTDATA function is the secret weapon of the advanced PivotTable user. Unfortunately, most people[…]
Read more
Tag: Excel
How to Hack Worksheet Passwords in Microsoft Excel
Microsoft Excel Tips and Tricks In this short video, I want to show you how to unlock protected excel sheets[…]
Read more
Results for the Excel Challenge: Equal Playing Time
Microsoft Excel Tips and Tricks In this video I share some results from our Excel Equal Playing Time Challenge. We[…]
Read more
Power Query Keyboard Shortcuts Uncover HIDDEN Features!
Microsoft Excel Tips and Tricks Power Query keyboard shortcuts not only speed up your work, but they uncover some functionality[…]
Read more
3 Ways to Password Protect your Microsoft Excel Files
Microsoft Excel Tips and Tricks In this video, I will show you 3 ways to secure your Microsoft Excel files[…]
Read more