Enhanced descriptions from Syndetics:

Excel 2013 On Demand is built from the ground up for today's beginning-to-intermediate-level Exceluser. Like every book in the On Demand Series, it teaches visually, using an easy, friendly, full-colour format designed to "show you how," instead of "telling you how." But that's not all. This book: Combines step-by-step training with quick-reference material users can rely on long after they've mastered the core skills they need Provides easy-to-follow task-based coverage of the techniques you'll use most often, presenting most tasks in just one or two pages Offers in-depth coverage of all new MOS (Microsoft Office Specialist) exam objectives, so you can use it as a study guide to enhance your job prospects or current career Provides additional end-of-chapter workshops, plus even more hands-on projects online Includes a complete practical troubleshooting guide Helps you upgrade by presenting New Feature icons, plus a detailed list of new features indexed to the pages where they're covered

Table of contents provided by Syndetics

• Introduction (p. xvii)
• 1 Getting Started with Excel (p. 1)
• Starting Excel (p. 2 New!)
• Viewing the Excel Window (p. 3 New!)
• Using the Ribbon (p. 4 New!)
• Choosing Commands (p. 5 New!)
• Working with the Ribbon and Toolbars (p. 6)
• Choosing Dialog Box Options (p. 8)
• Using the Status Bar (p. 9)
• Creating a Blank Workbook (p. 10 New!)
• Creating a Workbook Using a Template (p. 11 New!)
• Opening an Existing Workbook (p. 12 New!)
• Converting an Existing Workbook (p. 14)
• Using Task and Window Panes (p. 15)
• Moving Around the Workbook (p. 16 New!)
• Arranging Windows (p. 18 New!)
• Getting Help While You Work (p. 20 New!)
• Saving a Workbook (p. 22 New!)
• Saving a Workbook with Different Formats (p. 24 New!)
• Saving a Workbook to Online Services (p. 26 New!)
• Working with Accounts (p. 27 New!)
• Checking Compatibility (p. 28)
• Checking Accessibility (p. 29)
• Documenting Workbook Properties (p. 30)
• Switching Views (p. 31)
• Recovering a Workbook (p. 32)
• Closing a Workbook and Exiting Excel (p. 34 New!)
• 2 Basic Workbook Skills (p. 35)
• Making Label Entries (p. 36)
• Selecting Cells (p. 37)
• Selecting Rows, Columns, and Special Ranges (p. 38)
• Entering Labels on a Worksheet (p. 40)
• Entering Values on a Worksheet (p. 42)
• Entering Values Quickly with AutoFill (p. 44)
• Inserting Content with Flash Fill (p. 46 New!)
• Editing Cell Contents (p. 48)
• Clearing Cell Contents (p. 49)
• Understanding How Excel Pastes Data (p. 50)
• Storing Cell Contents (p. 51)
• Copying Cell Contents (p. 52)
• Moving Cell Contents (p. 54)
• Inserting and Deleting Cell Contents (p. 56)
• Finding and Replacing Cell Contents (p. 58)
• Correcting Cell Contents with AutoCorrect (p. 60)
• Inserting Information the Smart Way (p. 62)
• Checking Spelling (p. 64)
• Changing Proofing Options (p. 65)
• Using Custom Dictionaries (p. 66)
• Inserting Symbols (p. 68)
• Finding the Right Words (p. 69)
• Inserting Research Material (p. 70)
• Translating Text to Another Language (p. 71)
• Using Multiple Languages (p. 72)
• Work with Touch Screens (p. 73 New!)
• Undoing and Redoing an Action (p. 74)
• 3 Working with Formulas and Functions (p. 75)
• Understanding Formulas (p. 76)
• Creating a Simple Formula (p. 78)
• Creating a Formula Using Formula AutoComplete (p. 80)
• Editing a Formula (p. 82)
• Understanding Cell Referencing (p. 84)
• Using Absolute Cell References (p. 85)
• Using Mixed Cell References (p. 86)
• Using (p. 3-D Cell Ref)
• Naming Cells and Ranges (p. 88)
• Entering Named Cells and Ranges (p. 90)
• Managing Names (p. 92)
• Simplifying a Formula with Ranges (p. 94)
• Displaying Calculations with the Status Bar (p. 95)
• Calculating Totals with AutoSum (p. 96)
• Calculating Totals with Quick Analysis (p. 98 New!)
• Performing One Time Calculations (p. 100)
• Converting Formulas and Values (p. 102)
• Correcting Calculation Errors (p. 103)
• Correcting Formulas (p. 104)
• Auditing a Worksheet (p. 106)
• Locating Circular References (p. 107)
• Performing Calculations Using Functions (p. 108)
• Creating Functions (p. 109)
• Creating Functions Using the Library (p. 110 New!)
• Calculating Multiple Results (p. 111)
• Using Nested Functions (p. 112)
• Using Constants and Functions in Names (p. 114)
• 4 Modifying Worksheets and Workbooks (p. 115)
• Selecting and Naming a Worksheet (p. 116)
• Inserting and Deleting a Worksheet (p. 117)
• Moving and Copying a Worksheet (p. 118)
• Hiding and Unhiding Worksheets and Workbooks (p. 120)
• Selecting a Column or Row (p. 122)
• Hiding and Unhiding a Column or Row (p. 123)
• Inserting a Column or Row (p. 124)
• Deleting a Column or Row (p. 125)
• Adjusting Column Width and Row Height (p. 126)
• Freezing and Unfreezing a Column or Row (p. 128)
• Splitting a Worksheet into Panes (p. 129)
• Showing and Hiding Workbook Elements (p. 130)
• Zooming the View In and Out (p. 131)
• Creating Custom Views (p. 132)
• Setting Up for Personal Templates (p. 133 New!)
• Creating a Personal Template (p. 134 New!)
• Opening a Template (p. 135 New!)
• Changing a Template (p. 136 New!)
• 5 Formatting a Worksheet (p. 137)
• Formatting Numbers (p. 138)
• Formatting Text (p. 140)
• Applying Conditional Formatting (p. 142 New!)
• Applying Specialized Conditional Formatting (p. 144 New!)
• Creating Conditional Formatting (p. 146)
• Clearing Conditional Formatting (p. 147)
• Managing Conditional Formatting (p. 148)
• Finding Conditional Formatting (p. 149)
• Creating Sparkline Formatting (p. 150 New!)
• Changing Data Alignment (p. 152)
• Controlling Text Flow (p. 154)
• Changing Data Color (p. 155)
• Adding Color and Patterns to Cells (p. 156)
• Adding Custom Colors (p. 157)
• Adding Borders to Cells (p. 158)
• Formatting Tabs and Background (p. 160 New!)
• Copying Cell Formats (p. 161)
• Understanding Color Themes (p. 162)
• Viewing and Applying a Theme (p. 163)
• Creating Theme Colors (p. 164)
• Choosing Theme Fonts (p. 166)
• Choosing Theme Effects (p. 168)
• Creating a Custom Theme (p. 169)
• Choosing a Custom Theme (p. 170)
• Applying and Creating Cell Styles (p. 172)
• Modifying a Cell Style (p. 174)
• Finding and Replacing Cell Formatting (p. 176)
• 6 Viewing and Printing Worksheets and Workbooks (p. 177)
• Setting Up the Page (p. 178)
• Adjusting Page Margins (p. 180)
• Adding Headers and Footers (p. 182)
• Inserting Page Breaks (p. 184)
• Customizing Worksheet Printing (p. 186)
• Setting the Print Area (p. 188)
• Previewing a Worksheet (p. 189)
• Printing a Worksheet and Workbook (p. 190)
• Creating a PDF Document (p. 191)
• Creating an XPS Document (p. 192)
• 7 Inserting and Modifying Graphics (p. 193)
• Locating and Inserting Online Pictures (p. 194 New!)
• Inserting Pictures from an Online Service (p. 196 New!)
• Inserting Pictures from a SkyDrive or SharePoint (p. 198 New!)
• Inserting a Picture from a File (p. 199)
• Inserting a Picture Screen Shot (p. 200)
• Adding an Artistic Style to a Picture (p. 201)
• Adding a Quick Style to a Picture (p. 202)
• Applying a Shape to a Picture (p. 203)
• Applying a Border to a Picture (p. 204)
• Applying Picture Effects (p. 205 New!)
• Modifying Picture Size (p. 206 New!)
• Compressing a Picture (p. 208)
• Correcting a Picture (p. 209 New!)
• Recoloring a Picture (p. 210)
• Cropping and Rotating a Picture (p. 212)
• Removing a Picture Background (p. 214)
• Creating WordArt Text (p. 215)
• Formatting WordArt Text (p. 216)
• Applying WordArt Text Effects (p. 218)
• Modifying WordArt Text Position (p. 219 New!)
• Creating SmartArt Graphics (p. 220)
• Using the Text Pane with SmartArt Graphics (p. 222)
• Modifying a SmartArt Graphic (p. 224)
• Resizing a SmartArt Graphic (p. 225)
• Formatting a SmartArt Graphic (p. 226)
• Formatting a Shape in a SmartArt Graphic (p. 228)
• Adding Pictures to a SmartArt Graphic (p. 230)
• Creating an Organization Chart (p. 231)
• Modifying an Organization Chart (p. 232)
• 8 Drawing and Modifying Shapes (p. 233)
• Drawing and Resizing Shapes (p. 234)
• Inserting Multiple Shapes (p. 236)
• Adding Text to a Shape (p. 237)
• Drawing Lines and Arrows (p. 238 New!)
• Creating and Editing Freeforms (p. 240)
• Copying and Moving Objects (p. 241)
• Adding a Quick Style to a Shape (p. 242 New!)
• Adding a Quick Style to Shape Text (p. 243)
• Applying Color Fills (p. 244 New!)
• Applying Picture Fills (p. 246 New!)
• Applying Texture Fills (p. 247 New!)
• Applying Gradient Fills (p. 248 New!)
• Applying Shape Effects (p. 250 New!)
• Adding (p. 3-D Effects)
• Adding (p. 3-D Rotation)
• Creating Shadows (p. 255 New!)
• Aligning and Distributing Objects (p. 256)
• Connecting Shapes (p. 258)
• Selecting Objects Using the Selection Pane (p. 259)
• Changing Stacking Order (p. 260)
• Rotating and Flipping a Shape (p. 261)
• Grouping and Ungrouping Shapes (p. 262)
• 9 Creating and Modifying Charts (p. 265)
• Understanding Chart Terminology (p. 266 New!)
• Choosing the Right Type of Chart (p. 267)
• Creating a Chart (p. 268 New!)
• Editing a Chart (p. 270 New!)
• Moving and Resizing a Chart (p. 272)
• Selecting Chart Elements (p. 274)
• Changing Chart Elements (p. 275 New!)
• Changing a Chart Type (p. 276 New!)
• Changing a Chart Layout and Style (p. 278 New!)
• Formatting Chart Elements (p. 280 New!)
• Changing Chart Gridlines and Axes (p. 282 New!)
• Changing Chart Titles (p. 284 New!)
• Changing Chart Labels (p. 286 New!)
• Pulling Out a Pie Slice (p. 288)
• Formatting Chart Data Series (p. 289 New!)
• Formatting Chart Text (p. 290)
• Formatting Line and Bar Charts (p. 291 New!)
• Changing the Chart Background (p. 292)
• Enhancing a Chart (p. 293)
• Editing Chart Data (p. 294 New!)
• Adding and Deleting a Data Series (p. 296 New!)
• Saving a Chart Template (p. 298 New!)
• Managing Chart Templates (p. 300)
• 10 Analyzing Worksheet Data (p. 301)
• Understanding Tables (p. 302)
• Creating a Table (p. 303 New!)
• Formatting a Table (p. 304 New!)
• Creating or Modifying a Table Style (p. 305)
• Formatting Table Elements (p. 306 New!)
• Creating Calculations in a Table (p. 307)
• Working with Tables (p. 308)
• Removing Table Rows and Columns (p. 310)
• Entering Data in a Table Using a Drop-Down List (p. 311)
• Sorting Data in a Table (p. 312)
• Displaying Parts of a Table with AutoFilter (p. 314)
• Creating Custom Searches (p. 315)
• Using Slicers to Filter a Table (p. 316 New!)
• Exporting a Table to a SharePoint List (p. 317 New!)
• Analyzing Data Using a PivotTable (p. 318 New!)
• Analyzing Data Using a PivotChart (p. 320 New!)
• Updating a PivotTable or PivotChart (p. 321 New!)
• Modifying a PivotTable (p. 322 New!)
• Formatting a PivotTable (p. 323)
• Working with PivotTable Data (p. 324 New!)
• Using Slicers to Filter a PivotTable (p. 326)
• Displaying a Timeline to Filter a PivotTable (p. 328 New!)
• Drilling into PivotTable Data (p. 329 New!)
• Charting a PivotTable (p. 330 New!)
• Presenting Data with Power View (p. 332 New!)
• Working with PowerPivot (p. 334 New!)
• Creating Groups and Outlines (p. 335)
• Converting Text to Columns (p. 336)
• Adding Data Validation to a Worksheet (p. 337)
• Creating a Drop-Down List (p. 338)
• 11 Building More Powerful Worksheets (p. 339)
• Using Data Analysis Tools (p. 340)
• Using the Euro Conversion (p. 341)
• Looking at Alternatives with Data Tables (p. 342)
• Asking "What If" with Goal Seek (p. 343)
• Creating Scenarios (p. 344)
• Using Solver (p. 346)
• Using Inquire Tools (p. 348 New!)
• Using Lookup and Reference Functions (p. 350 New!)
• Using Text Functions (p. 352 New!)
• Summarizing Data Using Subtotals (p. 353)
• Summarizing Data Using Functions (p. 354)
• Using Date & Time Functions (p. 356 New!)
• Using Logical Functions (p. 358 New!)
• Using Financial Functions (p. 359 New!)
• Using Math Functions (p. 360 New!)
• Using Statistical Functions (p. 361 New!)
• Using Information Functions (p. 362 New!)
• Using Compatibility Functions (p. 363)
• Using Web Functions (p. 364 New!)
• 12 Protecting and Securing a Workbook (p. 365)
• Inspecting Workbooks (p. 366)
• Protecting a Worksheet (p. 368)
• Locking and Unlocking Worksheet Cells (p. 370)
• Adding Security Encryption to a Workbook (p. 371)
• Adding Password Protection to a Workbook (p. 372)
• Adding a Digital Signature (p. 374)
• Adding a Signature Line (p. 376)
• Avoiding Harmful Attacks (p. 378)
• Using the Trust Center (p. 380)
• Selecting Trusted Publishers and Locations (p. 381)
• Setting Document Related Security Options (p. 382)
• Setting App Catalog Security Options (p. 384 New!)
• Setting Add-in Security Options (p. 385)
• Setting ActiveX Security Options (p. 386)
• Setting Macro Security Options (p. 387)
• Changing Message Bar Security Options (p. 388)
• Setting Privacy Options (p. 389)
• Setting External Content Security Options (p. 390)
• Working with Office Safe Modes (p. 392)
• Marking a Workbook as Read-Only (p. 394)
• 13 Reviewing and Sharing Workbook Data (p. 395)
• Sharing Workbooks (p. 396)
• Creating and Reading a Cell Comment (p. 398)
• Editing and Deleting a Cell Comment (p. 399)
• Tracking Workbook Changes (p. 400)
• Sending a Workbook Using E-Mail (p. 402)
• Sending a Workbook by Internet Fax (p. 403 New!)
• Sending a Workbook by Instant Message (p. 404 New!)
• Presenting a Workbook Online (p. 405 New!)
• Sharing Information Between Programs (p. 406)
• Linking Data (p. 407)
• Linking and Embedding Files (p. 408)
• Exporting and Importing Data (p. 410)
• Consolidating Data (p. 412)
• Getting External Data (p. 414 New!)
• Getting Text Data (p. 415)
• Connecting to External Data (p. 416)
• Getting Query Data from a Database (p. 418)
• Getting Data from Microsoft Access (p. 420)
• Working with XML (p. 422)
• Creating an XML Data Map (p. 424)
• Exporting and Saving Data in XML (p. 426)
• 14 Publishing Workbook Data as Web Pages (p. 427)
• Opening a Workbook as a Web Page (p. 428)
• Previewing a Web Page (p. 429)
• Creating a Hyperlink (p. 430)
• Formatting a Hyperlink (p. 432)
• Changing Web Page Options (p. 433)
• Saving a Worksheet as a Web Page (p. 434)
• Publishing a Web Page (p. 436)
• Copying a Web Table to a Worksheet (p. 437)
• Creating Refreshable Web Queries (p. 438)
• Getting Data from Web Queries (p. 439)
• Getting Documents from the Web (p. 440)
• 15 Tools for Working More Efficiently (p. 441)
• Getting General Excel Options (p. 442 New!)
• Setting New Workbook and Start Up Options (p. 443 New!)
• Setting Editing Options (p. 444 New!)
• Setting Image Options (p. 446)
• Setting Chart Options (p. 447 New!)
• Setting Workbook and Worksheet Display Options (p. 448)
• Setting Display View Options (p. 450 New!)
• Setting Advanced Options (p. 451)
• Setting Formula Options (p. 452)
• Changing Advanced Document Properties (p. 453)
• Customizing the Way You Create Objects (p. 454)
• Accessing Commands Not in the Ribbon (p. 455)
• Working with Office Tools (p. 456 New!)
• Maintaining and Repairing Office (p. 458)
• 16 Expanding Excel Functionality (p. 459)
• Adding and Inserting Apps for Office (p. 460 New!)
• Viewing and Managing Add-ins (p. 462)
• Loading and Unloading Add-ins (p. 464 New!)
• Enhancing a Workbook with VBA (p. 466)
• Viewing the Visual Basic Editor (p. 468)
• Setting Developer Options (p. 469)
• Understanding How Macros Automate Your Work (p. 470)
• Recording a Macro (p. 471)
• Creating a Macro (p. 472)
• Running a Macro (p. 473)
• Controlling a Macro (p. 474)
• Adding a Digital Signature to a Macro Project (p. 476)
• Assigning a Macro to a Toolbar or Ribbon (p. 477)
• Saving a Workbook with Macros (p. 478)
• Opening a Workbook with Macros (p. 479)
• Inserting ActiveX Controls (p. 480)
• Using ActiveX Controls (p. 482)
• Setting ActiveX Control Properties (p. 483)
• Adding VBA Code to an ActiveX Control (p. 484)
• 17 Working Online with Office Documents (p. 485)
• Working Online with SharePoint and SkyDrive (p. 486 New!)
• Signing in to SharePoint or SkyDrive (p. 488 New!)
• Saving and Opening on SharePoint or SkyDrive (p. 490 New!)
• Accessing Documents on SharePoint (p. 492 New!)
• Syncing Documents on SharePoint (p. 494 New!)
• Sharing Documents on SkyDrive (p. 496 New!)
• Accessing Documents on SkyDrive (p. 498 New!)
• Managing Documents on SkyDrive (p. 500 New!)
• Downloading or Uploading Documents on SkyDrive (p. 502)
• Creating Office Documents on SkyDrive (p. 503)
• Sending Links to Documents on SkyDrive (p. 504 New!)
• Comparing the Office Desktop App to the Web App (p. 506)
• Working with Office Web Apps (p. 508 New!)
• Saving or Printing in Office Web Apps (p. 510)
• Co-authoring Documents with Office Web Apps (p. 512 New!)
• New Features (p. 515 New!)
• Microsoft Office Specialist (p. 521)
• Index (p. 529)

Author notes provided by Syndetics