Discover Classes. Earn Rewards.
Excel Forecasting and What-If Analysis is unfortunately unavailable

Thankfully we have 61 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.

Excel Forecasting and What-If Analysis

at ONLC Training Centers - Schaumburg

(7)
Course Details
Price:
$395
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Schaumburg, Suburbs
1320 Tower Rd 1st Fl
At N Wiley Rd
Chicago, Illinois 60173
(Map)
Important:
All classes are live, hands-on training via remote instructor.
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this excel class:

Excel has many built-in features and add-ons that will make it easier to develop complex models that incorporate What-If Analysis (using either Scenarios, Solver, or Data Tables). In addition, forecasts and trend lines can be easily projected and customized using Excel’s Forecast functions. Finally, the Excel Data Model is reviewed. This advanced feature allow you to access huge data sets within Excel.


Target Student

The course is for individuals who are responsible for creating forecasts and doing what-if analysis with Excel.


Prerequisites

Introduction to Excel class or equivalent skills and a general understanding of the issues related to forecasting and what-if analysis.

Version Note
While this class is being taught using the 2016 version of the Excel software, almost all topics will be applicable to users of Excel 2013. As a result, this class will be beneficial to users of either Excel 2016 or Excel 2013.


Course Outline

Forecasting
Using the Forecast Sheet
Modifying Options
Using Forecast Functions

Using the Quick Analysis Tool
Formatting Options
Creating Charts
Applying Totals
Creating Tables
Adding Sparklines

Using What-If Analysis
Working with Scenarios
Creating Data Tables
Using Goal Seek

Using Solver
Adding the Solver Add-in
Define a Problem Using Solver
Solving a Problem
Solver for Capital Budgeting
Solver for Financial Planning
Solver to determine Optimal Product Mix
Perform What-If Analysis with the Solver Tool

Gathering Data
Using the Power Query Editor
Appending Data
Merging Data
Transforming Data

Using the Excel Data Model
Viewing a Data Model
Getting Data
Linking Tables
Using the Model
Creating Calculated Columns
Creating Measures
Creating KPI’s


Still have questions? Ask the community.

Refund Policy
Student cancellation requests made 14 calendar days or less before the class starts will be charged 100% of the course fee and are not entitled to a refund. The student has one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.

Map

Google Map

ONLC Training Centers

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 3950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at ONLC Training Centers (4)

School: ONLC Training Centers

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Chicago educator.

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

61 Top Choices

Excel for Business Fundamentals

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Get started in Excel with this fundamental Excel course. Get comfortable using Excel and learn to boost your productivity with formulas, charts, and formatting techniques. Master the core Excel functions in this one-day course. Learn calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing....

Thursday Dec 3rd, 10am - 5pm Eastern Time

Intermediate Excel for Business

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Split and join text, create drop-down menus, and sort and filter data. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of this class,...

Friday Dec 4th, 10am - 5pm Eastern Time

Advanced Excel for Business

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Master advanced Excel techniques in this hands-on training. Learn how to use the more advanced tools in Excel like What-If Analysis, INDEX-MATCH, macros, and more. Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with...

Monday Dec 7th, 10am - 5pm Eastern Time

Intermediate Microsoft Excel

This class is temporarily being offered remotely.

at NYC Career Centers - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal time-saving tricks like Paste Special, keyboard...

Friday Dec 4th, 10am - 5pm Eastern Time

Microsoft Excel Essentials

This class is temporarily being offered remotely.

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

This live instructor-led hands-on course will cover basic to intermediate topics in Excel. All students will be given a computer to follow along and a custom training manual with all the steps and description of Excel functions. The topics covered in this course can be applied to Excel 2007, 2010, 2013, 2016 & 2019. This course is great for someone...

Monday Jan 11th, 10am - 6pm Eastern Time

Microsoft Excel Expert (Level 3)

This class is temporarily being offered remotely.

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

We are offering a Microsoft Excel Expert Course. The class will teach you how to create Marco's, conditional formatting, securing your workbooks, expert functions, auditing worksheets, analyzing data, and importing, exporting data.  This course is perfect for someone who uses Microsoft Excel already, or took our Excel essentials course and wants...

Wednesday Jan 13th, 10am - 6pm Eastern Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

