Business Management – 10/03/17
I. Bellwork- Google Classsroom
- Explain the revenue and expenses that make up your own personal budget?
II. Objectives
- Build formulas to create an accurate and flexible budget in Excel
- Use relative versus absolute cell addresses to support What-If Analysis in Excel
- Format a range of cells in Excel using the Format Painter
- Format a budget in Excel to protect calculated information
III. Discussion
- Budgets and What-If Analysis – PPT
- Pages 1-17
IV. Classwork: Files on iLearn
- Create a formula using a relative cell reference 11-12
- Create a Formula using absolute cell references pgs. 13-14
- Format a What-If-Analysis to clearly identify assumption information pgs. 15-16
- Format a What-If-Analysis to protect Calculated Information pg 18-19
V. Exit Ticket
Explain the importance of What-If-Analysis
Leave a Reply