Advanced Excel

Microsoft Excel is a spreadsheet organized in rows and columns which comprise cells, worksheets and workbooks for diverse purposes. Microsoft is arguably the most used tool by individuals and businesses. Excel helps you to organize, analyze, present, and share data effectively, whether for work or for personal needs. With its superior Data Analysis and Visualization features, Excel is an exceptional tool for analyzing data.

This course is designed to enhance your proficiency in data analysis, financial modeling, and spreadsheet management. This course demystifies Excel usage and adaptability to our business and personal needs.

Delivery Methodology:

This course is available in both classroom and virtual modes.

Course Content

Overview of fundamentals of Excel

  • Overview of the basic task and components of Excel
  • Basic functions of Excel

Excel Pivot Tables

  • Using pivot tables to summarize and make sense of large dataset
  • Grouping & counting the number of items in each categories e.t.c

Excel Power Pivot Tools

  • Explore trends based on information and datasets using pivot tools.

Excel Lookups Functions

  • Using lookup functions in referencing a cell to match values
  • Understanding forms of lookup functions using vector and array

Advance Excel Functions

  • Conditional Functions
  • Text-based Functions

Match Index

  • Combine INDEX, MATCH, and MATCH formulas in EXCEL

What If Tools

  • Gola Seek, Solver, Data Table, Scenario Analysis

Other Advanced Excel Tools

  • Introduction to Repetitive tasks in Excel with Macros
  • Introduction to Reporting in Excel
  • Interactive Dashboard in Excel
  • Introduction to Excel and Financials/Profitability Analysis and Finding Anomalies

Physical Class

For Individual

N70K
Course Enquiry

Our classroom training will hold at The City Mall, Onikan, Lagos Island, Lagos State

Online Class

For Individual

N50K
Course Enquiry

Date: The course will be held on Saturday 13th July, Saturday 20th July, and Saturday 27th July 2024.

Time: Class runs from 10 am – 5 pm. Participants are entitled to an hour refreshment break.

Attractions: Lunch, Parking spaces, Wi-fi connectivity, Course materials, Gift items and more