Advanced Excel Course | Excel Certification

What will I learn?

Master the Excel essentials of the real world and accelerate your career.

Quick Excel Brush-up (Gap Filing)

This section aims to bring all the candidates to the same level before moving to the most intensive, advanced and complex topics. It aims to equip you with a strong foundational knowledge of Excel to organize, analyze and work with data.

Why do I need a quick Excel brush-up?

60+ Advanced Excel Formulas

This section will cover 60+ essential, productive time-saving functions and formula-building techniques through suitable examples, required to solve a variety of data analysis problems. You'll also learn how to debug a formula, audit them, and simplify the complex functions.

Overview of 60+ Formulas

Pivots, Charts & Dashboards

This section is designed for Excel users to crunch numbers substantially, create reports dynamically using PivotTable, and, present professional information through Dashboards in Microsoft Excel that are beautiful, precise, and clear.

Pivots, Charts & Dashboards

Creating Pivot Table

Changing the Pivot Table layout
Formatting row , column and value fields
Grouping items – Number Grouping and Date Grouping
Inserting calculated fields
Display and hide data in fields
Layout reports directly on worksheet
Manual, Single & Multi sorting options
Manual, Single & Multi Filtering options
Multiple ways of presenting data in Pivot Table
Using advanced value field setting
Display Amount in Percentage
Pivot Table – Design Tab

Pivot table options Using slizers Charts & Pivot Charts

Bar Charts / Pie Charts / Line Charts
Dual Axis Charts
Dynamic Charting
Other Advanced Charting Techniques

Excel Dashboard

Bar Charts / Pie Charts / Line Charts
Planning a Dashboard
Adding Tables to Dashboard
Adding Charts to Dashboard
Adding Dynamic Contents to Dashboard

MIS Reporting & Dashboarding

This section will help you plug in all the Advanced Excel concepts learned in previous sections to work on various MIS reports such as summary reports, trend reports, exception reports, financial reports, inventory reports, sales reports, budget reports, etc.

Different types of MIS Reports

Cleansing & Transforming Data

This is the most important step for all the reporting requirements. You'll learn to prepare raw data for analysis by removing bad data, organizing the raw data, and filling in the null values. Data cleaning in data mining has utmost value when working with big data.

Common types of data errors

Data Transformation with Power Query

Whether you're consolidating multiple data sources, handling diverse data formats, or crafting dynamic queries, this versatile tool ensures efficiency and precision in your data preparation, spanning from data cleansing to advanced transformations.

Why should I learn Power query

Data Analysis with Power Pivot

Explore the most powerful tool to build data models, forecast estimates, perform what-if-analysis scenario etc. If you are yet to have the Power BI license, you would still be able to create powerful & blended reports and share it internally using Power Pivot.

Why Should I learn power Pivot

Quick Excel Brush-up (Gap Filing)

Why do I need a quick Excel brush-up?

All the participants come from different domain with different levels of Excel expertise. Brush-up will help you to fill up the gaps and get everyone at the same level to proceed with intense sessions. This will also ensure a structured learning.

60+ Advanced Excel Formulas

Mathematical Functions

1. Sum

2. Sumif

3. Sumifs

4. Average

5. Averageif

6. Averageifs

7. Max

8. Min

9. Sumproduct

10. Count

11. CountA

12. Countblank

13. Subtotal

Lookup Functions

1. Vlookup

2. Dynamic Vlookup

3. Hlookup

4. Dynamic Hlookups

5. Match

6. Index

7. Indirect

8. Offset

Text Functions

1. Istext

2. Code

3. Char

4. Exact

5. Len

6. Trim

7. Upper

8. Lower

9. Proper

10. Left

11. Right

12. Mid

13. Substitue

14. Replace

15. Find

16. Search

Date & Time Functions

1. Date

2. Datevalue

3. Day

4. Days360

5. EDate

6. Emonth

7. Month

8. Today

9. Weekday

10. Year

11. Now

12. Hour

13. Minute

14. Second

15. Time

16. Timevalue

Rounding Numbers

1. Ceiling

2. Even

3. Floor

4. INT

5. Mround

6. Odd

7. Round

8. Roundup

9. Rounddown

10. Trunc

Error Handling Functions

1. Isna

2. Iserr

3. Iserror

Pivots, Charts & Dashboards

Creating Pivot Table

