Learning Microsoft Excel 2016 for Mac

Course Curriculum

Chapter 1: Your Excel 2016 Journey Starts Here

Lecture 1: Important – Download These First – Working Files

Lecture 2: Quick Introduction To The New Excel 2016 Interface

Lecture 3: Do I Need A Microsoft Account?

Lecture 4: About Your Author

Lecture 5: Using The Included Working Files

Chapter 2: Managing Excel Workbooks And Worksheets

Lecture 1: Creating And Saving A New Workbook

Lecture 2: Opening And Closing Workbooks

Lecture 3: Saving And Opening Excel Files To And From OneDrive And iCloud

Lecture 4: Saving Excel Files In Other Formats

Lecture 5: Adding, Deleting, Moving, And Copying Worksheets

Lecture 6: Using The Excel 2016 Templates

Chapter 3: Entering And Editing Data In Cells

Lecture 1: Entering Text, Numbers, And Dates

Lecture 2: Editing The Contents Of Cells

Lecture 3: Undo And Redo Your Actions

Lecture 4: Cut, Copy, And Paste

Lecture 5: Drag And Dropping Cells

Lecture 6: The Fill Handle

Lecture 7: Inserting And Deleting Rows And Columns

Lecture 8: Changing Column Widths And Row Heights

Lecture 9: Hiding And Unhiding Rows, Columns And Sheets

Lecture 10: Searching For Values In A Workbook

Chapter 4: Math Basics

Lecture 1: Getting Started With Basic Mathematical Operators

Lecture 2: Order Of Operation With BODMAS

Lecture 3: Introduction To Basic Formula

Lecture 4: The New Formula Builder And Quick SUMs

Lecture 5: Copying Formula And Functions

Lecture 6: Displaying Formulae On A Worksheet

Chapter 5: Formatting Worksheets

Lecture 1: Selecting Cells For Formatting

Lecture 2: Modifying Typeface, Font Size And Colors

Lecture 3: Cell Alignment, Orientation And Merging

Lecture 4: Using Number Formats

Lecture 5: Adding And Removing Borders

Lecture 6: Applying Date Formats To Cells

Lecture 7: Format Painter And Fill Formatting

Lecture 8: Clearing Cell Contents And Formatting

Chapter 6: Page Setup And Printing

Lecture 1: Paper Size, Margins, Orientation And Scaling

Lecture 2: Using A Print Area And Printing Titles

Lecture 3: Using The Page Break Tools

Lecture 4: Creating Headers And Footers – Method 1

Lecture 5: Creating Headers And Footers – Method 2

Lecture 6: Other Print Options And Checking Spelling

Lecture 7: Generating A PDF From A Worksheet

Chapter 7: Mathematical Formulas

Lecture 1: The SUM Function

Lecture 2: Other Mathematical Functions – AVERAGE, MIN And MAX

Lecture 3: Useful Count Functions

Lecture 4: Averages, Mean, Mode, And Median

Lecture 5: Using PI In Formula

Lecture 6: Absolute Referencing Explained

Lecture 7: Formulas Across Worksheets

Lecture 8: 3D Referencing

Lecture 9: Making Use Of Named Ranges

Lecture 10: Dates, Shapes, And Formula

Lecture 11: IF Statements

Chapter 8: Advanced Formatting

Lecture 1: Adding, Editing, Deleting, And Printing Comments

Lecture 2: Creating Your Own Custom List

Lecture 3: Converting To A Table For Formatting

Chapter 9: Security

Lecture 1: Activate And Deactivate Worksheet And Workbook Protection

Lecture 2: Protecting Part Of A Worksheet To Aid Data Entry

Lecture 3: Password Protecting The Workbook File

Chapter 10: Excel 2016 Summary

Lecture 1: What You Have Learned