Excel TutorialsA collection of written and video based Excel tutorials (Power BI coming soon)
What is GETPIVOTDATA? When should you use and avoid it? What are the gotchas?
Excel’s OFFSET function is used to retrieve values from a cell or range
Three methods to replace part of a text string including SUBSTITUTE and REPLACE
On-demand recording of a live 60 minute training session covering Excel’s Lookup functions
The DROP function displays the contents of a specified range but excludes the first or last X number of rows or columns.
The TAKE function displays the contents of the first or last X rows or columns of a range
How to hide one or more rows in the Data Table that appears below a Chart
On-demand recording of a live 90 minute training session covering Power Query on a Mac
Disable protection when you don’t know the password – without using 3rd party apps