## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

## Book Description

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

1. Cover
2. Title Page
4. Dedication
5. Contents
6. I. Introduction
1. Who this book is for
2. The Step by Step approach
4. Ebook edition
5. Get support and give feedback
7. Part 1: Create and format workbooks
1. 1. Set up a workbook
1. Explore the editions of Excel 2016
2. Become familiar with new features in Excel 2016
3. Create workbooks
4. Modify workbooks
5. Modify worksheets
6. Merge and unmerge cells
7. Customize the Excel 2016 app window
8. Skills review
2. 2. Work with data and Excel tables
1. Enter and revise data
2. Manage data by using Flash Fill
3. Move data within a workbook
4. Find and replace data
5. Correct and expand upon data
6. Define Excel tables
7. Skills review
3. 3. Perform calculations on data
1. Name groups of data
2. Create formulas to calculate values
3. Summarize data that meets specific conditions
4. Set iterative calculation options and enable or disable automatic calculation
5. Use array formulas
6. Find and correct errors in calculations
7. Skills review
4. 4. Change workbook appearance
1. Format cells
2. Define styles
3. Apply workbook themes and Excel table styles
4. Make numbers easier to read
5. Change the appearance of data based on its value
7. Skills review
8. Part 2: Analyze and present data
1. 5. Manage worksheet data
1. Limit data that appears on your screen
2. Manipulate worksheet data
3. Define valid sets of values for ranges of cells
4. Skills review
2. 6. Reorder and summarize data
1. Sort worksheet data
2. Sort data by using custom lists
3. Organize data into levels
4. Look up information in a worksheet
5. Skills review
3. 7. Combine data from multiple sources
1. Use workbooks as templates for other workbooks
2. Link to data in other worksheets and workbooks
3. Consolidate multiple sets of data into a single workbook
4. Skills review
4. 8. Analyze alternative data sets
1. Examine data by using the Quick Analysis Lens
2. Define an alternative data set
3. Define multiple alternative data sets
4. Analyze data by using data tables
5. Vary your data to get a specific result by using Goal Seek
6. Find optimal solutions by using Solver
7. Analyze data by using descriptive statistics
8. Skills review
5. 9. Create charts and graphics
1. Create charts
2. Create new types of charts
3. Customize chart appearance
4. Find trends in your data
5. Create dual-axis charts
6. Summarize your data by using sparklines
7. Create diagrams by using SmartArt
8. Create shapes and mathematical equations
9. Skills review
6. 10. Create dynamic worksheets by using PivotTables
1. Analyze data dynamically by using PivotTables
2. Filter, show, and hide PivotTable data
3. Edit PivotTables
4. Format PivotTables
5. Create PivotTables from external data
6. Create dynamic charts by using PivotCharts
7. Skills review
9. Part 3: Collaborate and share in Excel
1. 11. Print worksheets and charts
2. Prepare worksheets for printing
3. Print worksheets
4. Print parts of worksheets
5. Print charts
6. Skills review
2. 12. Automate repetitive tasks by using macros
1. Enable and examine macros
2. Create and modify macros
3. Run macros when you click a button
4. Run a macro when you open a workbook
5. Insert form controls into a worksheet
6. Skills review
3. 13. Work with other Microsoft Office apps
1. Include Office documents in workbooks and other files
3. Paste charts into documents
4. Skills review
4. 14. Collaborate with colleagues
1. Share workbooks
2. Save workbooks for electronic distribution
4. Track and manage colleagues’ changes
5. Add protection to workbooks and worksheets
6. Finalize workbooks
7. Authenticate workbooks
8. Save workbooks for the web
9. Import and export XML data
10. Work with OneDrive and Excel Online
11. Skills review
10. Part 4: Perform advanced analysis
1. 15. Perform business intelligence analysis
1. Enable the Data Analysis add-ins
2. Define relationships between tables
3. Analyze data by using Power Pivot
4. View data by using timelines
5. Bring in external data by using Power Query
6. Skills review
2. 16. Create forecasts and visualizations
1. Create Forecast Worksheets
2. Define and manage measures
3. Define and display Key Performance Indicators
4. Create 3D maps
5. Skills review
11. Appendix: Keyboard shortcuts
12. Glossary
13. Index