How should you format an Excel spreadsheet? Is what makes an Excel spreadsheet look good simply a matter of opinion? One thing is for sure – Excel offers us a vast range of formatting options: colours, font types, column widths and so much more. No wonder people get into a mess when formatting Excel spreadsheets! And don’t worry, I’ve created many spreadsheets that make me cringe when I look back at them …

DOWNLOAD THE RESOURCES HERE

Watch The Video HERE

At the same time, and over the course of hundreds of spreadsheet development projects, I’ve crafted my own approach for formatting Excel spreadsheets. It’s built around an overarching idea: that formatting should serve the user by making data easier to access, read and interpret. Five principles guide how I format Excel spreadsheets: space, cleanliness, readability, coherent colour and distinctiveness.

In this session, I talk you through the five principles, with reference to real-world examples and Excel formatting tips and tricks to help you bring the principles into reality. The aim is to build your confidence formatting Excel spreadsheets and to simplify this often confusing topic. Though there are many spreadsheets out there that can feel like a ‘mess’, a well-formatted Excel spreadsheet can be a real wow factor – and can differentiate your work as an Excel analyst.

READ MORE ABOUT OUR PROFESSIONAL EXCEL DEVELOPMENT COMMUNITY: MEMBERS MONDAY