Excel Spreadsheet Design: Extreme Makeover
46mIntermediate2021-10-04
Authors

Joshua Rischin
Company Director of Axium Solutions
Course details
Whether you’re working on an Excel file for yourself or one that will be shared with thousands, spreadsheet design is crucial. When a spreadsheet is designed poorly, it’s hard for people to find the data they need, resulting in wasted time. In this hands-on and interactive course, Excel power user Joshua Rischin shares simple design tricks to give your Excel work an extreme makeover. Josh explains how to get the design right, apply finishing touches to your work, and avoid the common pitfalls of Excel workbook design so that you can create captivating spreadsheets that wow stakeholders.
Skills covered
SpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoftOne-Off
Concepts
0. Introduction
- 01 - Wow your stakeholders with an Excel extreme makeover
- 02 - Keeping your audience in mind
1. Getting the Design Right
- 03 - Why is spreadsheet design so important
- 04 - Principles of user-friendly design
2. Performing an Excel Makeover
- 05 - Laying things out the right way
- 06 - Get your data in the right place
- 07 - Remove ambiguity with cell formatting
- 08 - Maintain integrity with once-only data inputs
- 09 - Control inputs with data validation
- 10 - Distinguish results with conditional formatting
- 11 - Bring data to life with charts
3. Applying the Finishing Touches
- 12 - Get the most from tab customization
- 13 - Create safeguards with detailed pagination
- 14 - The big reveal
4. Consolidate Your Expertise
- 15 - When to makeover vs. rebuild a spreadsheet
Conclusion
- 16 - Getting the most from your makeover