- 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
Beginner
Online
10 Weeks
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
certificate providing authority
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
Latest Articles
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
Introduction to Data Analysis using Excel
Microsoft Corporation via Edx
Data for Effective Policy Making
IDB via Edx
Essentials of Data Literacy
Davidson College, Davidson via Edx
Excel Basics for Data Analysis
IBM via Coursera
Causal Diagrams Draw your Assumptions before your ...
Harvard University, Cambridge via Edx
Courses of your interest
C++ Foundation
PW Skills
Data Science Foundations to Core Bootcamp
Springboard
User Experience Design And Research
UM–Ann Arbor via Futurelearn
Artificial intelligence Design and Engineering wit...
CloudSwyft Global Systems, Inc via Futurelearn
Data Science Fundamentals on Microsoft Azure
CloudSwyft Global Systems, Inc via Futurelearn
Artificial Intelligence Projects
Great Learning
Software Testing Tutorial
Great Learning
More Courses by CloudSwyft Global Systems, Inc
Microsoft Future Ready Azure Cloud Fundamentals
CloudSwyft Global Syst... via Futurelearn