DATA IS NOW THE LANGUAGE OF OPPORTUNITY.
THE PROFESSIONALS WHO MASTER IT BECOME THE ONES WHO LEAD.

Across today’s Nigerian workplace, data is the strongest driver of competitive advantage. Many professionals still struggle to transform raw numbers into actionable insights that guide decisions. The gap between those who advance and those who remain unnoticed often comes down to one capability: the ability to analyze, interpret, and communicate data effectively.

From banking to telecoms, oil & gas to healthcare, every sector in Nigeria expects professionals to think with data. Employers want more than basic Excel skills. They want individuals who can analyze, visualize, and present insights using Excel, Power BI, and AI tools.

This is why we designed DATA ANALYSIS USING MS EXCEL + INTRODUCTION TO POWER BI (with AI Bonus Module!), a practical, fully hands-on programme equipping you to analyze data, build dashboards, automate tasks, and present insights confidently.

COURSE DETAILS

Dates: January 31, February 1, 7, 8 and 15, 2026 (5 Days / 3 Weekends)
Time: 6:00 PM – 10:00 PM (WAT), 4 hours per day
Mode: Live Instructor-Led Online Training on Zoom (recordings included)
Certificate: Certificate of Completion
Support: Dedicated WhatsApp group for collaboration, real-time interaction, peer learning, Q&A with facilitators, and continued mentorship
Facilitator Access: Instructors will support participants with real workplace Excel and data challenges

COURSE MODULES

Module 1: Excel Essentials Refresher

• Interface, shortcuts, data entry, and formatting
• Tables, ranges, and named ranges

Module 2: Powerful Formulas and Functions

• Text functions (LEFT, RIGHT, MID, LEN, TRIM)
• Date and time functions
• Logical functions (IF, AND, OR, NOT)
• Statistical and math functions (SUMIF, COUNTIF, ROUND, RANK)

Module 3: Data Cleaning and Transformation

• Removing duplicates, text-to-columns, flash fill
• Data validation and conditional formatting
• Handling missing data

Module 4: Lookup and Reference Functions

• VLOOKUP, HLOOKUP
• INDEX and MATCH
• XLOOKUP
• CHOOSE function

Module 5: Pivot Tables and Advanced Reporting

• Building and formatting pivot tables
• Grouping, calculated fields
• Slicers and timelines

Module 6: Data Visualization in Excel

• Chart types and visualization principles
• Dynamic charts and dashboards
• KPI reporting with sparklines and conditional visuals

Module 7: What-If Analysis and Scenario Building

• Goal Seek
• Scenario Manager
• Data Tables

Module 8: Introduction to Power BI

• Power BI interface and workspace
• Importing and transforming data with Power Query
• Creating basic visualizations and dashboards
• Publishing simple reports

Bonus Module: AI for Data Analysis

• Using AI tools to automate formulas
• Generating insights with AI assistance
• Enhancing reporting speed and accuracy

PRACTICAL HANDS-ON PROJECT

Participants complete a guided, end-to-end project:

• Cleaning and preparing a sample dataset
• Analyzing and deriving insights
• Building visual reports
• Creating simple dashboards in Excel and Power BI
• Presenting final outputs

The project is practical, straightforward, and designed for immediate workplace application.

WHY CHOOSE ACCELTAGE CONSULTING?

• Live, real-time instructor-led sessions (no pre-recorded videos)
• Practical, hands-on guidance and mentorship
• Continuous support community even after the programme ends
• Accredited by the Centre for Management Development (CMD) – Nigeria’s highest accreditation for management trainers
• Trusted by professionals from:
  GTBank, Airtel, MTN, NNPC, CBN, Access Bank, Ecobank, Leadway Assurance, Kimberly-Clark, BUA Flour Mills, Promasidor, Union Bank, Beiersdorf (Nivea), Sterling Assurance, American Towers Corporation, CWG PLC, and more

FOR BULK REGISTRATION OR ENQUIRIES

Please use the “Book Now” or “Inquire” buttons on this page to secure your space or request further information.