5 Design Tips for Better Excel Reports & Dashboards
I take you through 5 design tips that help create better Excel Reports and Dashboards.
Link to Excel Dashboard course: https://courses.xelplus.com/p/professional-excel-dashboards
Full article is here: https://www.xelplus.com/5-design-tips-for-excel-dashboards-reports/
5 tips to create the best Excel dashboard:
1. Create emphasis: Add a strong contrast to headings to show at a glance the KPIs on display in your Excel dashboard.
2. Connect different elements: Show relationships with alignment.
3. Draw parallels and create associations: Two things that should be repeated consistently in your dashboard are abbreviations and color usage.
4. Organise content and create focal points: Think about proximity. What will you choose to group or separate?
5. Balance large elements with smaller elements
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ 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
Видео 5 Design Tips for Better Excel Reports & Dashboards канала Leila Gharani
Link to Excel Dashboard course: https://courses.xelplus.com/p/professional-excel-dashboards
Full article is here: https://www.xelplus.com/5-design-tips-for-excel-dashboards-reports/
5 tips to create the best Excel dashboard:
1. Create emphasis: Add a strong contrast to headings to show at a glance the KPIs on display in your Excel dashboard.
2. Connect different elements: Show relationships with alignment.
3. Draw parallels and create associations: Two things that should be repeated consistently in your dashboard are abbreviations and color usage.
4. Organise content and create focal points: Think about proximity. What will you choose to group or separate?
5. Balance large elements with smaller elements
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ 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
Видео 5 Design Tips for Better Excel Reports & Dashboards канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
This Excel Chart will grab your attention (Infographic template included)4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1Beginner's Guide to Excel DashboardsDo's & Don'ts of Excel Spreadsheet Design (with Examples)Top 15 Advanced Excel 2016 Tips and TricksExcel Dashboard - Plan vs Actual Variances - FREE DownloadExcel Pivot Table Design TricksHow to build Interactive Excel DashboardsLearn Macros in 7 Minutes (Microsoft Excel)Secrets to Building Excel Dashboards in Under 15 Minutes!4 Hidden Excel Dashboard Design Tips for Beautiful ReportsProgress Circle Chart in Excel as NEVER seen before!Excel Combo Box without VBA - How to create a drop-down list50 Ultimate Excel Tips and Tricks for 2020Excel Pivot Chart with Slicers for Months to Show Values by Weekday NamesEXCEL PRO TIP: Color & Border DesignConsolidate & Clean Multiple Excel Sheets in One Pivot TableBuild Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel)Power Query Overview - Automate Data Tasks in Excel & Power BI