Book Description
Get more out of Microsoft Excel® 2013: more productivity and better answers for greater success! Drawing on his unsurpassed Excel experience, Bill Jelen (“Mr Excel”) brings together all the intensely useful knowledge you need: insights, techniques, tips, and shortcuts you just won’t find anywhere else. Excel 2013 In Depth is the fastest, best way to master Excel 2013’s full power; get comfortable with its updated interface; and leverage its new tools for everything from formulas, charts, and functions to dashboards, data visualization, and social media integration. Start by taking a quick “tour” of Excel 2013’s most valuable new features. Then, learn how to
Build more trustworthy, errorresistant, flexible, extensible, intelligent, and understandable spreadsheets
Get more productive with Excel 2013’s new Start Screen and Timelines
Create formulas, charts, subtotals, and pivot tables faster with new Flash Fill and Analysis Lens
Quickly apply attractive, consistent formats
Master every function you’ll ever need, including powerful new web services functions
Solve realworld business intelligence analysis problems
Create amazing PowerPivot data mashups that integrate information from anywhere
Use Power View to generate stunningly intuitive maps, dashboards, and data visualizations
Share workbooks on the Web and social networks
Leverage the improved Excel Web App to create highly interactive web pages and online surveys
Automate repetitive functions using Excel macros
Supercharge your workbooks with new apps from the Excel App Store
Like all In Depth books, Excel 2013 In Depth delivers complete coverage with detailed solutions, and troubleshooting help for tough problems you can’t fix on your own. Whatever you intend to do with Excel 2013, this is the only book you’ll need!
Table of Contents
 Title Page
 Copyright Page
 Contents at a Glance
 Table of Contents
 About the Author
 Dedication
 Acknowledgments
 We Want to Hear from You!
 Reader Services
 Introduction

I: Mastering the New User Interface
 1. Staying Connected Using Excel 2013
 2. Introducing Flash Fill and Quick Analysis

3. Using the Excel Interface
 Using the Ribbon
 Using the Quick Access Toolbar
 Using the FullScreen File Menu
 Using Other Excel Interface Improvements
 Using the New Sheet Icon to Add Worksheets
 Navigating Through Many Worksheets Using the Controls in the Lower Left
 Using the Mini Toolbar to Format Selected Text
 Expanding the Formula Bar
 Zooming In and Out on a Worksheet
 Using the Status Bar to Add Numbers
 Switching Between Normal View, Page Break Preview, and Page Layout View Modes
 4. Customizing Excel
 5. Extending Excel with Excel Apps and AddIns
 6. Keyboard Shortcuts

7. The Big Grid and File Formats
 Excel Grid Limits
 Why Are There Only 65,536 Rows in My Excel 2013 Spreadsheet?
 Other Limits in Excel 2013
 Tips for Navigating the Big Grid
 Understanding the File Formats
 Version Compatibility
 Opening Excel 2013 Files in Excel 2002 or 2003
 Creating Excel 2013 File Formats in Excel 2003
 Opening Excel 2013 Files in Excel 2007

II: Calculating with Excel
 8. Understanding Formulas
 9. Controlling Formulas
 10. Understanding Functions
 11. Using Everyday Functions: Math, Date and Time, and Text Functions
 12. Using Powerful Functions: Logical, Lookup, Web, and Database Functions
 13. Using Financial Functions
 14. Using Statistical Functions
 15. Using Trig, Matrix, and Engineering Functions
 16. Connecting Worksheets, Workbooks, and External Data
 17. Using Super Formulas in Excel

18. Using Names in Excel
 Advantages of Using Names
 Naming a Cell by Using the Name Dialog
 Using the Name Box for Quick Navigation
 Avoiding Problems by Using WorksheetLevel Scope
 Using Named Ranges to Simplify Formulas
 Managing Names
 Using a Name to Simplify an Absolute Reference
 Using a Name to Hold a Value
 Assigning a Formula to a Name

