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

Microsoft Office 2011 For The Mac Bundle Tutorial

This discounted bundle includes these four courses:
Microsoft Word 2011 Tutorial

Duration
4.5 Hours

Video lessons
75
Microsoft Excel 2011 Tutorial

Duration
4.5 Hours

Video lessons
59
Microsoft PowerPoint 2011 Tutorial

Duration
4.5 Hours

Video lessons
55
Microsoft Outlook 2011 Tutorial

Duration
3 Hours

Video lessons
48
COMPLETE COURSE CONTENTS
Free Sample
Section

Click a blue link to evaluate!
Sample Videos from Microsoft Word 2011
What Will I Be Able To Do With Word?
Making Use Of The Project Working Files
About The MS Word Tutor
Setting Page Size And Margins
Adding The Sender And Recipient Addresses
Adding Todays Date To The Letter
Salutation Ending And Content
Checking The Letter For Spelling Mistakes
Saving Your Letter In A Different Format
Adding A Label Or An Envelope
Printing Your Letter
Design The Letter For Your Campaign
Creating A Set Of Data To Use In Your Campaign
Telling The Letter Where To Put The Data
Filtering And Previewing The Merge Data
Running The Mail Merge
Changing The Data Source Of The Merge
Sample Videos from Microsoft Excel 2011
Creating A New Excel File To Record Data
Renaming Sheets And Printing
Creating The Other Eleven Months
Exporting To PDF And Emailing To The Accountant
A Near Match Lookup For The Event Scores
Data Entering The Actual Results
Adding Up The Scores And Ranking For Position
Adding The First Month
Adding A Summary Sheet
Sample Videos from Microsoft PowerPoint 2011
Animating Your Presentation
Adding Slides And Slide Content
Charts On Slides
Embedding A Movie Clip
Adding Text And Image Content
Generating A Sales Graph
Sample Videos from Microsoft Outlook 2011
Welcome To Outlook On A Mac?
About The MS Outlook Tutor
Adding A New Email Account To Outlook
Sending Your First Outlook Email
Sorting And Grouping Your Inbox
Managing Emails
Adding Signatures In Outlook
Categorizing Contacts
Sending An Attachment Directly From An Application
Recurring Appointments
Rearranging A Meeting
Completing A Task
Making Use Of The My Day Utility
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
Contents from the Microsoft Word 2011 Course
Using Word To Generate An Email Campaign
Design The Body Of The Email
Connecting The Data And Finalise The Email
Generating The Individual Emails
Dealing With The Emails In Outlook

Design And Print A Greeting Card
Using A Template For The Card Layout
Adding A Text Box To Your Card
Create A Greetings Card Manually
Adding A WordArt Item
Using ClipArt On The Card
Text Boxes Are For Text
Upside Down Objects On Some Pages
Printing And Folding Your Card

Manual/Documentation Creation
Page Setup For A Manual
Using Words Built In Styles
Customizing The Built In Styles
Creating And Using Your Own Styles
Using The Document Map To Navigate A Large File
Inserting And Handling Images
Add A Table To Improve Presentation
Replacing Text Throughout A Document
Optimized Use Of Headers And Footers
Making Use Of Footnotes
Use Sections To Have Different Page Orientation
Adding And Updating A Table Of Contents
Adding And Removing A DRAFT Watermark
Exporting Your Manual Document As A PDF

Creating Your Own Template
Starting A Letterhead And Adding A Logo
Adding Company Details
Our Letter Needs A Footer
Todays Date, Every Time You Use The Template
Saving The Template
Use The Template To Create Letters

SkyDrive
What Is SkyDrive
Saving Your Document Into SkyDrive
Opening The Document For Editing
Informing Others About The SkyDrive Document
Enabling Edit Permissions On A SkyDrive Document
Tracking Changes Of A SkyDrive Document
Reviewing A Tracked Document
Deleting Documents From SkyDrive

Useful Formatting Extras
Adding A SmartArt Object
Word And Organization Charts
Manual Tabs A
Manual Tabs B
Making Use Of Columns
Creating And Using Autotext

Forms In Word
Designing A Form Layout
Adding Data Collection Fields
Setting The Properties Of Form Fields
Status Bar Text Help Added To Form Fields
Locking The Form Ready For Completion
Distributing The Form For Completion
Collecting The Form Completions

Word Tables Vs Excel Spreadsheets
Word Tables With Formulas
Adding A Chart To Word
Linking To An Excel Chart

Close
Summary - What Did I Learn
Other Tasks To Explore
Contents from the Microsoft Excel 2011 Course
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?
Contents from the Microsoft PowerPoint 2011 Course
Getting Started
What Will My Final Projects Look Like?
Using The Included Working Files
About The MS PowerPoint Tutor

Creating A Simple Presentation
Planning The Content
Starting The Presentation And Saving The File
Save Variations
Adding Additional Slides
Adding Content And Customizing Bullets
Images Bring Colour To Your Presentation
Say YES With WordArt
Changing The Theme Design
Animating Your Presentation
Presenting The Slideshow

