Microsoft Excel is the world’s leading spreadsheet programme. It is a critical piece of software for office environments and financial businesses.

Our Microsoft Excel course teaches you how to manage, calculate and format data in clear and visually appealing ways. This includes making calculations, displaying data as graphs or charts and creating complex formulas.

Microsoft Excel is the most commonly used analytics, reporting and strategy software. Becoming an expert data analyst requires you to have mastery of  Excel skills. This course is aimed at taking your excel skills to the next level. You will be able to apply complex functions within Excel to manage, manipulate, analyze and visualize data.

ABOUT THIS COURSE

This Excel course comprises several lessons, which provide a detailed but manageable study programme, so you can be confident about your new skills in the workplace.

Having completed our Microsoft Excel course, you could add Microsoft Excel to your list of achievements, which could help maximise your career potential.

Comprising twenty two lessons this course covers areas such as creating worksheets, formatting text, simple and complex formulas; handling rows and columns, autocomplete, using styles, headers and footers, average, max and min functions and using charts.

TARGET AUDIENCE

This course is aimed at professionals who have none to intermediate Excel skills and want to advance those skills. From beginners, to advanced users, this course is perfect for all ability levels

COURSE DURATION

Online6 Weeks
Class Notification  Via WhatsApp

WHAT YOU WILL LEARN

By the end of this training the participants will be able to:

  • Master Excel formulas and functions
  • Consolidate data, link and export data in Excel
  • How to create and format worksheet
  • Create and edit tables and graphs
  • Become one of the top Excel users in your team
  • Design professional and good-looking advanced charts
  • Turn raw data into ‘must make’ decisions using PivotTables
  • You will learn the key concepts and techniques necessary to work with Excel
  • From the fundamentals, to the most advanced features, this training covers everything you need to know about Excel

COURSE OUTLINE

1.0 Intro to Excel – Quick Tour of Excel

2.0 Data Input & Hidden Features to Save Time

3.0 Excel WorkSheet – Navigation, Copying and Protecting Worksheet

4.0 Excel Formula

5.0 Excel Functions

6.0 Excel Data Management 

7.0 Formatting in Excel – Conditional and Number Formatting

8.0 Printing Excel Files & Saving as PDF

9.0 Workbook Design Principle 

10.0 Working with Excel Charts

11.0 Excel Pivot Tables

12.0 Power Query in Excel

13.0 Conclusion

TRAINING APPROACH

This course is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of Microsoft Excel. The course is taught through a mix of practical activities, quiz questions, examples and live classes.

Training manuals and additional reference materials are provided to the participants.

CERTIFICATION

Upon successful completion of this course, participants will be issued with a certificate.

PAYMENT

The training fee covers six weeks of live classes (August 12 to Sept 24, 2022), and a year access to our training videos.

Course Fee: #8,500

Payment should be sent to our bank account before start of training and proof of payment sent to: WhatApp @ 09129971102

Bank Details

UBA

2108725869

Oladejo Anuoluwapo