Learn your way! Get started

Microsoft Excel 2019 Data Analysis, Part 4 of 4: Analytical Tools

with experts Kari Hoien, Sondra Nelson


Watch trailer


Course at a glance


Release date 8/30/2020
Level Intermediate
Runtime 0h 53m
Closed captioning N/A
Transcript N/A
eBooks / courseware N/A
Hands-on labs N/A
Sample code Included
Exams Included


Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More



Course description

Explore an amazing set of topics in analysis and forecasting in this course which covers topics including Goal Seek, Scenarios, Solver, and Data Analysis. Learn to use Goal Seek’s capabilities when a value is unknown, explore Scenarios which allow for multiple views of how data changes based on set values, use the Solver to generate multiple solutions using objectives, variables and constraints, and explore the instant data analysis tools to quickly get what you need in order to enhance your data.

Prerequisites

This course is designed for students with a base knowledge of Excel and want to learn higher-level skills to display data and perform functions. Students should know how to perform calculations, modify worksheets, format worksheets, print workbooks and manage workbooks.

Meet the experts

I’m Kari Hoien. I have a Bachelors degree in Business and Accounting from Concordia College in Moorhead, I was a CPA and went on to get my Masters in Education Technology from Pepperdine in Malibu, California. I have been working as a trainer and consultant for Microsoft Office products for more than 20 years and I’ve helped clients in almost every industry in a wide range of different capacities and applications. I have taught thousands of people how to use Microsoft Office apps (Excel, Access, Outlook, PowerPoint etc). I have done stand-up classroom style training, virtual training, on-demand training, self-paced training, executive training, one-on-one training – you name it – I've probably done it. I LOVE teaching people how to use these everyday programs better, ways to save time so you can work SMARTER and have more time for the things that you love. Thanks so much for allowing me to help you learn.

Sondra Nelson is a Microsoft Certified Trainer and has been teaching Microsoft Office for over 15 years. She has teaching and consulting experience with high school students, college students and corporate employees.

Course outline



Analytical Tools

Goal Seek (07:28)
  • Introduction (00:28)
  • Goal Seek (00:58)
  • Calculate Interest Rate (01:33)
  • Demo: Calculate Interest Rate (02:05)
  • Voting Results (00:45)
  • Demo: Voting Results (01:19)
  • Summary (00:16)
Scenarios (17:46)
  • Introduction (00:21)
  • Scenarios (00:44)
  • Scenarios Demo (00:28)
  • Demo: Scenarios (01:03)
  • Worst-Case Scenario (00:44)
  • Demo: Worst-Case Scenario (02:17)
  • Worst-Case Scenario Continued (01:02)
  • Demo: Worst-Case Scenario Continued (01:32)
  • Best-Case Scenario (01:27)
  • Demo: Best-Case Scenario (04:05)
  • Scenario Summary (01:10)
  • Demo: Scenario Summary (02:28)
  • Summary (00:19)
Solver (12:20)
  • Introduction (00:15)
  • Solver (00:36)
  • Using the Solver (02:18)
  • Demo: Using the Solver (05:16)
  • Solver Answer Report (01:14)
  • Demo: Answer Report (02:21)
  • Summary (00:17)
Instant Data Analysis (11:36)
  • Introduction (00:17)
  • Instant Data Analysis (00:40)
  • Instant Data Analysis Formatting (00:35)
  • Demo: Formatting and Charts (00:00)
  • Instant Data Analysis Charts (03:31)
  • Instant Data Analysis Totals (00:46)
  • Instant Data Analysis Tables (00:32)
  • Instant Data Analysis Sparklines (00:43)
  • Demo: Totals, Tables, and Sparklines (04:15)
  • Summary (00:14)
Analysis and Formatting (04:10)
  • Introduction (00:08)
  • Demo: Analysis and Formatting (03:54)
  • Summary (00:08)