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
$13.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
Course Gallery
Charts
Students
Price
Rating & Reviews
Enrollment Distribution
Related Topics
1478304
udemy ID
21/12/2017
course created date
08/02/2020
course indexed date
Bot
course submited by