MM0050 - 16/11/20 - How To Understand A Complicated Excel File
How many times have you been handed a 'legacy' Excel file consisting of multiple sheets, formulae and even VBA? It's difficult! But, it happens a lot so we need an approach to help us understand what is going on.
Topics
- | Briefing - Improve An Existing File
- | The Spreadsheet As A Garden
- | Mike P - Homework Review
- | Excel As A Matter Of Opinion
- | Run Code When Userform Displays
- | How To 'Pre-Select' Values In A Listbox
- | Use The Locals Window
- | Iain L - Homework Review
- | VBA Array Example
- | Understand An Excel File - Overview
- | General Idea: OUT To In
- | Understand The History Of The File
- | What Process Does The File Fit Into?
- | "Don’t Be A Jobber"
- | Need To Capture Requirements
- | Ascertain Purpose Of The File
- | Found Out Number Of Sheets In File
1 Lesson