Accounting – 5/23/19
I. Bellwork Google Classroom
- What are some things you know about working with Excel?
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
II. Discussion
- Budgets and What-If Analysis – PPT
- Pages 1-17
III. 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
Leave a Reply