Changing the Pivot Table layout
Formatting row , column and value fields
Grouping items – Number Grouping and Date Grouping
Inserting calculated fields
Display and hide data in fields
Layout reports directly on worksheet
Manual, Single & Multi sorting options
Manual, Single & Multi Filtering options
Multiple ways of presenting data in Pivot Table
Using advanced value field setting
Display Amount in Percentage
Pivot Table – Design Tab

Pivot table options Using slizers Charts & Pivot Charts

Bar Charts / Pie Charts / Line Charts
Dual Axis Charts
Dynamic Charting
Other Advanced Charting Techniques

Excel Dashboard

Bar Charts / Pie Charts / Line Charts
Planning a Dashboard
Adding Tables to Dashboard
Adding Charts to Dashboard
Adding Dynamic Contents to Dashboard

MIS Reporting & Dashboarding

Getting started with Power BI is simple. Then, once you want to leverage its full potential, you need a different set of skills. Learn how to develop these skills, unlock more insights through better data analysis and visualization with this section.

Different types of MIS Reports

Different types of MIS reports aggregate different data points and present them in a format that provides clear insights and conclusions. The various departments in an organization present MIS report which outline their department’s specific functions. There can be different types of MIS reports based on which data is being analyzed and what it is being used for. We’ve tried to summarize the most 15 common types of MIS reports which you will find in an organization.

The Summary Reports
Funds Flow Statement
The Trend Reports
The Exception Reports
On-demand Reports
Financial Reports
Inventory Reports
Sales Reports
Budget Reports
Production Reports
Cash-flow statements
Budgeted & Actual Profit Reports
Predictive Reports
Cost Reports
Orders-in-hand Reports

Cleansing & Transforming Data

Common types of data errors

Data cleansing, also referred to as data cleaning or data scrubbing, is the process of fixing incorrect, incomplete, duplicate or otherwise erroneous data in a data set. It involves identifying data errors and then changing, updating or removing data to correct them.

Data cleansing is a key part of the overall data management process and one of the core components of data preparation work that readies data sets for use in business intelligence (BI) and data science applications.

It's typically done by data quality analysts and engineers or other data management professionals. But data scientists, BI analysts and business users may also clean data or take part in the data cleansing process for their own applications.

Common data errors

Typos and invalid or missing data
Inconsistent data
Duplicate data
Irrelevant data

Data Transformation with Power Query

Why should I learn Power query

What is Power Query?

It’s a Powerful data analysis and data modeling tool available in Excel as part of Office 365 Subscription.
A way to handle massive volumes of data in Excel
A way to add any formulas to pivot, and it adjusts!
A way to turn workbooks into selfmaintaining web applications
A much more agile and cost effective approach to Business Intelligence
Something that turns workbooks into industrial strength Apps

Data Analysis with Power Pivot

Why Should I learn power Pivot

What is Power pivot?

The easiest way to create a data model in Power BI and Power Pivot is to gather the data "as is" from a data source, define relationships, and then start designing reports. But this approach raises several issues when you have too many tables, or different levels of granularity.

Benefits of a proper data model with power pivot includes:

Faster queries.
Simpler DAX code
Easier maintenance

Both Online & Classroom is available.^*

All our classes are live, hands-on and with real-trainers.

No recorded sessions.

Course Content Overview

A snapshot of what you'll be learning in 2 weeks.

Core Fundamentals Advanced Formulas & Functions Pivots, Charts & Dashboards Miscellaneous Topics Power Query Power Pivot Modeling & MIS Reporting System Requirements

Objective: The term "basic" is subjective based on levels of knowledge, experience, exposure, etc. Basic for one individual doesn't have to be basic for another. Nearly all participants in this training are self-taught and have some Excel skills as well as some gaps.

The objective of this module is to fill gaps, bring everyone to the same level and empower them with comfort and confidence to learn Excel as a reporting solution and not as a computer tool.

Duration – 2 Hours (Rapid Session)

CORE FUNDAMENTALS

