Blogs and Posts

Excel “What-if Analysis” Webinar
- By: David Moran
- Date: May 18, 2016
- January 26, 2016
10:00 am - 12:00 pm
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)