| |
|
Quicktime is required for the movies,
click here to download if needed.
|
 |
Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.
Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials. Please do not hesitate to contact us for download help. |
|
- See right for full details on this Microsoft Office 2011 For The Mac Training
- See far right to purchase this Microsoft Office 2011 For The Mac Tutorial CD/DVD |
|
Microsoft Office 2011 For The Mac Tutorial - Premium Bundle
Microsoft Excel, Word, Outlook & PowerPoint
SPECIAL OFFER: 65% DISCOUNT & FREE SHIPPING!
|
 |
 Professionally created, self-study video training.
About this Tutorialshow details This bundle includes:
Microsoft Word 2011 Tutorial - 4.5 hrs / 75 Lessons
Microsoft Excel 2011 Tutorial - 4.5 hrs / 59 Lessons
MS Powerpoint 2011 Tutorial - 4.5 hrs / 55 Lessons
Microsoft Outlook 2011 Tutorial - 3 hrs / 48 Lessons
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. The training is backed up by work files, which allow you to work alongside the trainer providing more depth to learning experience. 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 method really is...
|
|
| Learn this Software - See below for FREE TUTORIALS |
|
|
FOUR COURSES AT A GREAT PRICE!
FREE Shipping on ALL Orders
|
| |
CD CONTENTS & FREE VIDEO TUTORIALS
Click on any linked lesson below for a
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left
MICROSOFT WORD 2011 SAMPLE VIDEOS
 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
MICROSOFT EXCEL 2011 VIDEOS
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
MS POWERPOINT 2011 SAMPLE VIDEOS
Animating Your Presentation
Adding Slides And Slide Content
Charts On Slides
Embedding A Movie Clip
Adding Text And Image Content
Generating A Sales Graph
MICROSOFT OUTLOOK 2011 VIDEOS
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 the lessons below & above, please purchase the course via CD or Download
MS WORD 2011 COMPLETE CONTENTS
Getting Started
What Will I Be Able To Do With Word?
Making Use Of The Project Working Files
About The MS Word tutor
Creating A Letter
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
Carrying Out A Marketing Mail Merge
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
Lessons on Running The Mail Merge
Changing The Data Source Of The Merge
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
Learning how to Add 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
MS EXCEL 2011 COMPLETE CONTENTS
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?
MS POWERPOINT 2011 FULL CONTENTS
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?
MS OUTLOOK 2011 COMPLETE CONTENTS
Getting Started
Welcome To Outlook On A Mac?
Making Use Of The Project Working Files
About The 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?
Microsoft Office for Mac Tutorial End |
  |
|
|
|
 |
|
|
IN STOCK
US & Canada