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!
In this Excel video, I will teach how to take advantage of Excel tables. There are plenty of tips and tricks to manage your data tables.
This video will teach you some tips and tricks on how to use Excel PivotTables for bookkeepers. It will show you things that can trip you up in a PivotTable and how to effectively report on your expenses.
In this video, I share a favorite trick of mine to format an entire transaction's row in Excel with a fill color based on a budget item.