I'm finding the Xlookup formula keeps on becoming a superpower of all lookups. In this tutorial I'll show you how to use an Xlookup twice to lookup multiple columns.
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.
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.
I'm excited to show you the first views of a new feature ofcreating Slicers in Google Sheets. Compare this to a previous post I did on Excel slicers. Slicers allow you to filter you data in easy to manage buttons.
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?
This video will teach you how to setup up tracking expenses in Quickbooks Online by departments. To turn on this feature you will need a QBO Plus or Advanced subscription. Gear Icon> Account and Settings > Advanced > Turn on location tracking and then select Departments label.