Learn how to create Multiple dependent dropdown lists using MATCH,...
Create a Profit & Loss Statement with PivotTable
Learn to take your raw data of income and expenses and create a “Profit & Loss Statement” using PivotTables. We show you from scratch how to create TableRanges, add necessary formulas and then create the Statement using PivotTables. All user levels should be able to follow our “step by step” tutorial however it will be easier to those that already have some basic Excel knowledge.
To further assist with the tutorial, a practice workbook is also provided for all to follow along as we at ESS believe that you learn by doing.
Content covered in tutorial
- Create and name TableRanges
- Add dropdowns and dependent dropdowns
- Add columns to TableRange
- Cell formatting (Percentage and Currency symbol)
- IF, UNIQUE and EOMONTH formula
- Basics to PivotTable creation
- Add calculated item to PivotTable
- Template amendments to PivotTable
- Add Date Slicer to PivotTable
Related Tutorials
Learn how to use the INDIRECT formula.
Learn how to use cell referencing in excel.
Learn how to create an IFS with AND formula.