Page 15 - Excel 2013 All-in-One For Dummies

Table of Contents xiii
Chapter 2: Adding Graphic Objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . .545
Graphic Objects 101 .................................................................................... 546 Manipulating graphics....................................................................... 547 Moving graphic objects to new layers ............................................ 548 Aligning graphic objects ................................................................... 551 Grouping graphic objects ................................................................. 551 Managing graphic objects in the Selection task pane...................552
Inserting Different Types of Graphics.......................................................554 Adding clip art.................................................................................... 554 Downloading images on the Web..................................................... 556 Inserting local pictures ..................................................................... 557 Editing pictures..................................................................................558 Formatting pictures...........................................................................559
Drawing Graphics ........................................................................................ 561 Drawing predefined shapes..............................................................561 Adding text boxes .............................................................................. 562 Inserting WordArt..............................................................................567 Inserting SmartArt graphics ............................................................. 568
Adding Screenshots of the Windows Desktop.........................................571 Using Themes............................................................................................... 573
Book VI: Data Management....................................... 575
Chapter 1: Building and Maintaining Data Lists . . . . . . . . . . . . . . . . . .577
Data List Basics............................................................................................ 577 Designing the basic data list............................................................. 578 Add new records to a data list ......................................................... 581 Eliminating records with duplicate fields.......................................586
Sorting Data..................................................................................................588 Sorting records on a single field ...................................................... 588 Sorting records on multiple fields ................................................... 589 Sorting the columns of a data list .................................................... 592 Sorting a data list on font and fill colors and cell icons................596
Subtotaling Data .......................................................................................... 597
Chapter 2: Filtering and Querying a Data List . . . . . . . . . . . . . . . . . . . .601
Data List Filtering 101 ................................................................................. 602 Filtering Data................................................................................................602 Using AutoFilter ................................................................................. 603 Using the Advanced Filter................................................................. 612 Using the Database Functions.................................................................... 620 External Data Query .................................................................................... 622 Retrieving data from Access database tables ................................ 624 Retrieving data from the web...........................................................626 Retrieving data from text files..........................................................628 Querying data from other data sources.......................................... 632 Retrieving external data with Microsoft Query ............................. 633