Office Productivity
Microsoft
Excel Formulas and Functions
Excel Data Analysis and Problem Solving
3.6 (22 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
163 students enrolled

Excel Data Analysis and Problem Solving

Be an Excel expert in less than 5 hours
3.6 (22 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
163 students enrolled
Created by Mofeed Abouseafa
Last updated 2/2018
Arabic
English
Preview this course
Excel Data Analysis and Problem Solving
Current price: $56.99 Original price: $94.99 Discount: 40% off
2 days left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 17 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Expand all 17 lectures 04:39:54
+ – Introduction to Excel
4 lectures 01:10:17
Formulas and functions
Preview 21:12
VLOOKUP function
22:51
Advanced filter
16:21
Consolidate
09:53
+ – Charts and Graph
2 lectures 28:59
Charts
16:06
Plot Math Functions
12:53
+ – Pivot Tables & Power Query
3 lectures 01:03:43
Pivot Table from one table
09:39
Using Pivot Table with Power Query
26:18
Power Pivot Table
27:46
+ – What-if Analysis and Solver
3 lectures 41:40
Goal Seek
10:46
Data Table
10:20
Solver
20:34
+ – Analysis ToolPak
3 lectures 36:59
Descriptive Statistics
15:07
Histogram
11:25
Anova (Single Factor)
10:27
+ – Dashboard and KPI Measure
2 lectures 38:16
Measures and KPIs
09:40
Dashboard
28:36