Excel for Mac Essential Training (Microsoft 365)

Course details

Excel for Mac is a powerful tool, but it can be intimidating for new users who either don't know where to start or don't know how to proceed beyond the most basic tasks. In this course, learn how to master the essential tasks in the Mac version of Excel for Microsoft 365. Excel expert Curt Frye shows how to manage workbooks, work with cells and cell data, and sort, filter, and manage worksheets. Plus, learn how to summarize data using core functions and formulas; format worksheet elements; create bar, column, and line charts; create and filter PivotTables; and share your spreadsheets with others.

Learning objectives
Navigate the Excel for Mac program window and find commands on the Excel for Mac ribbon.
Open, create, and save workbooks, and set workbook properties in Excel.
Select cells and groups of cells, copy and paste Excel data, and enter data using AutoFill and other techniques.
Create and use named ranges, Excel tables, and data validation rules.
Use Excel formulas, functions, and operators, and apply formatting to cells, manage cell styles, and define conditional formats.

Concepts

0. Introduction

01 - Analyze your data effectively using Excel for Mac

1. Getting Started with Excel

02 - What can you do with Excel for Mac
03 - Explore the Excel for Mac program window
04 - Introduce the ribbon
05 - Set program preferences
06 - Get help in Excel

2. Managing Workbooks

07 - Open, create, and, save workbooks
08 - Set workbook properties
09 - Create and modify templates

3. Working with Cells, Ranges, and Data

10 - Select cells and groups of cells
11 - Copy and paste cell data
12 - Enter data using AutoFill and other techniques
13 - Create named ranges
14 - Create an Excel table
15 - Locate and change data using Find and Replace
16 - Guide cell input using validation rules
17 - Enable data entry using validation lists

4. Sorting, Filtering, and Managing Worksheets

18 - Sort worksheet data
19 - Create a custom sort order
20 - Filter worksheet data
21 - Insert, move, and delete cells and cell ranges
22 - Manage worksheets

5. Summarizing Data Using Formulas and Functions

23 - Introduce Excel formulas, functions, and operators
24 - Add a formula to a cell
25 - Use relative and absolute cell references
26 - Control how Excel copies and pastes formulas
27 - Refer to Excel table data in formulas
28 - Summarize data on the status bar
29 - Summarize data using IF functions
30 - Identify precedents and dependents

6. Formatting Worksheet Elements

31 - Apply fonts, background colors, and borders
32 - Apply number and date formats to cells
33 - Manage text alignment
34 - Copy cell formats
35 - Manage cell styles
36 - Create rule-based conditional formats
37 - Define data bar conditional formats
38 - Define color scale conditional formats
39 - Define icon set conditional formats
40 - Manage conditional formats

7. Working with Charts

41 - Create bar and column charts
42 - Create line charts
43 - Create XY (scatter) charts
44 - Change chart types and layouts
45 - Format chart elements
46 - Manage chart axes and numbering
47 - Create sparkline charts

8. Exploring PivotTables

48 - Create a PivotTable
49 - Pivot a PivotTable
50 - Manage subtotals and grand totals
51 - Change the data field summary operation
52 - Change the format of a data field
53 - Create a PivotChart

9. Reviewing and Sharing Your Spreadsheets

54 - Check spelling
55 - Set AutoCorrect and AutoReplace options
56 - Manage workbook comments
57 - Print a worksheet or workbook
58 - Set and remove print areas
59 - Export workbooks to other formats

Conclusion

60 - Additional resources