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
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 Should Attend!
- Any one wants to develop his capabilities in Excel
- Accountants, analysts and marketing officers
- Teachers and graduate students
Tags
- Data Analysis
- Excel Charts
- Excel Formulas and Functions
Subscribers
171
Lectures
17
TAKE THIS COURSE
