Mastering Data Analysis in Excel
Unlock the power of Excel to utilize its analytical tools from Vlookup to Pivot Table - no matter your experience level
4.38 (555 reviews)
6 456
students
5 hours
content
Sep 2022
last update
$13.99
regular price
What you will learn
Learn different techniques for data analysis that can be easily implemented in Excel 2010, 2013, 2016, and 2019
Transform Data into insight using powerful methods of analysis, techniques and tools
Bring your skills of Excel from Beginner or Intermediate levels to Expert level
Work with real-world data sets and solve real-world tasks
Learn 60+ frequently used functions in Excel (Logical, Text, Date, Math, Statistical, Financial)
Execute aggregation commands (SUM, COUNT, SUBTOTAL, etc.) and their conditional variants (SUMIFS, COUNTIFS, AVERAGEIFS, etc.) to summarize data sets
Combine data from multiply worksheets by VLOOKUP, INDEX and MATCH functions
Perform scenario and sensitivity analysis by Goal Seek, Data Table and Scenario Manager tools
Learn best practices for data analysis and data presentation using PivotTable and PivotChart tools
Perform statistical analysis by using Data Analysis ToolPak including Linear Regression
Learn best practices for the design and setup of interactive dashboards
Work in Excel faster by using hot key shortcuts
Screenshots
2263844
udemy ID
10/03/2019
course created date
16/06/2019
course indexed date
Bot
course submited by