This ExpertTrack offers an accessible entry-point into the world of data analysis and Microsoft Excel for complete beginners.
5 hrs per week
Approx 10 weeks
Certificates
Find out more
100% online
How it works
Cost
Find out more
Level
See requirements
Course 1
Introduction to Data Analysis using Excel for Absolute Beginners
3.4 (13 reviews)Learning from scratch? This course provides an accessible entry-point into the fascinating world of data analysis.
2 tests
3 weeks
5 hours per week
Week 1
Course Introduction
- About this Course
- Our Data-Driven World
- Data Fluency
- Your First Data Walkthrough
- Unpacking the Walkthrough
- Wrapping up the Week
Week 2
Data Structure, Analysis and Visualisation
- Data Structures
- Data Anatomy
- Data Joins
- Data Analysis Methods
- Data Visualisation
- Wrapping up the Week
Week 3
Data Analysis in Context
- Data Analysis in Context
- Data Ethics
- Career Paths
- Wrapping Up the Course
Course 2
How to Use Microsoft Excel for Data Analysis
3.2 (6 reviews)Improve your skills using Microsoft Excel and associated Excel features, to better report and analyse your data.
2 weeks
5 hours per week
Week 1
Introduction to Excel Table and Pivot Table Fundamentals
- Welcome to the Course!
- Introduction to Reporting in Excel
- CloudSwyft Hands-On Lab 1
- Excel Tables
- CloudSwyft Hands-On Lab 2
- Basic Pivot Tables
- CloudSwyft Hands-On Lab 3
- Wrapping up the Week
Week 2
Reporting, Analysing and Comparing Data in Excel
- Dashboards
- CloudSwyft Hands-On Lab 4
- Profitability Analysis and Finding Anomalies
- CloudSwyft Hands-On Lab 5
- Comparative Data in Pivot Tables
- CloudSwyft Hands-On Lab 6
- Reporting Hierarchical Data
- CloudSwyft Hands-On Lab 7
- Introduction to Multi-Table Pivot Tables and the Data Model
- CloudSwyft Hands-On Lab 8
- Wrapping up the Course
Course 3
Data Visualisation Fundamentals for Absolute Beginners
4.0 (5 reviews)Gain an introduction into data visualisations to communicate your data analytics to a diverse audience.
1 test
2 weeks
5 hours per week
Week 1
Welcome to the Course
- About this Course
- Visualisations are Everywhere
- Visualisation Fundamentals
- Visuals for Comparing and Relating
- Visuals for Interacting and Analysing Data
- Wrapping Up the Week
Week 2
Business Visualisations and Visualisations of Tomorrow
- Business Visualisations
- Business Context for Visualisations
- Advanced Visualisations
- The Future of Visualisation
- Wrapping Up the Course
Course 4
Essential Mathematics for Data Analysis in Microsoft Excel
4.3 (6 reviews)Understand the basic maths that powers data analysis with this beginner’s course.
1 test
3 weeks
5 hours per week
Week 1
Introduction to Working with Data
- About this Course
- Introduction to Data and Variables
- Types of Data
- Notation
- Means and Deviations
- Weekly Wrap Up
Week 2
Summarising and Graphically Representing Data
- Summarising Data with Distributions and Graphs
- Bar Graphs and Pie Charts
- Mode, Mean and Median
- SD vs IQR
- Proportions
- Weekly Wrap Up
Week 3
Business Statistics and KPI's
- Business Statistics
- Business KPIs
- Introduction to Inferential Math and Forecasting
- Course Wrap Up
More courses you might like
Learners who joined this course have also enjoyed these courses.