Exam 77-428 Microsoft Excel 2013 EXPERT 1. Manage and Share Workbooks 1.1 Manage Multiple Workbooks: Link to External Data

Back in Microsoft Excel In Excel, a Table is a Defined Range of Rows and Columns. The Tables can be Named, Sorted and Filtered. The Named Ranges can be used in Formulas, such as vLookup. Microsoft Excel can also analyze the Tables in a database. The Tables are linked so the information is live, viewed in real-time. 1. Try This: Get External Data There is a blank spreadsheet open in Excel. Go to Data->Get External Data. Click on From Access. Browse to the Documents folder. Select a file: Charlottes Website Data.accdb Click Open. Keep going... Data->Get External Data->From Access