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 add Slicers in Google Sheets
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.
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?
Track expenses by department in QuickBooks Online
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.