From Basics to Pro

Excel doesn’t have to be complicated.
Build Powerful Excel Dashboards, Reports & Models with Ease

Whether you're new to Excel or looking to sharpen your skills, this 16-hour course will show you how to turn raw data into meaningful reports and models. You'll master advanced formulas, streamline MIS reporting, and build solutions that make your work faster, smarter, and more impactful—ready to apply directly to your day-to-day tasks.

In just 2 weeks, you'll be able to:

Master complex Excel formulas to solve real-world business problems with ease.

Create professional, impactful MIS reports that drive business decisions.

Design dynamic, interactive dashboards that provide actionable insights.

Build scalable Excel models that support comprehensive business analysis.

Visualize complex data trends to bring clarity and enhance the effectiveness of your reports.

Ensure report accuracy and consistency by leveraging advanced Excel features for data validation and error-checking.

In just 2 weeks, you'll be able to:

Master complex Excel formulas to solve real-world business problems with ease.

Create professional, impactful MIS reports that drive business decisions.

Design dynamic, interactive dashboards that provide actionable insights.

Build scalable Excel models that support comprehensive business analysis.

Visualize complex data trends to bring clarity and enhance the effectiveness of your reports.

Ensure report accuracy and consistency by leveraging advanced Excel features for data validation and error-checking.

Ideal For:

Finance & Accounting

Seeking to streamline financial reporting and model building.

Project Managers

Looking to enhance reporting workflows and decision-making with efficient data handling.

Operations & Admin Managers

Wanting to improve MIS reporting and automate data-driven decision-making.

Business Analysts

Looking to enhance reporting, modeling, and data analysis skills.

Anyone working with Data

Who needs to turn large data sets into meaningful, actionable reports and models.

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

Course Syllabus Overview

Core Fundamentals

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

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 – 4 Hours

Fundamentals Of Functions & Formulas

Quick techniques to work with formulas & functions

DATE AND TIME FUNCTIONS

For data and time calculations
Today, Now
Day, Month, Year
Date, DateDif, DateAdd
EOMonth, Weekday
Workdays, NetWorkdays, Edate

TEXT FUNCTIONS

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

LOGICAL FUNCTIONS

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

MATHEMATICAL FUNCTIONS

For fundamental analysis
Sum, Count, CountA, Average, AverageA, Max & Min
SumIf, SumIfs
CountIf, CountIfs
AverageIf, AverageIfs
MaxIfs, MinIFs

LOOKUP FUNCTIONS

For joins with multiple tables
Vlookup / HLookup
Match
Dynamic Two Way Lookup
Creating Smooth User Interface Using Lookup
Offset
Index
Dynamic Worksheet linking using Indirect

ERROR HANDLING FUNCTIONS

For handling errors in functions

Modern Functions (New)

Duration – 2 Hours

Dynamic Array Functions

FILTER
SORT
SORTBY
UNIQUE
SEQUENCE
RANDARRAY

Lookup & Reference Functions

XLOOKUP
XMATCH

Text Functions

TEXTSPLIT
TEXTJOIN
TEXTBEFORE
TEXTAFTER
CONCAT

Logical Functions

IFS
SWITCH
LET
LAMBDA

Math & Trigonometry Functions

MAP
REDUCE
SCAN

Array Manipulation Functions

VSTACK
HSTACK
CHOOSECOLS
CHOSEROWS
WRAPROWS / WRAPCOLS

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

Fundamentals Of Reporting using Pivots & Dashboards

What are Measures?
What are Dimensions?
What does it mean to refresh reports?
How do you handle data structure changes?
What are the basic types of measurements?
What are themes in reporting?
What is meant by formatting measures?
What does it mean to create reports with multiple measurements?
What are advanced measurement types?
What are the different sorting options available?
What are the various types of filters?
What does group or categorizing data mean?
Understanding fundamentals of visualization / charting.

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

Modeling & MIS Reporting

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 – 6 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

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

System Requirements

Excel 2016 & above with PowerPivot

