Excel Expert Program

Get The Excel Expert Skills You Need To Succeed

5 Courses

t

Online Quizzes

}

20 Hours

4 Week Program

Add our Live Daily Webinars for additional Support

20 x Live Webinars. Running everyday at 11.30am. 60 minutes long.

Live tutoring from our Expert Trainers.

Only an internet connection is required to join.

Become an Excel Expert and increase your career potential

Excel is the most widely used application in business today, but very few people maximize its potential.

When you take this Program, you’ll learn everything you need to know to make using Excel easy.

Whether you’re new to Excel or a seasoned pro, this program will bring you to Expert level.

What's covered in your Excel Expert Program

Master Skills
Understand the Basics of Excel Step-by-Step
Excel Foundations
Start here and know all the essential tools in Excel – and how to get the most out of them
Master Skills
Discover the must-know Excel Formula’s and Functions
Excel Formulas & Functions
Put your calculator in the bin, let Excel do it all and save yourself hours of work
Analyzing Data
Know how to analyze data in Excel to make better decisions
Analyzing Data in Excel
If you work with lists and tables – you need to turn data into information
Master Skills
Discover How to Make Beautiful Charts in Excel
Excel Charts
Display the meaning behind the numbers, making comparisons and trends easier to see
Master Skills
Pivot Tables made easy – everything you need to know
Excel Reporting & Dashboards
Be Brilliant at using Pivot Tables and Dashboards to impress your Boss and Colleagues
Master Skills
15 Time Saving Excel Tips You’ll Use Everyday

Free BONUS: Excel Tips!

In 30 minutes you’ll discover the tips and tricks the experts use and wow your colleagues

5 CPD Certified Courses – what’s covered in each:

Excel Foundations

Module 1 : Start Up and Interface

Opening Microsoft Excel and the Interface

We start at the beginning and walk you step by step through the navigation of Excel so you can find your way around

The Excel Quick Access Toolbar

Discover the Excel Quick access toolbar and be introduced to Tabs and Ribbons

The Formula Bar and Status Bar

Find out about the Formula Bar, what it does and how you can use it.

Opening, Closing and Saving Workbooks

Know how to open, close workbooks, and how to save your work in Excel

 

Module 2 : Formatting and Editing

Formatting Fonts and Cells

Know how to format fonts in Excel. Understand how to merge and align cells

Formatting Numbers, Dates & Currencies

Find out about all the different types of formatting that can be done in Excel

Editing Cells in Excel

Discover the differences between ‘Cell’ editing and ‘Formula Bar’ editing

Format Painter and Autofill

Find out how to use the Format Painter Tool and Autofill to save you time

 

Module 3 : Worksheets

Formatting an Excel Worksheet

Find out how to Insert and Edit cells, insert columns and rows, and how to Hide & Unhide them

More Sheet Options

Discover the features in Excel that allow you to Group Sheets, Freeze Panes, Link Sheets, Create Custom Views and insert Headers and Footers

 

Module 4 : Printing & Scaling

Printing your Excel work

In this module you’ll find out how to use Print Preview; Scale To Fit, Editing Margins And Orientation, and Print Titles

Printing to Scale

Discover the best ways to Print or Not Print Grid lines And Headings, Print One Sheet And Multiple Sheets

Excel Formulas and Functions

Module 1 : Essential Formula

The Top 8 Formula that you’ll use every day

We start at the beginning and walk you step by step through the most used Excel Formulas

Understand Operators

Know how to turn Excel into your super-efficient calculator to solve basic mathematical operations

Know how to Automate Formula

Save time when you know how to apply formula across worksheets

 

Module 2 : Defining and Auditing Formula

Absolute and Relative Referencing

Know how to copy formula across multiple cells

Name Manager

Understand why defining a name for cells is important

Formula Auditing

Discover how and why you should be auditing formula

The Watch Window and Calculation Options 

Find out why the Watch window makes it convenient to inspect formula

 

Module 3 : Functions

IF Statements

Be able to use IF Statements, one of the most popular instructions among the Decision Making Statements

VLOOKUP and HLOOKUP

When you need to look in a single row or column to find a value from a second row or column, you need to a LOOKUP. Find out how in this section

 

Module 4 : Advanced Functions

Using Excel’s Quick Analysis Tool

With the Quick Analysis Tool you can create different Chart types such as Scattered, Clustered and Stacked. We show you how.

Date and Database Functions

If you need to find information using given criteria, you need to know Functions like DSUM, DCOUNT and DVAR

Analyzing Data in Excel

Module 1 : Working with Lists

How to Apply Sorts and Filters

Sort and Filter are some of the most commonly used features for analyzing data in Excel. This module gives you the skills you need

Advanced Formats and Filters

We explain Custom Formats, show you how to use Conditional Formatting and advanced Filters, use Data Bars and Icons Custom Lists

 

