Excel Data Analysis and Problem Solving
Be an Excel expert in less than 5 hours
4.31 (24 reviews)
175
students
4.5 hours
content
Feb 2018
last update
$19.99
regular price
What you will learn
- Dealing with formulas and functions in Excel
- Advanced search, sorting and filtering mechanism
- Dealing with tables and charts and plot math functions
- Using consolidate to merge data
- Create pivot table and use it in data analysis
- Using Power Query and Power pivot table
- Using what-if tools and Solver to solve problems
- Record a macro and make a button to use it
- Use the analysis ToolPak such as ANOVA test, descriptive statistics and histogram chart
- Create Key Performance Indicators (KPI)
- Create Dashboard from scratch
Screenshots
Related Topics
1478304
udemy ID
12/22/2017
course created date
2/8/2020
course indexed date
Bot
course submited by