Table of Contents

• Part 1: Create and format workbooks
• Chapter 1: Set up a workbook
• Chapter 2: Work with data and Excel tables
• Chapter 3: Perform calculations on data
• Chapter 4: Change workbook appearance
• Part 2: Analyze and present data
• Chapter 5: Manage worksheet data
• Chapter 6: Reorder and summarize data
• Chapter 7: Combine data from multiple sources
• Chapter 8: Analyze alternative data sets
• Chapter 9: Create charts and graphics
• Chapter 10: Create dynamic worksheets by using PivotTables
• Part 3: Collaborate and share in Excel
• Chapter 11: Print worksheets and charts
• Chapter 12: Automate repetitive tasks by using macros
• Chapter 13: Work with other Microsoft Office apps
• Chapter 14: Collaborate with colleagues
• Part 4: Perform advanced analysis
• Chapter 15: Perform business intelligence analysis
• Chapter 16: Create forecasts and visualizations
• Keyboard shortcuts
• Glossary
• Index
• About the author

About the Author

Curtis Frye is the author of more than 30 books, including  Microsoft Excel 2013 Step by Step for Microsoft Press and  Brilliant Excel VBA Programming for Pearson, UK. He has also created and recorded more than three dozen courses for lynda.com, including  Excel for Mac 2016 Essential Training and  Excel 2013: PivotTables in Depth. In addition to his work as a writer, Curt is a popular conference speaker and performer, both as a solo presenter and as part of the Portland, Oregon ComedySportz improvisational comedy troupe. He lives in Portland with his wife and three cats.