Industrial Advanced
Excel & MIS Reporting
- Training on Office 365
- Index Match Function
- Sum Product Function
- Indirect Function
- Advanced Financial Function
- Dynamic Lookup
- Power Map
- Power View
- Dashboard
- Power Query
- Merge Query
- Append Query
- Functions Recording with Macros
- Advanced Statistical Functions
- Advanced Conditional Formatting
- Advanced Data Validation
- Excel Apps (Add on Tools)
- All Type Chart
- Advanced Pivot Table
- Pivot & Unpivot of Data
- Advanced Additional Functions
- Advanced Lookup Functions
- Export Data from Tally or Accounting Software & Generate MIS
- 150+ Industrial Practical Examples
- 5 Business Analytics Project