Description
Working with Spreadsheets that other people have created:
This session covers the key tasks you should complete when you inherit someone else's spreadsheet to ensure that it is running well and to make sense of any complex formulas.
Formula Auditing tools (trace precedents, evaluate formula), Using Find to identify data validation and conditional formatting, examining where named ranges are, using the formula bar to unravel nested functions.
You will need to be familiar and confident with creating formulas before attending this course. If you aren't, have a look at our Creating Formulas and More Formulas courses