Understanding Excel Environment
Entering, Editing and Deleting Text, Numbers, Dates
How Excel Understand your information including Text, Numbers and Date values.
Fundamental Formatting Techniques & Best Practices
Understanding Cell Formats including Advanced Custom Formats
Copying and Clearing Formats
Working with Styles
Understanding Simple Conditional Formatting
Moving and Copying data
Quick Navigation Techniques
Inserting, Deleting and Hiding Rows & Columns
Inserting, Deleting, Moving and Copying Sheets
Working with multiple Excel Worksheets & Workbooks
Working with View Tab including freeze panes, split, new workbook, etc
Quick Data Entry Techniques including Auto Fills
Understanding & Working with Formulas
Mastering Referencing Techniques including Relative, Absolute & Mixed Reference
Working with fundamental functions including sum, count, average, max, min, etc
Fundamental Keyboard Shortcuts

Objective: Master 60+ MS Excel formulas to dramatically simplify the work you do in Excel. By the end of the section, you'll be writing robust, elegant formulas from scratch.

Duration – 5 Hours

MATHEMATICAL FUNCTIONS

SumIf, SumIfs
CountIf, CountIfs
AverageIf, AverageIfs
SumProduct, Subtotal

LOOKUP FUNCTIONS

Vlookup / HLookup
Match
Dynamic Two Way Lookup
Creating Smooth User Interface Using Lookup
Offset
Index
Dynamic Worksheet linking using Indirect

LOGICAL FUNCTIONS

Nested If ( And Conditions , Or Conditions )
Alternative Solutions for Complex IF Conditions to make work simple
And, Or, Not

TEXT FUNCTIONS

Upper, Lower, Proper
Left, Mid, Right
Trim, Len
Concatenate
Find, Substitute

DATE AND TIME FUNCTIONS

Today, Now
Day, Month, Year
Date, DateDif, DateAdd
EOMonth, Weekday

ROUNDING FUNCTIONS

Round
RoundUp
RoundDown
MRound

ERROR HANDLING FUNCTIONS

isNa
isErr
isError

Objective: This module will help you set up a professional dashbaord - learn how to visualize data through graphs and charts, create data models, and add interactivity.

Duration – 2 Hours

PIVOT TABLES

Creating Simple Pivot Tables
Basic and Advanced Value Field Setting
Sorting based on Labels and Values
Filtering based on Labels and Values
Grouping based on numbers and Dates
Drill-Down of Data
GetPivotData Function
Calculated Field & Calculated Items

CHARTS & PIVOT CHARTS

Bar Charts / Pie Charts / Line Charts
Dual Axis Charts
Dynamic Charting
Other Advanced Charting Techniques

EXCEL DASHBOARD

Bar Charts / Pie Charts / Line Charts
Planning a Dashboard
Adding Tables to Dashboard
Adding Charts to Dashboard
Adding Dynamic Contents to Dashboard

Objective: This section is all about working with data - and making it easy to work with. It will walk you through the different features of Excel to get your data prepared for analysis.

Duration – 2 Hours

ADVANCED PASTE SPECIAL TECHNIQUES

Paste Formulas
Paste Formats
Paste Validations
Paste Conditional Formats
Add / Subtract / Multiply / Divide
Merging Data using Skip Blanks
Transpose Tables

SORTING

Sorting on Multiple Fields
Dynamic Sorting of Fields
Bring Back to Ground Zero after Multiple Sorts

FILTERING

Filtering on Text, Numbers & Date
Filtering on Colors
Copy Paste while filter is on
Advanced Filters
Custom AutoFilter

PRINTING WORKBOOKS

Working with Themes
Setting Up Print Area
Printing Selection
Branding with Backgrounds
Adding Print Titles
Fitting the print on to a specific defined size
Customizing Headers & Footers

IMPORT & EXPORT OF INFORMATION

Using Text To Columns

WHAT IF ANALYSIS

Goal Seek
Scenario Analysis
Data Tables

GROUPING & SUBTOTALS DATA VALIDATION

Number, Date & Time Validation
Text Validation
List Validation
Handling Invalid Inputs
Dynamic Dropdown List Creation using Data Validation

PROTECTING EXCEL

File Level Protection
Workbook Level Protection
Sheet & Cell Level Protection
Setting Permissions for Specific Tasks
Track changes

CONSOLIDATION

Consolidating data with identical layouts
Consolidating data with different layouts
Consolidating data with different Sheets

ADVANCED CONDITIONAL FORMATTING

Working with advanced conditional formatting rules incorporating formulas

Objective: It is an activity-based section with the goal of collaborating on all the topics you have learned so far to build dynamic MIS Reports. You'll learn to model different scenarios based on input, and assumptions.

Duration – 7.5 Hours