19. Fabulous Table Intelligence
 Defining Suitable Data for Excel Tables
 Adding a Total Row to a Table
 Toggling Totals
 Expanding a Table
 Adding New Formulas to Tables
 Selecting Only the Data in the Column
 Using Table Data for Charts to Ensure Stickiness
 Replacing Named Ranges with Table References
 Creating Banded Rows and Columns with Table Styles
 Dealing with the Filter DropDowns

III: Business Intelligence
 20. Sorting Data
 21. Removing Duplicates and Filtering
 22. Using Automatic Subtotals

23. Using Pivot Tables to Analyze Data
 Creating Your First Pivot Table
 Dealing with the Compact Layout
 Rearranging a Pivot Table
 Finishing Touches: Numeric Formatting and Removing Blanks
 Four Things You Have to Know When Using Pivot Tables
 Calculating and Rollups with Pivot Tables
 Formatting a Pivot Table
 Finding More Information on Pivot Tables
 24. Using Slicers and Filtering a Pivot Table

25. Mashing Up Data with PowerPivot
 Joining Multiple Tables Using the Data Model in Regular Excel 2013
 Benefits of Moving to PowerPivot
 Enabling PowerPivot
 Case Study: Building a PowerPivot Report
 Some Things Are Different
 Two Kinds of DAX Calculations
 Using DAX to Create a Calculated Field in the Pivot Table
 Defining KPIs with PowerPivot
 Using QuickExplore
 Other Notes
 26. Creating Interactive Dashboards with Power View or GeoFlow
 27. Using WhatIf, Scenario Manager, Goal Seek, and Solver

28. Automating Repetitive Functions Using VBA Macros
 Checking Security Settings Before Using Macros
 Recording a Macro
 Case Study: Macro for Formatting for a Mail Merge
 EverydayUse Macro Example: Formatting an Invoice Register
 Understanding VBA Code—An Analogy
 Using Simple Variables and Object Variables
 Customizing the EverydayUse Macro Example: GetOpenFileName and GetSaveAsFileName
 FromScratch Macro Example: Loops, Flow Control, and Referring to Ranges
 Combination Macro Example: Creating a Report for Each Customer

29. More Tips and Tricks for Excel 2013
 Speeding Up Calculation
 Watching the Results of a Distant Cell
 Opening the Same Files Every Day
 Comparing Documents Side by Side with Synchronous Scrolling
 Calculating a Formula in Slow Motion
 Inserting a Symbol in a Cell
 Edit an Equation
 Adding a Digital Signature Line to a Workbook
 Protecting a Worksheet
 Sharing a Workbook
 Separating Text Based on a Delimiter
 Translating Text
 Auditing Worksheets Using Inquire

IV: Visual Presentation
 30. Formatting Worksheets

31. Using Data Visualizations and Conditional Formatting
 Using Data Bars to Create InCell Bar Charts
 Using Color Scales to Highlight Extremes
 Using Icon Sets to Segregate Data
 Using the Top/Bottom Rules
 Using the Highlight Cells Rules
 Tweaking Rules with Advanced Formatting
 Combining Rules
 Clearing Conditional Formats
 Extending the Reach of Conditional Formats
 Special Considerations for Pivot Tables

32. Graphing Data Using Excel Charts
 Choosing from Recommended Charts
 Using Paintbrush Icon for Styles
 Deleting Extraneous Data Using the Funnel
 Changing Chart Options Using the Plus Icon
 Showing Two Orders of Magnitude Using a Combo Chart
 Labeling Charts
 Controlling the Axis Range
 Seeing the Relationship Between Two Variables in a Scatter Chart
 Summarizing Data Using the Quick Analysis Icon
 Saving Time with Charting Tricks
 33. Using Sparklines
 34. Using SmartArt, Shapes, WordArt, and Text Boxes
 35. Using Pictures and Clip Art
 V: Sharing Information
 Index
Product Information
 Title: Excel® 2013 In Depth
 Author(s):
 Release date: January 2013
 Publisher(s): Que
 ISBN: 9780133259322