Advance Excel Day 8 - Mathematical and Database Functions and Pivot
Topics Covered for Today
Mathematical Functions
COUNTA
SUMIF
AVERAGEIF
Database Functions
DSUM
DGET
DCOUNT
DAVERAGE
Getting Started with Pivot Table
How to create reports
Selecting data
Shelf
i. Row
ii. Column
iii. Values
iv. Filter
Change Data Source
Refresh Pivot
Update Data
Table and Name Manager for Automation
Adding Drill Down Reports in Rows and Columns