MODELING & MIS REPORTING

Creating advanced Excel Models
Creating Simple Professionally Formatted Data Models to Simulate Simple Business Scenarios
Importing, Cleansing and Normalization Data
Aging Reports and Other Complex Date & Time Calculations
Reconciling Complex Datasets
Develop Advanced Data Models to Simulate Complex Business Scenarios for What IF Analysis
Reporting Using Relational Data
Consolidation and Reporting of Datasets of Different Structures

System Requirements

Computer Requirements

Operating System: Windows operating system
RAM: Minimum 4GB (8GB or higher recommended)
Processor: Dual-core processor or higher
Internet Connection: Reliable internet connection for online sessions and downloads

Software Requirements

Microsoft Excel: Version 2010 or later should be installed on your computer.
Secondary Monitor (optional, but recommended)

Having a secondary monitor, will greatly enhance your learning experience by allowing you to keep up with the trainer's pace and work with multiple Excel workbooks simultaneously.
Webcam

A functional webcam is required for active participation in online sessions. Please ensure that your webcam is working properly and positioned appropriately for clear visibility during collaborative sessions and discussions.

Introduction to Microsoft Power Query
for Excel Import data from external data sources Import with Standard Connectors

Connect to a Text or CSV file
Connect to a Web page
Connect to an Excel Table/Range

Import Data from a File

Connect to an Excel workbook
Connect to a Text or CSV file
Connect to an XML file
Connect to a JSON file

Import Data from a Database

Connect to a SQL Server database
Connect to an Access database
Connect to a MySQL database

Import Data from Online Services

Connect to Salesforce Objects
Connect to a Sharepoint Online List
Connect to Facebook

Import Data from Other Sources

Connect to an Excel Table or Range
Connect to a Web page

Shape data from Multiple Data Sources

Shape or transform a query
Refresh a query
Combine data from multiple data sources
Filter a table
Sort a table
Group rows in a table
Expand a column containing an associated table
Aggregate data from a column
Insert a custom column into a table
Combine multiple queries
Merge columns
Remove columns
Remove rows with errors
Promote a row to column headers
Split a column of text
Insert a query to the worksheet

Introduction to PowerPivot

Limitation of Excel Functions
Limitation of Excel PivotTable
Why PowerPivot?
PowerPivot Features - Overview

PowerPivot Environment

Opening PowerPivot Environment
Understanding External Data Section
Understanding Formatting
PowerPivot Views
Understanding Measures

Taking Data into PowerPivot

From Excel
From MS Access
From Ms-SQL
From Custom Query
From Text Files
From Other Sources

Calculated Columns

Calculated Columns
Entering Formulas
Using AutoComplete Feature
Renaming Columns
Understanding Tables

Creating Measures

Creating Simple DAX Measures
Explicit Measure Vs Implicit Measure
Referencing Measures in Other Measures
Formatting Measures

Manage Data Relationships Working with Multiple Tables Disconnected Tables Creating custom calendars using
ADVANCED FILTER() Advanced calculated columns

Understanding Relationship Concept
JOIN TABLES
LEFT JOIN TABLES
RIGHT JOIN TABLES
Using UNION QUERIES

Data visualization Using

Power View
Charts, Score Cards and Dashboards
Slicers
Map Visualizations
Data Binding and Formatting

Creating Advanced Dashboards with
PowerPivot

Course Fee

$399

What is included?

25 hours of Instructor-led training.

Real-time Excel Assignments

8 MIS Reporting Projects

6 Power Query Projects

Data Transformation and MIS Reporting Expert Certificate

View Certificate

READY TO BE CERTIFIED AS A

Data Transformation and Reporting Expert?

Course Content Overview

A snapshot of what you'll be learning in 2 weeks.

What's included in your training?

25 hours of Instructor-led training.

Real-time Excel Assignments

8 MIS Reporting Projects

6 Power Query Projects

Data Transformation and MIS Reporting Expert Certificate

View Certificate

Course details

Core Fundamentals

Duration – 2 Hours (Rapid Session)

CORE FUNDAMENTALS

