Microsoft Excel 2016 Step by Step

Now in full color!

The quick way to learn Microsoft Excel 2016!

This is learning made easy. Get more done quickly with Excel 2016. Jump in wherever you need answers–brisk lessons and full-color screen shots show you exactly what to do, step by step.

• Quickly set up workbooks, enter data, and format it for easier viewing
• Perform calculations and find and correct errors
• Filter, sort, summarize, and combine data
• Analyze data by using PivotTables, PivotCharts, scenarios, data tables, and Solver
• Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps
• Build data models and use them in business intelligence analyses
• Create timelines, forecasts, and visualizations, including KPIs and PowerMap data maps
• Look up just the tasks and lessons you need

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