Essential Excel For Business Statistics and Data Analytics

Essential Excel For Business Statistics and Data Analytics, available at $54.99, has an average rating of 4.5, with 55 lectures, based on 87 reviews, and has 615 subscribers.

You will learn about Introduction to Excel and navigating around the interface Reading in external data (including data from webpages) into Excel Derive insights from the data via grouping and pivoting Describe your data (descriptive statistics, including identifying the best statistic) Data visualisation through charts Inferential statistics in Excel (including hypothesis testing) Regression modelling in Excel This course is ideal for individuals who are Data analysts or Business and management students 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 Data analysts or Business and management students 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: Essential Excel For Business Statistics and Data Analytics

Summary

Title: Essential Excel For Business Statistics and Data Analytics

Price: $54.99

Average Rating: 4.5

Number of Lectures: 55

Number of Published Lectures: 55

Number of Curriculum Items: 55

Number of Published Curriculum Objects: 55

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

Introduction to Excel and navigating around the interface
Reading in external data (including data from webpages) into Excel
Derive insights from the data via grouping and pivoting
Describe your data (descriptive statistics, including identifying the best statistic)
Data visualisation through charts
Inferential statistics in Excel (including hypothesis testing)
Regression modelling in Excel

Who Should Attend

Data analysts
Business and management students
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

Data analysts
Business and management students
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 and Statistics Tasks

I’m Minerva Singh, and I’m an expert data scientist. I’ve graduated from 2 of the best universities in the world; 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 undertaking common business statistical analysis with Microsoft Excel, including reading data from different sources and building data visualisations. You don’t need any prior exposure to data analytics and visualization to get started 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
Basic webscraping with Excel
Carry out common business data analytic tasks including filtering and pivoting
Carry out pre-processing and data summarization to glean insights from data
Develop powerful visualisations with MS Excel
Learn important statistical techniques, including hypothesis testing and inferential statistics
Carry out common statistical analysis using MS Excel-including correlations and regression analysis
Include qualitative attributes in your regression models and interpret the results

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 would 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 The Course?

Lecture 1: Whats This Course About?

Lecture 2: Data and Code

Lecture 3: Introduction to Different Data Types

Lecture 4: Say Hello To the Excel Interface

Lecture 5: Excel Templates

Lecture 6: Rock The Ribbon

Chapter 2: Read Data Into Excel

Lecture 1: Read Data From External Sources

Lecture 2: Messy Data

Lecture 3: Reading Web Data Into Excel-Run a Web Query

Lecture 4: Read in a Wikipedia Table

Lecture 5: A Slightly Complicated Wikipedia Table

Lecture 6: A Non-Wikipedia HTML Table

Lecture 7: Read in XML Data

Chapter 3: Basic Data Processing With Excel

Lecture 1: Logical Operations

Lecture 2: Basic Sort and Filter

Lecture 3: Filtering-2

Lecture 4: Check For Conditions-If Only

Lecture 5: Apply AND/OR Conditions

Lecture 6: Basics Of Pivot Tables

Lecture 7: More Pivot Tables

Lecture 8: Order Of Progression Computations

Lecture 9: More BODMAS

Lecture 10: Remove Dollar Sign

Chapter 4: Describe Your Data

Lecture 1: Descriptive Statistics in Excel

Lecture 2: Measuring Central Tendency

Lecture 3: Summarisation By a Categorical Variable

Lecture 4: Subgroup Statistics

Lecture 5: Data Visualisations

Lecture 6: Line Chart

Lecture 7: Scatter Plot

Lecture 8: Histograms

Lecture 9: Bar Charts-Basics

Lecture 10: More Bar Charts

Chapter 5: Inferential Statistics

Lecture 1: What Is Hypothesis Testing?

Lecture 2: Comparing Two Groups

Lecture 3: Carry Out a T-Test (Check For Variances First)

Lecture 4: Why Do We Need ANOVAs?

Lecture 5: Carry Out One Way ANOVA In Excel

Lecture 6: Interpretation of One Way ANOVA

Lecture 7: Run a Two Way ANOVA In Excel

Lecture 8: Interpretation of Two Way ANOVA

Lecture 9: Understanding Interactions (In Case of of 2 Way ANOVAs)

Lecture 10: Confidence Interval-Theory

Chapter 6: Statistical Relationship Between Variables

Lecture 1: Relationships Between Categorical Variables: Chi-Square Tests

Lecture 2: Compute the Chi-Square Statistic

Lecture 3: Carry Out the Chi-Square Test

Lecture 4: Establishing a Relationship Between Quantitative Variables

Lecture 5: More Correlations

Lecture 6: Important Point to Note

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

Lecture 8: Categorical Predictors-Dummy Variables

Lecture 9: Create Dummy Variables

Lecture 10: Regression With Dummy Variables

Lecture 11: Interpret the Results of the Regression With Dummy Variables

Lecture 12: Coefficient of Determination

Instructors

Minerva Singh
Bestselling Instructor & Data Scientist(Cambridge Uni)

Rating Distribution

1 stars: 2 votes
2 stars: 4 votes
3 stars: 13 votes
4 stars: 20 votes
5 stars: 48 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