Previous Edition 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.