4 Hidden Excel Dashboard Design Tips for Beautiful Reports

10 months ago
37
XelplusVis Leila Gharani Advanced Excel tricks Excel online course Excel tips and tricks Excel for analysts Microsoft Excel tutorials Microsoft Excel Excel 2016 Excel 2013 Excel 2019

4 Jun 2020 Excel Dashboards & Reports

First 1000 people who use the link will get 2 free months of Skillshare premium: https://skl.sh/xelplus11

Creating Excel Dashboards can be very time consuming. You need to define the most important key performance indicators and find a reliable data source for your dashboard. But the visual representation of the data is just as important.

Don't just plaster the report with numbers! Keep enough white space and use shapes to create emphasis. Of course, finding the right balance and implementing it in your Excel Dashboard can take a LOT of time.

In this Excel tutorial, I show you 4 hidden Excel tips that can help you to create a clean, well-designed and informative dashboard without wasting a lot of time.

Leila's Hidden Dashboard Tips:
00:00 Intro
00:55 Convert SmartArt to Shapes
03:32 Hide Unused Rows and Columns
04:20 Select Objects from the Selection Pane
05:15 Use Linked Pictures

Many thanks to Skillshare for sponsoring this video!

⯆ Read the full article & download workbook: https://www.xelplus.com/excel-hidden-dashboard-tips

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

✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

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

Get Microsoft 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...