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

Microsoft Office 2010 Production Bundle Tutorial

This discounted bundle includes these four courses:
Microsoft Excel 2010 Tutorial

Duration
9.5 Hours

Video lessons
126
Microsoft Outlook 2010 Tutorial

Duration
8.5 Hours

Video lessons
114
Microsoft Word 2010 Tutorial

Duration
5 Hours

Video lessons
101
MS PowerPoint 2010 Tutorial

Duration
10.5 Hours

Video lessons
152
COMPLETE COURSE CONTENTS
Free Sample
Section

Click a blue link to evaluate!
Sample Videos from Microsoft Excel 2010
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
Sample Videos from Microsoft Outlook 2010
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
Sample Videos from Microsoft Word 2010
Text Effects
Format Painter
Headers And Footers
Insert A TOC
Inserting Pictures
SmartArt
Charts
Using Hyperlinks
WordArt
Insert A Watermark
Sample Videos from Microsoft PowerPoint 2010
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 lessons below & above, please purchase the course via DVD or Download.
Paid Content
Section

Get all lessons with purchase
Contents from the Microsoft Excel 2010 Course
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 MS Excel Tutor
Microsoft Excel 2010 Training CD End
Contents from the Microsoft Outlook 2010 Course
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
Contents from the Microsoft Word 2010 Course
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
Contents from the Microsoft PowerPoint 2010 Course
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
A professionally created, self-study video training course
Includes 34 hours of easy to follow Microsoft Office 2010 Production 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 2010 Production Bundle tutorial videos by clicking a blue link below:
  • Tutor: Guy Vaccaro
  • Duration: 34 hours
  • Video lessons: 523
  • Product code: 01611
  • In stock: YES
  • Available on: DVD & Download
  • Work files included: YES
  • Works on: MS Windows PC & Mac
  • Also Recommended: Office 2010 Premium Bundle
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...
What Our Customers Are Saying

"Your training cds have been invaluable and i am going to be ordering some more. I have developed new skills really fast at a low cost. Once again, thanks a lot."Andrew Fast, Freelance Photographer
 
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 523 Microsoft Office 2010 Production Bundle training videos (listed left), lasting a total of 34 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 2010 Production 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 2010 Production 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 2010 Production 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 was pointed to your site by a professor at my University. I have not only benefited by your excellent training in learning more, but I have also saved hundreds on textbooks and other reference material."David Willams Essex (UK)