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
Category: Excel
10 Excel Functions You NEED to KNOW as Engineers!
Microsoft Excel Tips and Tricks If you work as an engineer, make sure you learn these Excel functions and Excel[…]
Read more
Combination Stacked & Clustered Column Chart in Excel – 2 Examples
Microsoft Excel Tips and Tricks Combination Stacked & Clustered Column Chart in Excel – 2 Examples Credit Chester Tugwell
Read more
How to Perform a Z-Score Calculation in Excel
Microsoft Excel Tips and Tricks How to Perform a Z-Score Calculation in Excel Credit Chester Tugwell
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