Excel for Mac Essential Training (Microsoft 365) (2021)

Focused View

Curt Frye

3:53:54

0 View

[1] Introduction

[1] Learn how to succeed with Excel for Mac.mp4

00:32

[2] What you should know.mp4

00:54

[2] 1. Getting Started with Excel

[1] What can you do with Excel for Mac.mp4

02:43

[2] Explore the Excel for Mac program window.mp4

04:25

[3] The ribbon.mp4

05:08

[4] Set program preferences.mp4

04:08

[5] Get help in Excel.mp4

03:18

[3] 2. Managing Workbooks

[1] Open, create, and save workbooks.mp4

03:41

[2] Set workbook properties.mp4

02:53

[3] Create and modify templates.mp4

02:20

[4] 3. Working with Cells, Ranges, and Data

[1] Select cells and groups of cells.mp4

05:42

[2] Copy and paste cell data.mp4

04:56

[3] Enter data using AutoFill and other techniques.mp4

05:56

[4] Create named ranges.mp4

05:17

[5] Create an Excel table.mp4

05:11

[6] Locate and change data using Find and Replace.mp4

04:45

[7] Guide cell input using validation rules.mp4

06:05

[8] Enable data entry using validation lists.mp4

05:12

[5] 4. Sorting, Filtering, and Managing Worksheets

[1] Sort worksheet data.mp4

04:10

[2] Create a custom sort order.mp4

05:09

[3] Filter worksheet data.mp4

04:32

[4] Insert, move, and delete cells and cell ranges.mp4

02:55

[5] Manage worksheets.mp4

04:27

[6] 5. Summarizing Data Using Formulas and Functions

[1] Introduce Excel formulas, functions, and operators.mp4

03:41

[2] Add a formula to a cell.mp4

07:16

[3] Use relative and absolute cell references.mp4

04:53

[4] Control how Excel copies and pastes formulas.mp4

05:04

[5] Refer to Excel table data in formulas.mp4

02:48

[6] Summarize data on the status bar.mp4

02:34

[7] Summarize data using IF functions.mp4

05:30

[8] Identify precedents and dependents.mp4

03:58

[7] 6. Formatting Worksheet Elements

[1] Apply fonts, background colors, and borders.mp4

06:27

[2] Apply number and date formats to cells.mp4

04:49

[3] Manage text alignment.mp4

04:33

[4] Copy cell formats.mp4

04:59

[5] Manage cell styles.mp4

05:56

[6] Create rule-based conditional formats.mp4

04:12

[7] Define data bar, color scale, and icon set conditional formats.mp4

06:41

[8] Manage conditional formats.mp4

04:57

[8] 7. Working with Charts

[1] Create bar and column charts.mp4

04:10

[2] Create line charts.mp4

03:27

[3] Create XY (scatter) charts.mp4

02:51

[4] Change chart types and layouts.mp4

02:44

[5] Format chart elements.mp4

03:35

[6] Manage chart axes and numbering.mp4

04:53

[7] Create sparkline charts.mp4

04:17

[9] 8. Exploring PivotTables

[1] Create a PivotTable.mp4

03:54

[2] Pivot a PivotTable.mp4

03:28

[3] Manage subtotals and grand totals.mp4

03:47

[4] Change the data field summary operation.mp4

05:58

[5] Change the format of a data field.mp4

02:05

[10] 9. Reviewing and Sharing Your Spreadsheets

[1] Check spelling.mp4

02:44

[2] Set AutoCorrect and automatic Replace options.mp4

03:40

[3] Manage workbook comments.mp4

03:05

[4] Print a worksheet or workbook.mp4

02:20

[5] Set and remove print areas.mp4

01:24

[6] Export workbooks to other formats.mp4

02:00

[11] Conclusion

[1] Further information.mp4

00:55

Description

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 Office 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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Curt Frye

Instructor's Courses

I'm president and founder of Technology and Society, Incorporated, an Oregon "C" Corporation that encompasses my work as a course developer, writer, and speaker. I offer programs on effective teamwork, personal development, and business storytelling. BA (political science) and MBA.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.