Name: Excelgoodies
Brand: Excelgoodies
SKU: 2037693689
Price: 399 GBP
Availability: InStock
Rating: 5 (4583 reviews)

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

Forecasting, Budgeting & Costing Models *

Budgeting and financial forecasting are tools that companies use to establish a plan for where management wants to take the business budgeting and whether it is heading in the right direction—financial forecasting. This section will guide you to build such models.

Different types of forecasting & budgeting models

Budgeting Models

A budget model is a framework for how you create and manage your budget.

Most people are familiar with the different approaches to budgeting for personal finances like the envelope method or 50/30/20.

Similarly, there are multiple approaches to creating a budget for your business.

5 most common types of budget models used

Zero-based Budget
Static Budget
Flexible Budget
Rolling Budget
Incremental Budget

Forecasting Models

There are three basic types—qualitative techniques, time series analysis and projection, and causal models. The first uses qualitative data (expert opinion, for example) and information about special events of the kind already mentioned and may or may not take the past into consideration.

The second, on the other hand, focuses entirely on patterns and pattern changes, and thus relies entirely on historical data.

The third uses highly refined and specific information about relationships between system elements and is powerful enough to take special events formally into account. As with time series analysis and projection techniques, the past is important to causal models.

*	Please note that topics marked with an asterisk are advanced concepts beyond the regular Excel program and require an additional cost. Alternatively, our comprehensive Full Stack BI Reporting Course covers all these exciting topics.

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

Forecasting, Budgeting & Costing Models *

Different types of forecasting & budgeting models

Budgeting Models

A budget model is a framework for how you create and manage your budget.

Most people are familiar with the different approaches to budgeting for personal finances like the envelope method or 50/30/20.

Similarly, there are multiple approaches to creating a budget for your business.

5 most common types of budget models used

Zero-based Budget
Static Budget
Flexible Budget
Rolling Budget
Incremental Budget

Forecasting Models

The second, on the other hand, focuses entirely on patterns and pattern changes, and thus relies entirely on historical data.

*	Please note that topics marked with an asterisk are advanced concepts beyond the regular Excel program and require an additional cost. Alternatively, our comprehensive Full Stack BI Reporting Course covers all these exciting topics.

Our 5 Steps Learning Process

Excel Learning Redefined.

LEARN from Microsoft Certified Trainers

PRACTICE with real-time Assignments

REVISE with 10+ Case Studies

SPEED-UP with our Excel Shortcut Tool

ON-JOB Support to implement learnings

Taught by Microsoft Certified Trainers.^*

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 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.5 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.5 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.5 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.

Course Fee

£399

What is included?

20 hours of Instructor-led training.

Real-time Excel Assignments

7 MIS Reporting Projects

30-Days post-training support (via Email)

MIS Reporting Specialist Certificate

View Certificate

READY TO BE CERTIFIED AS A

Advanced Excel, MIS Reporting & Model Building Specialist?

Course Content Overview

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

What's included in your training?

20 hours of Instructor-led training.

Real-time Excel Assignments

7 MIS Reporting Projects

30-Days post-training support (via Email)

MIS Reporting Specialist Certificate

View Certificate

Course details

Core Fundamentals

Duration – 2.5 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.5 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.5 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

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

USD 499

Certifications

Advanced Excel & MIS Reporting Specialist

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

Susan Rodezno

Power BI Training

Analyst, Process Improvement, Corporate Budgeting & Reporting

Essex Property Trust

United States

Sami's very knowledgeable and professional and clearly an expert in what he does. He was patient with us and provided us with a lot of content, giving us the tools to succeed while not giving away the farm sot to speak. I feel like I learned a great deal and looking forward to going back to reference material as well as completing the project for this class completion. thank you,

Tao Peng

Power BI Training

Information Technology Specialist

Minnesota State College Southeast

United States

This is an excellent training. Sami is a great and patient instructor. He made sure everyone is on course and understands the topic fully before he moves on, if help is needed beyond class time, he also was there before the class to answer questions. I am really impressed with his knowledge and expertise, it seems he always knows the answer to questions. I will definitely take another class with Sami and Excelgoodies again.

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

Learner stories
around the world

Total Reviews

4583

Overall growth till now

Average Rating

4.9

Average rating this year

Susan Rodezno

Power BI Training

Analyst, Process Improvement, Corporate Budgeting & Reporting

Essex Property Trust

United States

Tao Peng

Power BI Training

Information Technology Specialist

Minnesota State College Southeast

United States

Iris Bradshaw

Power BI Training

Data Analyst

Qnnect

United States

BY INDUSTRY

BY FUNCTION

Reserve My Seat

Advanced Excel, MIS Reporting & Model Building

Program at a Glance

Total Course Duration

20-hours, 8-Sessions

Live Online (Weekdays)

Training Schedule

View Schedule View Schedule

Course Fee

£399

Enroll Now

Certification

Advanced Excel & MIS Reporting Specialist

Sample Certificate Sample Certificate

Re-invented Excel Learning for Power Users.

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?

Forecasting, Budgeting & Costing Models *

Different types of forecasting & budgeting models

Quick Excel Brush-up (Gap Filing)

60+ Advanced Excel Formulas

Pivots, Charts & Dashboards

MIS Reporting & Dashboarding

Cleansing & Transforming Data

Forecasting, Budgeting & Costing Models *

Our 5 Steps Learning Process

Taught by Microsoft Certified Trainers.*

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

Advanced Excel, MIS Reporting & Model Building Specialist?

Training Schedule

Certifications

Connect with Us

Course Content Overview

CORE FUNDAMENTALS

MATHEMATICAL FUNCTIONS

LOOKUP FUNCTIONS

LOGICAL FUNCTIONS

TEXT FUNCTIONS

DATE AND TIME FUNCTIONS

ROUNDING FUNCTIONS

ERROR HANDLING FUNCTIONS

Advanced Excel &
MIS Reporting Specialist

Taught by Microsoft Certified Trainers.^*

Learner stories
around the world

Full Stack BI
Reporting & Automation Course.