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

Microsoft Excel 2016 Tutorial

A professionally created, self-study video training course
Includes 9 hours of easy to follow Microsoft Excel 2016 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 tutorial videos by clicking a blue link below:
  • Tutor: Guy Vaccaro
  • Duration: 9 hours
  • Video lessons: 82
  • Product code: 02329
  • In stock: YES
  • Available on: DVD & Download
  • Work files included: YES
  • Works on: MS Windows PC & Mac
  • Date Released: 1st June 2016
In this Learning Microsoft Excel 2016 training course, expert author Guy Vaccaro will teach you everything you need to know to begin creating and managing spreadsheets in Excel 2016. This course is designed for the absolute beginner, meaning no experience with Excel is required.

You will start by learning how to manage workbooks and worksheets, then jump into learning how to enter and edit data in cells. From there, Guy will teach you about formulas and functions, formatting, and page setup and printing. This video tutorial will also cover workbook and worksheet management, mathematical formulas, security, and charts in detail. Finally, you will learn about advanced formulas, including using an IF formula, text manipulation using functions, and date manipulation functions.

Once you have completed this computer based training course, you will have learned everything you need to know to be able to create and manage spreadsheets in Microsoft Excel 2016. Working files are included, allowing you to follow along with the author throughout the lessons.
What Our Customers Are Saying

"I received my Civil 3d training cd today and I wanted to send a thank you email. I am very pleased with your service. I also have the Revit Architecture training cd. I first ordered this as a download, and upon having difficulty I was very pleased with your prompt fix to the problem by sending the cd instead of using the download program. Again I thank you and look forward to future business with you."Brett Carmer, Indiana
COMPLETE COURSE CONTENTS
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
Section

Get all lessons with purchase
Entering And Editing Data In Cells
Entering And Editing Text Numbers And Dates
Cut Copy Paste Vs Drag And Drop
Special Features Of The Fill Handle
Managing Columns And Rows
Searching Within A Worksheet Workbook

Math: The Basics
Normal Mathematic Operators
Starting With Basic Functions
Copying Formula
Displaying Formula And Functions

Formatting
Cell And Range Selection
Modifying Typeface Size Colors
Number Formats Alignment And Orientation
Merging And Wrapping Cell Contents
Cell Borders
Applying Editing Date Formats
The Format Painter
Clearing Finding And Replacing Formatting

Workbook And Worksheet Management
Worksheet Navigating Copying Moving And Tab Color
Side By Side Comparison Of Worksheets
Modifying More Than One Sheet At A Time

Page Setup And Printing
Controlling Print And Screen Headings
Orientation Margins And Scaling
Headers And Footers
Using Page Break And Page Layout Views Effectively
Printing Parts Of A Worksheet
Spellchecking And Smart Lookup

Mathematical Formulas
The Sum Function
Other Mathematical Functions Average Min Max
Various Count Functions
Absolute Referencing
Formula Across Multiple Sheets
3D Referencing In Action
The Advantages Of Named Cells And Ranges

Security
Protection Of Whole Or Part Worksheets
Protection For The Whole Excel Workbook

Charts In Excel
Using The Recommended Charts Option
Create A Chart Quickly Or Slowly
Formatting A Chart
Modifying The Chart Type
Formatting Chart Elements
Adding A Trendline
The Pie Chart
Sparklines Mini Charts
The New Forecast Sheet
New To 2016 Chart Types

Graphics Objects
Inserting And Enhancing Images
Inserting Shapes And Screenshots
Using SmartArt Graphics
Formatting Graphical Objects
Stacking Grouping And Flowcharts
A Mathematical Formula With A Graphic Object

Excel As A Database
Fixing Onscreen And In Print Rows And Columns
Sorting Data
Filter Data To Reduce Dataset Size
Removing Duplicate Entries
Using Subtotals In A Worksheet Of Data
Using Text To Columns
The New Get And Transform For Using Web Data

Advanced Formula
Using An IF Formula
New IFs For Multiple Criteria
DATEDIF A Useful Hidden Function
Text Manipulation Functions
Use Of Text To Format Numbers
Date Manipulation Functions
Introducing SUMIF COUNTIF AVERAGEIF
Use Of Rank To Calculate Placings
Flash Fill The Magic Touch

What's Next
Office Apps For Excel 2016
Are You Ready To Go Advanced
Purchase Info - 30% OFF MARKED PRICE!
The DVD and Download options include the same training contents and both priced as below:
PRICE
CURRENCY
   
 
Item(s):
   
Once purchased, you will receive 82 Microsoft Excel 2016 training videos (listed left), lasting a total of 9 hours and the working files.

Worldwide
Shipping
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.
WE AIM TO PLEASE
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 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


USING THE SAME EXCELLENT CONTENT AS SINGLE USER COURSES
For companies and educational establishments wanting multi user access to training resources, we offer this Microsoft Excel 2016 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.

EASILY VIEWED OVER A 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.

ADDITIONAL USERS AND TITLES CAN BE ADDED
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.
PRICE
(Per 10 user concurrent licence)
Closely Related Courses
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. Show your boss or potential employer!
Weekly Special
Promoted Course
View sample videos from the new
AutoCAD 2016
A recent customer speaks out...
"We have purchased 11 of these training CDs to date. Their structure and content have improved our technical skills at our own pace. We've extracted ourselves from many a production problem by referring back to the relevant CD."Ian Walsh, Slide FX Ltd, Ireland