Available with Office 365 subscriptions that include desktop versions of Excel for Windows.
Secondary Monitor (optional, but recommended)

Having a secondary monitor will greatly assist in following the pace of the trainer. It allows you to view instructions and your own workspace simultaneously, enhancing your learning experience.

Taught by Microsoft Certified Trainers

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

Specialist Certification

Certification: MS-Excel Associate

A piece of paper means nothing if you can’t apply the skills. Our certifications are industry-recognized and backed by hands-on training—ensuring you’re not just qualified, but ready to perform from day one.

Eligibility:

On clearing post-training assessment.

View Sample Certificate

Shareable certificate

Add to your LinkedIn profile

Level : SPECIALIST

Certificate Code : EG-SPL-001

Eligibility:

On clearing post-training assessment.

Shareable certificate

Add to your LinkedIn profile

Training Schedule

06:00 AM to 08:00 AM ET

Limited Seats. Registration Closing Soon

Have Questions?

Tel:

+1 650 491 3131

Email:

support@excelgoodies.com

Projects & Assignments

What's included?

16 hours of live instructor-led sessions
200+ practical, system-based assignments
5 reporting & model-building projects
Specialist Certificate (exam-based)
30 days of post-training job support

Upcoming Cohort

Starts On

Tue, 06 Jan 2025

Time

Course Fee

$399

Tel: +1 650 491 3131

FAQs

If you miss a session, we provide class notes and exercises to help you catch up. Additionally, you can attend the same session in a future batch (subject to availability).

Yes! This course goes beyond basic Excel, covering Advanced Excel, MIS Reporting, and Business Model Building. You'll learn to create structured, data-driven reports and models for real-world business decision-making—without coding or automation.

We accept credit/debit cards, wire transfers, and corporate invoices for employer-sponsored payments.

No! The course starts with core Excel skills and progresses to advanced reporting and model-building techniques, ensuring a structured learning experience for all levels.

Yes! While most Excel functions are available on Mac, some advanced reporting and modeling features work best on Windows.

You will get access to 150+ real-world assignments via our assignment portal to practice MIS reporting techniques and structured model building. This ensures you can apply what you learn in actual business scenarios.

Yes! We provide corporate invoices for employer-sponsored payments. You can either use a company card or request an invoice to forward to your finance team for processing. These options are available at the Sign-Up form.

Yes! We offer corporate discounts for teams of 5 or more enrolling together. We also provide customized corporate training tailored to your organization's needs.

Yes! You will earn the Excel Reporting Specialist Certificate after passing the final exam.

This is a live, instructor-led course with real-time coding, hands-on exercises, and Q&A discussions, ensuring a highly engaging learning experience.

You can retake sessions from a future batch (subject to availability), but full course re-enrollment may require an additional fee.

Unlike pre-recorded courses, this is a live, interactive program with hands-on learning and direct access to expert instructors.

See all frequently asked questions

Build Real-World Solutions During the Course

Key Skills You'll Master

Data Structuring and Organization

Advanced Data Analysis

Report Creation and Formatting

Data Visualization (Charts & Graphs)

Pivot Tables and Dynamic Reports

Data Validation and Conditional Formatting

About The Trainer

Mr. Sami

MCT, MCP, MEE, MOS

30,000+

Students Trained

18+

Year of Experience

4.9

Reviews

Mr. Sami is an exceptionally accomplished and certified Microsoft Trainer, possessing extensive expertise in the fields of Finance, HR, and Information Technology. With an impressive 14-year tenure in the industry, he has successfully trained and empowered over 23,000 professionals, and the number continues to grow.

He has undertaken assignments with the renowned IRS, The World Bank, Tata Chemicals, Buckman Laboratories, Standard Chartered, ING Barings and much more. His nature of going that Extra Mile has got him the startling popularity amongst the Excelgoodies prominent clients.

Government Institutions We've Worked With.

Trusted by Government Entities

Build Real-World Solutions During the Course

The Excelgoodies Difference

We Spot Trends Before They Become Industry Standards

The analytics industry moves fast. We move faster. We constantly update our courses to match the latest industry needs, so you’re always learning what’s in demand—before everyone else.