The bootcamp is designed to provide students with a general overview of Excel topics and specifically more knowledge of several different functions. It combines most of the material from the two workshops into an intense one-day session. Given the short timeframe and large amount of topics covered, students are expected to be able to learn quickly....

Friday Dec 11th, 11am - 5pm Eastern Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Online, Massachusetts 00000

The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring the COVID-19 situation very carefully and are adjusting delivery of our programs. Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online...

Friday Dec 11th, 11am - 5pm Eastern Time

Virtual Excel Beginning Class

This class is temporarily being offered remotely.

at Computers Etc Software Training Center - Online

Build formulas to add, subtract, multiply, divide, average, and figure percentages. Create different spreadsheets from scratch, learn many tips and shortcuts, as well as Charts. What you will learn: Create Formulas that add, subtract, multiply divide, etc: Learn how to create Formulas that add, subtract, multiply, and divide numbers, calculate...

Thursday Dec 3rd, 9am - 4pm Pacific Time

Excel Dashboards for Interactive Reporting - Online

This class is temporarily being offered remotely.

at Colorado Free University - Online 00000

A dashboard is a single screen used for reporting that displays charts, tables, and other visual data components on a related subject. Learn how to create Dashboards that will transform business data into actionable information. You will: Create an interactive, dynamic information source within Excel without creating a monster workbook or submitting...

Thursday Dec 3rd, 9am - 4pm Mountain Time

Microsoft Excel Level 1

This class is temporarily being offered remotely.

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on beginner class is suitable for Excel 2010, 2013 and 2016 users. You will learn to create, modify, format and print Excel worksheets and workbooks. You will learn basic formulas and functions, how to manipulate data, and how to add charts. Live face-to-face instructor. No minimum class size - all classes guaranteed to run! This course...

Monday Dec 7th, 9am - 4:30pm Pacific Time

Microsoft Excel Level 2

This class is temporarily being offered remotely.

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on intermediate class is suitable for Excel 2010/2013/2016 users. You will learn to share data across multiple worksheets and workbooks, work with named ranges, filter and sort data, use PivotTables and PivotCharts, conditional formatting, advanced charting, and how collaborating with others.  Live face-to-face instructor. No minimum...

Tuesday Dec 8th, 9am - 4:30pm Pacific Time

Microsoft Excel Level 3

This class is temporarily being offered remotely.

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on class is suitable for Excel 2013, 2016, 2019 and 365 users. On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis,...

Wednesday Dec 9th, 9am - 4:30pm Pacific Time

Financial & Statistical Applications in Microsoft Excel

This class is temporarily being offered remotely.

at Baruch College - CAPS - Online 00000

This course is designed for Excel users who would like develop their quantitative skills for managerial decision making. Students will learn how to use present value, Internal Rate of Return, Standard Deviation and more. It features a mix of case studies, individual exercises and group activities. This course is appropriate for all students who wish...

Saturday Dec 5th, 9:30am - 5:30pm Eastern Time

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

Monday Dec 7th, 9pm - 11:55pm Eastern Time

Excel VBA Macros: Write Custom Excel Macros in VBA

This class is temporarily being offered remotely.

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

Learn to create automated custom Excel applications using VBA. This two-day VBA Programming course helps advanced Excel users (Windows only) develop new skills writing and debugging powerful VBA code to automate workbook operations, create interactive forms, insert calculations and handle run-time errors. Prerequisites: This class is ideally suited...

Thursday Dec 17th, 9am - 4pm Pacific Time

  (2 sessions)
$895

2 sessions

Excel PivotTables: Data Summarization and Analysis

This class is temporarily being offered remotely.

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

A PivotTable is Excel's most powerful data summarization tool. In this three-hour session for Windows and Mac users, you will learn what kinds of data works best for PivotTables and how to prepare your data. You will create PivotTables based on various data sources, summarize data by multiple categories using sum, average and count, format the PivotTable,...

Saturday Dec 19th, 9am - 12pm Pacific Time

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, San Francisco, California 00000

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

Monday Dec 7th, 6pm - 9pm Pacific Time

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online, Online, California 00000

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

Monday Dec 7th, 6pm - 9pm Pacific Time

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online , Denver, Colorado 00000

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel.  This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help...

Monday Dec 7th, 7pm - 10pm Mountain Time

Loading...