Learn Microsoft Excel Quickly
This course that will show you how to get the best out of Excel that you can complete in under 7 hours!
Buy our complete Excel 2019 course for N4,500 which comes with an accredited certificate. Start date 7th January 2023.
What You'll Learn in this Course
When you sign up, you get immediate access to the course. You can access the lessons any time and there is a WhatsApp support Group you can Ask and get answers to your questions anytime.
- How to use Excel
- Functions, Ranges and Shortcuts
- Printing, Formatting and Conditional Formatting
- Data Analysis: Text, Formulas & Logic
- 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: 82
Videos: 6 hours and 44 minutes
Certificate: Get a certificate of completion accredited by the INVIN Academy that can be displayed on LinkedIn
Versions: The course is created in Excel 2019 (365) but works in Excel 2016, 2013, 2010, and 2007
Mode of Delivery
WhatsApp Lessons Notes and Videos
Live Video Sessions Weekly
Downloadable files and resources
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
- MODULE 5
5.1 Formatting Font
5.2 Formatting Alignment
5.3 Formatting Borders
5.4 Formatting Numbers
- 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
MODULE 9
9.1 Chart Basics
9.2 Chart Series and Column Charts
9.3 Bar Charts
9.4 Pie Charts
MODULE 10
11.1 What is a macro?
11.2 Recording a Macro
11.3 Relative and Absolute Macros
Whether you are a complete beginner or even at an intermediate level, this course will rapidly build your skills and confidence and have you doing your work in Excel very quickly and productively.
You can go through the course with the confidence that it’s taught by a highly experienced professional who has used Excel for over 10 years.