Master Data Analysis Using Excel Powerful Tools & Functions
Data Analysis With Excel
Ratings 0.00 / 5.00
What You Will Learn!
- Data Cleaning and Transformation
- Power Query
- Relative and Absolute cell references
- Sumif, Countif, Averageif, Xlookup, Filter, Sort, Subtotal, and Take Functions in Excel
- Conditional formatting in Excel
- Data Validation
- Pivot tables
- Data Visualisation
Description
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
Who Should Attend!
- This course is suitable for those who are interested in pursuing a career in data analysis or data science, as well as anyone looking to use Excel for data analysis in their own domain.