30% OFF Marked Prices & FREE Shipping!   -   ENDS 5PM FRIDAY!   -   Use Discount Code 303

Microsoft Excel 2016 for Mac Tutorial

A professionally created, self-study video training course
Includes 6 hours of easy to follow Microsoft Excel 2016 for Mac video tutorials presented by an industry expert.
The training is delivered to your desktop allowing you to learn at a time that suits you and at your own pace.
You can start learning online right away. Sample Microsoft Excel 2016 for Mac tutorial videos by clicking a blue link below:
  • Tutor: Guy Vaccaro
  • Duration: 6 hours
  • Video lessons: 60
  • Product code: 02087
  • In stock: YES
Learn the how to use and how to fully utilize the powerful features of this impressive spreadsheet application with the help of these Microsoft Excel 2016 for Mac tutorial videos.

Commencing from the absolute basics, expert MS Office tutor Guy Vaccaro uses step-by-step video training movies to help explain and demonstrate the important features and functions of Microsoft Excel 2016 helping you to use this software with confidence and proficiency.

In almost six hours of professionally created video training, the tuition includes a tour of the new interface, creating your spreadsheet, lessons on formulas, profit and loss, how to create charts and tables, formatting text, creating a mail merge in Excel 2016 and so much more.
The training is taught using practical project based examples and the work files are also included so you can work on the same material as the trainer helping you to effortlessly keep pace with Guy's instruction.

You can start your MS Excel education right away. Click any blue linked lesson below to sample the FREE Excel 2016 video tutorials and discover how effective this practical teaching guide is!
What Our Customers Are Saying

"Your Products are the best example of CD and internet computer training I've seen."Christine Maggio Abacus Technology, Inc., NJ
We hope you enjoyed the free lessons. To view the complete contents, including all lessons below & above, please purchase the course via DVD or Download.
Paid Content

Get all lessons with purchase
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

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

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

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 - Lesson / Method 1
Creating Headers And Footers - Lesson / Method 2
Other Print Options And Checking Spelling
Generating A PDF From A Worksheet

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
3D Referencing
Making Use Of Named Ranges
Dates, Shapes, And Formula
IF Statements

Advanced Formatting
Adding, Editing, Deleting, And Printing Comments
Creating Your Own Custom List
Converting To A Table For Formatting

Activate And Deactivate Worksheet And Workbook Protection
Protecting Part Of A Worksheet To Aid Data Entry
Password Protecting The Workbook File

MS Excel 2016 Summary

What You Have Learned
Purchase Info - 30% OFF MARKED PRICE!
The DVD and Download options include the same training contents and both priced as below:
Once purchased, you will receive 60 Microsoft Excel 2016 for Mac training videos (listed left), lasting a total of 6 hours and the working files.

Delivery Details
Download Course downloadable when payment processed (within one hour average)

CD/DVDs No shipping charges. Please allow 2-3 days for UK, Europe, US & Canada. 3-5 days rest of world.
All DVD courses have a 100% money back guarantee. If you are not happy with your course contact us within 30 days of purchase for a refund.
View our full product guarantee
Need to Train Multiple Users?
This Microsoft Excel 2016 for Mac course is available in multi-user format ideal for corporate users, schools and universities.

The course loads directly onto your server and delivered to multiple users over your network.

An unlimited number of users can access the training with a pre-determined number viewing the tuition at any one time.

Training Multiple Users

Load onto your server
Deliver on your network or existing learning management system

For companies and educational establishments wanting multi user access to training resources, we offer this Microsoft Excel 2016 for Mac course to do just that.
Now you can integrate training or technical support within your own computer network, or allow employees or students to gain access to training and support from home or any other location that they can gain access to your organizations network.

The courses can be played over a LAN using a standard browser such as Microsoft Internet Explorer, Safari or Firefox.
The movies are viewed using Adobe Flash (same method as YouTube) and are slightly compressed in order to not clog the network.
All advanced and the "for dummies" courses are available via this multi user solution and can be copied directly to a hard disk for faster access and the access page may be customized, if needed, using a html editor.

More than one title can exist on your server and the supplied player will automatically show titles that are available.
Simply purchase more user licences (supplied as files) and drop them into the folder. This will automatically increase the number of users allowed onto the system. All purchases are backed up by excellent after-sales support team and easy to follow instruction manual.
You can order multi user online or speak to our knowledgeable sales team.
(Per 10 user concurrent licence)
Closely Related Courses
See our complete range of Microsoft Office for Mac Tutorials
See our complete range of Microsoft Excel Tutorials
Prove Your Capabilities
Once a course is completed you can download a free certificate.

This certifies that you have started from the beginners level, have now viewed all instruction. The certificate advises you now possess essential skills and an in-depth knowledge of Microsoft Excel 2016 for Mac. Show your boss or potential employer!
Weekly Special
Promoted Course
View sample videos from the new
AutoCAD 2016
A recent customer speaks out...
"I'm very happy that i bought this training for Pro Tools. Before i purchased this, i was very undecided what to buy, there are so many out there. But I'm glad that i decided on this one, it's very nice & clear, and above all his sense of humor...I would defiantly recommend this to other people."Solomon Wechter, New York