Excel Data Analysis and Problem Solving

Excel Data Analysis and Problem Solving

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

Be an Excel expert in less than 5 hours

Url: View Details

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

Rating: 3.75

Level: All Levels

Duration: 4.5 hours

Instructor: Mofeed Abouseafa