Basic to Advance Excel
This course covers basis to advance all topics used in excel.
- Basic Overview
- Formula and Functions
- Text Logical, Mathematical, Fi
- Data Tools
- Data Validation
- Data Visualization
- Pivot Table
- Dashboard
- What if Analysis
- Solver
- Form Controls
- Connect data from various source
- Merge and Append Queries
- Joining
- Create Relationship
- Report building
Introduction to Power Query, Power Pivot, Power Map + Power BI
In this course we introduced Business Intelligence analytics tools added in excel 2010 through which user can Extract data from various source and transform it to interactive report.
- Current Excel Capabilities
- Need Business Intelligence Tool
- Data Connection
- Data Transformation
- Appending Queries
- Add Column By Example
- Queries (Merge and Append)
- Table Joining
- Data Modelling & Relationship
- Reporting through Pivot Table
- Power Map for Visual Dashboard over Globe
- Visual Analytics
- Reporting through Power BI
- Power BI Charts
- Filter and Controls
- Publish Report