Data Analysis Fundamentals using Excel

Topics we will cover: 

• Data Analysis Fundamentals

• Data Cleaning with Power Query

• Pivot Tables and Analysis

• Visualization with Dashboard

Click here for Pre-Assessment

Slides (PDFs):

• Introduction to Data Analytics
• Data Cleaning with Power Query
• Data Analysis with Pivot Table
• Data Modelling

Working Resources(.xlsx):

• 1.-Cross-Tab-vs-Flat-File
• 2. Power Query Case Study
• 3. Data Cleaning Exercises
• 4. IMDb Movie Database
• 5. Creating Dashboard
• 6. 12 min Excel Dashboards
• 7. Delicious Pizza_Sales-Data

Click here for Post-Assessment

Feedback :

(Important for your course completion Certificate)

• Please Click  this link
• Class ID: 44644

UOB Feedback :

• Please Click  this link