Excel 2019 for Mac Essential Training

Introduction

• Learn how to succeed with Excel for Mac
• What you should know

1. Getting Started with Excel

• What can you do with Excel for Mac?
• Explore the Excel for Mac program window
• The ribbon
• Set program preferences
• Get help in Excel

2. Managing Workbooks

• Open, create, and save workbooks
• Set workbook properties
• Create and modify templates

3. Working with Cells, Ranges, and Data

• Select cells and groups of cells
• Copy and paste cell data
• Enter data using AutoFill and other techniques
• Create named ranges
• Create an Excel table
• Locate and change data using Find and Replace
• Guide cell input using validation rules
• Enable data entry using validation lists

4. Sorting, Filtering, and Managing Worksheets

• Sort worksheet data
• Create a custom sort order
• Filter worksheet data
• Insert, move, and delete cells and cell ranges
• Manage worksheets

5. Summarizing Data Using Formulas and Functions

• Introduce Excel formulas, functions, and operators
• Add a formula to a cell
• Use relative and absolute cell references
• Control how Excel copies and pastes formulas
• Refer to Excel table data in formulas
• Summarize data on the status bar
• Summarize data using IF functions
• Identify precedents and dependents

6. Formatting Worksheet Elements

• Apply fonts, background colors, and borders
• Apply number and date formats to cells
• Manage text alignment
• Copy cell formats
• Manage cell styles
• Create rule-based conditional formats
• Define data bar, color scale, and icon set conditional formats
• Manage conditional formats

7. Working with Charts

• Create bar and column charts
• Create line charts
• Create XY (scatter) charts
• Change chart types and layouts
• Format chart elements
• Manage chart axes and numbering
• Create sparkline charts

8. Exploring PivotTables

• Create a PivotTable
• Pivot a PivotTable
• Manage subtotals and grand totals
• Change the data field summary operation
• Change the format of a data field

9. Reviewing and Sharing Your Spreadsheets

• Check spelling
• Set AutoCorrect and automatic Replace options
• Manage workbook comments
• Print a worksheet or workbook
• Set and remove print areas
• Export workbooks to other formats

Conclusion

• Further information