5 Courses
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
Free BONUS: Excel Tips!
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
Who should get Certified as an Excel Expert?
Finance Professionals
If you work in Banking or any Finance related role – being an Excel Expert will save you hours of work each week
Data Analysts
Use your Excel Expert skills to turn large data into information and help companies make better business decisions
Investment Analysts
Use advanced Excel to provide information to in-house fund managers or banks to make investment decisions.
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
Bloomberg Business Week
The Key to a Good-Paying Job Is…Microsoft Excel
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…