Microsoft Excel Training

This intensive, hands-on Excel Accelerator is designed for professionals who want to move beyond basic spreadsheets and confidently analyze, visualize, and present data for smarter decision-making. You’ll learn Excel tools and shortcuts used daily by top business analysts, project managers, and executives.

Level: Beginner to Intermediate
Mode: Virtual or Onsite (Lagos)

What You’ll Learn

✅ Navigate Excel confidently and efficiently
✅ Perform accurate calculations using formulas and functions
✅ Clean, format, and manage data for professional reports
✅ Build charts and dashboards for executive presentation
✅ Automate repetitive tasks and enhance productivity

Course Content

Day 1 – Foundations of Excel Mastery (Basic Level)
Module 1: Understanding the Excel Interface & Navigation

• Ribbon, toolbars, and workbook structure

• Creating, saving, and formatting worksheets

• Shortcuts and efficiency tips

Module 2: Essential Formulas & Functions

• SUM, AVERAGE, COUNT, MIN, MAX

• Text functions (LEFT, RIGHT, CONCATENATE)

• Logical functions (IF, AND, OR)

• Date and time functions

Module 3: Data Organization & Formatting

• Sorting, filtering, and conditional formatting

• Data validation and drop-down lists

• Printing and page setup mastery

Day 2 – Intermediate Excel for Business Performance

Module 4: Working with Data Sets & Analysis

• Tables and structured references

• PivotTables and PivotCharts

• Slicers and timelines

Module 5: Visualization and Reporting

• Creating professional charts and dashboards

• Sparklines, data bars, and advanced visuals

• Best practices for management reporting

Module 6: Automation & Efficiency

• Named ranges, quick analysis tools

• Intro to Macros and automation basics

• Tips for Excel integration with Word and PowerPoint

Additional Benefits

• Live instructor-led practical sessions

• Access to editable templates and exercises

• Certificate of Completion

• Post-training Q&A support