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

Microsoft Excel 2011 for Mac Tutorial

A professionally created, self-study video training course
Includes 5 hours of easy to follow Microsoft Excel 2011 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 2011 for Mac tutorial videos by clicking a blue link below:
  • Tutor: Guy Vaccaro
  • Duration: 5 hours
  • Video lessons: 75
  • Product code: 01643
  • In stock: YES
Learn the how to use and how to fully utilize the innovative features of this powerful spreadsheet program with the help of these Microsoft Excel 2011 for Mac tutorial videos.

Commencing from the 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 2011 helping you to use this application to a confident and proficient standard.

In over four hours of professionally created tutorials, the video 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 2011 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.

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

"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
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
Getting Started
How Time Saving Are These Excel Projects?
Making Use Of The Project Working Files
About The Excel Tutor
An Introduction To Math In Excel

Recording And Monitoring Sales Data
Creating A New Excel File To Record Data
Saving Your Workbook In The Correct Format
Improve Your Worksheet With Some Formatting
Adding Formulas To Total Rows And Columns
Adding Formulas The Quick Way
Working Out Our Average Consumption
Conditional Formatting To Improve Presentation
Renaming Sheets And Printing

Using Excel For A Profit And Loss
Creating The Data Collection Sheet
Setting Up A List Using A Named Range
Adding Formula To Create January Profit And Loss
Changing The Data Entry To A Single Sheet
Creating The Other Eleven Months
Using D Referencing To Generate The Whole Years Profit And Loss
Exporting To PDF And Emailing To The Accountant

Score Sheets For School Sports Day
Setting Up The Scoresheet Structure
Looking Up The Competitor Name
A Near Match Lookup For The Event Scores
Using Sheet Replication To Create The Other Event Sheets
Adding Protection To Protect Your Formula
Data Entering The Actual Results
Completing The Competitor Summary
Creating An Error Check For Events Competed
Adding Up The Scores And Ranking For Position

Expenses Claim Form
Expenses Claim Document Setup And Header Page
Adding The First Month
Displaying The Month Name Instead Of The Number
Creating Destination Lookups For January
Protecting January And Setting Print Options
Creating The Other Eleven Months
Adding A Summary Sheet
Using And Submitting Your Expenses Claim

Sales Contacts Management
Setting Up Excel To Store Data And Entering That Data
Creating A Unique ID And Freezing Titles
Calculating New Values Using String Manipulation
Sorting Your Excel Database
Filtering Your Dataset
Removing Duplicate Records From Your Dataset
Mail Merge Using Your Dataset
Form View In Excel
Summarizing The Dataset With Pie Charts

Stock Sales Summaries
Starting The Sales Data Record Sheet
Adding A Sales Chart To The Data
Replicate Sheets To Create Other Sales Regions
Summarizing The Sales Data
Importing CSV Format Sales Data
Adding Some Calculations To The Imported Data
Interrogating The Sales Data With A Pivot Table
Formatting The Pivot Table
Sorting And Filtering The Pivot Table

Next Steps
Reviewing Absolute And Relative Formulas
What Is The SkyDrive?
Saving An Excel File To SkyDrive
Informing Others That The SkyDrive Document Is There
MS Excel 2011 Summary
What Is Next?
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 75 Microsoft Excel 2011 for Mac training videos (listed left), lasting a total of 5 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 2011 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


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 2011 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.

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 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 2011 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 have been recently been using your Photoshop training to demonstrate techniques to my students. I've been trying to persuade them to purchase it themselves, as I believe it to be an excellent training tool, and the best instructional CD on this subject to date by far! Not only is it easy to follow and presented clearly, but it is also a bargain."Joe Doyle Vista Community College, Berkeley, CA