Excel Spreadsheet Design: Extreme Makeover

Focused View

Joshua Rischin

45:59

151 View

01 - Introduction

01 - Wow your stakeholders with an Excel extreme makeover.mp4

01:19

02 - Keeping your audience in mind.mp4

02:23

02 - Getting the Design Right

01 - Why is spreadsheet design so important.mp4

03:14

02 - Principles of user-friendly design.mp4

02:30

03 - Performing an Excel Makeover

01 - Laying things out the right way.mp4

02:14

02 - Get your data in the right place.mp4

03:00

03 - Remove ambiguity with cell formatting.mp4

05:34

04 - Maintain integrity with once-only data inputs.mp4

04:13

05 - Control inputs with data validation.mp4

04:14

06 - Distinguish results with conditional formatting.mp4

02:14

07 - Bring data to life with charts.mp4

03:32

04 - Applying the Finishing Touches

01 - Get the most from tab customization.mp4

01:57

02 - Create safeguards with detailed pagination.mp4

02:59

03 - The big reveal.mp4

02:04

05 - Consolidate Your Expertise

01 - When to makeover vs. rebuild a spreadsheet.mp4

03:16

06 - Conclusion

01 - Getting the most from your makeover.mp4

01:16

Exercise Files

Ex_Files_Excel_Spreadsheet_Design_Extreme_Makeover.zip

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Joshua Rischin

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.