Power Query Split Columns Example
The Power Query feature has a very cool feature called Split Columns. In this example I'll show you how to split your data into columns and rows based off the comma delimiter.
Excel Quick Start Guide
If you are new to Excel and are struggling to understand the basics let me share with you a downloadable guide that will help. Access your Excel Quick Start Guide here.
How to use the Xlookup in Excel
The new Xlookup formula is a brand new formula that can replace the use of Vlookup. It searches down or across to find the value you want and then returns a value within the return range. Take a look at my video to see it in action.
How to remove duplicates in Google Sheets and Excel
There's a new feature release from Google Sheets and that includes remove duplicates. Here's my video that shows you the differences between the two programs. Which spreadsheet tool do you prefer?