Back to School Sale - Enjoy 20% off all courses with code BTS2019
The goals of data visualization and dashboards, what they should do, and what they shouldn't.
Video time: 5m 00s
How do you go from a blank spreadsheet to a dashboard?
Video time: 5m 02s
Dynamically highlighting values that fall in the top or bottom ranges of your data sets.
Video time: 5m 44s
The easiest way to add easy to read "bling" to your Dashboard.
Video time: 5m 37s
Adding stoplights, check marks, flags and other icons to your Dashboard.
Video time: 5m 50s
Applying dynamic heat maps to your data in order to show outliers and trends.
Video time: 4m 47s
The key to adding dynamics to your dashboard starts with Excel's Logic Functions.
Video time: 6m 00s
Leveraging the logic of the IF() function to drive conditional formats based on formulas.
Video time: 5m 34s
Understanding why you can define two different conditional formatting rules, yet end up with a mixture of both.
Video time: 5m 21s
Exploring two rules that help ensure your charts convey their intended message.
Video time: 5m 24s
Exploring the final three rules that help ensure your charts convey their intended message.
Bar Charts are useful for comparing values to each other. This lesson examines features that can be tweaked to optimize their consumption.
Video time: 5m 27s
Column Charts are useful for comparing values to each other. This lesson explores ways to help make them as effective as possible via some of their available options.
Video time: 4m 09s
Pie Charts can be useful for comparing values as a % of the whole. This lesson explores way to help make them more effective.
Video time: 6m 46s
Useful for showing trends over time, this lesson explores line charts and some of their options.
Video time: 6m 03s
This chart type can be useful for identifying clusters and outliers.
Video time: 6m 30s
Sunburst and Treemap charts are intended to show the breakdown of the source data.
Video time: 6m 38s
Combination charts open a whole new world of charting. In this lesson we combine column and line charts together to make a compelling chart.
Video time: 4m 42s
This lesson shows a trick to include an extra data series in your chart that fades in and out of view as it's needed.
Video time: 6m 12s
When you need to show values of a different scale, there is no better way than to add an additional axis.
Video time: 5m 03s
This complex looking chart conveys a TON of information comparing a single target value against multiple different markers.
Video time: 4m 53s
Waterfall charts help break "net change" into increases and decreases, giving more information about the business cycle.
Video time: 6m 26s
In this lesson, we will look at sparklines: what they are and how to create and modify them.
Video time: 6m 08s
Generating forecast charts in Excel is only a few clicks away, resulting in a chart that you can customize and update later.
Leveraging Micro Charts to build a very quick visual summary of your key metrics.
Video time: 5m 11s
The MATCH() function may not look like much, but it can pull back the position of a data element: something that is key for dynamic dashboarding
Video time: 6m 06s
Using a combination of the INDEX() and MATCH() functions to dynamically restate the dashboard source information
Video time: 6m 25s
Many users fear #N/A values appearing in their spreadsheets. This module explores how to create this result with the NA() function, and why it's fantastic for charts
Drop down lists avoid the risk of "Garbage Out" by preventing your users from putting "Garbage In"
A variety of different objects that add some visual style to your dashboards, as well as provide mechanisms to force valid data entry
Video time: 6m 13s
A brief introduction/reminder about the power of Pivot Tables
Video time: 5m 59s
Understanding the tips and tricks to get conditional formats working properly on Pivot Tables
Video time: 5m 04s
Highly visible and engaging, these devices can provide your users with a method to easily select valid object or filter in to just their slice of the pie
Video time: 5m 51s
Leveraging the GETPIVOTDATA() function in order to extract specific data points from a Pivot Table
Video time: 5m 20s
The ins, outs and shortcomings of Pivot Charts
Video time: 5m 26s
Excel has an entire language for displaying values just the way you need them. Don't see your format in the list? Let's look at how to roll your own!
Video time: 6m 22s
A classic cost-accounting trick to display variance in a easy to read way (and avoid watching your audience do math in their heads at each review)
Video time: 5m 19s
Leveraging Custom Number Formats in order to provide conditional formatting for chart axes
Video time: 5m 58s
Leveraging the REPT() function and a special font in order to build charts in cells via formulas
Video time: 5m 54s
Did you know that Excel can display Emojis in the worksheet? Why not leverage that ability to help convey your message?
Video time: 3m 28s
Sometimes showing the chart just isn't enough and you want to display a text message with an indicator on the chart canvas. This lesson explores how to make that happen
Video time: 4m 19s
A cool trick that shows how we can dynamically look up pictures and return them to our worksheet
Video time: 6m 16s
Share this course
Please confirm the name that should appear on the certificate
Warning! Once you have confirmed, you will not be able to change it. If you have accidentally misspelled this name, please contact us at email@example.com.
Start a tour to see how the lessons work
or dive right into your course. You can always access the tour at a later time.