Learn What Matters, Not Just What’s Trending

BI & Analytics isn’t about knowing one tool—it’s about knowing how to use the right tools together. Our courses don’t just teach software; they teach end-to-end reporting, automation, and cloud-driven analytics workflows—exactly what businesses need.

Tech-Enabled Learning,
Zero Hassles

Forget scattered emails and outdated PDFs. Our AI-powered student portal keeps everything in one place—live classes, assignments, progress tracking, instructor feedback, invoices, and instant support—so you stay focused on learning.

Real Projects, Real Experience, Real Confidence

No more theory-only learning—you’ll walk out of our courses with proven expertise in the tools and techniques hiring managers want.

Corporate Training

Avail additional 10% Corporate Benefit on the total course fee for 10+participants.

Get you team BI ready, today.

Mr. Perrie Smith

Business Associate

+1 650 491 3131

support@excelgoodies.com

Prove you're human: Type the code shown.

By clicking any of the above buttons, I agree to the terms & conditions and privacy policy, and I consent to receive updates via SMS or email

Esteemed Clientele

Thousands Trained. Here’s What They Say.

Total Reviews 2080k

Average Rating

4.5

Quotes icon Overall really enjoyed the course. Nice balance between demos, guided practice and independent practice. I really enjoyed the exercises where criteria was displayed and we had 20 minutes to build it up. Content felt very heavy on dashboard creation with an accelerated run thru PowerQuery material in the last several days; I think this could be a bit more balanced. My company had 5 students with stronger use needs for automated data manipulation than db's. The SQL review on Day10 was a bit fuzzy, I couldn't quite follow the benefits or use cases where this would be relevant. I would recommend adding a 5min break to the middle of each session for biological needs; 2.5 hrs is a long shot for some folks. We spent about 5 minutes at the beginning of each lesson setting up the day's folder structure, copying over data sets, etc. Could eliminate this and replace with a break if the overall folder structure was distributed with data sets already loaded in place at start of course. I.e. send zipped structure with folders for Days 1-10, each containing the ""Project X - Dashboard"" subfolders with Sales.Data.csv, etc, already saved in place. Thanks for the experience! looking forward to applying the knowledge! Quotes icon

Delaney Sullivan | Finance Transformation Project Manger | American Tower | United States (Power BI Training)

Quotes icon I had a little experience with Power BI prior to the class. The information given greatly expanded my knowledge and I am excited to put the knowledge to use. Sami's instructions were very easy to follow and he made sure to answer everyone's questions. The only issue I had with the course was with the students not the instructor or course itself. It was a bit frustrating when some of the students were not prepared (especially not having the system requirements installed) and we had to wait for them to download materials or software. Sami handled it professionally but it took away time that could have been used for training. Overall, I am very please with what I have learned and will be looking into taking the Full Stack BI training. Thank You, Iris Bradshaw Quotes icon

Iris Bradshaw | Data Analyst | Qnnect | United States (Power BI Training)

Quotes icon I liked the pace and content of this introduction to Power BI. The instructor was able to quickly troubleshoot most issues that people had, although some problems did stall the pace quite a bit at times (participants really should have a strong Excel skillset and ability to manage files). Perhaps on a daily basis before the training , a quick 'setup' email would be helpful (which folders to create and which files to copy) so that everyone could set themselves up ahead of time. (Or include day-by-day setup instructions in the content zip file with this info.) On another note, I would like to have spent more time on publishing and refreshing published reports (and the Power BI workspace) instead of the SQL server mini course. As it was, though, the lessons we learned in this training will be almost immediately applied and the results should be very helpful to people in my organization looking for dashboard summaries of their data. Thank you. Quotes icon

Michele Sabatino | Data Analytics Manager | Harbor Health | United States (Power BI Training)

Quotes icon Sami did a great job introducing the basics of Power BI through instruction and hands-on learning. This is a good course for a complete beginner, and would probably benefit some early intermediate students as well. My only complaint would be the amount of time needed to troubleshoot so many students' technical issues. We probably spend 40% of the total class time with Sami troubleshooting. It's not a knock on Sami or the course. Maybe a slightly smaller class would make it a little easier. Quotes icon

