O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Table of Contents

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