Understanding Excel Environment
Entering, Editing and Deleting Text, Numbers, Dates
How Excel Understand your information including Text, Numbers and Date values.
Fundamental Formatting Techniques & Best Practices
Understanding Cell Formats including Advanced Custom Formats
Copying and Clearing Formats
Working with Styles
Understanding Simple Conditional Formatting
Moving and Copying data
Quick Navigation Techniques
Inserting, Deleting and Hiding Rows & Columns
Inserting, Deleting, Moving and Copying Sheets
Working with multiple Excel Worksheets & Workbooks
Working with View Tab including freeze panes, split, new workbook, etc
Quick Data Entry Techniques including Auto Fills
Understanding & Working with Formulas
Mastering Referencing Techniques including Relative, Absolute & Mixed Reference
Working with fundamental functions including sum, count, average, max, min, etc
Fundamental Keyboard Shortcuts

Advanced Formulas & Functions

Objective: Master 60+ MS Excel formulas to dramatically simplify the work you do in Excel. By the end of the section, you'll be writing robust, elegant formulas from scratch.

Duration – 5 Hours

MATHEMATICAL FUNCTIONS

SumIf, SumIfs
CountIf, CountIfs
AverageIf, AverageIfs
SumProduct, Subtotal

LOOKUP FUNCTIONS

Vlookup / HLookup
Match
Dynamic Two Way Lookup
Creating Smooth User Interface Using Lookup
Offset
Index
Dynamic Worksheet linking using Indirect

LOGICAL FUNCTIONS

Nested If ( And Conditions , Or Conditions )
Alternative Solutions for Complex IF Conditions to make work simple
And, Or, Not

TEXT FUNCTIONS

Upper, Lower, Proper
Left, Mid, Right
Trim, Len
Concatenate
Find, Substitute

DATE AND TIME FUNCTIONS

Today, Now
Day, Month, Year
Date, DateDif, DateAdd
EOMonth, Weekday

ROUNDING FUNCTIONS

Round
RoundUp
RoundDown
MRound

ERROR HANDLING FUNCTIONS

isNa
isErr
isError

Pivots, Charts & Dashboards

Objective: This module will help you set up a professional dashbaord - learn how to visualize data through graphs and charts, create data models, and add interactivity.

Duration – 2 Hours

PIVOT TABLES

Creating Simple Pivot Tables
Basic and Advanced Value Field Setting
Sorting based on Labels and Values
Filtering based on Labels and Values
Grouping based on numbers and Dates
Drill-Down of Data
GetPivotData Function
Calculated Field & Calculated Items

CHARTS & PIVOT CHARTS

Bar Charts / Pie Charts / Line Charts
Dual Axis Charts
Dynamic Charting
Other Advanced Charting Techniques

EXCEL DASHBOARD

Bar Charts / Pie Charts / Line Charts
Planning a Dashboard
Adding Tables to Dashboard
Adding Charts to Dashboard
Adding Dynamic Contents to Dashboard

Miscellaneous Topics

Objective: This section is all about working with data - and making it easy to work with. It will walk you through the different features of Excel to get your data prepared for analysis.

Duration – 2 Hours

ADVANCED PASTE SPECIAL TECHNIQUES

Paste Formulas
Paste Formats
Paste Validations
Paste Conditional Formats
Add / Subtract / Multiply / Divide
Merging Data using Skip Blanks
Transpose Tables

SORTING

Sorting on Multiple Fields
Dynamic Sorting of Fields
Bring Back to Ground Zero after Multiple Sorts

FILTERING

Filtering on Text, Numbers & Date
Filtering on Colors
Copy Paste while filter is on
Advanced Filters
Custom AutoFilter

PRINTING WORKBOOKS

Working with Themes
Setting Up Print Area
Printing Selection
Branding with Backgrounds
Adding Print Titles
Fitting the print on to a specific defined size
Customizing Headers & Footers

IMPORT & EXPORT OF INFORMATION

Using Text To Columns

WHAT IF ANALYSIS

Goal Seek
Scenario Analysis
Data Tables

GROUPING & SUBTOTALS DATA VALIDATION

Number, Date & Time Validation
Text Validation
List Validation
Handling Invalid Inputs
Dynamic Dropdown List Creation using Data Validation

PROTECTING EXCEL

File Level Protection
Workbook Level Protection
Sheet & Cell Level Protection
Setting Permissions for Specific Tasks
Track changes

CONSOLIDATION

Consolidating data with identical layouts
Consolidating data with different layouts
Consolidating data with different Sheets

ADVANCED CONDITIONAL FORMATTING

Working with advanced conditional formatting rules incorporating formulas

