What You'll Learn in this Course

How to use Excel
Functions, Ranges and Shortcuts
Printing, Formatting and Conditional Formatting
Data Analysis: Text, Formulas & Logic

Creating Charts
Pivot Tables, Power Query and Dashboards
Macros & VBA to really speed up your work!
... and much more!

Skill Level:

Beginner to Advanced

Language:

English

Lessons:

Videos:

6 hours and 44 minutes

Certificate:

Get a certificate of completion accredited by the CPD* that can be displayed on LinkedIn

Versions:

The course is created in Excel 2019 (365) but works in Excel 2016, 2013, 2010, and 2007

Course Modules

MODULE 1

1.1 Introduction
1.2 Overview

MODULE 2

2.1 Combine what you can enter in a cell
2.2 Relative and Absolute Cell Referencing
2.3 Entering Formula
2.4 Order of Operations
2.5 Date Serial Numbers

MODULE 3

3.1 Copy and Drag
3.2 Working with rows and columns
3.3 Working with sheets

MODULE 4

4.1 Functions
4.2 SUM Function
4.3 Copy and Drag Formula
4.4 More Basic Functions
4.5 Named Ranges
4.6 Names Constants and Formula
4.7 Shortcuts
4.8 More Shortcuts

MODULE 5

5.1 Formatting Font
5.2 Formatting Alignment
5.3 Formatting Borders
5.4 Formatting Numbers
5.5 Conditional Formatting Pre-Configured
5.6 Conditional Formatting with Formula
5.7 Conditional Formatting Dialogue Box Formula Trick

MODULE 6

6.1 Icons Shapes and Formatting
6.2 Printing Page Layout
6.3 Printing Headers Footers

MODULE 7

7.1 Data Sort
7.2 Filtering
7.3 Tables
7.4 Text to Columns
7.5 Flash Fill
7.6 Data Validation
7.7 Group and Outline
7.8 Freeze Panes

MODULE 8

8.1 Relative and Absolute Referencing
8.2 VLOOKUP
8.3 Index Match
8.4 IF
8.5 Nested If
8.6 Countif Countifs
8.7 SUMIF SUMIFS
8.8 LEN
8.9 RIGHT LEFT MID
8.10 SEARCH
8.11 Common Error Types
8.12 IFERROR

MODULE 9

9.1 Chart Basics
9.2 Chart Series and Column Charts
9.3 Bar Charts
9.4 Pie Charts
9.5 Composite Charts

MODULE 10

10.1 Power Query Intro
10.2 Power Query Consolidation
10.3 Pivot Tables
10.4 Setting up a Pivot Table
10.5 Pivot Table Field Settings
10.6 Pivot Table Calculated Fields
10.7 Pivot Table Groupings
10.8 Pivot Table Slicers and Timelines
10.9.1 Dashboards Part 1
10.9.2 Dashboards Part 2

MODULE 11

11.1 What is a macro?
11.2 Recording a Macro
11.3 Relative and Absolute Macros

MODULE 12

12.1 Introduction to VBE
12.2 Object Model
12.3 Module Worksheets Classes
12.4 Variables and Constants
12.5 vba Formatting
12.6a If Statement
12.6b Select Case
12.7a For Loop
12.7b DoWhile DoUntil Loop
12.7c ForEach Loop
12.8a Errors
12.8b Errors
12.9 Consolidate

Testimonials

100,000+ Students Love
Earn & Excel

“This course transformed my career. The lessons were easy to follow and immediately applicable to my career goals as a financial analyst.”

Brenna Goyette

“I was a complete beginner in Excel, but this course made me an expert. Highly recommended!”

Mei Chen

“The instructor explains complex concepts in a simple and understandable way. I learned a lot from this course.”

Dan Schaefer

“The VBA course has been a game changer as the ability to automate was something I longed for in order to be more efficient and more effective as a professional. This course is the complete package, I would recommend this course 100%”

Maria Rodriguez

“This course is excellent. The skills I have developed have given me the confidence to tackle advanced problems in an Investment Banking environment. Unlike other courses, the tutorials are practical, to the point and are relevant to professionals. I would highly recommend this course.”

Isabella Rossi

“The course content is comprehensive and well-structured. It covers everything you need to know about Microsoft Office.”

Noah Tremblay

“I was able to improve my productivity significantly after taking this course. It is worth every penny.”

Gabriel Silva

“I applied many of the skills I learnt through your Excel course to automate many aspects of my work and it has been a huge help. My next step is to improve my VBA skills!”

Kim Seoyeon

“The course was a revelation. The instructor was knowledgeable and the content was well-structured. I would recommend this to anyone looking to upskill.”

Rick Muller

And Work At Some Of The World's Best Companies

It's Time to Accelerate Your Career

Elevate Your Professional Skills

Our course is designed to provide a comprehensive, practical, and affordable learning experience. Taught by trainers with 10+ years of real-world experience.

Comprehensive Skills: Enhance your career with a wide range of skills from Microsoft Office to Data Science, tailored to the modern workplace.
Accredited & Affordable: Earn a CPD accredited certificate upon completion of this course.
Flexible Learning: Learn at your own pace with over 18 hours of video lessons and lifetime access.
Comprehensive Curriculum: Courses designed to cover beginner to advanced levels, ensuring a complete learning journey.
Expert Instructors: Learn from industry experts who bring years of professional experience into the classroom.
Community Support: Join a community of peers to collaborate and enhance your learning experience.

Limited Time Offer

Our regular price of $69 has been reduced down to $7!

Buy Now

Frequently asked questions

How do you deliver your courses?: After signing up, we'll email you a link to our training dashboard. All courses consist of video lessons and exercise files, accessible on any device.
Are you certified by a governing body?: We are accredited by the CPD (Continuing Professional Development) governing body, a recognized accreditation center in the UK.
Why choose your courses?: Our trainers have 10+ years of real-world experience. We focus on what works and leave out unnecessary information, saving your time.
How long will it take to learn these skills?: It depends on your commitment. Our students have seen results from as little as 30 minutes a day. The key is applying the skills as much as learning them.
Can my employer pay for my training?: Yes, we often help corporate employees. We offer bulk discounts for teams, but payment must be made with a corporate credit/debit card.
Do you have a refund policy?: Yes, we offer a 30-day refund policy if the training isn’t right for you.

Master Excel in Hours