Description

Work confidently and quickly in Excel. Using a case study you will build a budget, calculating the costs for various items, grouping them together, and totaling up. We do all of this using best practice, including column widths, handling hardcoded numbers, formatting, building formulas, copying formulas and formatting, consistent formulas across rows/columns, how to edit a model confidently, and adding checks.

Learning Objectives

---

1. Utilize Excel tools, using the ribbon for formatting, and format painter.
2. Use best practice setting up the Excel file.
3. Input and format hardcode numbers correctly.
4. Input formulas using assumptions and figures in other cells.
5. Use $ signs to lock absolute references.
6. Use consistent formulas in rows and columns.
7. Recall the importance of matrix integrity.
8. Recall how to edit an Excel file confidently.
9. Add checks on subtotals.