Microsoft Excel 2016 Step by Step

Introduction
Who this book is for
The Step by Step approach
Download the practice files
Sidebar: Adapt exercise steps
Ebook edition
Get support and give feedback
Errata and support
We want to hear from you
Stay in touch

Part 1: Create and format workbooks
1. Set up a workbook
2. Work with data and Excel tables
3. Perform calculations on data
4. Change workbook appearance

Part 2: Analyze and present data
5. Manage worksheet data
6. Reorder and summarize data
7. Combine data from multiple sources
8. Analyze alternative data sets
9. Create charts and graphics
10. Create dynamic worksheets by using PivotTables

Part 3: Collaborate and share in Excel
11. Print worksheets and charts
12. Automate repetitive tasks by using macros
13. Work with other Microsoft Office apps

Part 4: Perform advanced analysis
15. Perform business intelligence analysis

Keyboard shortcuts
Glossary
Index
About the author