Microsoft Office 2011 For The Mac - Premium Bundle Training Video

expand all / collapse all

• 00. Free Videos - Microsoft Word 2011

  • What Will I Be Able To Do With Word?
  • Making Use Of The Project Working Files
  • About The Author
  • 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

• 00. Free Videos - 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

• 00. Free Videos - 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

• 00. Free Videos - Microsoft Outlook 2011

  • Welcome To Outlook On A Mac?
  • About The Author
  • 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

• 01. Microsoft Word 2011 - Getting Started

  • 0101 What Will I Be Able To Do With Word?
  • 0102 Making Use Of The Project Working Files
  • 0103 About The Author

• 02. Microsoft Word 2011 - Creating A Letter

  • 0201 Setting Page Size And Margins
  • 0202 Adding The Sender And Recipient Addresses
  • 0203 Adding Todays Date To The Letter
  • 0204 Salutation Ending And Content
  • 0205 Checking The Letter For Spelling Mistakes
  • 0206 Saving Your Letter In A Different Format
  • 0207 Adding A Label Or An Envelope
  • 0208 Printing Your Letter

• 03. Microsoft Word 2011 - Carrying Out A Marketing Mail Merge

  • 0301 Design The Letter For Your Campaign
  • 0302 Creating A Set Of Data To Use In Your Campaign
  • 0303 Telling The Letter Where To Put The Data
  • 0304 Filtering And Previewing The Merge Data
  • 0305 Running The Mail Merge
  • 0306 Changing The Data Source Of The Merge

• 04. Microsoft Word 2011 - Using Word To Generate An Email Campaign

  • 0401 Design The Body Of The Email
  • 0402 Connecting The Data And Finalise The Email
  • 0403 Generating The Individual Emails
  • 0404 Dealing With The Emails In Outlook

• 05. Microsoft Word 2011 - Design And Print A Greeting Card

  • 0501 Using A Template For The Card Layout
  • 0502 Adding A Text Box To Your Card
  • 0503 Create A Greetings Card Manually
  • 0504 Adding A WordArt Item
  • 0505 Using ClipArt On The Card
  • 0506 Text Boxes Are For Text
  • 0507 Upside Down Objects On Some Pages
  • 0508 Printing And Folding Your Card

• 06. Microsoft Word 2011 - Manual/Documentation Creation

  • 0601 Page Setup For A Manual
  • 0602 Using Words Built In Styles
  • 0603 Customizing The Built In Styles
  • 0604 Creating And Using Your Own Styles
  • 0605 Using The Document Map To Navigate A Large File
  • 0606 Inserting And Handling Images
  • 0607 Add A Table To Improve Presentation
  • 0608 Replacing Text Throughout A Document
  • 0609 Optimized Use Of Headers And Footers
  • 0610 Making Use Of Footnotes
  • 0611 Use Sections To Have Different Page Orientation
  • 0612 Adding And Updating A Table Of Contents
  • 0613 Adding And Removing A DRAFT Watermark
  • 0614 Exporting Your Manual Document As A PDF

• 07. Microsoft Word 2011 - Creating Your Own Template

  • 0701 Starting A Letterhead And Adding A Logo
  • 0702 Adding Company Details
  • 0703 Our Letter Needs A Footer
  • 0704 Todays Date, Every Time You Use The Template
  • 0705 Saving The Template
  • 0706 Use The Template To Create Letters

• 08. Microsoft Word 2011 - SkyDrive

  • 0801 What Is SkyDrive
  • 0802 Saving Your Document Into SkyDrive
  • 0803 Opening The Document For Editing
  • 0804 Informing Others About The SkyDrive Document
  • 0805 Enabling Edit Permissions On A SkyDrive Document
  • 0806 Tracking Changes Of A SkyDrive Document
  • 0807 Reviewing A Tracked Document
  • 0808 Deleting Documents From SkyDrive

