Join Nate Makdad for an in-depth discussion in this video Recording a macro, part of Creating Interactive Dashboards in Excel 2013.
- Macros let you repeat a task in Excel automatically,…and by using them in our dashboard,…we can change our pivot tables and make our dashboard…a dynamic tool for analyzing data.…So when we're talking about adding this…dynamic ability, what we really want to…be able to do, is change our charts…with the push of a button.…This lets us share our dashboard with a…wide audience, and allows them to see…exactly the dimensions that they want.…This is great not only for our ability to cut…down on the number of charts that we need,…but also as a great analysis tool.…
So as we start to dig into the data,…we might be curious about how the number…of openings varies by Bureau, then maybe we…want to switch, and see how it's effected by Agency,…maybe you wanna filter on a particular Agency…and then we start to play around with it.…So, we can really dive in and start analyzing…our data a bit with these buttons as well.…So in the context of this dashboard,…what we're going to do is create a button that is then…gonna work on each of these pivot tables,…
- 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.