Microsoft Excel - Dashboards

Take your Excel skills to a whole new level by learning how to build dynamic Excel dashboards to show off your data. This online course will teach you the data visualization skills you need to design any dashboard in Excel exactly the way you want.

You should come to this course with a comfort level of building IF functions at a minimum, and knowledge of Pivot Tables is an asset, but not a requirement. At the end of the course, you will have gained the practical skills you need to create beautiful, functional and interactive Excel dashboards.

Highlights:

42 practical tutorials.

Understand the goals of data visualization.

Learn to use conditional formatting, from data bars to icon sets to add finesse to your dashboard.

Review the Excel logic functions which are key to adding dynamics to your dashboard.

Explore the 5 rules of effective charting.

Start by building bar charts, column charts, pie charts and line charts to display your data.

Build more complex charts like scatter plots, combination charts and more to really tell your story.

Add interactivity to your dashboard with the MATCH () and INDEX () functions.

Leverage pivot tables within your dashboard to add even more interactivity.

Learn “black magic” dashboarding tricks, like using Emojis and VLOOKUP to further enhance your data.

Video tutorials are recorded in Microsoft Excel 2016 for PC. Learn more about how a GoSkills Excel certification can boost your career.

Want to be a more efficient Excel user? Start learning 200 of the best Excel shortcuts for PC and Mac.

Once enrolled, our friendly support team and tutors are here to help with any course related inquiries.

Microsoft Excel - Dashboards

Topics

Grade Levels

Formats

Related Resources