• 09. Microsoft Word 2011 - Useful Formatting Extras

  • 0901 Adding A SmartArt Object
  • 0902 Word And Organization Charts
  • 0903 Manual Tabs A
  • 0903 Manual Tabs B
  • 0904 Making Use Of Columns
  • 0905 Creating And Using Autotext

• 10. Microsoft Word 2011 - Forms In Word

  • 1001 Designing A Form Layout
  • 1002 Adding Data Collection Fields
  • 1003 Setting The Properties Of Form Fields
  • 1004 Status Bar Text Help Added To Form Fields
  • 1005 Locking The Form Ready For Completion
  • 1006 Distributing The Form For Completion
  • 1007 Collecting The Form Completions

• 11. Microsoft Word 2011 - Word Tables Vs Excel Spreadsheets

  • 1101 Word Tables With Formulas
  • 1102 Adding A Chart To Word
  • 1103 Linking To An Excel Chart

• 12. Microsoft Word 2011 - Close

  • 1201 Summary - What Did I Learn
  • 1202 Other Tasks To Explore

• 01. Microsoft Excel 2011 - Getting Started

  • 0101 How Time Saving Are These Excel Projects?
  • 0102 Making Use Of The Project Working Files
  • 0103 About The Author
  • 0104 An Introduction To Math In Excel

• 02. Microsoft Excel 2011 - Recording And Monitoring Sales Data

  • 0201 Creating A New Excel File To Record Data
  • 0202 Saving Your Workbook In The Correct Format
  • 0203 Improve Your Worksheet With Some Formatting
  • 0204 Adding Formulas To Total Rows And Columns
  • 0205 Adding Formulas The Quick Way
  • 0206 Working Out Our Average Consumption
  • 0207 Conditional Formatting To Improve Presentation
  • 0208 Renaming Sheets And Printing

• 03. Microsoft Excel 2011 - Using Excel For A Profit And Loss

  • 0301 Creating The Data Collection Sheet
  • 0302 Setting Up A List Using A Named Range
  • 0303 Adding Formula To Create January Profit And Loss
  • 0304 Changing The Data Entry To A Single Sheet
  • 0305 Creating The Other Eleven Months
  • 0306 Using 3D Referencing To Generate The Whole Years Profit And Loss
  • 0307 Exporting To PDF And Emailing To The Accountant

• 04. Microsoft Excel 2011 - Score Sheets For School Sports Day

  • 0401 Setting Up The Scoresheet Structure
  • 0402 Looking Up The Competitor Name
  • 0403 A Near Match Lookup For The Event Scores
  • 0404 Using Sheet Replication To Create The Other Event Sheets
  • 0405 Adding Protection To Protect Your Formula
  • 0406 Data Entering The Actual Results
  • 0407 Completing The Competitor Summary
  • 0408 Creating An Error Check For Events Competed
  • 0409 Adding Up The Scores And Ranking For Position

• 05. Microsoft Excel 2011 - Expenses Claim Form

  • 0501 Expenses Claim Document Setup And Header Page
  • 0502 Adding The First Month
  • 0503 Displaying The Month Name Instead Of The Number
  • 0504 Creating Destination Lookups For January
  • 0505 Protecting January And Setting Print Options
  • 0506 Creating The Other Eleven Months
  • 0507 Adding A Summary Sheet
  • 0508 Using And Submitting Your Expenses Claim

• 06. Microsoft Excel 2011 - Sales Contacts Management

  • 0601 Setting Up Excel To Store Data And Entering That Data
  • 0602 Creating A Unique ID And Freezing Titles
  • 0603 Calculating New Values Using String Manipulation
  • 0604 Sorting Your Excel Database
  • 0605 Filtering Your Dataset
  • 0606 Removing Duplicate Records From Your Dataset
  • 0607 Mail Merge Using Your Dataset
  • 0608 Form View In Excel
  • 0609 Summarizing The Dataset With Pie Charts

