Microsoft Excel 2019 Step by Step, First Edition

Table of contents

1. Cover Page
2. Title Page
3. Copyright Page
4. Contents
5. Acknowledgments
6. About the Author
7. Introduction
   1. Who this book is for
   2. The Step by Step approach
   3. Download the practice files
   4. Ebook edition
   5. Get support and give feedback
8. Part 1: Create and format workbooks
   1. 1 Set up a workbook
      1. Explore the editions of Excel 2019
      2. Become familiar with new features in Excel 2019
      3. Create workbooks
      4. Modify workbooks
      5. Modify worksheets
      6. Merge and unmerge cells
      7. Customize the Excel 2019 app window
      8. Skills review
      9. 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 expand upon data
      6. Define Excel tables
      7. Skills review
      8. Practice tasks
   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
      8. Practice tasks
   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
      6. Add images to worksheets
      7. Skills review
      8. Practice tasks
9. 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
      5. Practice tasks
   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
      6. Practice tasks
   3. 7 Combine data from multiple sources
      1. Use workbooks as templates for other workbooks
      2. Link to data in other workbooks and worksheets
      3. Consolidate multiple sets of data into a single workbook
      4. Skills review
      5. Practice tasks
   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
      9. Practice tasks
   5. 9 Create charts and graphics
      1. Create charts
      2. Perform business intelligence analysis using charts
      3. Customize chart appearance
      4. Find trends in your data
      5. Create combo charts
      6. Summarize your data by using sparklines
      7. Create diagrams by using SmartArt
      8. Create and manage shapes
      9. Create and manage mathematical equations
      10. Skills review
      11. Practice tasks
   6. 10 Use PivotTables and PivotCharts
      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
      8. Practice tasks
10. 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 repetitive tasks by using macros
       1. Enable and examine macros
       2. Create and modify macros
       3. Click a button to run a macro
       4. Run a macro when you open a workbook
       5. Insert form controls into a worksheet
       6. Skills review
       7. Practice tasks
    3. 13 Work with other Microsoft Office apps
       1. Include Office documents in workbooks and other files
       2. Create hyperlinks
       3. Paste charts into documents
       4. Skills review
       5. Practice tasks
    4. 14 Collaborate with colleagues
       1. Save workbooks for electronic distribution
       2. Manage comments
       3. Protect workbooks and worksheets
       4. Finalize workbooks
       5. Authenticate workbooks
       6. Save workbooks for the web
       7. Import and export XML data
       8. Work with OneDrive and Excel Online
       9. Skills review
       10. Practice tasks
11. Part 4: Perform advanced analysis
    1. 15 Perform business intelligence analysis
       1. Define a Data Model
       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
       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 maps
       5. Skills review
       6. Practice tasks
12. Keyboard Shortcuts
13. Glossary
14. Index
15. Code Snippets