Course Content
Introduction to Data Analytics
0/2
What is Data?
00:00
Download and Install 365
00:00
Microsoft Excel Introduction
0/2
Overview of Microsoft Excel
00:00
Flash Fill & Text to Column
00:00
Data Validation & Conditional Formatting
0/2
Data Validation in Excel
00:00
Conditional Formatting
00:00
Sorting, Filter and Duplicate Data
0/3
Sorting Up Data
00:00
Filter the Data
00:00
Remove Duplicate
00:00
Null, Blank and White Space
0/2
Working with Null
00:00
Working with Space
00:00
Learning Functions in Excel
0/6
Text Function
00:00
Logical Function
00:00
Date & Time Function
00:00
Numeric Function
00:00
Maths + Logical Function
00:00
What are Data Connectors
00:00
Basics of Power Query Editor
0/2
Overview of Power Query Editor
00:00
Uploading Data with Folders
00:00
Cleaning and Transforming Data
0/2
Text Tools in Power Query Editor
00:00
Cleaning Data in Power Query Editor
00:00
Custom and Conditional Column
0/2
Custom Column
00:00
Conditional Column
00:00
Data Modelling and Merging
0/2
Merge Queries
00:00
Data Modelling
00:00
Data Modelling Relationship
0/2
Creating Relationship
00:00
Hierarchy in Modelling
00:00
Pivot Table and Charts
0/3
Pivot Table After Modelling
00:00
Charts After Pivot Table
00:00
Slicers and Timeline
00:00
Data Analytics Guide with Microsoft Excel: Step by Step For From Scratch
Previous
Next
0% Complete