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 Information3- Clean Data vs Dirty Data4- Why would you want to convert a range into an Excel table5- Relative vs Absolute Cell Reference6- Data Validation7- Conditional Formatting8- Useful Excel Functions for Data AnalysisSumIf Function CountIf FunctionAverageif FunctionXlookup FunctionSubtotal FunctionSort FunctionFilter FunctionTake Function9- Pivot TablesBuilding dashboards to analyze data10- Power QueryGetting familiar with the "Data" tabGetting familiar with Power Query RibbonRemove ColumnsChoose ColumnsRemove RowsKeep RowsUsing Power Query to Transform/Clean - TextUsing Power Query to Transform/Clean - NumbersUsing Power Query to Transform/Clean - Date and Time11- Get Data from a Folder using Power Query12- Get Data from a latest file in a folder Using Power Query.