Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn Microsoft Excel for Mac 2019 - Beginners
Section 1: Introduction to Excel
Introduction to Excel for Mac (5:23)
The Difference between PC and Mac Excel (7:12)
Course Overview (3:42)
Overview of the Excel window (15:38)
Mouse and Trackpad Features (3:34)
Creating a New Workbook (3:17)
Course Exercise Files
Course Demo Files
Section 2: Creating Workbooks
Entering Text and Numbers (9:14)
Creating Basic Formulas (9:53)
Relative vs Absolute References (8:06)
Order of Operations (3:42)
Working with Ranges (6:52)
Practice Exercise 01 (2:02)
Section 3: Saving Workbooks
Saving and Sharing Spreadsheets (6:41)
Practice Exercise 02 (0:53)
Section 4: Navigating Large Workbooks
Freeze Panes Option (3:46)
Split Screen Option (2:35)
Arranging Windows Option (2:16)
Practice Exercise 03 (0:57)
Section 5: Page Setup and Print Options
Headers and Footers (6:20)
Print Titles (3:12)
Comments (6:05)
Page Setup Options (5:08)
Printing Workbooks (3:32)
Practice Exercise 04 (1:23)
Section 6: Working with Rows, Columns and Cells
Adding and Deleting Rows, Columns and Cells (3:42)
Changing Column and Row Widths (3:50)
Practice Exercise 05 (1:07)
Section 7: Moving Data
Cut, Copy and Paste (7:38)
Copying Formulas (6:01)
Practice Exercise 06 (1:14)
Section 8: Formulas and Functions
Overview of Formulas (8:40)
Creating Formulas using Functions - Part 1 (13:25)
Creating Formulas using Functions - Part 2 (14:16)
Practice Exercise 07 (2:08)
Section 9: Working with Sheets
3 Dimensional Formulas (6:25)
Sheet Tab Options (6:08)
Practice Exercise 08 (2:09)
Section 10: Formatting Worksheets
Formatting Cells - Part 1 (8:12)
Formatting Cells - Part 2 (7:35)
Number Formatting (7:13)
Formatting as Table (9:45)
Using Styles (8:15)
Conditional Formatting (10:19)
Using Format Painter (3:07)
Protecting Sheets (6:05)
Fill Handle and Custom Lists (4:43)
Section 11: Charts
Creating Charts (5:47)
Editing Charts - Part 1 (9:11)
Editing Charts - Part 2 (8:12)
Practice Exercise 10 (1:25)
Section 12: Sorting and Filtering
Remove Duplicates (6:42)
Sort Data (4:35)
Filter Data (6:29)
Advanced Filter (3:36)
Practice Exercise 11 (1:08)
Section 13: Conclusion
Course Close (1:25)
Course Quiz and Certificate of Completion
Remove Duplicates
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock