We’ll also look at tricks we can use to display data that spans different years, axes labelling tricks, charting two data sets, logarithmic scaling and more.
When charting different units of measure it makes sense to use a secondary axis, especially if the units being displayed have vastly different scales. Using a secondary axis allows both units of measure to be clearly displayed in one chart.
Upon completion, students will have a variety of techniques and examples that can be applied to their own datasets.
Students will be able to choose the right chart for their data, write easy to interpret reports, know which areas of the dashboard will get the most attention, animate charts using VBA, create interactive reports (so users can change views and filter information), among a host of other abilities taught in this course.
3 hours of the tutorials are optional supplementary Excel lessons and only for students who need to fill any knowledge gaps.
I don't waffle on, my tutorials get to the point so you're up to speed fast.
The course covers advanced features of Excel Dashboards, such as display and visualization principles for clear dashboard creation, using interactive controls to keep information informative and relevant, analyzing and automating information for a fully functional and complete dashboard.
It also includes key considerations for distributing dashboards like password protections, locking and unlocking cells and protecting workbooks.
The price of this course reflects its value and I'm confident you'll get results.
Not sure if its just my computer yet, currently testing the issue with different computers.
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
Plus I teach you 9 design principles that will ensure your reports are easy on the eye and don't end up a mish mash of formatting junk.
In this lesson we’ll cover charts that are good for displaying data that follows a trend, for example, over time.