Excel Intermediary

Take your Excel skills to the next level. Master intermediate to advanced formulas, data analysis tools, PivotTables, charts, and automation techniques used by professionals.

Created by

Asogbon Samuel

    • (0 Reviews)

0 Hours

0 Enrolled

English

Last updated

Wed, 08-Apr-2026

Course description

This Excel Intermediate course is designed for users who already know the basics of Excel and want to become highly proficient. 

You will learn powerful functions and formulas (VLOOKUP, INDEX & MATCH, SUMIFS, TEXT functions, etc.), how to clean and transform data efficiently, create dynamic dashboards, use PivotTables and PivotCharts for deep data analysis, apply conditional formatting, work with large datasets, and automate repetitive tasks using macros and basic VBA.

The course focuses heavily on real-world business applications such as financial analysis, sales reporting, inventory management, and data visualization. By the end, you will be able to handle complex Excel tasks confidently and work much faster and smarter.

What will i learn?

  • Use advanced Excel functions and formulas confidently (including nested formulas) Perform powerful data analysis using PivotTables and PivotCharts Create professional and dynamic dashboards Clean and transform messy data efficiently Apply advanced conditional formatting and data validation Work with large datasets without slowing down Excel Automate tasks using macros and introduction to VBA Build real-world reports used in business and finance

Requirements

  • Good knowledge of Excel basics (formatting, simple formulas, sorting & filtering)
  • Microsoft Excel 2016, 2019, 2021, or Microsoft 365 installed
  • A computer with stable internet (for practice files)

Frequently asked question

This course goes far beyond basic formulas. It focuses on real data analysis, advanced functions, PivotTables, dashboards, and automation.

No. We start with recording macros and gradually introduce basic VBA concepts.

Yes. Most examples and projects are based on real business scenarios like sales analysis, financial reporting, and inventory management.

Asogbon Samuel

View profile

₦20000

₦25000

Lectures

0

Skill level

Intermediate

Expiry period

2 Months

Certificate

Yes
Remove from cart Add to cart Buy now

Share this course

Related courses

Intermediate

Advanced Excel

0

(0 Reviews)

0 Hours

₦50000

₦65000

Enroll now

Intermediate

Power BI

0

(0 Reviews)

0 Hours

₦50000

₦60000

Enroll now

Intermediate

Tableau

0

(0 Reviews)

0 Hours

₦50000

₦65000

Enroll now

Intermediate

SQL (Structured Query Language)

0

(0 Reviews)

0 Hours

₦50000

₦60000

Enroll now

Intermediate

Project Management

0

(0 Reviews)

0 Hours

₦50000

₦60000

Enroll now

Advanced

Virtual Assistance for Data Analytics

0

(0 Reviews)

0 Hours

₦100000

₦120000

Enroll now