Blogs and Posts

Excel “What-if Analysis Webinar
- By: Garry Feldman
- Date: January 29, 2016
U.S. Computer Connection, www.uscomputer.com, and Computer Training Solutions, www.computertrainingsolutions.biz presents Excel “What-if Analysis”.
We are frequently using values from our Excel workbooks to create formulas resulting from our raw data – ex: multiplying the sales volume by the price to arrive at the gross sales. Sometimes, we may want to arrive at a particular answer – how much I can afford to pay per month on a car loan, by working backwards to figure out how much I can afford to borrow, or for how long. This type of analysis is called What-If.
The webinar will deal with three types of what-if analysis.
• Goal Seek – which allows you to reach a specific answer by altering one variable.
• Solver – Allows you to reach an optimal or specific answer by modifying one or more variables.
• Scenarios – Look at potential alternatives using different choices for more than one variable – and saving a variety of scenarios.
Each function will be demonstrated and explained, and questions can be asked while you are on line at the Webinar. and Computer Training Solutions, www.computertrainingsolutions.biz presents Excel “What-if Analysis”.
We are frequently using values from our Excel workbooks to create formulas resulting from our raw data – ex: multiplying the sales volume by the price to arrive at the gross sales. Sometimes, we may want to arrive at a particular answer – how much I can afford to pay per month on a car loan, by working backwards to figure out how much I can afford to borrow, or for how long. This type of analysis is called What-If.
The webinar will deal with three types of what-if analysis.
• Goal Seek – which allows you to reach a specific answer by altering one variable.
• Solver – Allows you to reach an optimal or specific answer by modifying one or more variables.
• Scenarios – Look at potential alternatives using different choices for more than one variable – and saving a variety of scenarios.
Each function will be demonstrated and explained, and questions can be asked while you are on line at the Webinar.
White Papers
-
Ransomware E-book
The Business Guide to Ransomware.
-
IT Move: Soup to Nuts
Take a look for IT Move Project Planning.
Blog Archive
Blog Archives
- June 2019 (1)
- May 2019 (1)
- April 2019 (1)
- December 2018 (1)
- November 2018 (1)
- September 2018 (1)
- August 2018 (4)
- July 2018 (5)
- June 2018 (7)
- May 2018 (5)
- April 2018 (5)
- March 2018 (5)
- February 2018 (4)
- January 2018 (5)
- December 2017 (6)
- November 2017 (5)
- October 2017 (6)
- September 2017 (6)
- August 2017 (4)
- July 2017 (4)
- June 2017 (6)
- May 2017 (4)
- April 2017 (6)
- March 2017 (4)
- February 2017 (5)
- January 2017 (5)
- December 2016 (5)
- November 2016 (5)
- October 2016 (4)
- September 2016 (6)
- August 2016 (4)
- July 2016 (7)
- June 2016 (7)
- May 2016 (6)
- April 2016 (5)
- March 2016 (7)
- February 2016 (5)
- January 2016 (5)
- December 2015 (6)
- November 2015 (1)
- October 2015 (2)
- August 2015 (5)
Categories
- Backup and Disaster Recovery (12)
- Business IT (73)
- Security (5)
- Security Tips (71)
- Training (35)
- Uncategorized (5)
- Webinar (28)