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…
- Defining your requirements
- Setting up data
- Adding reference tables
- Creating hierarchy in the layout
- Choosing color and typography
- Importing data
- Inserting slicers
- Recording a macro
- Editing VBA code
- Improving the user experience
Skill Level Intermediate
Excel Data Analysis: Forecastingwith Wayne Winston3h 7m Intermediate
Up and Running with Excel What-If Analysiswith Curt Frye1h 10m Intermediate
Cleaning Up Your Excel 2013 Datawith Dennis Taylor1h 59m Appropriate for all
1. Introduction to Dynamic Dashboards
Topics in this course5m 39s
2. Preparing Your Data
3. Designing Your Visual Layout
Design elements: Color6m 20s
4. Designing the Report
5. Improving User Experience
Next steps1m 53s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.