Module 2 : Data Tools

Flash Fill and Strings

Discover how to use Excel’s awesome CONCATENATE function to join up to 255 text strings into one text string – and why this is useful

Data Validation, Consolidation and Goal Seek

Find out how to make sure that users enter certain values into Cells

The Data Table, Forecast Sheet and Grouping 

This makes it really easy to turn existing data into forecasting

 

Module 3 : Working with Tables

Creating and Designing Tables in Excel

Learn how to insert tables and format them to make showcasing data simple

The Slicer Tool

Discover how to insert Slicers into Excel and How to filter Pivot Tables

Excel Charts

Module 1 : Inserting Objects

Inserting Objects, Pictures and Media

We show you how to embed objects in Excel Worksheets and why you may want to do this

Creating Basic Charts and Editing them 

A simple Chart can say a whole let more than a bunch of numbers in cells. We explain step-by-step how you can make an impression

Using Hyperlinks in Excel 

You can insert hyperlinks in Excel so that anyone can click to an external website, worksheets or file locations. Handy if you’re presenting data

 

 

 

Module 2 : Sparklines & Charts

What are Sparklines and why they’re great

Find out why these tiny Charts inside a worksheet cell can provide a brilliant visual representation of data. You can use Sparklines to show trends easily

Charts

Find out why Charts are such powerful tools. Learn all the different Chart types and how to manipulate them with ease

 

Module 3 : Advanced Charts

Showing Filters and Formatting

Find out how to format your charts just the way you want them

Advanced Chart Types and Tools 

Discover how to add secondary axis, add trend-lines, use different Chart types for different data sets and display charts with negative values

Excel Reporting and Dashboards

Module 1 : Intro to Pivot Tables

What is a Pivot Table?

Pivot Tables are one of Excel’s most powerful features. They allow you to get data from a larger data set. This Module explains how.

Recommended Pivot Tables

We show you to utilize the inbuilt recommended Pivot Tables in Microsoft

Build your own Pivot Tables

We walk you through step-by-step examples of how to create your own Pivot Tables and how to edit them

Data Source, Table Styles and Drill-down Options

Once you have your Pivot Table, we show you how to utilize it

 

Module 2 : Advanced Pivot Tables

Slicers and Timelines

You’ll be able to filter your Pivot Table with Slicers and Timelines and see what Filters are applied

Pivot Charts

Find out how to easily represent, visually, the data in your Pivot Table, in the form of Pivot Charts. How to get the Data, Filter Connections and Design your Table

 

Module 3 : Dashboards

An introduction to Dashboards

Excel Dashboards are a very powerful way to improve your Excel Data visualization. We start at the beginning and guide step by step using examples

More Advanced Dashboards

Over 45 bite-size lessons we show you Styles, examples, the Camera Tool, and how to make your amazing Dashboard truly interactive

FREE BONUS! Excel Tips and Tricks

15 Time Saving Excel Tips You’ll Use Everyday. In 30 minutes you’ll discover the tips and tricks the experts use and wow your colleagues.

3 reasons to become an Excel Expert

When you’re an Excel Expert, you’ll be an asset to any Business.

You’ll truly understand the power of Excel.

You will save you and companies hundreds of hours of work.

These are all Skills that Businesses pay for - your salary increases when you're an Excel Expert.

This is the Certificate you can add to your Resume

Internationally recognized accreditation

Excel Master Diploma Online

Who should get Certified as an Excel Expert?

Excel Foundations

Finance Professionals

If you work in Banking or any Finance related role – being an Excel Expert will save you hours of work each week

Excel Foundations

Data Analysts

Use your Excel Expert skills to turn large data into information and help companies make better business decisions

Excel Foundations

Investment Analysts

Use advanced Excel to provide information to in-house fund managers or banks to make investment decisions.

Excel Foundations

Accountants

An Excel Expert can prepare asset, liability, and capital account entries by compiling and analyzing information

Why you should become a Certified Excel Expert

The Excel Error That Changed History

Harvard University economists Carmen Reinhart and Kenneth Rogoff have acknowledged making a spreadsheet calculation mistake in a 2010 research paper, “Growth in a Time of Debt” (PDF), which has been widely cited to justify budget-cutting…..

Bloomberg Business Week

The Key to a Good-Paying Job Is…Microsoft Excel

Want a job that promises a living wage and a good shot at a middle-class life? Learn Microsoft Excel and other basic digital skills. That’s the conclusion of a report released Thursday by Burning Glass Technologies a labor-market analysis firm that reviewed millions of jobs….

The Wall Street Journal

Your Excel skills could land you your next job

When it comes to hunting for a job, perhaps the nerdiest skill you can put in your resume may be the one that sends you over the top. High proficiency in software like Microsoft Excel is increasingly helping people land jobs.. from Middle-income jobs to Wall Street analysts…

Fortune.com