The Complete Data Analytics Course in Excel

A complete data analysis course using the tools you already have.

4.60 (873 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
5,862
students
15 hours
content
Sep 2023
last update
$74.99
regular price

What you will learn

Data Analytics

Data Visualization

Hypothesis Testing

Statistics

Forecasting

Excel

Regression

Monte Carlo Simulation

Linear Programming

Pivot Tables

Business Intelligence

Excel Analytics

Description

Do you think you need to learn new software to perform data analysis, statistics, simulations? You don't! Everything you need to get started in the world of data analytics is already on your computer in the wonderful application called Excel.

This course will first acquaint you with the Excel environment including how to use simple and complex functions, hot-key shortcuts and navigation tips to make sure you work efficiently and effectively. From there, I lead you in lectures and practice exercises on the fundamental topics of data analytics.

Data Visualizations - Visualizing data is an important part in analyzing data as well as presenting and explaining what it means. Lectures in this course Included how to craft and use bar charts, line charts, radial charts, histograms, box and whisker charts, pie charts, conditional formatting and Sparklines.

Pivot Tables - Pivot Tables are very powerful, simple to use tools built into excel. The lectures will include how to structure data to get the most out of pivot tables, and then a few use cases including root cause analysis, comparative analysis, along with other visualization tools specific to pivot tables.

Statistics - The Statistics module is by far the most densely packed module in this course. As a statistician by training, I present a deep dive into the data behind the statistics and how to use different statistical tests based on different circumstances. The module is filled with different lectures and exercises involving ANOVA tests, T Tests, Chi-Squared Tests, Tests for Normality, Regression Analysis and more.

Forecasting - Organizations have to be able to anticipate the future. The forecasting tools presented in this course help us accomplish this feat. Forecasting is presented in two different ways - Factor forecasting and Time Series forecasting. For each approach to forecasting, many tools and techniques are introduced and reviewed including Regression analysis, Monte Carlo Simulation, Simple Moving Averages, and Auto-Regressive techniques.

Excel Tools - Excel has a lot of useful tools that don't quite fit neatly into any of the other modules. The last module of this course explores the use cases of using these tools. In particular, several archetypal problems are introduced and solved using the miscellaneous data analysis tools found in excel, including Excel Solver.

Content

Lectures

Navigation Part 1
Navigation Part 2
Basic Excel Formulas
Structuring Data in Excel
Intermediate Excel Functions
Descriptive Statistics Part 1
Descriptive Statistics Part 2
Module #1 Practice & Solutions

Visualizations

Introduction to Visualizations and Pie Charts
Histograms
Bar Charts
Line Charts
Box and Whisker
Radial Charts
Combo Charts
Scatter Plots
Conditional Formatting Part 1
Conditional Formatting Part 2
Conditional Formatting Part 3
Sparklines
Module #2 - Practice & Solutions

Pivot Tables, Charts and Slicers

Introduction to Pivot Tables
Root Cause Analysis
Comparative Analysis
Pivot Charts and Slicers
Module #3 - Practice & Solutions

Statistics: Hypothesis Testing and Regression

Types of Data
Fundamentals of Sampling
Distributions Part 1
Distributions Part 2
Introduction to Hypothesis Testing
T-tests Part 1
T-tests Part 2
T-tests Part 3
Chi-Squared Test Part 1
Chi-Squared Test Part 2
Test for Normality Part 1
Test for Normality Part 2
ANOVA Part 1
ANOVA Part 2
Simple Regression Part 1
Simple Regression Part 2
Multi-Variate Regression Part 1
Multi-Variate Regression Part 2
Multi-Variate Regression Part 3
Module 4 - Practice & Solutions

Forecasting

Introduction to Forecasting
Factor Forecasting - Regression Part 1
Factor Forecasting - Regression Part 2
Factor Forecasting - Monte Carlo Simulation - Part 1
Factor Forecasting - Monte Carlo Simulation - Part 2
Factor Forecasting - Monte Carlo Simulation - Part 3
Time Series Forecasting - The Simple Moving Average Part 1
Time Series Forecasting - The Simple Moving Average Part 2
Time Series Forecasting - Parameter Tuning Part 1
Time Series Forecasting - Parameter Tuning Part 2
Time Series Forecasting - Parameter Tuning Part 3
Time Series Forecasting - Auto Regression
Time Series Forecasting - Time Series ARMA
Time Series Forecasting - Time Series ARIMA
Module 5 - Practice Set #1 & Solutions
Module 5 - Practice Set #2 & Solutions

Miscellaneous Analytical Tools

Intro and Goal Seek
Scenario Analysis
Data Tables
Introduction to Excel Solver Tool
Excel Solver Tool - The Backpack Problem
Excel Solver Tool - The Mixing Problem
Excel Solver Tool - The Traveling Salesman Problem
Module 6 - Practice & Solutions

Screenshots

The Complete Data Analytics Course in Excel - Screenshot_01The Complete Data Analytics Course in Excel - Screenshot_02The Complete Data Analytics Course in Excel - Screenshot_03The Complete Data Analytics Course in Excel - Screenshot_04

Reviews

Sebastian
September 3, 2023
I enjoyed the course. Various ways of putting Excel to work. I finished the course with the sense of learning confidently few things. Thanks.
James
September 1, 2023
Clear, concise instructions and walk through. Enjoying this course as I am new to Data analysis and this is great for me!
Flavien
August 24, 2023
I have never posted a review at the start of a course, but honestly, This course is promising to be one of the best courses I have come across on Udemy on this subject. I will post another review at the end of it.
Raúl
August 13, 2023
Amazing course. It is definitely a must for every professional who wants to stand out in their workplace. I will follow the instructor closely to continue learning with him
林煒承
July 26, 2023
Very easy to understand! The contents are exactly what I'm looking for, which combines the excel functions with statistical knowledge, but interpreted in the plain way instead of the mathematical way. Thanks!
Cat
July 21, 2023
the ctrl shortcuts were not working for me at first because it was not in edit mode, which I didn't know until I closed out and reopened. It may also be helpful to add that the CTRL + Page up/down will work only if num lock is not on (that also was not working and confused me a bit).
Nekha
June 23, 2023
The course is the best choice I have made to kick-start my career in data analysis. The lecturer perfectly explains even the smallest of details, ensuring everyone understands all the aspects of the course. I would like to thank the lecturer for putting up such amazing content that is crystal clear and sufficient for anyone learning Excel.
Jessica
June 18, 2023
These are definitely basics for me, but I am expecting there will be skills that needed brushed up, some that I didn't know (or completely forgot about) later on. But it is very well taught and I like the pace and presentation so far.
Ashwathy
June 13, 2023
The material was great. Good concepts but could have been explained better. The professor could use voice modulation to keep the lecture active. Apart from that great concepts and shown well practically.
Antonio
June 8, 2023
Learning materials are useful but some explanations are hard to understand, excel in videos are sometimes blurred.
Adebowale
June 3, 2023
The introduction to shortcuts and their functions are amazing and straightforward. very useful thank you
Ponmile
May 27, 2023
The course got really boring towards the end. Concentrating was so hard . However, this is no fault of the instructor
Pratik
May 23, 2023
Many thanks to the tutor, I've learned a lot of new topics and there is good effort in preparing the resources to practice the topics as well. If you keep updating this course with more knowledgeable insights, that would be just awesome (Of course pertaining to topics you have covered). Happy to learn other courses from this tutor. Thanks a lot.
David
May 11, 2023
I've been finding myself regularly having trouble figuring out why I'm doing certain things or how the math works out. But really, it's an excel(ent) course!
Phil
January 27, 2023
So far this has been a perfect match for me. The perfect level of complexity, theory and practical instruction, and excellent resources and examples.

Coupons

DateDiscountStatus
5/22/2021100% OFF
expired
6/29/20210% OFF
expired

Charts

Price

The Complete Data Analytics Course in Excel - Price chart

Rating

The Complete Data Analytics Course in Excel - Ratings chart

Enrollment distribution

The Complete Data Analytics Course in Excel - Distribution chart

Related Topics

4026424
udemy ID
5/4/2021
course created date
5/18/2021
course indexed date
Bot
course submited by