Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Intro to Data Analytics using Excel

Learn to apply statistical tools to slice, dice, and analyze your data like never before!
4.1
4.1/5
(65 reviews)
218 students
Created by

9.2

CourseMarks Score®

9.1

Freshness

9.0

Feedback

9.0

Content

Platform: Udemy
Video: 3h 29m
Language: English
Next start: On Demand

Table of contents

Description

Our world, your company, and your life are filled with endless amounts of data just begging you to do something with it! If you work with data in any capacity and want to learn how to start analyzing it in an easy-to-understand manner, this course is for you.
In this course, you’ll learn the basics of data analysis, some fundamental tools and how to apply them, how to ask questions of your data, and how to present your findings in a slick dashboard. The entire course is done in Excel, no need to have some fancy-shmancy statistical software.

*We do highly recommend taking our “Beginner Statistics for Data Analytics” course before taking this course. The stats course gives you a great background on many of the tools we’ll be using.*

We start by demystifying the terms big data and data analytics before jumping into our statistics bootcamp (don’t worry, it’s not as scary as it sounds) to learn the key analytics tools. Armed with these tools, we’ll dive into a case study where we’ll use various analytical tools to analyze our data, come up with hypotheses, and test our assumptions. We top everything off by learning how to present data using a dynamic dashboard.
At completion, you’ll know how to use analytical techniques to analyze data sets.

Our courses are always:   
•Very easy to understand – There is not memorizing complex formulas (we have Excel to do that for us) or learning abstract theories. Just real, applicable knowledge.
•Fun – We keep the course light-hearted with fun examples
•To the point – We removed all the fluff so you’re just left with the most essential knowledge

Let’s start learning!  

You will learn

✓ Understand what “big data” and “data analytics” actually mean and why they are so important
✓ Learn different data analysis tools, how they work together, and how to use them with your data
✓ Know how to ask deeper and more meaningful questions of your data
✓ Apply various analysis techniques to datasets in Excel including a regression analysis
✓ Build a fully dynamic dashboard to present your findings

Requirements

• We highly recommend taking our “Beginner Statistics for Data Analytics” course first before this course.
• Intermediate knowledge of Excel (e.g. IF statements, VLOOKUP, etc.)
• Microsoft Excel 2013+

This course is for

• Anyone who wants to learn more about their data, but don’t know where to start
• Beginners in analytics looking to start gaining value from their data
CFO, Corporate Finance expert, Instructor, Mentor
Wisdify is an online training platform with a mission to empower professionals with the skills and knowledge to succeed professionally.
Our engaging online courses equip you with extremely relevant and in-demand hard and soft skills so you can become more employable and promotable.
Our courses include: SQL for Data Analytics, Intro to Data Analytics, Microsoft Power BI, Marketing Analytics, Microsoft VBA Macros, Financial Statement Analysis and more!
To receive CPE credit, you must complete the final exam on our website.

About the instructor
Joseph is the owner of Wisdify and is Joseph has a loves sharing his knowledge of finance, accounting, and business operations.  He is passionate about helping individuals and teams unlock their true potential.  He is an avid teacher and mentor, entrepreneur, and small business advisor.
Joseph is an active CFO with almost 20 years of experience in finance, accounting, and consulting.  He has worked in large public companies, private companies, and private-equity owned businesses.  His industry experience cuts across manufacturing, media/entertainment, real estate, capital/banking, and more.
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 3h 29m
Language: English
Next start: On Demand

Students are also interested in