Table of Contents

• Introduction
• Examining the Excel environment
  • Chapter 1: What's new in Microsoft Excel 2013
  • Chapter 2: Exploring Excel fundamentals
  • Chapter 3: Custom-tailoring the Excel workspace
  • Chapter 4: Security and privacy
• Building worksheets
  • Chapter 5: Planning your worksheet design
  • Chapter 6: How to work a worksheet
  • Chapter 7: How to work a workbook
• Formatting and editing worksheets
  • Chapter 8: Worksheet editing techniques
  • Chapter 9: Worksheet formatting techniques
• Adding graphics and printing
  • Chapter 10: Creating and formatting graphics
  • Chapter 11: Printing and presenting
• Creating formulas and performing data analysis
  • Chapter 12: Building formulas
  • Chapter 13: Using functions
  • Chapter 14: Everyday functions
  • Chapter 15: Formatting and calculating date and time
  • Chapter 16: Functions for financial analysis
  • Chapter 17: Functions for analyzing statistics
  • Chapter 18: Performing a what-if analysis
• Creating charts
  • Chapter 19: Designing charts
  • Chapter 20: Formatting charts
  • Chapter 21: Using sparklines
• Managing databases and tables
  • Chapter 22: Managing information in tables
  • Chapter 23: Analyzing data with PivotTable reports
  • Chapter 24: An introduction to PowerPivot
  • Chapter 25: Working with external data
• Using Excel collaboratively
  • Chapter 26: Collaborating on a network or by email
  • Chapter 27: Working in the cloud
• Automating Excel
  • Chapter 28: Recording macros
  • Chapter 29: Creating custom functions
  • Chapter 30: Debugging macros and custom functions
• Integrating and extending Excel
  • Chapter 31: Linking, hyperlinking, and embedding
  • Chapter 32: Using Excel data in Word documents
• Appendixes
  • Menu-to-ribbon command reference
  • Keyboard shortcuts
  • Function reference
• Index to troubleshooting topics
• About the authors

About the Author

Craig Stinson is a computer journalist and author specializing in Microsoft Office and Windows. He has written or coauthored more than 20 books, including Windows 7 Inside Out, Deluxe Edition, and Microsoft Excel 2010 Inside Out.