Comprehensive Video Tutorials

MS Office 2011 for Mac Training Bundle

CareerVision Training
Online

£ 120 - ($ 467.621)
+ IVA

Información importante

  • Curso
  • Online
  • Duración:
    Flexible
  • Cuándo:
    A definir
  • Campus online
Descripción

  The following course, offered by Career vision, will help you improve your skills and achieve your professional goals. During the program you will study different subjects which are deemed to be useful for those who want to enhance their professional career. Sign up for more information!

Información importante
Sedes

Dónde se imparte y en qué fechas

Inicio Ubicación
A definir
Online

¿Qué aprendes en este curso?

IT
Office IT
Ms Office
Mac

Programa académico

 

 •  Format: DVD or Instant Download
 •  Duration: 16.5 Hours (237 lessons)
 •  Instructor: Guy Vaccaro
 •  Platform: Windows PC or Mac
 

This bundle includes:
Microsoft Word 2011 for Mac - 4.5 hrs / 75 Lessons
Microsoft Excel 2011 for Mac - 4.5 hrs / 59 Lessons
Microsoft Powerpoint 2011 for Mac - 4.5 hrs / 55 Lessons
Microsoft Outlook 2011 for Mac - 3 hrs / 48 Lessons

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.

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.


Benefits of this Software Training:
 •  Tuition by expert tutors.
 •  Narrated training videos demonstrate the key tools and professional techniques
        helping you to work faster and smarter.
 •  Learning is fast as the trainers guide you using simplistic terms and minimal jargon.
 •  Personal Tutoring - Step-by-step video training from your own desktop.
        Delivered via DVD/CD training or online tuition.
 •  The tutor transfers knowledge to you quickly and effectively.
 •  All the concepts of each application are explained clearly and precisely.
 •  Course works on PC and Mac.
 •  Alternative to a boring book or manual and expensive training courses,
        seminars and amp; classes.
 •  Jump to and from lessons - learn at your own pace.
 •  The visual and practical nature shortens the learning curve compared to standard
        training manuals.


 

The following sections are available for free viewing. Click on the links below to get started.

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

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

 

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?

 

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?

 

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