MS Excel Spreadsheet Best Practices course
An online ‘MS Excel Spreadsheet Best Practices’ that covers all the key best practice tips and suggestions in order to build flexible, robust and safe financial models and reporting spreadsheets.
- Time Req – 45 minutes
- Skill Level>3.0
- FAQ
- All Online Courses
- Live Course Options
- Ask a Question
Modules
Spreadsheet Best Practice
Lessons
- Consistency – no hard coding numbers in excel Free Preview
- Consistency of Row and Column structures Free Preview
- Consistency of Formula across rows/ columns Free Preview
- Consistently using inbuilt Excel Formulas Free Preview
- Consistently use simple Excel formulas (even if you need to use more cells) Free Preview
- Consistently use the same formats and units throughout Free Preview
- Consistently display negative numbers clearly Free Preview
- Consistency of headers and flags Free Preview
- Separating the inputs, calculations and outputs Free Preview
- Separation- Dealing with the inputs of a spreadsheet Free Preview
- Separation- Dealing with the Calculations of a spreadsheet Free Preview
- Separation- Dealing with the Reports of a spreadsheet Free Preview
- Spreadsheet Integrity Free Preview
- Other best practice suggestions Free Preview
