• Start Date: 4th of October
  • End Date: 2nd of November
  • Time: 10am – 12pm (WAT)
  • Schedule: Tuesdays, Thursdays

Advanced Microsoft Excel is much more than a quick way to add up numbers. In this course, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP. This course also covers Sparklines, and goes in-depth with Pivot Tables and Charts. Finally, you will learn how to create and record your own Macros.

Pre-requisite: No knowledge of computer and/or IT is required to attend this program.

Who Should Attend?

Data Analysts
Financial Analysts
Intermediate Excel Users
Freshers seeking jobs in Analytics/Consulting job streams

COURSES OBJECTIVES

After the completion of the Microsoft Excel Course, you would have learnt the following:

Learn to use formulas and functions.

Create and modify charts.

Convert, sort, filter, and manage lists.

Insert and modify illustrations in a worksheet.

Learn to work with tables.

Learn to use conditional formatting and styles

Create pivot tables and charts

Learn to trace precedents and dependents

Convert text and validate and consolidate data

Collaborate with others by protecting worksheets and workbooks

Create, use, edit, and manage macros

Import and export data

TRAINING FEATURES

  • Instructor-led Live Sessions
  • Real-life Case Studies
  • Assignments
  • Lifetime Access
  • 24 x 7 Expert Support
  • Internationally Recognised Certificate

FAQs

What are the system requirements for this course?

Operating System: Windows 7 or higher, Mac OS.

Processor: 1 gigahertz (GHz) or faster processor or SoC

RAM: 1 gigabyte (GB) for 32-bit or 2 GB for 64-bit

Hard disk space: 16 GB for 32-bit OS or 20 GB for 64-bit OS

Graphics card: DirectX 9 or later with WDDM 1.0 driver

Display: 800 x 600

What if I miss a class?

All classes are recorded and uploaded on our Learning Management System(LMS). So you can catch up on your course during your free time if you miss a class.

Do I receive a certificate after completing the Course?

Yes, you receive an internationally recognized certificate after the course.

Who are the Instructors?

Our Instructors are in-house professionals with at least 5 years of relevant experience in various domains. They are subject matter experts and are trained to provide a great learning experience.

Course Content

Expand All
Not Enrolled

₦5,500

Course Includes

  • 9 Modules
  • 35 Topics
  • 1 Quiz
  • Course Certificate
small_c_popup.png

Join our Mailing List

Receive updates on our upcoming courses, free webinars & promotions