Excel Data Analysis and Problem Solving

Course details

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