COMPLETE BEGINNER → ADVANCED

Master Microsoft Excel for Data Analytics

Go from Excel beginner to confident data analyst with practical, hands-on training built around real-world business tasks.

This course takes learners from the fundamentals of Microsoft Excel through advanced formulas, data analysis, PivotTables, dashboards and Power Query.

US$70Complete course

Laptop showing an Excel dashboard with charts and pivot tables

Professionals from these organizations have taken our course

Logos of organizations whose professionals have taken our courses: Plan International, Banana, KRECS, Ruharo Mission Hospital, Koudijs, Pic-Ed, De Heus, SHONA, Ashinaga, Spectrum Real Estate Solutions, Bennett School of Taxation, Agribusiness Development Centre, Sopema Funeral Services, EduSkill

Choose Your Intake

Select the quarterly intake that fits your schedule.

January to March

Excel for Data Analytics

April to June

Power BI for Data Analytics

July to September

Excel for Data Analytics

October to December

Power BI for Data Analytics

Live online classes via Google Meet

Each intake is a live, instructor-led quarter. Pick the quarter that fits your schedule and join the next run of your chosen course.

Who Is This Course For?

What our course members say about Pivot Skills Global Academy training

Complete Course Curriculum

16 modules taking you from Excel fundamentals to practical data analytics.

Complete the Training. Submit Your Projects. Earn Your Certificate.

Learners submit their project files as part of the certificate qualification process. Once your training is complete and your project work has been submitted and reviewed, you qualify for your Pivot Skills Global Academy certificate.

Frequently Asked Questions

Ready to start? Enroll for US$70

Pay online or by bank transfer.

Bank transfer details

Account name: Birungi Godfrey

Bank: Equity Bank Uganda

Account number: 1030100812413

Need help first? Message us on WhatsApp at +256 773 523 826

CONTACT US

Master Microsoft Excel for Data Analytics

Professionals from these organizations have taken our course

Choose Your Intake

Who Is This Course For?

BEGINNERS

SELF-TAUGHT USERS

OFFICE PROFESSIONALS

STUDENTS & JOB SEEKERS

BUSINESS OWNERS & ENTREPRENEURS

ASPIRING & SEASONED DATA ANALYSTS

Complete Course Curriculum

MODULE 1: INTRODUCTION TO MICROSOFT EXCEL

MODULE 2: UNDERSTANDING THE EXCEL DATA TYPES

MODULE 3: BASIC FORMULAS, AUTO FILL & CUSTOM LISTS

MODULE 4: FINDING AND REPLACING VALUES IN EXCEL

MODULE 5: INTRODUCTION TO DATA VALIDATION

MODULE 6: CELL REFERENCING STYLES

MODULE 7: FORMULA AUDITING TOOLS

MODULE 8: SORTING AND FILTERING DATA

MODULE 9: WORKBOOK STRUCTURE & FILE PROTECTION

MODULE 10: TEXT FUNCTIONS FOR TEXT DATA MANIPULATION IN EXCEL

MODULE 11: LOGICAL FUNCTIONS (IF, XOR, AND, OR)

MODULE 12: LOOKUP AND REFERENCING FUNCTIONS IN EXCEL

MODULE 13: CONDITIONAL FORMATTING IN EXCEL

MODULE 14: PIVOT TABLES AND PIVOT CHARTS

MODULE 15: POWER QUERY (GET AND TRANSFORM DATA IN EXCEL)

MODULE 16: FINAL COURSE PROJECTS

Complete the Training. Submit Your Projects. Earn Your Certificate.

Frequently Asked Questions

Is this course suitable for complete beginners?

Do I need prior Excel experience?

What topics will I learn?

Is this course suitable for data analysts?

Will I work on practical projects?

How does the certificate qualification work?

Does the course cover Power Query?

Will I learn PivotTables and dashboards?

How much does the course cost?

How can I pay?

Ready to start? Enroll for US$70