Introduction To Data Analytics With Microsoft Excel

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

Requirements

Microsoft Excel for Windows installed and ready to use on your computer

Basic knowledge of Microsoft Excel is helpful but not required. This course is suitable for absolute beginners

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 applicationsView, enter, and format data types in ExcelUnderstand and apply Excel formulas and functionsImport file data and remove duplicatesIdentify data attributesSort data and apply filters, including advanced filtering techniquesApply Concatenation and Sum-if formulas to analyze data setsCreate problem statements to tackle complicated “or” criteriaCreate Pivot tables and chartsWork with Excel charts, including clustered columns, line graphs, and waterfallsUtilize database functions created specifically to work with large datasetsApply techniques to recognize and avoid formula errorsUnderstand and use the What-If Analysis toolkit which includes the Scenario Manager, Goal Seek, and Data Table functionsUse the Analysis ToolPak to calculate basic statistical concepts such as correlation and covarianceCompute descriptive statistics and moving averages and apply exponential smoothing techniquesUtilize rank and percentile options and generate histograms.This course includes:4+ hours of video tutorials36 individual video lecturesCourse files to follow alongCertificate of completion

Overview

Section 1: Course Introduction

Lecture 1 Introduction to the Course

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Instructor and Exercise Files

Lecture 4 Navigating Excel

Lecture 5 Data Types in Excel

Section 2: Using Excel Spreadsheets for Data Analysis

Lecture 6 Viewing and Entering Data

Lecture 7 Formatting and Data Types in Excel

Lecture 8 Excel Formula Basics

Lecture 9 Exploring Excel Functions

Lecture 10 Referencing Data in Formulas

Lecture 11 Exercise 1

Section 3: Cleaning and Managing Data

Lecture 12 Introduction to Data Quality

Lecture 13 Importing File Data

Lecture 14 Removing Duplicate Data

Lecture 15 Identifying Data Attributes

Lecture 16 Cleaning Data

Lecture 17 Exercise 2

Section 4: Analyzing Data

Lecture 18 Sort and Filter Data

Lecture 19 Concatenation and SUMIF

Lecture 20 Tackling Complicated "OR" Criteria

Lecture 21 Summarizing Data Using Pivot Tables

Lecture 22 Creating a Pivot Chart

Lecture 23 Working with Excel Charts

Lecture 24 Analysing Financial Data

Lecture 25 Waterfall Charts

Lecture 26 Conditional Formatting

Lecture 27 Using Database Functions

Lecture 28 Evading Formula Errors

Lecture 29 Exercise 3

Section 5: What-If Analysis and Analysis ToolPak

Lecture 30 Scenario Manager in What-If Analysis

Lecture 31 Data Tables in What-If Analysis

Lecture 32 Goal Seek in What-If Analysis

Lecture 33 Loading the Analysis ToolPak

Lecture 34 Correlation and Covariance in Analysis ToolPak

Lecture 35 Descriptive Statistics, Moving Average and Exponential Smoothing

Lecture 36 Additional Analytical and Statistical Applications

Lecture 37 Exercise 4

Lecture 38 Closing

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