Join Nate Makdad for an in-depth discussion in this video Selecting your software, part of Creating Interactive Dashboards in Excel 2013.
- So now that we're gonna be creating interactive dashboard,…another consideration for us to make…is where we wanna store our data.…There are a variety of software programs…that can feed data back to Excel,…which our template will then feed from.…And we're just gonna walk through the pros and cons…of a few of those software programs.…So the first one we're gonna talk about is Excel,…because frankly, lots of times…reports are just stored in Excel.…We use one sheet for the data,…and another for pivot tables and charts.…So what are the advantages or disadvantages of using Excel?…Well, first of all Excel is a flat file database,…so it's very good at referencing one table of data,…but not very good at referencing,…you know, multiple sheets together.…
So what I mean by that is, in our data set,…one of the examples that we have…is we've got work location, but we've got no borough,…and so one of the requirements…we put into the data was that…we need to add borough to this.…And so, a very frequent Excel formula is to do a VLOOKUP.…
- 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.