Do's & Don'ts of Excel Spreadsheet Design (with Examples)

1 year ago
25

17 October 2019 Excel Dashboards & Reports

Check out the complete Excel Essentials course: https://courses.xelplus.com/p/learn-excel-essentials.

In this Excel tutorial I cover the Do's and Don’ts when it comes to creating your next Excel Dashboard or Report. There are two main aspects when you design an Excel spreadsheet:
1. Excel Workbook Structure
2. Visual Design of Each Excel Worksheet

The tutorial includes examples of professional and beautiful Excel reports that follow these design principles.
If you don't have time to watch the whole video make sure you watch Tip#8 at 3:28. This is the one we tend to forget about because we're too busy analyzing and getting the work done. But a little formatting goes a long way. The good news is "less is more" so it really doesn't take much effort to get this right. If you have the proper structure in place as shown at the beginning of the video, the rest will be easily done. Remember: "Organize before you serve".

Putting into practice and making a habit of as many of the Excel spreadsheet design principles outlined in this video will elevate your spreadsheets far above those around you. Who knows; it could be the reason for your next promotion!

⯆ Full Blog Post is here: https://www.xelplus.com/excel-spreadsheet-design

More tips on designing Excel Dashboards: https://rumble.com/v2st67u

★ My Online Excel Courses ► https://www.xelplus.com/courses/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel #Excel #LeilaGharani

Loading comments...