Excel Data Analysis Tools

Teacher

Ohi

Review

(0 review)

£425.00 £25.00

Description

In today’s world, we are all presented with huge amounts of data. It can be an overwhelming task to try to analyze the data to get some meaningful information. These built-in tools in Excel can help you analyze your data and get the results that you need.

Course Features

Lectures 10
Quizzes 0
Duration 10 weeks
Skill level All levels
Students 50
Assessments Yes

Tracing Formulas 1
- Lecture1.1
  
  Tracing Formulas
  05 min
Using the Scenario Manager 1
- Lecture2.1
  
  Using the Scenario Manager
  10 min
Goal Seek 1
- Lecture3.1
  
  Goal Seek
  05 min
Solver 1
- Lecture4.1
  
  Solver
  05 min
Data Tables 1
- Lecture5.1
  
  Data Tables
  15 min
The Solver Add-in 1
- Lecture6.1
  
  The Solver Add-in
  20 min
Data Analysis Tools 1
- Lecture7.1
  
  Data Analysis Tools
  05 min
Forecast Sheet 1
- Lecture8.1
  
  Forecast Sheet
  10 min
Sumif, Countif,Averageif, Sumifs, and Countifs formulas 1
- Lecture9.1
  
  Sumif, Countif,Averageif, Sumifs, and Countifs formulas
  20 min
If, And, Or, and Nested If formulas 1
- Lecture10.1
  
  If, And, Or, and Nested If formulas