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.
This video tutorial will teach you how to use the Sumifs and Vlookup formulas to create sales commissions report after exporting QBO to Excel.
The Profit and Loss report is a financial document that shows income and expenses subtotals for a certain period of time. It is a very important document that is needed to report income for a tax period year. The report is also known as the Income Statement. Step 1: Click Reports on the left navigation tab and the select Profit and Loss report from the Business Overview category. Step 2: Change the date for the period you want to report Custom Range All Dates Today This Week This Week to-date This Month This Month to-date This Quarter This Quarter to-date This Year This Year to-date This Year to-last-month Yesterday Recent Last Week Last Week to-date [...]
Do Excel formulas with dollar signs trip you up? If so, this video was made for you. I share how to understand and use the absolute reference and when it is time to switch to a mixed reference. I'll use the countif function to determine if someone with scores of 5 star rating has 3 or more frequencies. The video will make a lot more sense. Enjoy!