| |
|
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 2010 Video Training
- See far right to purchase this Microsoft Excel 2010 Training DVD/CD |
|
Microsoft Office 2010 Video Training - Production Bundle
Microsoft Excel, Word, Outlook & PowerPoint
SPECIAL OFFER: 35% DISCOUNT - ENDS SOON!
|
 |
 Professionally created, self-study video training.
About this Tutorialshow details This bundle includes:
Microsoft Excel 2010 Tutorial - 9.5 hrs / 126 Lessons
Microsoft Word 2010 Tutorial - 5 hrs / 101 Lessons
Microsoft Outlook 2010 Tutorial - 8.5 hrs / 144 Lessons
MS PowerPoint 2010 Tutorial - 10.5 hrs / 152 Lessons
Start to get to grips with the most widely used Microsoft applications with the help of this Microsoft Office 2010 video training for the Production suite. Presented by expert tutors Guy Vaccaro and Tim Ellwood, they commence from the basics and use high quality video training movies to help explain how to use and get the best out of Microsoft Excel, Word, Outlook and MS PowerPoint 2010.
This bundle training title includes over 33 hours of professionally created video training that will transform you from beginner to confident and proficient Microsoft user in a very short space of time. Working files are also included so you can follow along with the teaching of the trainers. The complete training listings are laid out below and you can start learning right away, click any of the blue linked lessons to sample the FREE Office 2010 tutorial videos and discover just how effective this training 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 Excel 2010 SAMPLE VIDEOS
 Overview Of Excel 2010
The New File Menu In Excel 2010
Exploring The Excel Workbook
What Will I Be Able To Do At The End Of This Course
Customizing The Quick Access Toolbar
Working With The Ribbons
Using The Files Included With This Course
Creating A New Workbook
Saving A Workbook
Saving In Other Formats
Open A Existing Workbook
Navigating An Excel Workbook
Entering Text And Numbers
Entering Numbers As Text
Inputting Dates And Times
Editing The Contents Of A Cell
Using Copy And Paste
The FILL Handle
Using Undo And Redo
Shortcuts For Selecting Cells
Inserting Cells, Columns And Rows
Deleting Cells, Columns And Rows
Changing Column Widths And Row Heights
Hiding And Unhiding A Column Or Row
Searching For Values In A Worksheet
Microsoft Word 2010 SAMPLE VIDEOS
 Text Effects