• 07. Microsoft Excel 2011 - Stock Sales Summaries

  • 0701 Starting The Sales Data Record Sheet
  • 0702 Adding A Sales Chart To The Data
  • 0703 Replicate Sheets To Create Other Sales Regions
  • 0704 Summarizing The Sales Data
  • 0705 Importing CSV Format Sales Data
  • 0706 Adding Some Calculations To The Imported Data
  • 0707 Interrogating The Sales Data With A Pivot Table
  • 0708 Formatting The Pivot Table
  • 0709 Sorting And Filtering The Pivot Table

• 08. Microsoft Excel 2011 - Next Steps

  • 0801 Reviewing Absolute And Relative Formulas
  • 0802 What Is The SkyDrive?
  • 0803 Saving An Excel File To SkyDrive
  • 0804 Informing Others That The SkyDrive Document Is There
  • 0805 Excel 2011 Summary
  • 0806 What Is Next?

• 01. Microsoft Powerpoint 2011 - Getting Started

  • 0101 What Will My Final Projects Look Like?
  • 0102 Using The Included Working Files
  • 0103 About The Author

• 02. Microsoft Powerpoint 2011 - Creating A Simple Presentation

  • 0201 Planning The Content
  • 0202 Starting The Presentation And Saving The File
  • 0203 Save Variations
  • 0204 Adding Additional Slides
  • 0205 Adding Content And Customizing Bullets
  • 0206 Images Bring Colour To Your Presentation
  • 0207 Say YES With WordArt
  • 0208 Changing The Theme Design
  • 0209 Animating Your Presentation
  • 0210 Presenting The Slideshow

• 03. Microsoft Powerpoint 2011 - Generating A Sales Presentation

  • 0301 Do I Choose A Supplied Template Or Design My Own
  • 0302 Creating And Customizing The Slide Master
  • 0303 Adding Slides And Slide Content
  • 0304 Using Clip Art To Bring Color
  • 0305 Charts On Slides
  • 0306 SmartArt Graphics For Vibrant Presentations
  • 0307 Slide Master Helps Control Date And Footer Placement
  • 0308 Usefulness Of PowerPoint Slide Notes
  • 0309 Embedding A Movie Clip
  • 0310 Transitions And Animations
  • 0311 Running The Presentation

• 04. Microsoft Powerpoint 2011 - Create A Stand Alone Presentation

  • 0401 Planning A Standalone Presentation
  • 0402 Using The Plan To Setup The Presentation
  • 0403 Adding Text And Image Content
  • 0404 The Addition Of An Organization Chart
  • 0405 An Organization Chart With Photos
  • 0406 Generating A Sales Graph
  • 0407 Slide Transition And Duration Settings
  • 0408 Animating All The Objects On The Slides
  • 0409 Recording Narration For The Presentation
  • 0410 Background Music For The Presentation
  • 0411 Setting Continuous Playback
  • 0412 Exporting And Distributing The Presentation

• 05. Microsoft Powerpoint 2011 - Running A Slideshow

  • 0501 Preparation Before The Big Day
  • 0502 Running The Show Tips And Tricks
  • 0503 Broadcasting Your Presentation On The Web

• 06. Microsoft Powerpoint 2011 - Making A Presentation Interactive

  • 0601 What Is A Non Linear Presentation
  • 0602 Building The Content Of The Interactive Presentation
  • 0603 Adding Yes/No Buttons
  • 0604 Using Images As Action Buttons
  • 0605 Global Action Buttons
  • 0606 Opening External Files And URLs
  • 0607 Triggering Other Applications
  • 0608 Saving And Distributing Your Interactive Slideshow

• 07. Microsoft Powerpoint 2011 - SkyDrive

  • 0701 Get Started With SkyDrive
  • 0702 Saving SlideShows To SkyDrive
  • 0703 Tell Others Where The Slideshows Are Online
  • 0704 Editing A SkyDrive PowerPoint Document
  • 0705 Running A SlideShow In SkyDrive
  • 0706 Removing PowerPoint Files From SkyDrive