Power Query

Introduction to PowerPivot

Limitation of Excel Functions
Limitation of Excel PivotTable
Why PowerPivot?
PowerPivot Features - Overview

PowerPivot Environment

Opening PowerPivot Environment
Understanding External Data Section
Understanding Formatting
PowerPivot Views
Understanding Measures

Taking Data into PowerPivot

From Excel
From MS Access
From Ms-SQL
From Custom Query
From Text Files
From Other Sources

Calculated Columns

Calculated Columns
Entering Formulas
Using AutoComplete Feature
Renaming Columns
Understanding Tables

Creating Measures

Creating Simple DAX Measures
Explicit Measure Vs Implicit Measure
Referencing Measures in Other Measures
Formatting Measures

Manage Data Relationships Working with Multiple Tables Disconnected Tables Creating custom calendars using ADVANCED FILTER() Advanced calculated columns

Understanding Relationship Concept
JOIN TABLES
LEFT JOIN TABLES
RIGHT JOIN TABLES
Using UNION QUERIES

Data visualization Using

Power View
Charts, Score Cards and Dashboards
Slicers
Map Visualizations
Data Binding and Formatting

Creating Advanced Dashboards with PowerPivot

Power Pivot

Introduction to Microsoft Power Query for Excel Import data from external data sources Import with Standard Connectors

Connect to a Text or CSV file
Connect to a Web page
Connect to an Excel Table/Range

Import Data from a File

Connect to an Excel workbook
Connect to a Text or CSV file
Connect to an XML file
Connect to a JSON file

Import Data from a Database

Connect to a SQL Server database
Connect to an Access database
Connect to a MySQL database

Import Data from Online Services

Connect to Salesforce Objects
Connect to a Sharepoint Online List
Connect to Facebook

Import Data from Other Sources

Connect to an Excel Table or Range
Connect to a Web page

Shape data from Multiple Data Sources

Shape or transform a query
Refresh a query
Combine data from multiple data sources
Filter a table
Sort a table
Group rows in a table
Expand a column containing an associated table
Aggregate data from a column
Insert a custom column into a table
Combine multiple queries
Merge columns
Remove columns
Remove rows with errors
Promote a row to column headers
Split a column of text
Insert a query to the worksheet

Modeling & MIS Reporting

Duration – 7.5 Hours

MODELING & MIS REPORTING

Creating advanced Excel Models
Creating Simple Professionally Formatted Data Models to Simulate Simple Business Scenarios
Importing, Cleansing and Normalization Data
Aging Reports and Other Complex Date & Time Calculations
Reconciling Complex Datasets
Develop Advanced Data Models to Simulate Complex Business Scenarios for What IF Analysis
Reporting Using Relational Data
Consolidation and Reporting of Datasets of Different Structures

Course Fee

$ 399

Certifications

Data Transformation and Reporting Expert

Eligibility: On clearing post-training assessment

Sample Certificate: View here

System Requirements

Computer Requirements

Operating System: Windows operating system
RAM: Minimum 4GB (8GB or higher recommended)
Processor: Dual-core processor or higher
Internet Connection: Reliable internet connection for online sessions and downloads

Software Requirements

Microsoft Excel: Version 2010 or later should be installed on your computer.
Secondary Monitor (optional, but recommended)

Having a secondary monitor, will greatly enhance your learning experience by allowing you to keep up with the trainer's pace and work with multiple Excel workbooks simultaneously.
Webcam

A functional webcam is required for active participation in online sessions. Please ensure that your webcam is working properly and positioned appropriately for clear visibility during collaborative sessions and discussions.

Learner stories around
the world

Total Reviews

4583

Overall growth till now

Average Rating

4.9

Average rating this year

Graph

2.0K

1.0K

500

200

Star Rating

Trainer's Expertise

Course Structure

Course Content

Assignments

Certification Process

Scott A. Reifsynder

Power BI Training

Chief Financial Officer

Nexterus

United States

This class was extremely helpful in my knowledge and growth in these database, analysis and reporting tools. I really enjoyed the hands-on approach and got lots of “goodies” out of all the classes. Your approach, repetitiveness and patience is much appreciated and sincerely helped me learn how to accomplish these important tasks. Doing these activities again and again embedded these processes into my routines while I began strategizing how to best utilize these tools in my company’s reporting and analyses. I’d be happy to consider additional classes that you offer on related, important topics to continue enhancing my skills. Thank you very much for your teaching and training methods. I am also very grateful that you provided the daily sample dashboards, instruction steps and how-to descriptions.

