5 Formatting Principles For Better Excel Spreadsheets

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 …

🔥30 DAY EXCEL ANALYST PLAYLIST
https://tinyurl.com/4439xtnb
🔥FIRST VIDEO IN THE COURSE
https://youtube.com/live/CF-Y46c829Q
💻DOWNLOAD THE RESOURCES
https://tinyurl.com/2tb2sbst

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.

FOLLOW UP RESOURCES
🔥30 DAY EXCEL ANALYST PLAYLIST
https://tinyurl.com/4439xtnb
🔥MAKE EXCEL BEAUTIFUL: 14 EXCEL FORMATTING TIPS
   • 14 Excel Formatting Tips (Make Excel ...  
🔥THE THREE EXCEL SUPERPOWERS
   • The 3 Excel Superpowers  
🔥THE 72 THINGS YOU NEED TO KNOW IN EXCEL
   • The 72 Things You Need To Know In Exc...  
🔥STOP FILTERING EXCEL
   • Don't Use Excel Filters! Use This Inc...  
🔥LEARN EXCEL VBA WITH THIS 5-HOUR WALKTHROUGH PROJECT
   • Learn Excel VBA From Beginner Level W...  
🔥LET’S TALK ABOUT WHY YOU ARE BAD AT EXCEL
   • Let's Talk About Why You Are Bad At E...  

🔥READ MORE ABOUT OUR PROFESSIONAL EXCEL DEVELOPMENT COMMUNITY: MEMBERS MONDAY
https://tinyurl.com/2p8wy5dr