Format Painter
Headers And Footers
Insert A TOC
Inserting Pictures
SmartArt
Charts
Using Hyperlinks
WordArt
Insert A Watermark
Microsoft Outlook 2010 SAMPLE VIDEOS
The New Outlook 2010 Interface, Views And Ribbons
The New File Menu In Outlook 2010
What Will I Be Able To Do At The End Of This Course
Starting Outlook For The First Time
Customizing The Quick Access Toolbar
How Does Email Work?
Creating And Sending An Email
Sending Emails To More Than One Recipient
Receiving And Reading Emails
Using Carbon Copy And Blind Carbon Copy
Recommendations For Setting The Subject
Spell Checking Your Message
Hyperlinks In Emails
Attaching A File To A Message - Lesson 1
Attaching A File To A Message - Lesson 2
Setting The Importance Level
Setting The Sensitivity Level
Deleting Emails
Selecting The Right Text Format For Emails
Using Signatures On Email Messages
The Inbox Folder
Email Status Icons - Lesson 1
Email Status Icons - Lesson 2
Reading An Email
Replying To The Sender Only Of An Email
Replying To The Sender & All Recipients Of An Email
Forwarding An Email To Someone Else
Opening, Previewing And/Or Saving Attached Files
Saving An Email As A Draft Copy
Resending An Email
Recalling An Email
Printing An Email
Controlling How You're Notified When An Email Arrives
Sending Attachments As Zipped Files (Why And How)
Receiving/Handling Attachments Sent As Zipped Files
Microsoft PowerPoint 2010 VIDEOS
What Will I Be Able To Do At The End Of This Course
NEW PowerPoint 2010 Interface Views And Ribbons
The File Menu In PowerPoint 2010
Customizing The Quick Access Toolbar
Using The Files Provided With PowerPoint 2010
Starting PowerPoint And A New Presentation
Saving Presentations
Opening And Closing Existing Presentations
Working With More Than One Presentation Open
Screen Layout Options And Zooming
Turn On And Off The Ruler Gridlines And Guides
Adding Extra Slides
Entering Text Onto Slides
Copy And Paste Slide Content
Undo And Redo
Changing The Slide Layout Of An Existing Slide
Spellchecking A Presentation
Using A Presentation Theme
Change Font Style Size And Color
Controlling Your Bullet Point Styles
Paragraph Formatting
Superscript And Subscript
Managing Autocorrect In PowerPoint
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 EXCEL 2010 COMPLETE CONTENTS
Getting Started
Overview Of Excel 2010
The New File Menu In Excel 2010
Exploring The Excel Workbook
What Will I Be Able To Do At The End Of This Course
Customizing The Quick Access Toolbar
Working With The Ribbons
Using The Files Included With This Course
Working With An Excel Worksheet
Creating A New Workbook
Saving A Workbook
Saving In Other Formats
Open A Existing Workbook
Navigating An Excel Workbook
Selecting And Entering Data
Entering Text And Numbers
Entering Numbers As Text
Inputting Dates And Times
Editing The Contents Of A Cell
Using Copy And Paste
The FILL Handle
Using Undo And Redo
Shortcuts For Selecting Cells
Inserting Cells, Columns And Rows
Deleting Cells, Columns And Rows
Changing Column Widths And Row Heights
Hiding And Unhiding A Column Or Row
Searching For Values In A Worksheet
Developing A Workbook
Formatting And Naming Of Worksheet Tabs
Moving Worksheets Within And Between Workbooks
Copying Worksheets Within Workbooks
Inserting And Deleting Worksheets
Viewing More Than One Workbook
Hiding And Unhiding Worksheets
Printing And Page Setup
Using The Print Area Command To Control What Excel Prints
Setting Page Margins And Page Orientation
Creating A Header And Footer
Using Page Break View
Setting Print Titles For Large Worksheets
Printing Gridlines Column Row Headings And Other Related Options
Enabling The New Page Layout View
Running The Spell Checker
Print Preview And Printing The Whole Or Part Of The Worksheet
Workbook Formatting
Modifying Typeface, Font Size And Colors
Merging Cells
Applying Number Formats
Aligning Cell Contents
Changing The Text Direction In A Cell
Adding Borders To Cells And Ranges
Applying A Date Format To A Cell Or Range
Use Of The Format Painter
Clearing Cell Contents And/Or Formatting
Carrying Out Calculations
Getting Started With Basic Math Formula Addition
Getting Started With Basic Math Formula Subtraction
Getting Started With Basic Math Formula Multiplication
Getting Started With Basic Math Formula Division
Getting Started With Basic Math Formula Operand
Order Of Operations with BODMAS
Introduction To Excel Formulas: SUM
Copying Formulas And Functions
Displaying Formulae On A Worksheet
Some Useful Functions For Counting
Some Useful Functions For Averages
Some Useful Functions For Highest And Lowest
Absolute Referencing Requirements
Formulas Across Worksheets
Functions Across Worksheets
3D Referencing
Making Use Of Named Cells And Ranges
Advanced Formatting
Enhancing Worksheets Using Themes
Working With Comments
Creating Your Own AutoFill List
Turning Your Data Into A Table For Formatting
Security
Using Protection On A Worksheet
Protecting Part Of A Worksheet To Facilitate Data Entry
Controlling Access To Cell Ranges By Password And Or User Accounts
Saving A Workbook With Password Protection
Using Templates
Creating A Workbook From A Template
Creating Your Own Custom Template
Graphics Objects
Inserting And Modifying Clipart
Using SmartArt Graphics
Adding Drawn Shapes To A Worksheet
Inserting An External Picture
Adding A Background Image To A Worksheet
Formatting Graphic Objects
Controlling Stacking Order And Alignment Of Multiple Graphics Objects
Grouping Graphic Objects
Accessing Formula Results In A Callout Bubble
Using Excel As A Database
Fixing Rows And Columns On Screen
Fixing Rows And Columns For Print
Sorting Data In A Worksheet
Filtering Data In A Worksheet
Removing Duplicates In An Excel Database
Adding And Using Subtotals In An Excel Database
Splitting One Column Of Data Into More Columns
Splitting The Screen To View Different Parts Of The Same Worksheet
Linking To Data On A Webpage
Using Charts In Excel
Creating A Chart The Long Way
Creating A Chart The Quick Way
Changing A Chart From A Sheet Object To A Sheet
Modifying Your Chart Type
Controlling Chart Style And Layout
Adding A Trend line To A Chart
Pie Charts In More Detail
More Advanced Formula
Adding An IF Function For Cell Comparisons
Using the IF Function To Suppress Excel Error Messages
Text Manipulation With Formulae - Lesson 1
Text Manipulation With Formulae - Lesson 2
Date Formula In Excel
DATEDIF - A Hidden But Useful Formula
SUMIF COUNTIF And AVERAGEIF
Use Of A Formula To Rank Scores
Conditional Formatting
Changing Cell Appearance Based On Its Value
Editing Conditional Formatting Rules On A Worksheet
Removing Conditional Formatting Rules
Highlighting Duplicate Values Using Conditional Formatting
Identifying The Top Or Bottom Percentage Of A Range
Use Of Data Bars Within Conditional Formatting
Use Of Colour Scales Within Conditional Formatting
Applying An Icon Set To Conditional Formatting Rules
Office Web Apps And Excel
What Is Office Web Apps?
Sign In To Or Sign Up For Your Own SkyDrive
Saving An Excel Workbook Into SkyDrive
Accessing And Editing An Excel Workbook Through SkyDrive
Telling Others Where Your Public Documents Are
Direct Linking Or Embedding Of SkyDrive Documents
Creating A Folder Structure Within SkyDrive
Deleting Files From SkyDrive
Credits And Beyond
About The Tutor
Microsoft Excel 2010 Training CD End
MS WORD 2010 COMPLETE CONTENTS
Introduction
Welcome And Introduction
Accessing MS Word
Backstage
The Ribbon
Quick Access Toolbar
Help Options
Starting A Word Document
Opening A New Blank Document
Inserting Text
Navigation
Editing Text
Editing Text
Selecting Text
Cut Copy And Move
Paste Preview
Find And Replace
Undo And Redo
Formatting Text
Home Tab Font Basic Options
Default Font Settings
Text Effects
Format Painter
Character Spacing
Mini Toolbar
Formatting Paragraphs
Alignment
Indentation And Line Spacing
Bulleted And Numbered Lists
Hyphenation
Paragraph Borders And Shading
Controlling Pagination
Using Tabs
Clearing Tabs
Formatting Documents
Page And Section Breaks
Page Setup
Page Numbering
Headers And Footers
Footnotes And Endnotes
Creating Columns
Lining Up Columns
Revising Column Structure
Styles
Applying Styles
Amending Styles
Creating New Styles
Using Style Sets
Index And Contents
Insert A TOC
Updating A TOC
Mark Entries And Insert An Index
Tables
Creating A Table
Inserting And Deleting Rows And Columns
Positioning A Table
Row Height And Column Width
Table Borders And Shading
Formatting Cells In A Table
Calculations In Tables
Inserting Graphics
Inserting Pictures
Insert ClipArt
Picture Styles
Picture Effects
Shapes
SmartArt
Charts
Screenshots
Inserting Links & Text
Using Hyperlinks
Bookmarks
Cross-references
Text Boxes
Quick Parts
WordArt
Insert Symbols
Other Insert Tab Options
Page Layout
Themes
Insert A Watermark
Page Background
Mailings
Envelopes And Labels
Mail Merge Data Source
Mail Merge Document Inserting Fields
Finishing A Mail Merge
Proofing
AutoCorrect
Spelling And Grammar
Thesaurus
Translate Options
Tracking Changes
Accepting And Rejecting Changes
Comparing Documents
Publishing And Sharing
Prepare For Sharing
View Options
Document Views
Navigation Pane
Zoom Options
Windows
Save And Printing
Save A Document
Compatibility Mode
Open A Recent Document
Protecting Documents
Print Preview
Printing A Document
Macros
Recording Macros
Viewing And Editing Macros
Running Macros
Customizing
Word Options
Advanced Word Options
Customizing The Ribbon
Customizing Quick Access Toolbar
Templates
MS OUTLOOK 2010 COMPLETE CONTENTS
Getting Started
The New Outlook 2010 Interface, Views And Ribbons
The New File Menu In Outlook 2010
What Will I Be Able To Do At The End Of This Course
Starting Outlook For The First Time
Customizing The Quick Access Toolbar
How Does Email Work?
The Basics Of Email
Creating And Sending An Email
Sending Emails To More Than One Recipient
Receiving And Reading Emails
Using Carbon Copy And Blind Carbon Copy
Recommendations For Setting The Subject
Spell Checking Your Message
Hyperlinks In Emails
Attaching A File To A Message - Lesson 1
Attaching A File To A Message - Lesson 2
Setting The Importance Level
Setting The Sensitivity Level
Deleting Emails
Selecting The Right Text Format For Emails
Using Signatures On Email Messages
Managing Emails
The Inbox Folder
Email Status Icons - Lesson 1
Email Status Icons - Lesson 2
Reading An Email
Replying To The Sender Only Of An Email
Replying To The Sender & All Recipients Of An Email
Forwarding An Email To Someone Else
Opening, Previewing And/Or Saving Attached Files
Saving An Email As A Draft Copy
Resending An Email
Recalling An Email
Printing An Email
Controlling How You're Notified When An Email Arrives
Sending Attachments As Zipped Files (Why And How)
Receiving/Handling Attachments Sent As Zipped Files
Setting Up Email Accounts
Adding A New Pop Mail Account
Adding A Hotmail Mail Account
Connecting To An Exchange Server Email Account
Removing An Email Account
Editing A Mail Accounts Settings
Setting The Frequency Of Checking For New Emails
Carrying Out A Manual Check For New Mail
Adding A Yahoo!Mail Email Account
Adding A Google Mail Email Account
Manipulating Text
Text Selection Methods
Copying And Pasting Text FROM An Email
Copying And Pasting Text INTO An Email
Deleting Text In An Email
Formatting Text Within An Outlook Email Message
Emoticons That Work In Outlook
Removing An Attached File From A Received Email
Organizing Emails
Sorting The Contents Of The Inbox
Searching For An Email
Creating A New Mail Folder
Moving Emails Between Mail Folders
Deleting A Mail Folder
The Deleted Items Folder And Restoring Emails
Emptying The Deleted Items Folder Manually And Automatically
Flagging An Email Message
Removing A Flag From A Message
Adding Remainders To Flagged Emails
Marking Emails As Read Or Unread
Making Use Of The Favorites Bar
Junk Email
What Constitutes Junk
Editing The Junk Email Settings
Blocking A Sender
Unblocking A Blocked Sender
Contacts
What Are Contacts?
Creating A New Contact
Turning The Sender Of An Email Into A Contact
Addressing An Email To A Contact Or Contacts
Deleting A Contact
Importing Contact Information From Outside Of Outlook
Changing The View Of Contacts And Sorting
Using Find To Locate A Contact
Adding A Photograph To A Contact
Creating Editing A Contact Group
Sending An Email To A Contact Group
Organizing Your Contacts Into Sub Folders
Sending Contact Information Directly To Word Mail Merge
Exporting Contact Information From Outlook
Customize The Layout
Inbox And Other Folder Headings
The Navigation Pane
The To Do Bar
Managing The Reading Pane
The NEW People Pane
Viewing Emails With/Without Their Conversation Thread
Appointments
Explore The Outlook Calendar
Exploring The Different Appointment Types
Add An Appointment To The Calendar
Setting A Reminder For Appointments
Reminders Dismiss Or Snooze
Changing The Default Reminder Settings
Assigning And Managing Appointment Categories
Edit Delete Calendar Appointments
Copy Move Appointments
Add Recurring Appointments
Using Outlook To Help You Remember Birthdays And Anniversaries
Adding Attachments To Appointments
Schedule A Meeting With Others
Dealing With A Meeting Request Sent To You
Proposing An Alternative Meeting Time
Tracking Meeting Responses
Update Or Cancel A Meeting
Setting Your Working Hours And Working Week
Printing The Calendar
Email A Copy Of The Calendar
Adding Public Holidays To The Calendar
Publishing Your Calendar Online
Viewing A Published Calendar In Outlook
Changing Access Rights To The Published Calendar
Tasks
Create A New Task
Assign A Follow Up Flag
Edit Delete Restore A Task
Setting A Reminder Alarm For A Task
Categorizing Tasks
Available Task Views
Mark A Task As Complete Or Part Done
Delegating Tasks To Others
Receiving A Delegated Task
Updating The Owner With Progress
Notes
Create A Note
Edit/Delete A Note
Changing The Appearance Of Notes
Advanced Outlook Settings
Tracking An Emails Arrival Or Read Status
Using Stationery Themes For Emails
Archiving Old Emails
Managing The Quicksteps Shortcuts
The Outlook Journal
Rules
Creating A Message Rule
Editing An Email Rule
Create A Rule To Reply For You
Creating A Rule Response Template
Disable Or Delete A Rule
Text Messaging From Outlook
Setting Up A Text Messaging Account
Sending A Text Message From Outlook
Adding A Cellphone Number To A Contact
Using Outlook With An Exchange Server
Connecting To An Exchange Server Email Account
Automatic Out Of Office Replies
Using Public Folders
Giving Permission To Others To Access Your Account
Acting As A Delegate For Another Exchange User
Credits And Beyond the Training
About The MS Outlook Tutor
MS POWERPOINT 2010 FULL CONTENTS
Before We Begin
What Will I Be Able To Do At The End Of This Course
The New PowerPoint 2010 Interface Views & Ribbons
The File Menu In PowerPoint 2010
Customizing The Quick Access Toolbar
Using The Files Provided With PowerPoint 2010
Getting Started - Lesson 1
Starting PowerPoint And A New Presentation
Saving Presentations
Opening And Closing Existing Presentations
Working With More Than One Presentation Open At The Same Time
Screen Layout Options And Zooming
Turn On And Off The Ruler Gridlines And Guides
Adding Extra Slides
Entering Text Onto Slides
Copy And Paste Slide Content
Undo And Redo
Changing The Slide Layout Of An Existing Slide
Spellchecking A Presentation
Slide Design
Using A Presentation Theme
Change Font Style Size And Color
Controlling Your Bullet Point Styles
Paragraph Formatting
Superscript And Subscript
Managing Autocorrect In PowerPoint
Charts And Graphs
Adding Charts To A Presentation
Editing The Data For The Chart
Change The Chart Type
Using A Different Layout And Style
Changing Chart Layout Options
Formatting A Chart
Pie Chart Specific Formatting
Add A Chart To A Slide Without A Chart Placeholder
Removing A Chart From A Slide
Organization Charts
Adding A Slide With An Organization Chart
Insert An Organizational Chart On Any Slide
Adding A New Box To The Chart
Remove A Box From The Organization Chart
Rearranging Box Order Promoting And Demoting
Edit The Organization Chart Layout
Altering The Style Of The Chart And Or Individual Boxes
Removing An Organization Chart From A Presentation
Using Clip Art, Smart Art Or Images
Inserting A Piece Of Clip Art
Inserting Clip Art To Any Slide
Moving And Resizing Clip Art
Remove Clip Art From A Slide
Adding Moving Resizing And Removing Your Own Photographs
Using The Picture Tools Ribbon For Photograph Enhancements
Inserting A Smart Art Object To A Slide
Customizing The Smart Art Graphic
Removing A Smart Art Graphic
Word Art And Managing Drawing Objects
Add Word Art To A Slide
Editing Word Art Content And Style
Removing A Piece Of Word Art
Adding Drawn Shapes To A Slide
Formatting A Drawn Shape
Advanced Editing Of A Shape
Remove A Drawing Object
Aligning Multiple Objects On A Slide
Controlling Stacking Order And Grouping Shapes As One
Managing The Presentation
Exploring The Views Available In PowerPoint
Changing The Display Order Of Slides
Deleting And Hiding Slides
Insert Slides From Another Presentation
Running A Slideshow
Running Your Presentation
Useful Keyboard Commands During A Slideshow
Drawing On A Slide Whilst Running The Slideshow
PowerPoint Laser Pointer For Use During A Slideshow
Rehearsing And Setting Slide Show Timings
Record Narration For A Slideshow
Setting Up A Slideshow
Creating And Using A Custom Show
Saving As A PowerPoint Show
Broadcasting A Presentation In Real Time Across The Internet
Office Web Apps And PowerPoint
What Is Office Web Apps
Sign In To Or Sign Up For Your Own SkyDrive
Uploading Files To Your SkyDrive
Saving A PowerPoint Presentation Directly Into SkyDrive
Accessing And Editing A Presentation Through SkyDrive
Telling Others Where Your SkyDrive Public Documents Are
Direct Linking Or Embedding Of SkyDrive Documents
Creating A Folder Structure Within SkyDrive
Moving Copying And Deleting Files On SkyDrive
Editing Sharing Permissions On Folders In SkyDrive
Templates
Using The Microsoft Supplied PowerPoint Templates
Designing Saving And Using Your Own Template
Animation
Adding Transition Effects To Slides
Adding An Animation Effect To An Object On A Slide
Copying An Animation Effect To Another Object
Previewing Animation Effects
Adding A Secondary (Exit) Animation Effect To An Object
Making An Animation Object Follow A Path
Managing The Order In Which Animations Occur
Change The Animation Effect Assigned To An Object
Removing An Animation Effect From An Object
Changing The Trigger For An Animation Effect
Editing The Effect Options For An Animation Effect
Animating Charts And Smart Art
Speaker Notes
Adding Speaker Notes
Control Layout Of Notes Page Using The Notes Master
Adding A Footer A Header Page Number And Date To The Notes Pages
Printing The Notes Pages
Master Views
Overview And Accessing The Master View
Changing Slide Background Colours
Add A Image As Your Presentation Background
Add A Company Logo To Every Slide
Include A Footer Slide Number And Or Date On Slides
Animating The Slide Master
Using The Handout Master
The Need For Multiple Slide Masters
Printing
Printing Slides
Printing The Presentations Text Content Using Outline View
Printing Handouts
Printing The Notes Pages
Tables
Inserting Tables Onto Slides
Entering Text Into A Table
Inserting And Removing Rows And Columns
Adjusting Row Height And Or Column Width
Merging Multiple Cells Into One Or Splitting One Cell Into Many
Table Styles Explained
Custom Formatting Of Table Colors And Borders
Removing A Table
Flowcharts
Adding A Flowchart Diagram
Linking The Flowchart Boxes Together
Aligning And Rotating Flowchart Objects
Enhancing Flowchart Objects
Adding Yes No To Decision Boxes
Sections
Logical Division Of A Presentation Into Sections
Renaming Sections
Removing Section Breaks
Embedding External Files
Embedding And Linking Program Objects
Embedding Linked Excel Charts
Multimedia
Adding A Video File
Enhance The Formatting Of A Video Clip
Editing A Video Within PowerPoint
Controlling Video Playback During A Slideshow
Adding Flash (SWF) Files
Linking Instead Of Embedding Media Clips
Action Buttons
Adding An Action Button
Use An Action Button To Run Another Program
Change The Action Associated With An Action Button
Format An Action Button
Removing An Action Button
Action Buttons In The Master
Exporting And Importing
Prepare Your Presentation For Sharing And Distribution
Adding Slides From An External Text File
Set Permissions Before Distribution
Distributing The Presentation By Email
Sending Slides To Microsoft Word
Using The Package For CD Command
Create a Video (WMV) From A Presentation
PowerPoint Extras
Create A Photo Album
Capturing And Displaying Screenshots
Credits
About The Tutor
Microsoft Office PowerPoint 2010 Course End |
  |
|
|
|
 |
|
|
IN STOCK
US & Canada