Please ensure Javascript is enabled for purposes of website accessibility
Excel Data Analysis Tools
5.0( 1 REVIEWS )
1 STUDENTS
1h 10m
##### Thomas

This course is designed for those interested to learn Excel’s built-in data analysis tools. Learn about Scenario Manager, Forecast Sheet, and formulas such as If, Sumif, Countifs, and more.

Course Skill Level
Beginner
Time Estimate
1h 10m

### Instructor

##### Thomas

Tom Fragale is a computer professional w/over 30 years of experience. He is a Microsoft Certified Trainer. Available for webinars and 1-on-1 training.

Who this course is for:

• Students looking for an engaging and highly interactive approach to Excel data analysis training
• Excel users looking to build strong analytical thinking skills
• Anyone looking to pursue a career in data analysis

What you’ll learn:

• Tracing Formulas
• Using the Scenario Manager
• Goal Seek
• Solver
• Data Tables
• Data Analysis Tools
• Forecast Sheet
• Sumif, Countif, Averageif, Sumifs, and Countifs formulas
• If, And, Or, and Nested If formulas

Requirements:

• Microsoft Excel
• Basic Excel knowledge

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.

Our Promise to You

By the end of this course, you will have learned to use Excel’s data analysis tools.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

### Course Curriculum

 Section 1 - Excel Data Analysis Tools Student File 00:00:00 Tracing Formulas 00:00:00 Using The Scenario Manager 00:00:00 Goal Seek 00:00:00 Solver 00:00:00 Data Tables 00:00:00 Data Analysis Tools 00:00:00 Forecast Sheet 00:00:00 Sumif, Countif, Averageif, Sumifs, And Countifs Formulas 00:00:00 If, And, Or, And Nested If formulas 00:00:00

## 5.0

5.0
1 Ratings
1. Jeannette M Robinson March 2, 2021 at 05:39 AM

### Great lesson

5.0

I have used Excel for years and didn’t know a lot of what of the shortcuts that Tom Fragale was showing. What a great course. Thank you for all of the great information.