Join Nate Makdad for an in-depth discussion in this video Inserting hyperlinks within a report, part of Creating Interactive Dashboards in Excel 2013.
- Adding hyperlinks to our report can add…some quick navigation and help improve user experience.…So there's plenty of times when using this report…we might need to get to the PivotTables.…Some people might be more comfortable…working with PivotTables when we need to refresh the data.…Maybe as an analysis tool because we want to add some,…you know, to something to the column labels…we want to compare definitions,…which we don't have in these charts.…So very frequently, with this sort of report…we need to be able to get to…our raw data, or raw PivotTables.…And hyperlinks create a great mechanism for doing that.…
So to create a hyperlink,…you know similar to jumping out to web pages…this is just an internal hyperlink,…we're going to go over to our charts and…kind of go right underneath our chart and press Control, K.…And on the left-hand side, you'll see these Link tos…and we can do, we can insert an e-mail address…we can create a new document, but…what we want to do is click on Place in This Document.…The Text to display, is what people are going to see…
- 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.