Generating A Sales Presentation
Do I Choose A Supplied Template Or Design My Own
Creating And Customizing The Slide Master
Adding Slides And Slide Content
Using Clip Art To Bring Color
Charts On Slides
SmartArt Graphics For Vibrant Presentations
Slide Master Helps Control Date And Footer Placement
Usefulness Of PowerPoint Slide Notes
Embedding A Movie Clip
Transitions And Animations
Running The Presentation

Create A Stand Alone Presentation
Planning A Standalone Presentation
Using The Plan To Setup The Presentation
Adding Text And Image Content
The Addition Of An Organization Chart
An Organization Chart With Photos
Generating A Sales Graph
Slide Transition And Duration Settings
Animating All The Objects On The Slides
Recording Narration For The Presentation
Background Music For The Presentation
Setting Continuous Playback
Exporting And Distributing The Presentation

Running A Slideshow
Preparation Before The Big Day
Running The Show Tips And Tricks
Broadcasting Your Presentation On The Web

Making A Presentation Interactive
What Is A Non Linear Presentation
Building The Content Of The Interactive Presentation
Adding Yes/No Buttons
Using Images As Action Buttons
Global Action Buttons
Opening External Files And URLs
Triggering Other Applications
Saving And Distributing Your Interactive Slideshow

SkyDrive
Get Started With SkyDrive
Saving SlideShows To SkyDrive
Tell Others Where The Slideshows Are Online
Editing A SkyDrive PowerPoint Document
Running A SlideShow In SkyDrive
Removing PowerPoint Files From SkyDrive

Next Steps
Summary And Recap
What Next?
Contents from the Microsoft Outlook 2011 Course
Getting Started
Welcome To Outlook On A Mac?
Making Use Of The Project Working Files
About The Outlook Tutor

Outlook Account Setup
Adding A New Email Account To Outlook
Importing Settings And Mail From Other Mail Programs

Email Conversations
Sending Your First Outlook Email
Reading And Replying To Emails
Forwarding Emails To Somebody Else
Sorting And Grouping Your Inbox
Managing Emails
Flags And Categories To Help You Manage Emails
Changing An Emails Priority Level
Formatting Within An Email
Draft Emails
Adding Signatures In Outlook
Managing Junk/Spam Emails

Managing Your Outlook Contacts
Adding People To Your Contacts List
Editing And Deleting Contacts
Categorizing Contacts
Sending Emails To Your Contacts
Importing Contacts Into Outlook
Creating And Using Groups

Handling Attachments
Sending A File With Your Email
Sending An Attachment Directly From An Application
Dealing With Incoming Attachments

Personal Appointment Handling
Take The Outlook Calendar Tour
Adding Appointments
Editing Moving And Deleting Appointments
Recurring Appointments
Using The Category System With Appointments
Appointment Reminders And Email Notifications

Arranging A Meeting
Creating A Meeting From Scratch
Turn An Existing Appointment Into A Meeting
Checking For Responses Given
Rearranging A Meeting
Receiving A Meeting Invitation
Sending Documentation To Attendees

Tasks And Notes
Create An Outlook Task
Editing And Deleting Tasks
Categories Flags And Priority Ratings
Completing A Task
Recurring Tasks
Adding A Note
Editing And Deleting Notes
The Category System Works For Notes Too
Email A Note To A Friend

Next Steps
Making Use Of The My Day Utility
Summary And Is There More?
A professionally created, self-study video training course
Includes 17 hours of easy to follow Microsoft Office 2011 For The Mac Bundle 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 Office 2011 For The Mac Bundle tutorial videos by clicking a blue link below:
  • Tutor: Guy Vaccaro
  • Duration: 17 hours
  • Video lessons: 237
  • Product code: 01648
  • In stock: YES
  • Available on: DVD & Download
  • Work files included: YES
  • Works on: MS Windows PC & Mac
  • Date Released: 27th July 2011
Gain an in-depth and practical working knowledge of this popular suite of applications with the help of this comprehensive Microsoft Office 2011 for the Mac tutorial - Premium Bundle!

Presented by expert MS Office tutor Guy Vaccaro, he uses step-by-step video training movies to help explain and demonstrate the important, tools, features and workflow techniques for Microsoft Word, Outlook, PowerPoint, and Excel 2011 for Mac.

Throughout all courses, the trainers use and makes frequent reference to real MS Office exercise files. These are included with the DVD, online and download purchases helping you to easily keep pace with the on-screen actions and verbal instructions.

You can view he complete 237 video lessons below and start learning right away. Click any of the blue linked lessons to sample FREE Microsoft Office 2011 for Mac tutorial videos and discover just how effective this teaching guide really is...
What Our Customers Are Saying

"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
 
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 237 Microsoft Office 2011 For The Mac Bundle training videos (listed left), lasting a total of 17 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 Office 2011 For The Mac Bundle 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 Office 2011 For The Mac Bundle 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
See our complete range of Microsoft Outlook Tutorials
See our complete range of Microsoft PowerPoint Tutorials
See our complete range of Microsoft Word 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 Office 2011 For The Mac Bundle. Show your boss or potential employer!
Weekly Special
Promoted Course
View sample videos from the new
AutoCAD 2016
A recent customer speaks out...
"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