Join Nate Makdad for an in-depth discussion in this video Adding reference tables, part of Creating Interactive Dashboards in Excel 2013.
- We can also use Access to create reference tables…that might include data not originally in a report…and then match it up against our data to meet…reporting requirements.…In this particular example one of the original requirements…was to put in a borough to be able to map this data…and be able to see where do we have a lot of openings.…But if you scroll through the raw data,…there is no borough associated with the reports.…So it's not on the output.…So we can create a reference table that allows us to…build this data in.…
I built this reference table by opening up our…Open Jobs data.…And notice that every row has…a value in Work Location.…And though we have multiple rows in this field…we can use this to start to build our reference table.…So if I click on the column and then…Ctrl+C, copy the data, and go to a new sheet…and then hit Ctrl+V to paste the data in,…under the data ribbon I can click on Remove Duplicates.…
Make sure my data has headers and then press OK.…And now you can see I've gone down from 2274 values…
- 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.