In today’s workplace, data is the new gold. Yet, many professionals struggle to transform raw numbers into insights that drive smart decisions. The truth is the difference between those who advance in their careers and those who get overlooked often comes down to one skill: the ability to analyze and communicate data effectively.

Every industry is now driven by data — from finance to healthcare, manufacturing to tech. Employers are no longer asking if you can use Excel; they are asking how well you can analyze, visualize, and present data to solve real business problems.

That is why we created DATA ANALYSIS USING MS EXCEL (with AI Bonus Module!) — a practical, 100% hands-on program designed to help you master the most widely used analysis tool in business while adding the advantage of AI-powered efficiency.

COURSE DETAILS

• Dates: November 29, 30 and December 6, 7 and 13, 2025 (5 days/3 Weekends)
• Time: 6:00 PM – 10:00 PM (WAT), 4 hours each day
• Mode: Live Instructor-Led Online Training on Zoom (recordings available)
• Certificate: Certificate of Completion awarded
• Support: Access to a dedicated WhatsApp group for real-time interaction, peer collaboration, QandA with facilitators during the course, and continued mentorship even after the training ends.
• Facilitator Access: Instructors will also help solve YOUR real workplace challenges on Excel

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 (latest versions)
• CHOOSE function

Module 5: Pivot Tables and Advanced Reporting

• Building and formatting pivot tables
• Calculated fields and grouping
• Creating slicers and timelines for interactivity

Module 6: Data Visualization

• Chart types and best practices
• Dynamic charts and dashboards
• KPI reports with sparklines and conditional visuals

Module 7: What-If Analysis and Scenario Building

• Goal Seek and Data Tables
• Scenario Manager
• Sensitivity analysis for business decisions

Module 8: Financial Functions and Applications

• NPV, IRR, PMT, FV, and loan repayment schedules

Module 9: Automation with Macros and VBA Introduction

• Recording macros
• Understanding VBA basics
• Automating repetitive tasks

Module 10: AI Bonus Module – Excel with AI

• Using AI tools for data cleaning and summarization
• Automating insights with AI integration
• Practical demos of AI + Excel workflows

Final Module: Data Analysis Project

• A guided project using a sample dataset
• Cleaning, analyzing, and visualizing data
• Building simple dashboards and reports
• Practical and straightforward (not overly complex)

 Why Choose Acceltage Consulting?

• Live, real-time instructor-led sessions (not pre-recorded)
• Practical, hands-on guidance and mentorship
• Continuous support community even after the class
• 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 and Enquiries

Please use the “book now” or “inquire” buttons on this page to either book your space or make further enquiries.