Data Analytics
ADVANCED MICROSOFT EXCEL
A practical data analytics course focused on ADVANCED MICROSOFT EXCEL, hands-on class exercises, and job-ready digital skills.
Duration
6 Weeks
Days/Week
3 days per week
Classes
Physical
Fee
₦0
Course Overview
What this course covers
This course helps learners build practical knowledge in ADVANCED MICROSOFT EXCEL. The program combines guided teaching, applied exercises, project work, and mentorship so students can understand the tools, practice real workflows, and develop confidence for work, business, freelancing, or further study in data analytics.
Course Outline
- Advanced formulas, lookup functions, and dynamic arrays
- Data cleaning, validation, and structured tables
- Pivot tables, pivot charts, slicers, and timelines
- Power Query for automated data preparation
- Dashboard layout, charts, and business reporting
- Excel automation basics and final workbook project
Learning Outcomes
- Use advanced formulas and lookup tools confidently.
- Clean and structure data for reliable reporting.
- Build pivot reports, dashboards, and automated transformations.
- Design professional Excel dashboards for business users.
- Complete an advanced Excel workbook project.
Prerequisites
- Student should have access to a personal computer.
Why Choose It
- Deepens Excel skills beyond basic spreadsheet use.
- Useful for office reporting, finance, operations, and administrative roles.
- Covers dashboards, Power Query, formulas, and automation-friendly workflows.
- Helps learners save time and reduce reporting errors.
Ready to start advanced microsoft excel?
Contact Mayorkay Technologies Services for enrollment, class schedule, and group training arrangements.
Contact Us