Microsoft Excel Step by Step (Office 2021 and Microsoft 365)

Table of contents

1. Cover Page
2. Title Page
3. Copyright Page
4. Pearson’s Commitment to Diversity, Equity, and Inclusion
5. Contents
6. Acknowledgments
7. About the author
8. Introduction
   1. Who this book is for
   2. The Step by Step approach
   3. Features and conventions
   4. Download the practice files
   5. E-book edition
   6. Get support and give feedback
9. Part 1: Create and format workbooks
   1. 1. Set up a workbook
      1. Create workbooks
      2. Modify workbooks
      3. Modify worksheets
      4. Merge and unmerge cells
      5. Customize the Excel app window
      6. Skills review
      7. Practice tasks
   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 fine-tune data
      6. Define Excel tables
      7. Skills review
      8. Practice tasks
   3. 3. Perform calculations on data
      1. Name data ranges
      2. Create formulas to calculate values
      3. Summarize data that meets specific conditions
      4. Copy and move formulas
      5. Create array formulas
      6. Find and correct errors in calculations
      7. Configure automatic and iterative calculation options
      8. Skills review
      9. Practice tasks
   4. 4. Change workbook appearance
      1. Format cells
      2. Define and manage cell styles
      3. Apply and modify workbook themes
      4. Apply and modify table styles
      5. Make numbers easier to read
      6. Change the appearance of data based on its value
      7. Add images to worksheets
      8. Skills review
      9. Practice tasks
10. Part 2: Analyze and present data
    1. 5. Manage worksheet data
       1. Filter data ranges and tables
       2. Summarize filtered data
       3. Enforce data entry criteria
       4. Skills review
       5. Practice tasks
    2. 6. Reorder and summarize data
       1. Sort worksheet data
       2. Sort data by using custom lists
       3. Outline and subtotal data
       4. Skills review
       5. Practice tasks
    3. 7. Combine data from multiple sources
       1. Look up data from other locations
       2. Link to data in other locations
       3. Consolidate multiple sets of data
       4. Skills review
       5. Practice tasks
    4. 8. Analyze alternative data sets
       1. Define and display alternative data sets
       2. Forecast data by using data tables
       3. Identify the input necessary to achieve a specific result
       4. Skills review
       5. Practice tasks
    5. 9. Create charts and graphics
       1. Create standard charts
       2. Create combo charts
       3. Create specialized charts
       4. Customize chart appearance
       5. Identify data trends
       6. Summarize data by using sparklines
       7. Illustrate processes and relationships
       8. Insert and manage shapes
       9. Skills review
       10. Practice tasks
    6. 10. Create PivotTables and PivotCharts
       1. Analyze data dynamically in PivotTables
       2. Filter, show, and hide PivotTable data
       3. Edit PivotTables
       4. Format PivotTables
       5. Create dynamic PivotCharts
       6. Skills review
       7. Practice tasks
11. Part 3: Collaborate and share in Excel
    1. 11. Print worksheets and charts
       1. Add headers and footers to printed pages
       2. Prepare worksheets for printing
       3. Print worksheets
       4. Print parts of worksheets
       5. Print charts
       6. Skills review
       7. Practice tasks
    2. 12. Automate tasks and input
       1. Enable and examine macros
       2. Create and modify macros
       3. Run macros
       4. Present information and options as form controls
       5. Skills review
       6. Practice tasks
    3. 13. Work with other Microsoft 365 apps
       1. Combine Excel, Word, and PowerPoint content
       2. Create hyperlinks from worksheets
       3. Copy or link to charts
       4. Skills review
       5. Practice tasks
    4. 14. Collaborate with colleagues
       1. Manage comments
       2. Protect workbooks and worksheets
       3. Finalize workbooks
       4. Save workbook content as a PDF file
       5. Create and distribute workbook templates
       6. Skills review
       7. Practice tasks
12. Part 4: Perform advanced analysis
    1. 15. Perform business intelligence analysis
       1. Manage the Excel Data Model
       2. Define relationships between data sources
       3. Manage data by using Power Pivot
       4. Display data on timelines
       5. Import data by using Power Query
       6. Skills review
       7. Practice tasks
    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 data maps
       5. Skills review
       6. Practice tasks
13. Appendix: Keyboard Shortcuts
    1. Excel for Microsoft 365 keyboard shortcuts
    2. Excel function key commands
    3. Microsoft 365 app keyboard shortcuts
14. Glossary
15. Index