Learning Microsoft Excel 2016 For Mac

Learn to Manage Your Data Using Spreadsheet Functionality

What you'll 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

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.

Overview

Section 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

Section 2: Managing Excel Workbooks And Worksheets

Lecture 6 Creating And Saving A New Workbook

Lecture 7 Opening And Closing Workbooks

Lecture 8 Saving And Opening Excel Files To And From OneDrive And iCloud

Lecture 9 Saving Excel Files In Other Formats

Lecture 10 Adding, Deleting, Moving, And Copying Worksheets

Lecture 11 Using The Excel 2016 Templates

Section 3: Entering And Editing Data In Cells

Lecture 12 Entering Text, Numbers, And Dates

Lecture 13 Editing The Contents Of Cells

Lecture 14 Undo And Redo Your Actions

Lecture 15 Cut, Copy, And Paste

Lecture 16 Drag And Dropping Cells

Lecture 17 The Fill Handle

Lecture 18 Inserting And Deleting Rows And Columns

Lecture 19 Changing Column Widths And Row Heights

Lecture 20 Hiding And Unhiding Rows, Columns And Sheets

Lecture 21 Searching For Values In A Workbook

Section 4: Math Basics

Lecture 22 Getting Started With Basic Mathematical Operators

Lecture 23 Order Of Operation With BODMAS

Lecture 24 Introduction To Basic Formula

Lecture 25 The New Formula Builder And Quick SUMs

Lecture 26 Copying Formula And Functions

Lecture 27 Displaying Formulae On A Worksheet

Section 5: Formatting Worksheets

Lecture 28 Selecting Cells For Formatting

Lecture 29 Modifying Typeface, Font Size And Colors

Lecture 30 Cell Alignment, Orientation And Merging

Lecture 31 Using Number Formats

Lecture 32 Adding And Removing Borders

Lecture 33 Applying Date Formats To Cells

Lecture 34 Format Painter And Fill Formatting

Lecture 35 Clearing Cell Contents And Formatting

Section 6: Page Setup And Printing

Lecture 36 Paper Size, Margins, Orientation And Scaling

Lecture 37 Using A Print Area And Printing Titles

Lecture 38 Using The Page Break Tools

Lecture 39 Creating Headers And Footers - Method 1

Lecture 40 Creating Headers And Footers - Method 2

Lecture 41 Other Print Options And Checking Spelling

Lecture 42 Generating A PDF From A Worksheet

Section 7: Mathematical Formulas

Lecture 43 The SUM Function

Lecture 44 Other Mathematical Functions - AVERAGE, MIN And MAX

Lecture 45 Useful Count Functions

Lecture 46 Averages, Mean, Mode, And Median

Lecture 47 Using PI In Formula

Lecture 48 Absolute Referencing Explained

Lecture 49 Formulas Across Worksheets

Lecture 50 3D Referencing

Lecture 51 Making Use Of Named Ranges

Lecture 52 Dates, Shapes, And Formula

Lecture 53 IF Statements

Section 8: Advanced Formatting

Lecture 54 Adding, Editing, Deleting, And Printing Comments

Lecture 55 Creating Your Own Custom List

Lecture 56 Converting To A Table For Formatting

Section 9: Security

Lecture 57 Activate And Deactivate Worksheet And Workbook Protection

Lecture 58 Protecting Part Of A Worksheet To Aid Data Entry

Lecture 59 Password Protecting The Workbook File

Section 10: Excel 2016 Summary

Lecture 60 What You Have Learned

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