- Introduction to MS Excel
- Working with Tables
- Understanding Cell References
- Basics Functions of Excel
- Sorting Data
- Filtering Data
- Data Consolidation / Basics of Formula/Functions
- If Functions and text Functions
- Working with Dates, CountIfs, and SumIfs
- Module 10: Lookup and Information Functions
- Using Named Ranges
- Data Validation
- Dynamic Array Formula
- Using Conditional Formatting
- Macros (Only Recording, Non VBA)
- Summarizing Data with Pivot Tables
- Working with Slicers
- Power Pivot / Power Query
- Charts
- Excel Dashboard
- Protecting and Security
- Mail Merge
MS-Office
Tally ERP9 with GST
Spoken English