Microsoft Excel - Data Analytics Course

[Farid]

The Ultimate Microsoft Excel Data Analytics Course
Published 7/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.79 GB | Duration: 4h 15m
This course will teach you advanced Excel techniques all aimed at helping you make sense of the numbers in your business

What you'll learn
Learn and Understand Data Manipulation using Excel
Learn How to Create Formulas to Help you Analyze Data
Learn and Understand Data Cleansing
Learn and Understand Tables in Excel
Learn various ways to model data for businesses
Build impressive tables and combine datasets using Excel's built-in functionality
Learn basics of Pivot Tables and Charts
Clean and prepare your data
Create a basic Excel Pivot Table and format numbers in it
Use multiple fields and dimension, and methods of aggregation
Create Pivot Charts based on Pivot Table data
Learning Power Query, Power Map and Power Pivot
Requirements
You have an attitude to learn while having fun :)
Basic Excel knowledge is helpful but not required
Description
Welcome to this course. Microsoft Excel is one of the easiest to use data analysis tools you will ever come across. We need to analyze data these days since we live in a very data-driven world. Therefore, data is important in any business, whether you are looking for trends or forecasting future business needs. As there is a lot of importance placed on data analysis, you must have the relevant skills to analyze data effectively. Microsoft Excel has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. Its simplicity and powerful features has made it the go to tool for all your data needs. Complex operations with Excel, such as creating charts and graphs, visualization, and analyzing data make it a great tool for managers, data scientists, financial data analysts, and those who work closely with data. Learning data analysis and will help you bring your data skills to the next level. We'll start with the basic topics in Microsoft Excel. Then we will create workbooks; enter data into; explore page setup and print options; work with rows, columns, and cells; learn how the Cut, Copy, and Paste option works; understand functions and formulas; and also get introduced to PivotTables, logical, and lookup formulas. After this, we will move towards advanced concepts such as lookup and advanced lookup functions, financial functions including calculating interest and depreciation, statistical functions, learning how to connect to other workbooks and datasets outside of Excel, and creating awesome visualizations using sparklines and data bars. You will gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information.In this course, you'll learn:Learn and Understand Data Manipulation using ExcelLearn How to Create Formulas to Help you Analyze DataLearn and Understand Data CleansingLearn and Understand Tables in ExcelLearn various ways to model data for businessesBuild impressive tables and combine datasets using Excel's built-in functionalityLearn basics of Pivot Tables and ChartsClean and prepare your dataCreate a basic Excel Pivot Table and format numbers in itUse multiple fields and dimension, and methods of aggregationCreate Pivot Charts based on Pivot Table dataLearning Power Query, Power Map and Power PivotAt the end of this course, you'll learn the skills required to be able to clean the data, put it in the Pivot Table, analyse the data efficiently, and keep it updated with a single click.

Overview

Section 1: Welcome

Lecture 1 Introduction

Section 2: Getting Started

Lecture 2 Introduction

Lecture 3 Data Manipulation - Learn How to Sort Data

Lecture 4 Data Manipulation - Learn How to Filter Data

Lecture 5 Data Manipulation - Learn How to Create a Chart to Manipulate Data

Section 3: Microsoft Excel - Learning Data Cleansing

Lecture 6 Introduction

Lecture 7 Learning Data Cleansing - Dealing With Duplicate Records

Lecture 8 Learning Data Cleansing - Learn How to Change the Case

Lecture 9 Learning Data Cleansing - Learn How to Replace Text

Lecture 10 Learn How to Remove Non Printing Characters & Spaces

Lecture 11 Learning Data Cleansing - Learn About Numbers Standardized

Lecture 12 Learning Data Cleansing - Learn How to Deal With Date & Time Issues

Lecture 13 Learning Data Cleansing - Learn How to Merge & Split Data Columns

Lecture 14 Learning Data Cleansing - Learn How to Rearrange Columns and Rows

Lecture 15 Section Summary

Section 4: Learning Tables in Microsoft Excel

Lecture 16 Introduction

Lecture 17 Understanding Tables - Formatting Your Tables

Lecture 18 Learn How to Manage Rows & Columns

Lecture 19 Understanding Table Data - Sorting & Filtering

Lecture 20 Learn How to Use the Totals Row

Lecture 21 Tables in Excel - Learn How to Add a Calculated Column

Lecture 22 Understanding Table Data - Learn How to Add Charts & Pivot Tables

Lecture 23 Learning Data Entry & Editing

Lecture 24 Filtering Your Data

Lecture 25 Learn About Advanced Filtering

Lecture 26 Section Summary

Section 5: Microsoft Excel - Learning Pivot Tables

Lecture 27 Introduction

Lecture 28 Learn About Recommended Pivot Tables

Lecture 29 Learn How to Rename Column Headings

Lecture 30 Learn How to Change The Data Function

Lecture 31 Learn How to Move a Pivot Table

Lecture 32 Understanding the Report Filter Option

Lecture 33 Pivot Table - Sorting and Filtering

Lecture 34 Learn How to Refresh a Pivot Table

Lecture 35 Pivot Table - Numbers

Lecture 36 Learning Pivot Table Styles

Lecture 37 Learning Multiple Fields

Lecture 38 Pivot Tables - Grand and Sub Totals

Lecture 39 Pivot Tables - Filtering Columns & Rows

Lecture 40 Pivot Tables - Additional Options

Lecture 41 Pivot Tables - Data Slicer

Lecture 42 Pivot Tables - SQL Server Database

Lecture 43 Section Summary

This course is for anyone who works with Microsoft Excel even if you've never used data analytics, Pivot Table and Pivot Charts

Microsoft Excel - Data Analytics Course (644.32 MB)

KatFile Link(s)

[To see links please register or login]

RapidGator Link(s)

[To see links please register or login]