Why Excel?

  • Data Analysis and Visualization: Excel is the industry-standard tool for data analysis and visualization, allowing you to create interactive dashboards, charts, and reports that bring data to life.
  • Data Modeling and Forecasting: Excel’s advanced formulas and functions enable you to build complex data models and forecasts, helping you predict trends and make informed decisions.
  • Collaboration and Sharing: Excel makes it easy to share and collaborate on spreadsheets with colleagues and stakeholders, streamlining workflows and improving productivity.

Are you ready to elevate your Excel skills to the next level? Whether you’re an experienced analyst or just starting, Excel Mastery For Modern Analyst is an e-book providing a comprehensive roadmap to mastering Microsoft Excel, making it your most powerful tool for data analysis, financial modelling, reporting, and much more.

Buy Now

Session's Calendar

Virtual Classes

Online live classes

Duration

2 months

Matriculation date

December 28 2025

Graduation date

February 28 2026

Time:

Default time schedule – Saturdays & Sundays 4:00pm – 7:00pm WAT

WHAT YOU WILL LEARN IN EXCEL

  • The world of data analysis in a glance
  • Basic definitions, applications in the excel space and navigation between worksheets.
  • Sequencing
  • Auto-fitting and auto filling techniques with applications
  • Harnessing formulars and functions within the excel space.
  • Harnessing Logical functions, Mathematical functions, Text functions and applications.
  • Understanding cell references and ranges
  • Understanding and applying Relative, Absolute, Mixed cell references
  • The use of named ranges.
  • Data cleaning & formatting
  • Dealing with errors, spaces and unwanted notations in Data
  • Data Validation
  • Data Filtering and sorting techniques
  • Pivot tables, pivot chats, advanced filtering (Slicers), Power Pivot
  • Conditional Formatting
  • Discussing, Understanding, harnessing 6 different lookup functions for data analysis.
  • The what-if Analysis
  • The model of Scenario analysis
  • The model of goal goal seeking
  • Data Table
  • Financial functions and applications
  • Forecasting technique
  • peer to peer environment
  • project work
  • project defense
Enroll Now
Scroll to Top