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.

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 your questions anytime.