MM0059 - 18/01/21 - 5 Excel Data Management Principles
VBA, Formulae, Pivot Tables … there is so much to think about in Excel! But, things get a lot easier if overall data structure is logical and understandable. Let's look at 5 Excel data management principles.
Topics
Topics
- | Tiffany B Drops In!
- | About Tiffany's Excel Development
- | Importance Of The Data Management Tips
- | Should You Use Excel At All?
- | Don't Read Too Much LinkedIn!
- | Don't Fragment Datasets
- | Learn To Navigate Large Datasets
- | Don't Mix Up Data And Formulae
- | Techniques For Analysing Large Datasets
- | How To Filter And Alternatives To Filters
- | When You Should Use Filtering - Testing!
- | DSUM - How To Build
- | Strategies To Manage Dataset Size
- | COUNTA
- | INDIRECT
- | Start With The End In Mind
1 Lesson