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. Read more.
Tom Fragale is a computer professional w/over 30 years of experience. He is a Microsoft Certified Trainer. Available for webinars, Live Onsite Training and 1-on-1 training. He is also a published author with a book on Pivot Tables published by Wiley Publishing.
Buy this course for $199 $10
and keep lifetime access.
Access all courses in our library for only $9/month with All Access Pass
About This Course
Who this course is for:
- Excel users who want to learn more about Excel’s built-in data analysis tools
- 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
- The Solver Add-in
- 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.
Get started today and learn more about Excel.
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 | ||
About This Course
Who this course is for:
- Excel users who want to learn more about Excel’s built-in data analysis tools
- 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
- The Solver Add-in
- 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.
Get started today and learn more about Excel.
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 | ||
Course Review
4.5
2 RatingsRelated Courses
Are you interested in higher education?
All Rights Reserved
Great Information
Excellent presentation, excellent information
Great lesson
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.