Learning Microsoft Excel 2016 for Mac

Learn to Manage Your Data Using Spreadsheet Functionality
4.5 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
39 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 60
  • Length 5.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2016 English

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

What are the requirements?

  • Microsoft Excel 2016 for Mac

What am I going to get from this course?

  • Once you have completed this training course, you will have gained the knowledge necessary to manage your own workbooks and worksheets in Microsoft Excel 2016 for Mac

What is the target audience?

  • This course is designed for the absolute beginner, meaning no previous experience with Excel is required

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Your Excel 2016 Journey Starts Here
Important - Download These First - Working Files
Article
Quick Introduction To The New Excel 2016 Interface
Preview
03:16
Do I Need A Microsoft Account?
Preview
02:39
About Your Author
Preview
01:35
Using The Included Working Files
Preview
02:15
Section 2: Managing Excel Workbooks And Worksheets
Creating And Saving A New Workbook
Preview
05:26
Opening And Closing Workbooks
05:00
Saving And Opening Excel Files To And From OneDrive And iCloud
04:01
Saving Excel Files In Other Formats
05:33
Adding, Deleting, Moving, And Copying Worksheets
07:16
Using The Excel 2016 Templates
06:53
Section 3: Entering And Editing Data In Cells
Entering Text, Numbers, And Dates
07:51
Editing The Contents Of Cells
05:39
Undo And Redo Your Actions
04:01
Cut, Copy, And Paste
07:03
Drag And Dropping Cells
04:03
The Fill Handle
08:33
Inserting And Deleting Rows And Columns
06:21
Changing Column Widths And Row Heights
05:16
Hiding And Unhiding Rows, Columns And Sheets
05:33
Searching For Values In A Workbook
05:24
Section 4: Math Basics
Getting Started With Basic Mathematical Operators
05:18
Order Of Operation With BODMAS
04:06
Introduction To Basic Formula
06:52
The New Formula Builder And Quick SUMs
07:20
Copying Formula And Functions
07:03
Displaying Formulae On A Worksheet
05:22
Section 5: Formatting Worksheets
Selecting Cells For Formatting
05:17
Modifying Typeface, Font Size And Colors
06:26
Cell Alignment, Orientation And Merging
05:11
Using Number Formats
05:46
Adding And Removing Borders
05:27
Applying Date Formats To Cells
07:20
Format Painter And Fill Formatting
05:28
Clearing Cell Contents And Formatting
03:35
Section 6: Page Setup And Printing
Paper Size, Margins, Orientation And Scaling
05:39
Using A Print Area And Printing Titles
05:34
Using The Page Break Tools
04:15
Creating Headers And Footers - Method 1
05:17
Creating Headers And Footers - Method 2
05:45
Other Print Options And Checking Spelling
06:05
Generating A PDF From A Worksheet
03:47
Section 7: Mathematical Formulas
The SUM Function
04:30
Other Mathematical Functions - AVERAGE, MIN And MAX
07:09
Useful Count Functions
05:27
Averages, Mean, Mode, And Median
07:46
Using PI In Formula
05:12
Absolute Referencing Explained
06:42
Formulas Across Worksheets
05:38
3D Referencing
06:42
Making Use Of Named Ranges
06:47
Dates, Shapes, And Formula
07:45
IF Statements
05:56
Section 8: Advanced Formatting
Adding, Editing, Deleting, And Printing Comments
05:53
Creating Your Own Custom List
03:28
Converting To A Table For Formatting
04:22
Section 9: Security
Activate And Deactivate Worksheet And Workbook Protection
04:35
Protecting Part Of A Worksheet To Aid Data Entry
02:59
Password Protecting The Workbook File
04:05
Section 10: Excel 2016 Summary
What You Have Learned
05:04

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Ready to start learning?
Take This Course