Learning Microsoft Excel 2016 for Mac

Video description

Learning Microsoft Excel 2016 for Mac

Video description

In this Learning Microsoft Excel 2016 for Mac training course, expert author Guy Vaccaro will teach you everything you need to know to be able to work in Excel 2016, including managing your own workbooks, formatting worksheets, and creating and using formulas. This course is designed for the absolute beginner, meaning no previous experience with Excel is required.

You will start by learning how to manage Excel workbooks and worksheets, including creating and saving a new workbook, saving Excel files in other formats, and using the Excel 2016 templates. From there, Guy will teach you how to enter and edit data in cells. This video tutorial also covers how to use basic mathematical operators, format worksheets, and use mathematical formulas. Finally, you will cover advanced formatting and security, including activating worksheet and workbook protection and password protecting the workbook file.

Once you have completed this computer based training course, you will have gained the knowledge necessary to manage your own workbooks and worksheets in Microsoft Excel 2016 for Mac. Working files are included, allowing you to follow along with the author throughout the lessons.

Publisher resources

Download Example Code

Your Excel 2016 Journey Starts Here

Quick Introduction To The New Excel 2016 Interface 00:03:16

Do I Need A Microsoft Account? 00:02:40

About Your Author 00:01:36

Using The Included Working Files 00:02:16

Managing Excel Workbooks And Worksheets

Creating And Saving A New Workbook 00:05:27

Opening And Closing Workbooks 00:05:00

Saving And Opening Excel Files To And From OneDrive And iCloud 00:04:01

Saving Excel Files In Other Formats 00:05:34

Adding, Deleting, Moving, And Copying Worksheets 00:07:16

Using The Excel 2016 Templates 00:06:53

Entering And Editing Data In Cells

Entering Text, Numbers, And Dates 00:07:51

Editing The Contents Of Cells 00:05:40

Undo And Redo Your Actions 00:04:01

Cut, Copy, And Paste 00:07:04

Drag And Dropping Cells

The Fill Handle

Inserting And Deleting Rows And Columns

Changing Column Widths And Row Heights

Hiding And Unhiding Rows, Columns And Sheets

Searching For Values In A Workbook

Math Basics

Getting Started With Basic Mathematical Operators

Order Of Operation With BODMAS

Introduction To Basic Formula

The New Formula Builder And Quick SUMs

Copying Formula And Functions

Displaying Formulae On A Worksheet

Formatting Worksheets

Selecting Cells For Formatting

Modifying Typeface, Font Size And Colors

Cell Alignment, Orientation And Merging

Using Number Formats

Adding And Removing Borders

Applying Date Formats To Cells

Format Painter And Fill Formatting

Clearing Cell Contents And Formatting

Page Setup And Printing

Paper Size, Margins, Orientation And Scaling

Using A Print Area And Printing Titles

Using The Page Break Tools

Creating Headers And Footers - Method 1

Creating Headers And Footers - Method 2

Other Print Options And Checking Spelling

Generating A PDF From A Worksheet

Mathematical Formulas

The SUM Function

Other Mathematical Functions - AVERAGE, MIN And MAX

Useful Count Functions

Averages, Mean, Mode, And Median

Using PI In Formula

Absolute Referencing Explained

Formulas Across Worksheets

3D Referencing

Making Use Of Named Ranges

Dates, Shapes, And Formula

IF Statements

Advanced Formatting

Adding, Editing, Deleting, And Printing Comments

Creating Your Own Custom List

Converting To A Table For Formatting

Security

Activate And Deactivate Worksheet And Workbook Protection

Protecting Part Of A Worksheet To Aid Data Entry

Password Protecting The Workbook File

Excel 2016 Summary

What You Have Learned

Start your Free Trial

Self paced

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.