Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Your Excel 2016 Journey Starts Here|
Important - Download These First - Working Files
Quick Introduction To The New Excel 2016 InterfacePreview
Do I Need A Microsoft Account?Preview
About Your AuthorPreview
Using The Included Working FilesPreview
|Section 2: Managing Excel Workbooks And Worksheets|
Creating And Saving A New WorkbookPreview
Opening And Closing Workbooks
Saving And Opening Excel Files To And From OneDrive And iCloud
Saving Excel Files In Other Formats
Adding, Deleting, Moving, And Copying Worksheets
Using The Excel 2016 Templates
|Section 3: Entering And Editing Data In Cells|
Entering Text, Numbers, And Dates
Editing The Contents Of Cells
Undo And Redo Your Actions
Cut, Copy, And Paste
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
|Section 4: 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
|Section 5: 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
|Section 6: 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
|Section 7: 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
Making Use Of Named Ranges
Dates, Shapes, And Formula
|Section 8: Advanced Formatting|
Adding, Editing, Deleting, And Printing Comments
Creating Your Own Custom List
Converting To A Table For Formatting
|Section 9: Security|
Activate And Deactivate Worksheet And Workbook Protection
Protecting Part Of A Worksheet To Aid Data Entry
Password Protecting The Workbook File
|Section 10: Excel 2016 Summary|
What You Have Learned
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.