Introduction to Data Analytics with Microsoft Excel

سرفصل های دوره

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

1. Course Introduction

1. Introduction to the Course

2. WATCH ME Essential Information for a Successful Training Experience

3.1 Data Analytics in Excel Course and Exercise Files.zip

3. DOWNLOAD ME Instructor and Exercise Files.html

4. Navigating Excel

5. Data Types in Excel

6. Section Quiz.html

2. Using Excel Spreadsheets for Data Analysis

1. Viewing and Entering Data

2. Formatting and Data Types in Excel

3. Excel Formula Basics

4. Exploring Excel Functions

5. Referencing Data in Formulas

6. Exercise 1

7. Section Quiz.html

3. Cleaning and Managing Data

1. Introduction to Data Quality

2. Importing File Data

3. Removing Duplicate Data

4. Identifying Data Attributes

5. Cleaning Data

6. Exercise 2

7. Section Quiz.html

4. Analyzing Data

1. Sort and Filter Data

2. Concatenation and SUMIF

3. Tackling Complicated OR Criteria

4. Summarizing Data Using Pivot Tables

5. Creating a Pivot Chart

6. Working with Excel Charts

7. Analysing Financial Data

8. Waterfall Charts

9. Conditional Formatting

10. Using Database Functions

11. Evading Formula Errors

12. Exercise 3

13. Section Quiz.html

5. What-If Analysis and Analysis ToolPak

1. Scenario Manager in What-If Analysis

2. Data Tables in What-If Analysis

3. Goal Seek in What-If Analysis

4. Loading the Analysis ToolPak

5. Correlation and Covariance in Analysis ToolPak

6. Descriptive Statistics, Moving Average and Exponential Smoothing

7. Additional Analytical and Statistical Applications

8. Exercise 4

9. Closing

10. Section Quiz.html

235,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training