Zane Kinsey | Business Controller | Pacific Power Group | United States (Power BI Training)

Quotes icon This training was great! I've been working with Power BI for a little while now but was mostly self-taught so it was nice to learn some best practices for the way to do things. Also good to learn more about DAX and Power Query. Thank you Sami! Quotes icon

Michael Morrison | Platform Analyst | Cross First Bank | United States (Power BI Training)

Thousands Trained. Here’s What They Say.

Delaney Sullivan

Power BI Training

Finance Transformation Project Manger

American Tower

United States

Overall really enjoyed the course. Nice balance between demos, guided practice and independent practice. I really enjoyed the exercises where criteria was displayed and we had 20 minutes to build it up. Content felt very heavy on dashboard creation with an accelerated run thru PowerQuery material in the last several days; I think this could be a bit more balanced. My company had 5 students with stronger use needs for automated data manipulation than db's. The SQL review on Day10 was a bit fuzzy, I couldn't quite follow the benefits or use cases where this would be relevant. I would recommend adding a 5min break to the middle of each session for biological needs; 2.5 hrs is a long shot for some folks. We spent about 5 minutes at the beginning of each lesson setting up the day's folder structure, copying over data sets, etc. Could eliminate this and replace with a break if the overall folder structure was distributed with data sets already loaded in place at start of course. I.e. send zipped structure with folders for Days 1-10, each containing the ""Project X - Dashboard"" subfolders with Sales.Data.csv, etc, already saved in place. Thanks for the experience! looking forward to applying the knowledge!

Iris Bradshaw

Power BI Training

Data Analyst

Qnnect

United States

I had a little experience with Power BI prior to the class. The information given greatly expanded my knowledge and I am excited to put the knowledge to use. Sami's instructions were very easy to follow and he made sure to answer everyone's questions. The only issue I had with the course was with the students not the instructor or course itself. It was a bit frustrating when some of the students were not prepared (especially not having the system requirements installed) and we had to wait for them to download materials or software. Sami handled it professionally but it took away time that could have been used for training. Overall, I am very please with what I have learned and will be looking into taking the Full Stack BI training. Thank You, Iris Bradshaw

Michele Sabatino

Power BI Training

Data Analytics Manager

Harbor Health

United States

I liked the pace and content of this introduction to Power BI. The instructor was able to quickly troubleshoot most issues that people had, although some problems did stall the pace quite a bit at times (participants really should have a strong Excel skillset and ability to manage files). Perhaps on a daily basis before the training , a quick 'setup' email would be helpful (which folders to create and which files to copy) so that everyone could set themselves up ahead of time. (Or include day-by-day setup instructions in the content zip file with this info.) On another note, I would like to have spent more time on publishing and refreshing published reports (and the Power BI workspace) instead of the SQL server mini course. As it was, though, the lessons we learned in this training will be almost immediately applied and the results should be very helpful to people in my organization looking for dashboard summaries of their data. Thank you.

Zane Kinsey

Power BI Training

Business Controller

Pacific Power Group

United States

Sami did a great job introducing the basics of Power BI through instruction and hands-on learning. This is a good course for a complete beginner, and would probably benefit some early intermediate students as well. My only complaint would be the amount of time needed to troubleshoot so many students' technical issues. We probably spend 40% of the total class time with Sami troubleshooting. It's not a knock on Sami or the course. Maybe a slightly smaller class would make it a little easier.

Michael Morrison

Power BI Training

Platform Analyst

Cross First Bank

United States

This training was great! I've been working with Power BI for a little while now but was mostly self-taught so it was nice to learn some best practices for the way to do things. Also good to learn more about DAX and Power Query. Thank you Sami!

Google Reviews

Jackson Yu, Medpoint Management

I recently completed the Power BI training, and it was an excellent learning experience. The course was well-structured, covering everything from basic visualization techniques to advanced DAX functions. The instructor was highly knowledgeable and explained complex concepts in a clear and practical manner.

