Applied Data Analytics with Advanced Microsoft Excel
Learn advanced Excel techniques for data analysis including pivot tables, formulas, and statistical functions.
0
Students
0
Lectures
About This Course
Course Overview
Take your Excel skills to the next level with this comprehensive analytics course. Learn to use Excel as a powerful data analysis tool for business intelligence and research.
What You Will Learn
- Advanced formulas: VLOOKUP, INDEX-MATCH, array formulas
- Pivot Tables and Pivot Charts mastery
- Statistical functions for data analysis
- What-if analysis: Goal Seek, Scenario Manager, Data Tables
- Data cleaning and transformation techniques
- Power Query for data import and transformation
Who Should Attend
Finance professionals, administrators, researchers, and anyone who needs to analyze data regularly using Excel.
Allan Nuwagaba
3
Courses
0
Students
Allan is a Business Intelligence Consultant & a Data Analytics Trainer with specialty in using Microsoft tools Excel & Power BI. He has over eight years of professional experience. Allan focuses on solving organizational, business operational & financial decision-making problems using data analytics and visualization.
Curriculum Overview
This course includes 0 modules, 0 lessons, and 0 hours of materials.
Certificates
1 Parts
Course Certificate
Course Certificate
If you pass all the lessons in this course, you will receive this certificate.
Type
Course Certificate
0
0 Reviews
Content Quality (0)
Instructor Skills (0)
Value for Money (0)
Support Quality (0)
This Course Includes
Downloadable Content
Official Certificate
Instructor Support
Course Forum
Course Specifications
Start Date
1 Jan 1970 | 00:00
Sections
0
Lessons
0
Capacity
Unlimited
Duration
30:00 Hours
Students
0
Created Date
28 Jan 2026
Updated Date
28 Jan 2026
You are viewing
Applied Data Analytics with Advanced Microsoft Excel
Ready to transform your career?
Start Your Data Analytics Journey Today
Browse Courses Visit BC AfrikaContact Us
© 2026 Blueprint Consortium Africa. All rights reserved.
Reply to Comment