Wendy Flowers

Power BI Training

Financial and Business Analyst

First Light

United States

This Power BI course was an exceptional training experience. It was very fast paced -- necessary as it covered Power Pivots, Power Query, DAX, Power BI, and SQL. Sami ran the training smoothly, staying after to help individuals with questions. We also are able to schedule up to two 30-minute sessions after the end of the course for guidance on projects. Highly recommend!

Tim Palacios

Power BI Training

WFM Data Developer

World Connection

United States

This course was excellent. Sami had a systematic approach to the course curriculum which I feel is key to most if not all learning experiences. He was very knowledgeable and very quick with troubleshooting and helping support when we had any challenges with our work. I am definitely going to take more courses from Excelgoodies. If you are an IT professional or require Data Analytics for your job, this is a great course and I highly recommend it. I think my only critique is that I would have like to have more time devoted to the database side of the class, but that is just a personal preference.

Learner stories
around the world

Total Reviews

4583

Overall growth till now

Average Rating

4.9

Average rating this year

Scott A. Reifsynder

Power BI Training

Chief Financial Officer

Nexterus

United States

Wendy Flowers

Power BI Training

Financial and Business Analyst

First Light

United States

Tim Palacios

Power BI Training

WFM Data Developer

World Connection

United States

BY INDUSTRY

BY FUNCTION

Reserve My Seat

Data Transformation & Advanced MIS Reporting using MS-Excel and Power Query

Program at a Glance

Total Course Duration

25-hours, 10 Sessions

Live Online (Weekdays)

Training Schedule

View Schedule View Schedule

Course Fee

$399

Enroll Now

Certification

Data Transformation and Reporting Expert Using Excel and Power Query

Sample Certificate Sample Certificate

Supercharging Business Users with Next-Level of Excel Reporting.

Taught by Microsoft Certified Trainers.

What will I learn?

Quick Excel Brush-up (Gap Filing)

Why do I need a quick brush-up?

60+ Advanced Excel Formulas

60+ Advanced Excel Formulas

Pivots, Charts & Dashboards

Pivots, Charts & Dashboards

MIS Reporting & Dashboarding

Different Types of MIS Reports

Cleansing & Transforming Data

Why cleaning & transforming is so important?

Data Transformation with Power Query

Why should I learn Power Query?

Data Analysis with Power Pivot

Why should I learn Power Pivot?

Quick Excel Brush-up (Gap Filing)

60+ Advanced Excel Formulas

Pivots, Charts & Dashboards

MIS Reporting & Dashboarding

Cleansing & Transforming Data

Data Transformation with Power Query

Data Analysis with Power Pivot

Both Online & Classroom is available.*

All our classes are live, hands-on and with real-trainers.

No recorded sessions.

Course Content Overview

CORE FUNDAMENTALS

MATHEMATICAL FUNCTIONS

LOOKUP FUNCTIONS

LOGICAL FUNCTIONS

TEXT FUNCTIONS

DATE AND TIME FUNCTIONS

ROUNDING FUNCTIONS

ERROR HANDLING FUNCTIONS

PIVOT TABLES

CHARTS & PIVOT CHARTS

EXCEL DASHBOARD

ADVANCED PASTE SPECIAL TECHNIQUES

SORTING

FILTERING

PRINTING WORKBOOKS

IMPORT & EXPORT OF INFORMATION

WHAT IF ANALYSIS

GROUPING & SUBTOTALS DATA VALIDATION

PROTECTING EXCEL

CONSOLIDATION

ADVANCED CONDITIONAL FORMATTING

MODELING & MIS REPORTING

$399

What is included?

READY TO BE CERTIFIED AS A

Data Transformation and Reporting Expert?

Training Schedule

Certifications

Connect with Us

About Your Trainer

Mr. Sami

Course Content Overview

CORE FUNDAMENTALS

MATHEMATICAL FUNCTIONS

LOOKUP FUNCTIONS

LOGICAL FUNCTIONS

Supercharging Business Users with
Next-Level of Excel Reporting.

Both Online & Classroom is available.^*

Learner stories around
the world

Learner stories
around the world

Full Stack BI ^R
Reporting & Automation Course.