Excel Data Analysis and Problem Solving
Be an Excel expert in less than 5 hours
Created by Mofeed Abouseafa
30-Day Money-Back Guarantee
What you'll 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
Requirements
- MS Excel
Description
This course includes a set of basic and advanced information and skills, through which you will be able to write formulas and functions, advanced filtering operations and conditional formatting and create pivot tables from tables in the data sheet and from external databases using Power Query and use Power Pivot tables to create Measures and KPI (Key Performance Indicator) And using What-if Tools and Solver to solving problems and using Analysis ToolPak to in Anova test, Discriptive Statistics, and Histogram and how to make a dashboard, through simplified examples and more ..
- All examples are attached with the course and you can download them
- All Lectures are translated to English
Who this course is for:
- Any one wants to develop his capabilities in Excel
- Accountants, analysts and marketing officers
- Teachers and graduate students
Course content
6 sections • 17 lectures • 4h 39m total length
- Preview21:12
- 22:51VLOOKUP function
- 16:21Advanced filter
- 09:53Consolidate
Instructor
Educational consultant