In this video you will learn how to use IF statement and pivot table together and make it automatic and also how to use maps in pivot table.
#PivotTable #msExcel #IFstatement
00:00 - Introduction
00:45 - Create Pivot Table
04:15 - How to change the number format to Millions
06:10 - How to sort pivot tables
06:30 - How to use IF Statement
12:20 - % difference from previous year or month
13:50 - Maps
Sample file to practice: https://github.com/12aashish/Onlysolu...