Modelling workspace and Excel settings set-up
Half of the slow, error-prone modelling people blame on skill is really a badly set-up machine: automatic calculation switched off by accident, iterative calculation left on so circular errors hide, a mouse doing what the keyboard should. Spending one session fixing settings, add-ins and the ribbon means every model you build afterwards starts from the same reliable base.
First tasks
- Check calculation mode and iterative calculation settings in Excel options
- Write a one-page list of the twenty shortcuts you use most
- Install and test any modelling add-in your firm or course provides
- Save a default workbook style with your fonts and number formats