Master Data Analysis Using Excel Powerful Tools & Functions

About Master Data Analysis Using Excel Powerful Tools & Functions

This course will help you to visualize, analyze and gain insights from your data using excel functions such as SumIf, CountIf, AverageIf, Xlookup, Subtotal, Sort, Filter, Take, etc. and very powerful tools such as Pivot Tables, Dashboards, Power Query. You will develop employable data analyst skills, starting with the Excel basics, what it can do, and the data analysis steps you should follow.

Topics included in this course:

1- What is data analysis and why is it important.

2- Data vs Information

3- Clean Data vs Dirty Data

4- Why would you want to convert a range into an Excel table

5- Relative vs Absolute Cell Reference

6- Data Validation

7- Conditional Formatting

8- Useful Excel Functions for Data Analysis

SumIf Function

CountIf Function

Averageif Function

Xlookup Function

Subtotal Function

Sort Function

Filter Function

Take Function

9- Pivot Tables

Building dashboards to analyze data

10- Power Query

Getting familiar with the “Data” tab

Getting familiar with Power Query Ribbon

Remove Columns

Choose Columns

Remove Rows

Keep Rows

Using Power Query to Transform/Clean - Text

Using Power Query to Transform/Clean - Numbers

Using Power Query to  Transform/Clean - Date and Time

11- Get Data from a Folder using Power Query

12- Get Data from a latest file in a folder Using Power Query