Join Nate Makdad for an in-depth discussion in this video Definitions and help text, part of Creating Interactive Dashboards in Excel 2013.
- Adding definitions can help improve your experience…by providing clear references to our data.…This allows people to quickly understand the data…and make sure that their understanding…of the information being presented is the same.…So we talked earlier about creating standards,…and this is really about reinforcing those standards…and making sure that we're able…to clearly communicate those standards.…Also a great way to help communicate changes to the report.…But really what we want to do…is add some definitions to our report,…and there's a couple of different ways you could do this,…and I'm sure many, many, more.…
But the way I've done this in the past…is one, I want to rename this away from my sheet one,…and I'm gonna call this my summary tab.…And we could create a definitions tab, right,…so people could quickly jump between these two.…We could type in our total number of openings…and what that's equal to.…We could go ahead and insert a text box…and total number of openings, et cetera.…
And even format it if we wanted to.…
- Recognize three dimensions of a PivotTable.
- Summarize four design tips.
- Identify the two default sections for values in Excel.
- Explain how to add slicers in a single column.
- Recall the shortcut used to insert a hyperlink.
- Determine the location to look when you have an error while pasting data.