Complete Excel Data Analysis Bootcamp For Beginners

Complete Excel Data Analysis Bootcamp For Beginners, available at $49.99, has an average rating of 4.48, with 38 lectures, based on 170 reviews, and has 897 subscribers.

You will learn about Get started with using Excel for basic data processing and analysis Carry out analytical tasks in Excel Data visualisation in Excel Basic statistical analysis in Excel This course is ideal for individuals who are Beginner data analysts or Students and professionals seeking to use Excel for data tasks or Those looking to use Excel for basic data visualisations or Those looking to use Excel for basic statistical modelling It is particularly useful for Beginner data analysts or Students and professionals seeking to use Excel for data tasks or Those looking to use Excel for basic data visualisations or Those looking to use Excel for basic statistical modelling.

Enroll now: Complete Excel Data Analysis Bootcamp For Beginners

Summary

Title: Complete Excel Data Analysis Bootcamp For Beginners

Price: $49.99

Average Rating: 4.48

Number of Lectures: 38

Number of Published Lectures: 38

Number of Curriculum Items: 38

Number of Published Curriculum Objects: 38

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

Get started with using Excel for basic data processing and analysis
Carry out analytical tasks in Excel
Data visualisation in Excel
Basic statistical analysis in Excel

Who Should Attend

Beginner data analysts
Students and professionals seeking to use Excel for data tasks
Those looking to use Excel for basic data visualisations
Those looking to use Excel for basic statistical modelling

Target Audiences

Beginner data analysts
Students and professionals seeking to use Excel for data tasks
Those looking to use Excel for basic data visualisations
Those looking to use Excel for basic statistical modelling

If You Are…..

A business intelligence (BI) practitioner
Data analyst
Interested in gaining insights from data (especially financial, geographic, demographic and socio-economic data)

Excel Is Your Friend for Common Business Data Analysis Tasks

I’m Minerva Singh, and I’m an expert data scientist. I’ve graduated from 2 of the world’s best universities: an MPhil from Oxford University (Geography and Environment) and a PhD holder in Computational Ecology from Cambridge University. I have several years of experience in data analytics and data visualization.

My course aims to help you start with no prior/limited exposure to data analysis and become proficient in producing powerful visualizations and analyses with Microsoft Excel. You don’t need prior exposure to data analytics and visualization to start with MS Excel. So if you have struggled with Excel, worry no more. After finishing my course, you will be able to:

Read in and clean messy data in MS Excel.
Carry out common business data analytic tasks, including filtering
Carry out pre-processing and data summarization to glean insights from the data
Develop powerful visualisations with MS Excel
Carry out basic statistical analysis using MS Excel

If you take this course and it ever feels like a disappointment, feel free to ask for a refund within 30 days of your purchase, and you will get it at once. Become an expert in Data Analytics and Visualization with a new and powerful tool by taking up this course today!

Course Curriculum

Chapter 1: Welcome to Excel Bootcamp

Lecture 1: What Is This Course About?

Lecture 2: Data and Code

Lecture 3: Introduction to Different Data Types

Lecture 4: Introduction to the Excel Interface

Lecture 5: Rock the Ribbon

Lecture 6: A Really Messy CSV

Chapter 2: Let's Start With Excel

Lecture 1: A Date With Dates-Part 1

Lecture 2: Read in Data From External Sources-Text File

Lecture 3: Basic Sort and Filter

Lecture 4: Filtering- Part 2

Lecture 5: Logical Operations in Excel

Lecture 6: Check For Conditions

Lecture 7: Apply AND/OR Conditions

Chapter 3: Basic Excel Computations

Lecture 1: Introduction To Using Basic Stats Formulae in Excel

Lecture 2: Introduction To Autosum

Lecture 3: Of Brackets and BODMAS

Lecture 4: More BODMAS

Chapter 4: Data Summarisation With Excel

Lecture 1: Data Summarisation-Basic Stats

Lecture 2: Pivot Table Basics

Lecture 3: Slicing It With Slicers

Lecture 4: Summarise With More Stats

Chapter 5: Data Visualisation With Excel

Lecture 1: Theory Behind Data Visualisation

Lecture 2: Histogram

Lecture 3: Create a Basic Bar Chart

Lecture 4: More Bar Charts

Lecture 5: Scatter Plot

Lecture 6: Line Chart

Chapter 6: Statistical Analysis in Excel

Lecture 1: Priming For Data Analysis

Lecture 2: Association Between Quantitative Variables-Correlation

Lecture 3: Correlation in Excel-1

Lecture 4: Compute Correlation in Excel-2

Lecture 5: What is Ordinary Least Squares (OLS) Regression?

Lecture 6: Important Point To Note

Lecture 7: Run a Basic OLS Model in Excel

Lecture 8: Create Dummy Variables For Categorical Variables

Lecture 9: Linear Regression With 2 Factor Dummy Variables

Lecture 10: Coefficient of Determination

Lecture 11: Linear Forecasting

Instructors

Minerva Singh
Bestselling Instructor & Data Scientist(Cambridge Uni)

Rating Distribution

1 stars: 3 votes
2 stars: 7 votes
3 stars: 21 votes
4 stars: 46 votes
5 stars: 93 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu