Join Nate Makdad for an in-depth discussion in this video Creating action queries, part of Creating Interactive Dashboards in Excel 2013.
- So we can finish building our database…in our clean data table by using Action Queries…to finalize the data, and complete…the last step in our data flow process.…So, to do this, I'm going to use this query Open Jobs Clean,…because I've built in almost all of the requirements here,…that we're gonna need in our final table,…and then I'm going to change to Design View.…So if I go over to the View, I can click on…the dropdown arrow and click Design View.…And now, under the Design tab,…we've got a variety of selections.…And right now we're set on Select…but we wanna change this to Make Table.…
And so when I press on the Make Table, a new box…is gonna pop up, and again, the reason…we're gonna use Make Table here is we wanna create…that clean database, or that clean table…that Excel's gonna look to.…And the Make Table is going to allow us to create…all of the same column headings…that are in this query, and the same data types.…So I'm gonna call this Open Jobs_Clean…so that that way I know the name…of what I'm gonna come back and look for, press Okay.…
- 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.