Excel Tutorials
A collection of written and video based Excel tutorials (Power BI coming soon)Use OFFSET to Retrieve Rows from an Excel List
Excel’s OFFSET function is used to retrieve values from a cell or range
Replace Part of a String in Excel
Three methods to replace part of a text string including SUBSTITUTE and REPLACE
The ULTIMATE Guide to Lookups in Excel: Live
On-demand recording of a live 60 minute training session covering Excel’s Lookup functions
The Drop Function in Excel
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 in Excel
The TAKE function displays the contents of the first or last X rows or columns of a range
Hide a Series in an Excel Chart Data Table
How to hide one or more rows in the Data Table that appears below a Chart
Power Query on Excel for Mac: Live Training
On-demand recording of a live 90 minute training session covering Power Query on a Mac
How to Crack Password Protection in Excel
Disable protection when you don’t know the password – without using 3rd party apps
Power Query FINALLY Comes to The Mac
The Power Query Editor is now available to Beta Channel users in Excel for Mac