Excel 2010 Bible

Chapter 33: Getting Data from External Database Files 679 Importing Access Tables Microsoft Access is included with some version ...

Part V: Analyzing Data with Excel 680 FIGURE 33.2 Use this dialog box to specify the location of the imported table. FIGURE 33.3 ...

Chapter 33: Getting Data from External Database Files 681 On the CD The database file used in this example is available on the c ...

Part V: Analyzing Data with Excel 682 One approach to this task is to import the entire Access file into a worksheet using the m ...

Chapter 33: Getting Data from External Database Files 683 Click the Connect button to display another dialog box that asks for ...

Part V: Analyzing Data with Excel 684 Using the Query Wizard The Choose Data Source dialog box has a check box at the bottom tha ...

Chapter 33: Getting Data from External Database Files 685 If you want to see the data for a particular column, select the column ...

Part V: Analyzing Data with Excel 686 l (^) From the Column to Filter list, select Category. In the right panel, select equals f ...

Chapter 33: Getting Data from External Database Files 687 For this example, select the Return Data to Microsoft Excel option but ...

Part V: Analyzing Data with Excel 688 FIGURE 33.11 The results of the query. Working with Data Returned by Query Excel stores th ...

Chapter 33: Getting Data from External Database Files 689 For more settings (applicable for advanced users), click the Propertie ...

Part V: Analyzing Data with Excel 690 Caution After performing a query, you may want to copy or move the external data range, wh ...

Chapter 33: Getting Data from External Database Files 691 FIGURE 33.13 Display the Criteria pane as shown here so that you’ll be ...

Part V: Analyzing Data with Excel 692 Figure 33.14 shows how the query for the example presented earlier in this chapter appears ...

Chapter 33: Getting Data from External Database Files 693 Note When you add tables to a query, the Tables pane in Query connects ...

...

695 CHAPTER Introducing Pivot Tables IN THIS CHAPTER An introduction to pivot tables Types of data appropriate for a pivot table ...

Part V: Analyzing Data with Excel 696 One minor drawback to using a pivot table is that unlike a formula-based summary report, a ...

Chapter 34: Introducing Pivot Tables 697 l (^) The date the account was opened l The day of the week the account was opened l (^ ...

Part V: Analyzing Data with Excel 698 FIGURE 34.2 A simple pivot table. FIGURE 34.3 A pivot table that uses a report filter. Dat ...