Learning Microsoft Excel 2016 for Mac
4.0 (10 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.
51 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learning Microsoft Excel 2016 for Mac to your Wishlist.

Add to Wishlist

Learning Microsoft Excel 2016 for Mac

Learn to Manage Your Data Using Spreadsheet Functionality
4.0 (10 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.
51 students enrolled
Last updated 1/2017
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
Requirements
  • Microsoft Excel 2016 for Mac
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.

Who is the target audience?
  • This course is designed for the absolute beginner, meaning no previous experience with Excel is required
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 60 Lectures Collapse All 60 Lectures 05:20:32
+
Your Excel 2016 Journey Starts Here
5 Lectures 09:46
+
Managing Excel Workbooks And Worksheets
6 Lectures 34:09

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
+
Entering And Editing Data In Cells
10 Lectures 59:44
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
+
Math Basics
6 Lectures 36:01
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
+
Formatting Worksheets
8 Lectures 44:30
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
+
Page Setup And Printing
7 Lectures 36:22
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
+
Mathematical Formulas
11 Lectures 01:09:34
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
+
Advanced Formatting
3 Lectures 13:43
Adding, Editing, Deleting, And Printing Comments
05:53

Creating Your Own Custom List
03:28

Converting To A Table For Formatting
04:22
+
Security
3 Lectures 11:39
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
+
Excel 2016 Summary
1 Lecture 05:04
What You Have Learned
05:04
About the Instructor
Infinite Skills
4.4 Average rating
36,372 Reviews
678,903 Students
331 Courses
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.