Data Analysis with Excel for Complete Beginners

CloudSwyft Global Systems, Inc via Futurelearn

Beginner

Online

10 Weeks

particular

details

                                    Medium of instructions
                                    English

                                    Mode of learning
                                    Self study

                                    Mode of Delivery
                                    Video and Text Based

                                    Learning efforts
                                    5 Hours Per Week
                                

Introduction to Data Analysis using Excel for Absolute Beginners

Course Introduction

About this Course
Our Data-Driven World
Data Fluency
Your First Data Walkthrough
Unpacking the Walkthrough
Wrapping up the Week

Data Structure, Analysis and Visualisation

Data Structures
Data Anatomy
Data Joins
Data Analysis Methods
Data Visualisation
Wrapping up the Week

Data Analysis in Context

Data Analysis in Context
Data Ethics
Career Paths
Wrapping Up the Course

How to Use Microsoft Excel for Data Analysis

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

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

Data Visualisation Fundamentals for Absolute Beginners

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

Business Visualisations and Visualisations of Tomorrow

Business Visualisations
Business Context for Visualisations
Advanced Visualisations
The Future of Visualisation
Wrapping Up the Course

Essential Mathematics for Data Analysis in Microsoft Excel

Introduction to Working with Data

About this Course
Introduction to Data and Variables
Types of Data
Notation
Means and Deviations
Weekly Wrap Up

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

Business Statistics and KPI's

Business Statistics
Business KPIs
Introduction to Inferential Math and Forecasting
Course Wrap Up

Popular Courses

Popular Platforms

Popular Searches

Data Analysis with Excel for Complete Beginners

Beginner

Online

10 Weeks

Quick Facts

Course and certificate fees

certificate availability

certificate providing authority

The syllabus

Introduction to Data Analysis using Excel for Absolute Beginners

Course Introduction

Data Structure, Analysis and Visualisation

Data Analysis in Context

How to Use Microsoft Excel for Data Analysis

Introduction to Excel Table and Pivot Table Fundamentals

Reporting, Analysing and Comparing Data in Excel

Data Visualisation Fundamentals for Absolute Beginners

Welcome to the Course

Business Visualisations and Visualisations of Tomorrow

Essential Mathematics for Data Analysis in Microsoft Excel

Introduction to Working with Data

Summarising and Graphically Representing Data

Business Statistics and KPI's

Articles

Popular Articles

Latest Articles

Similar Courses

Courses of your Interest

More Courses by CloudSwyft Global Systems, Inc

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Thank You!

Download the Careers360 App on your Android phone