Brochure
Enquire
- About this Course
- Our Data-Driven World
- Data Fluency
- Your First Data Walkthrough
- Unpacking the Walkthrough
- Wrapping up the Week
- Home
- CloudSwyft Global Systems, Inc
- Courses
- Data Analysis with Excel for Complete Beginners
Data Analysis with Excel for Complete Beginners
Quick Facts
| particular | details | ||||
|---|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Learning efforts
5 Hours Per Week
|
Course and certificate fees
certificate availability
Yes
certificate providing authority
Futurelearn
The syllabus
Introduction to Data Analysis using Excel for Absolute Beginners
Course Introduction
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
Articles
Popular Articles
prev
next
Latest Articles
prev
next
Similar Courses
Foundations of Data Analysis Part 1 Statistics Usi...
University of Texas, Austin via Edx
Data Analysis Essentials
Imperial College Business School, London via Edx
Sabermetrics 101 Introduction to Baseball Analytic...
BU Boston via Edx
Visualization for Data Journalism
University of Illinois, Urbana Champaign via Coursera
Population Health Responsible Data Analysis
Leiden University, Leiden via Coursera
Assessment for Data Analysis and Visualization Fou...
IBM via Coursera
RShiny for Everyone
Davidson College, Davidson via Edx
Introduction to Data Analysis using Excel
Microsoft Corporation via Edx
Data for Effective Policy Making
IDB via Edx
prev
next
Courses of your Interest
Managing Services
IIT Kanpur via Swayam
Business Analytics Foundations
PW Skills
Value Based Care Organizational Competencies
University of Houston, Houston via Coursera
Communication and Leadership during a Public Healt...
SUNY via Coursera
Data Management for Clinical Research
Vanderbilt via Coursera
Quality Improvement in Healthcare Organizations
Rutgers University, New Brunswick via Coursera
Introduction to International Business Management
University of Kent, Canterbury via Futurelearn
International Leadership Skills for the Workplace
Coventry University, Coventry via Futurelearn
Tourism and Hospitality Management
University of Palermo, Buenos Aires via Futurelearn
prev
next
More Courses by CloudSwyft Global Systems, Inc
Artificial intelligence Design and Engineering wit...
CloudSwyft Global Systems, Inc via Futurelearn
Data Science Fundamentals on Microsoft Azure
CloudSwyft Global Systems, Inc via Futurelearn
Microsoft Future Ready Azure Cloud Fundamentals
CloudSwyft Global Systems, Inc via Futurelearn
Microsoft Future Ready Fundamentals of Enterprise ...
CloudSwyft Global Systems, Inc via Futurelearn
prev
next
