“Structure determines behaviour” is an aphorism I first heard on my Masters degree. Since then, I’ve adapted the phrase slightly since it succinctly sums up my experience of developing Excel files. “Structure determines programmer behaviour!”

DOWNLOAD THE RESOURCES HERE

Watch The Video HERE

Yes, if your Excel file is effectively structured, the development process is generally smooth. The opposite applies if you’re dealing with sub-optimal structure – your Excel file might drive you mad! This is why structure determines programmer behaviour. The fact is, it doesn’t matter how good you are at Excel formulae, Power Query or VBA; if you cannot structure an Excel file effectively, you will always feel stressed when building a spreadsheet.

In this session, I talk you through what I consider to be effective Excel file structure. We’ll explore the topic on two levels: worksheet layout and overall file structure. By the end of the session, you should be able to plan the structure of an Excel file with confidence – which could have a profound effect on your work as an Excel analyst. Welcome back to 30 Day Excel Analyst!

READ MORE ABOUT OUR PROFESSIONAL EXCEL DEVELOPMENT COMMUNITY: MEMBERS MONDAY