Introduction to Data Analytics with Microsoft Excel

Focused View

Simon Sez IT

4:17:34

152 View

1. Course Introduction

1. Introduction to the Course.mp4

05:00

2. WATCH ME Essential Information for a Successful Training Experience.mp4

02:11

3.1 Data Analytics in Excel Course and Exercise Files.zip

3. DOWNLOAD ME Instructor and Exercise Files.html

4. Navigating Excel.mp4

09:52

5. Data Types in Excel.mp4

05:56

6. Section Quiz.html

2. Using Excel Spreadsheets for Data Analysis

1. Viewing and Entering Data.mp4

08:55

2. Formatting and Data Types in Excel.mp4

08:44

3. Excel Formula Basics.mp4

09:44

4. Exploring Excel Functions.mp4

09:38

5. Referencing Data in Formulas.mp4

08:51

6. Exercise 1.mp4

03:57

7. Section Quiz.html

3. Cleaning and Managing Data

1. Introduction to Data Quality.mp4

09:59

2. Importing File Data.mp4

05:36

3. Removing Duplicate Data.mp4

07:49

4. Identifying Data Attributes.mp4

08:25

5. Cleaning Data.mp4

07:34

6. Exercise 2.mp4

02:21

7. Section Quiz.html

4. Analyzing Data

1. Sort and Filter Data.mp4

06:59

2. Concatenation and SUMIF.mp4

06:53

3. Tackling Complicated OR Criteria.mp4

06:52

4. Summarizing Data Using Pivot Tables.mp4

07:29

5. Creating a Pivot Chart.mp4

06:34

6. Working with Excel Charts.mp4

05:14

7. Analysing Financial Data.mp4

09:18

8. Waterfall Charts.mp4

07:25

9. Conditional Formatting.mp4

07:07

10. Using Database Functions.mp4

07:13

11. Evading Formula Errors.mp4

08:05

12. Exercise 3.mp4

02:01

13. Section Quiz.html

5. What-If Analysis and Analysis ToolPak

1. Scenario Manager in What-If Analysis.mp4

09:54

2. Data Tables in What-If Analysis.mp4

08:41

3. Goal Seek in What-If Analysis.mp4

07:03

4. Loading the Analysis ToolPak.mp4

03:10

5. Correlation and Covariance in Analysis ToolPak.mp4

07:31

6. Descriptive Statistics, Moving Average and Exponential Smoothing.mp4

08:01

7. Additional Analytical and Statistical Applications.mp4

08:43

8. Exercise 4.mp4

03:54

9. Closing.mp4

04:55

10. Section Quiz.html

Description

Explore the key features of Microsoft Excel that makes it such an essential tool for Data Analytics

What You'll Learn?

Learn the fundamentals of Excel spreadsheets, from their layout to the applications
Understand and apply Excel formulas and functions and apply techniques to recognize and avoid formula errors
Identify data attributes and view, enter, and format data types in Excel
Sort data and apply filters, including advanced filtering techniques
Create problem statements to tackle complicated “OR” criteria
Create Pivot tables and charts and work with Excel charts, including clustered columns, line graphs, and waterfalls
Understand and use the What-If Analysis toolkit which includes the Scenario Manager, Goal Seek, and Data Table functions
Utilize database functions created specifically to work with large datasets
Use the Analysis ToolPak to calculate basic statistical concepts such as correlation and covariance
Compute descriptive statistics and moving averages and apply exponential smoothing techniques
Utilize rank and percentile options and generate histograms

Who is this for?

Microsoft Excel novice

People who want to start their careers in data analytics

Those who want to utilize Excel for data analysis and explore the Analysis Toolpak

More details

Description
This course includes downloadable instructor files to work with and follow along.

One of the most rapidly developing areas in today's market is data analyticsâ€”it is also an area in which businesses are struggling to find qualified staff. In this course, we will explore the key features of Microsoft Excel that make it such an essential tool for data analytics.

Using the data analysis and visualization features that are native to Excel, this course will show you how to extract maximum value most efficiently from the information your organization collects. This course starts off with the fundamentals, walking you through all you need to understand about spreadsheets, from layout to applications. We will cover a variety of topics, including exploring formulas, cleaning data, and identifying data attributes.

This course demonstrates how to analyze data using Excel and tackle complicated criteria. We will use Excel charts to depict data, relationships, and potential outcomes. In addition, we will also be discussing how to use the what-if functionality of the Analysis ToolPak add-in that comes with Excel. Each section includes practical examples that show how to apply these techniques to real-world business problems.

After finishing this course, students will be able to:
Describe the fundamentals of Excel spreadsheets, from their layout to the applications
View, enter, and format data types in Excel
Understand and apply Excel formulas and functions
Import file data and remove duplicates
Identify data attributes
Sort data and apply filters, including advanced filtering techniques
Apply Concatenation and Sum-if formulas to analyze data sets
Create problem statements to tackle complicated â€œorâ€ criteria
Create Pivot tables and charts
Work with Excel charts, including clustered columns, line graphs, and waterfalls
Utilize database functions created specifically to work with large datasets
Apply techniques to recognize and avoid formula errors
Understand and use the What-If Analysis toolkit which includes the Scenario Manager, Goal Seek, and Data Table functions
Use the Analysis ToolPak to calculate basic statistical concepts such as correlation and covariance
Compute descriptive statistics and moving averages and apply exponential smoothing techniques
Utilize rank and percentile options and generate histograms.

This course includes:
4+ hours of video tutorials
36 individual video lectures
Course files to follow along
Certificate of completion
Who this course is for:
Microsoft Excel novice
People who want to start their careers in data analytics
Those who want to utilize Excel for data analysis and explore the Analysis Toolpak

User Reviews

Rating

average 0

Total votes0

Focused display

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 8,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 630,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.