Microsoft Excel for Data Analytics




12 Weeks


About the Course

Microsoft Excel for Data Analytics Course covers all the essential topics necessary for the course taker to have a mastery of Excel to be used in analyzing data both in a professional or personal setting. The course content includes all the main concepts that the individual needs to master to use Excel productively. There is a short quiz at the end of each lesson to test what you've learned. You MUST get at least 80% on all quizzes to qualify for a CERTIFICATE.

The Curriculum includes:

1. Introduction
2. Mathematical Functions
3. Text Manipulation Functions
4. Logical Functions
5. Creating Reports (Filtering Data, Formatting and Charts)
6. Conditional Formatting
7. Excel Tables (Data Tables, Summarizing data)
8. Functions to Organize Data (VLOOKUP, HLOOKUP)
9. Pivot Tables
10. Advanced Graphs and Charts (Line, Bar and Pie charts • Pivot charts • Scatter plots • Histograms
11. Basic Statistics
12. The Data Analysis Tool (Descriptive Statistics, T-test, F-test)
13. Dashboards

Your Instructor

Nelson Achelengwa

Nelson Achelengwa is an IT Consultant with key skills in Data Analytics, Visualizations and related tools including Microsoft Excel and Tableau. He possesses rich experience as Instructor and a Data Analyst which will be reflected in the content of this course.

Nelson Achelengwa