Mariah Mayhew, Financial Analyst

Sami was a great instructor. He took the time to make sure everyone could follow along and understand the material. While I already had experience with Power BI prior to this course, it was still a great refresher. If you're new to Power BI this is a great course to take!

Regina King, Accounting Manager

Sami, our trainer, was really good. He was very thorough in explaining concepts as well as navigating the user interface. He kept a good pace while ensuring that nobody was left behind . I recommend this course.

Industry Insights

Excel

5 Common Excel Mistakes That Can Sabotage Your MIS Reports

Excel

5 Excel Functions Every MIS Professional Should Know

Excel

10 Ways Power Query Can Supercharge Your Excel Reports

Industry Insights

FSBI

Real-World Business Scenario: PwC Case Study – From Weeks to hours

FSBI

Exploring the Different Roles and Career Paths in FSBI & Automation

FSBI

Real-World Business Scenario: PwC Case Study – From Weeks to hours

APPLICATION DEADLINE

Registration Closes
on .

+1 650 491 3131

support@excelgoodies.com

Prove you're human: Type the code shown.

By clicking any of the above buttons, I agree to the terms & conditions and privacy policy, and I consent to receive updates via SMS or email

+1 650 491 3131

support@excelgoodies.com

Compare Power BI Bootcamp to Similar Courses

Course on Excel Automation.

Excel VBA Programming for Automation

VB Programming | Report Automation | MS-Office Automation

Compare

For Aspiring Data Analysts

Power BI Reporting: Beginner to Expert

Power BI | Power Pivot | Power Query | DAX

Compare

Compare Now

Select one or more checkboxes

Fill-in the details.

Business Professionals

Techno-Business Professionals

Technology Professionals

Microsoft Excel Reporting:

Program Overview

Training Schedule

Pre-Requisite

Course Fee

Excel doesn’t have to be complicated. Build Powerful Excel Dashboards, Reports & Models with Ease

In just 2 weeks, you'll be able to:

In just 2 weeks, you'll be able to:

Ideal For:

Course Syllabus Overview

Core Fundamentals

CORE FUNDAMENTALS

Advanced Formulas & Functions

Fundamentals Of Functions & Formulas

Quick techniques to work with formulas & functions

DATE AND TIME FUNCTIONS

TEXT FUNCTIONS

LOGICAL FUNCTIONS

MATHEMATICAL FUNCTIONS

LOOKUP FUNCTIONS

ERROR HANDLING FUNCTIONS

Modern Functions (New)

Dynamic Array Functions

Lookup & Reference Functions

Text Functions

Logical Functions

Math & Trigonometry Functions

Array Manipulation Functions

Pivots, Charts & Dashboards

Fundamentals Of Reporting using Pivots & Dashboards

PIVOT TABLES

CHARTS & PIVOT CHARTS

EXCEL DASHBOARD

Modeling & MIS Reporting

MODELING & MIS REPORTING

Miscellaneous Topics

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

System Requirements

Taught by Microsoft Certified Trainers

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

Specialist Certification

Certification: MS-Excel Associate

Training Schedule

Projects & Assignments

What's included?

Upcoming Cohort

Course Fee

FAQs

What if I miss a session?

Is this course different from regular Excel courses?

What payment methods do you accept?

Do I need prior experience in Excel?

Can Mac users take this course?

What kind of hands-on practice will I get?

Can my employer sponsor my enrolment?

Do you offer corporate discounts?

Will I receive a certificate after completing the course?

How interactive are the sessions?

Can I retake the course if needed?

How does this course compare to online tutorials?

Build Real-World Solutions During the Course

Key Skills You'll Master

About The Trainer

Trusted by Government Entities

The Excelgoodies Difference

Corporate Training

Avail additional 10% Corporate Benefit on the total course fee for 10+participants.

Excel doesn’t have to be complicated.
Build Powerful Excel Dashboards, Reports & Models with Ease

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

Registration Closes
on .