Data Analysis
with Advanced Excel
Bestseller
Language: Urdu / Hindi
Language: Urdu / Hindi
This course is tailored for accountants and auditors to master
advancedExcel skills. It covers essential topics from basic to
advanced functions, data analysis, reconciliation, aging reports,
goal seek analysis, dashboard reporting, and power query.
Participants will gain the expertise to analyze large datasets,
automate tasks, and create visually compelling reports.
This Course Includes:
- 15+ hours on-demand video
- 15 Lectures
- 1 Year access time
- Certificate of completion
- 24/7 WhatsApp Support
This Course Includes:
- 15+ hours on-demand video
- 15 Lectures
- 1 Year access time
- Certificate of completion
- 24/7 WhatsApp Support
Course Content
Module 1: Basic to Advance Functions
• Introduction to Excel functions
• Advanced Functions (IF, SUMIF, VLOOKUP, HLOOKUP, INDEX-MATCH)
• Logical Functions (AND, OR, NOT) including Date Function
• Nested Functions and Formulas
Module 2: Data Modeling and Relationships
• Filtering, sorting and formatting data
• Conditional Formatting
• Pivot Tables and Charts
• Grouping and Subtotaling Data
• Data Validation and Error Checking
• Advanced Excel Tables
Module 3: Dashboard Reporting
• Creating Dashboards in Excel
• Interactive Dashboards
• Pivot Table Dashboards
• One click Demonstration
Module 4: Power Query
• Introduction to Power Query and Its Capabilities
• Understanding Data Import Techniques and Transformation Processes
• Effective Strategies for Merging Data from Multiple Sources
• How to Create Tables and Charts Using Data Queries
Course Content
Module 1: Basic to Advance Functions
• Introduction to Excel functions
• Advanced Functions (IF, SUMIF, VLOOKUP, HLOOKUP, INDEX-MATCH)
• Logical Functions (AND, OR, NOT) including Date Function
• Nested Functions and Formulas
Module 2: Data Modeling and Relationships
• Filtering, sorting and formatting data
• Conditional Formatting
• Pivot Tables and Charts
• Grouping and Subtotaling Data
• Data Validation and Error Checking
• Advanced Excel Tables
Module 3: Dashboard Reporting
• Creating Dashboards in Excel
• Interactive Dashboards
• Pivot Table Dashboards
• One click Demonstration
Module 4: Power Query
• Introduction to Power Query and Its Capabilities
• Understanding Data Import Techniques and Transformation Processes
• Effective Strategies for Merging Data from Multiple Sources
• How to Create Tables and Charts Using Data Queries