By the end of this course, you will be able to
How to obtain knowledge on data cleansing, manipulation, and extracting information out of a dataset. Then you will go through Pivot-Tables and its features.
How to perform data analysis using Microsoft Excel, then you will gain an immersive understanding of data (Definition, Categories, Types, and Qualities).
How to use different types of charts, write advanced formulas including lookup functions and Dynamic Arrays, and how you can use spreadsheets as a data analysis tool.
Course details
- 2 h 28 m/43 lessons
- Last updated: 11/10/2022
- Course completion certificate
Course Content
Introduction
What is Data
Data Types of Excel
Auto-Filling
Navigation
Introduction
What is Data
Data Types of Excel
Auto-Filling
Navigation
How to download a free dataset
Traits of Quality Data
Duplicate Values and Blanks
TRIM
Proper, Upper & Lower
Nested Functions
Data Type Formatting
Currency Data Type Formatting
Filter and Sort
Concatenation
Text To Column
Flash Filling
Substitute
Formatting Data as a Table
Mean-Median-Mode
Name-Labeling
SUM
SUMIF
Operators
Minimum and Maximum Values Function
Count Functions
If-Ifs and Nested If
VLOOKUP
HLOOKUP
Introduction to Pivot-Tables
How to create a pivot-table
Formatting Data in a Pivot-table
How to Apply calculations in a pivot-table
How to sort data in a Pivot-Table
Recommended Pivot-Tables
Slicers
Bar Chart
Column Chart
Line Chart
Pie Chart
How to Create a Pivot-Chart
How to Apply a Slicer to a Pivot-Chart
How to Style your Pivot-Chart
About this course
Many do use Microsoft Excel for data analysis or data analytics as it is a remarkable tool for many businesses. It has " Pivot-Tables and Pivot-Charts," features used to analyze and visualize data. Excel has over 400 built-in functions that cover all aspects depending on your business case, many built-in chart types, interactive dashboards, and click-based software; also, it's compatible with other Microsoft Office programs. Throughout this course, you will exploit Excel capabilities to perform data analysis using data cleansing, data manipulation formulas, pivot tables, and pivot charts.
Course requirements and prerequisites
There are no requirements for this course. Your interest in the topic and your commitment to learning are all you need to achieve the utmost benefit from this course.
Mentor
Moustafa Ahmed
Data Analyst
2,212 Learners
2 Course