 |
Excel Forecasting and What-If Analysis Onsite Group Training Course |
Course Description:Overview
- This course explores Excel’s advanced forecasting and What–If Analysis tools including Solver, Scenarios, and Forecast functions.
- Students will learn to use Excel to create projections, analyze multiple outcomes, and structure decision–support models.
- The class also covers Excel Data Model and Power Query for managing larger data sets.
- Teach students how to use Excel’s Forecast Sheet and functions to project trends and future values.
- Develop skills in What–If Analysis tools such as Goal Seek, Solver, and Data Tables.
- Enable the use of Power Query and Excel Data Model for advanced data handling and KPI creation.
- Individuals responsible for creating forecasts and performing scenario analysis in Excel
- Professionals needing to support strategic planning with data modeling
- Analysts and business managers working with projections and decision models
- Business professionals, analysts, and managers
- Finance, operations, and planning teams seeking to build and analyze models
- Anyone who wants to enhance their Excel proficiency for forecasting and analysis tasks
Excel Forecasting and What-If Analysis - Course Syllabus
Warning: include(oisyllabus/onlc-excel365-2.php.php): failed to open stream: No such file or directory in /home/busin148/public_html/includes/microsoft-onsite-instructor-classes.php on line 49
Warning: include(oisyllabus/onlc-excel365-2.php.php): failed to open stream: No such file or directory in /home/busin148/public_html/includes/microsoft-onsite-instructor-classes.php on line 49
Warning: include(): Failed opening 'oisyllabus/onlc-excel365-2.php.php' for inclusion (include_path='.:/opt/cpanel/ea-php74/root/usr/share/pear') in /home/busin148/public_html/includes/microsoft-onsite-instructor-classes.php on line 49
How On-Site Training Works
How On-Site Training Works
- Discuss your team's educational needs with a BCS representative.
- Schedule class date(s) that fit your team's availabilty.
- Professional Trainer will conduct the class at your facility or online.
- We provide the instructor, instructor travel and lodging, training manuals and digital practice for each student.
- You provide the meeting/conference room, student xomputers with correct software installed and a projector for the instructor to use.
- Usually a two-week lead time to schedule a class.
- Classes normally run from 9am-4:30pm local time, but can be adjusted to fit your schedule.
- 1 Hour Lunch Break, and Two 15-minute Break
On-Site excel Training Packages
Small Group Package (up to 6 students)
- A Professional Instructor will come to your office and train your students
- Up to 6 students can attend the class for the flat rate course price of $1800/day
- Additional students can be added for $125/person/day
- Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
- Course is scheduled based on dates you provide (Subject to instructor availability)
- We usually require about 2-weeks lead time to arrange a training session
- Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
- Two 15 minute breaks and one hour long break for lunch
Total Cost for 6 students: $1800/day (Flat Rate)
Medium Group Package (up to 12 students)
- A Professional Instructor will come to your office and train your students
- Up to 12 students can attend the class for the flat rate course price of $2500/day (over 31% off our Individual Training rates)
- Additional students can be added for $100/person/day
- Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
- Course is scheduled based on dates you provide (Subject to instructor availability)
- We usually require about 2-weeks lead time to arrange a training session
- Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
- Two 15 minute breaks and one hour long break for lunch
Total Cost for 12 students: $2500/day (Flat Rate)
Large Group Package (up to 18 students)
- A Professional Instructor will come to your office and train your students
- Up to 18 students can attend the class for the flat rate course price of $3100 (over 43% off our Individual Training rates)
- Additional students can be added for $75/person/day
- Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
- Course is scheduled based on dates you provide (Subject to instructor availability)
- We usually require about 2-weeks lead time to arrange a training session
- Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
- Two 15 minute breaks and one hour long break for lunch
Total Cost for 18 students: $3100/day (Flat Rate)
Related On-Site Training Courses
excel Self Paced On-Demand Courses
On-Site Training Request
Please complete the information request form below, and one of our representatives will contact you within one business day.
"Great class!! Clear explanations of complex topics. I could repeat lessons as many times as needed to make sure I mastered them."
- Thomas L(Akron, OH)