• 08. Microsoft Powerpoint 2011 - Next Steps

  • 0801 Summary And Recap
  • 0802 What Next?

• 01. Microsoft Outlook 2011 - Getting Started

  • 0101 Welcome To Outlook On A Mac?
  • 0102 Making Use Of The Project Working Files
  • 0103 About The Author

• 02. Microsoft Outlook 2011 - Outlook Account Setup

  • 0201 Adding A New Email Account To Outlook
  • 0202 Importing Settings And Mail From Other Mail Programs

• 03. Microsoft Outlook 2011 - Email Conversations

  • 0301 Sending Your First Outlook Email
  • 0302 Reading And Replying To Emails
  • 0303 Forwarding Emails To Somebody Else
  • 0304 Sorting And Grouping Your Inbox
  • 0305 Managing Emails
  • 0306 Flags And Categories To Help You Manage Emails
  • 0307 Changing An Emails Priority Level
  • 0308 Formatting Within An Email
  • 0309 Draft Emails
  • 0310 Adding Signatures In Outlook
  • 0311 Managing Junk/Spam Emails

• 04. Microsoft Outlook 2011 - Managing Your Outlook Contacts

  • 0401 Adding People To Your Contacts List
  • 0402 Editing And Deleting Contacts
  • 0403 Categorizing Contacts
  • 0404 Sending Emails To Your Contacts
  • 0405 Importing Contacts Into Outlook
  • 0406 Creating And Using Groups

• 05. Microsoft Outlook 2011 - Handling Attachments

  • 0501 Sending A File With Your Email
  • 0502 Sending An Attachment Directly From An Application
  • 0503 Dealing With Incoming Attachments

• 06. Microsoft Outlook 2011 - Personal Appointment Handling

  • 0601 Take The Outlook Calendar Tour
  • 0602 Adding Appointments
  • 0603 Editing Moving And Deleting Appointments
  • 0604 Recurring Appointments
  • 0605 Using The Category System With Appointments
  • 0606 Appointment Reminders And Email Notifications

• 07. Microsoft Outlook 2011 - Arranging A Meeting

  • 0701 Creating A Meeting From Scratch
  • 0702 Turn An Existing Appointment Into A Meeting
  • 0703 Checking For Responses Given
  • 0704 Rearranging A Meeting
  • 0705 Receiving A Meeting Invitation
  • 0706 Sending Documentation To Attendees

• 08. Microsoft Outlook 2011 - Tasks And Notes

  • 0801 Create An Outlook Task
  • 0802 Editing And Deleting Tasks
  • 0803 Categories Flags And Priority Ratings
  • 0804 Completing A Task
  • 0805 Recurring Tasks
  • 0806 Adding A Note
  • 0807 Editing And Deleting Notes
  • 0808 The Category System Works For Notes Too
  • 0809 Email A Note To A Friend

• 09. Microsoft Outlook 2011 - Next Steps

  • 0901 Making Use Of The My Day Utility
  • 0902 Summary And Is There More?

In this Premium video training bundle for Microsoft Office 2011 For the Mac, expert author Guy Vaccaro guides you through the ins and outs of using this powerful and popular suite of tools. Training in this bundle includes:

Learning Microsoft Word 2011 For the Mac
Learning Microsoft Excel 2011 For the Mac
Learning Microsoft Powerpoint 2011 For the Mac
Learning Microsoft Outlook 2011 For the Mac

Each individual training course focuses on the core components of each program, taught in a unique and engaging fashion, using projects. Through each project, you will learn essential skills such as formatting, creating mail merges, emailing and maintaining contacts, creating in-depth spreadsheets with advanced formulas, and much, much more.

By the completion of each of these video training tutorials, you will be fully competent in each of these programs, on your Macintosh computer. Each training video comes complete with working files, so that you can work alongside the author as he teaches you each concept.