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

Microsoft Office 2013 - Production Bundle Tutorial

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

Duration
7.5 Hours

Video lessons
106
Microsoft Outlook Tutorial

Duration
10 Hours

Video lessons
106
Microsoft Word 2013 Tutorial

Duration
9.75 Hours

Video lessons
113
Microsoft PowerPoint 2013 Tutorial

Duration
10 Hours

Video lessons
91
COMPLETE COURSE CONTENTS
Free Sample
Section

Click a blue link to evaluate!
Sample Videos from Microsoft Excel 2013
Lets Get Started With Excel 2013
About The Author
Navigating An Excel Workbook
The Fill Handle
Merging And Wrapping Cell Contents
Modifying More Than One Worksheet At A Time
Paper Size, Orientation, Margins, And Scaling Options
Absolute Referencing Explained
Converting Data To A Table For Formatting
Using The 2013 Templates
Formatting Graphical Objects
The Pie Chart In Detail
Filtering Data To Reduce Dataset Size
Text Manipulation Using Functions
Altering Cell Appearance Based On The Cell Value
Sample Videos from Microsoft Outlook 2013
Getting Excited About Outlook
About The Author
How To Use The Working Files
What Is Outlook?
Understanding E-Mail
Addressing Mail Using To, Cc, And Bcc
Setting Message Importance
Using The Attachment Reminder
Adding Images As Message Content
Sending And Responding To Voting Messages
Viewing Related Messages As Conversations
Using Folder And Mailbox Cleanup
Organizing And Scheduling Meetings
Customizing And Sending Business Cards
Adding Tasks To The Calendar
Printing Outlook Items
Downloading The Address Book
The Outlook 2013 Windows 8 Connection
Sample Videos from Microsoft Word 2013
Welcome To Word 2013
About The Author
Account Options And SkyDrive
New Resume Reading
Saving The Document For People Without Word 2013
Password Protection To Open And Or Modify A Document
Paragraph Alignment And Indentation
Controlling Hyphenation
Increase And Decrease Row Height And Column Width
Create, Save, And Use An AutoText Entry
Applying And Using Multilevel Bullets
Disable Or Undo An AutoCorrect Feature
Different Headers And Footers On Odd And Even Pages
Repeating Column Headings On Multiple Pages
Mail Merge From Data Held In Word
Inserting Images From The Web Or Your Computer
Inserting A Chart
Editing Word Documents Online
Sample Videos from Microsoft PowerPoint 2013
What Is The Point Of Powerpoint
About The Author
Creating Presentations In Two Steps
Adding Text To Slides
Understanding Masters
Working In The Outline Pane - Part 1
Working With Headers And Footers
Enabling Gridlines And Guides
Merging Shapes
Inserting Your Own Images
Inserting A SmartArt Graphic
Creating Tables
Creating Charts From Existing Excel Data
Bringing Presentations To Life With Video
Arranging And Hiding Slides
Adding Built In Animations
Sharing Presentations
Enhancing Presentation Skills With Notes
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 2013 Course
Start Here
Let's Get Started With Excel 2013
The Excel Workbook Explained
Signing Up For Your Own Free SkyDrive
Customize The Quick Access Toolbar
Using The Included Working Files
About The MS Excel Tutor

Managing Excel Workbooks And Worksheets
Creating And Saving A New Workbook
Opening Workbooks And Save As Options
Saving And Opening SkyDrive Files
Navigating An Excel Workbook
Adding And Removing Worksheets
Renaming Copying And Moving Worksheets

Entering And Editing Data In Cells
Entering Text, Numbers, And Dates
Entering Numbers As Text
Editing The Contents Of A Cell
Undo And Redo Actions
Cut, Copy, And Paste
Dragging And Dropping Cells
The Fill Handle
Inserting And Deleting Cells Columns And Rows
Changing Column Widths And Row Heights
Hiding And Un-Hiding Columns And Rows
Searching For Values In A Workbook

Math Basics
Getting Started With Basic Math Formulas
Order Of Operation With BODMAS
Introduction To Basic Formulas
Copying Formulas And Functions
Displaying Formulas On A Worksheet

Formatting Worksheets
Selecting Cells For Formatting
Modifying Typeface Font, Size, And Colour
Merging And Wrapping Cell Contents
Using Number Formats
Cell Content Alignment And Orientation
Adding And Removing Borders From A Selection
Applying A Date Format To A Cell Or Range
The Format Painter
Finding And Replacing Formats
Clearing Cell Contents VsClearing Cell Formatting

Workbook And Worksheet Management
Worksheet Navigation And Coloured Worksheet Tabs
Moving Or Copying Worksheets Within And Between Workbooks
Viewing And Scrolling Multiple Workbooks At The Same Time
Hiding And Un-Hiding Sheets
Modifying More Than One Worksheet At A Time

Page Setup And Printing
Using Print Titles And Print Areas
Paper Size, Orientation, Margins, And Scaling Options
Creating Headers and Footers
Using The Page Break And The Page Layout Views
Printing A Range Of Cells
Running The Spell Checker
Controlling Most Print Settings In One Place

Mathematical Formulas
The Sum Function
Copying Formulas And Functions
Other Mathematical Functions: Average, Min, And Max
Useful Count Functions
Absolute Referencing Explained
Formulas Across Worksheets
3D Referencing
Making Use Of Named Cells And Ranges

Advanced Formatting
Enhancing Worksheets Using Themes
Adding, Editing, And Deleting Comments
Creating Your Own Autofill List
Converting Data To A Table For Formatting

Security
Activating And Deactivating Worksheet Protection
Protecting Part Of A Worksheet To Aid Data Entry
Password Protecting The Whole Workbook

Excel 2013 Templates
Using The 2013 Templates
Creating And Using Your Own Template

Graphics Objects
Obtaining And Inserting Online Images
Using SmartArt Graphics
Inserting Shapes And Screenshots
Formatting Graphical Objects
The Stacking Order
Grouping Multiple Objects Together
Using Graphical Objects And Mathematical Formulas

Using Charts In Excel
The New Recommended Charts Option
Create A Chart Using The Long Or The Short Method
Formatting A Chart With The 2013 Shortcut Options
Modifying The Chart Type
Formatting Chart Elements
Adding A Trendline
The Pie Chart In Detail
Mini Graphs: Sparklines

Excel As A Database
Fixing On Screen Rows And Columns
Fixing Print Rows And Columns
Sorting Data In Excel
Filtering Data To Reduce Dataset Size
Removing Duplicate Entries In The Data
Adding Subtotals To A Worksheet Of Data
Using Text To Columns Effectively
Linking To Data On A Webpage

Advanced Formulas
Using An If Formula
Use Of The If Function To Hide Excel Error Messages
Datedif: A Useful But Hidden Formula
Text Manipulation Using Functions
Use The Text Function To Format Numbers
Date Manipulation Functions
Introducing Sumif, Countif, And Averageif
Use Of Rank To Calculate Placings
Flash Fill: The Magic Touch

Conditional Formatting
Altering Cell Appearance Based On The Cell Value
Displaying Data Bars, Color Scales, Or Icon Sets
Using Top And Bottom Rules For Formatting
Creating A Formatting Rule From Scratch
Managing The Conditional Formatting Rules

What's Next
The New Office Apps For MS Excel 2013
Ready To Go Advanced
Contents from the Microsoft Outlook 2013 Course
Introducing Outlook 2013
Getting Excited About Outlook
How To Use The Working Files
What Is Outlook?
Understanding E-Mail
Adding Email Accounts - Lesson 1: Using The Wizard
Adding Email Accounts - Lesson 2: IMAMP Enhancements
Adding Email Accounts - Lesson 3: Using Manual Configuration
Configuring Outlook With Exchange Server Accounts - Lesson 1
Configuring Outlook With Exchange Server Accounts - Lesson 2
Understanding Outlook Data Files
Changing The Outlook Background And Theme
Launching Outlook
Navigating Through The Outlook Interface
Accessing And Configuring Outlook Today
Accessing The To-Do Bar
Taking A Look At Outlook Peeks
Getting A Feel For The In box

Composing Basic E-Mail
Understanding And Setting Email Formats - Lesson 1
Understanding And Setting Email Formats - Lesson 2
Addressing Email Using Address Lists
Addressing Mail Using To, Cc, And Bc
Addressing Email Using Auto complete
Checking Email Addresses
A Few Words About Subject Lines
Setting Message Importance
Requesting Delivery And Read Receipts
Creating And Adding Signatures

Working With Attachments
Using The Attachment Reminder
Adding Attachments To Messages
Resizing Images While Sending Messages
Previewing Attachments
Saving And Removing Attachments

Creating Elegant E-Mail
Using Stationery And Themes
Applying Text Styles To Messages
Using Tables To Format Message Layout
Adding Images As Message Content
Creating And Inserting Quick Parts
Extending Message Content Through Hyperlinks
Sending And Responding To Voting Messages
Receiving And Tallying Message Votes
Setting Message Expiration
Delaying Message Delivery
Direct Message Replies To Others
Reviewing Messages

Managing Incoming Messages
Controlling Send Receive Options
Managing In box Views
Sorting And Grouping Folder Content
Viewing Related Messages As Conversations
Cleaning Up Conversations
Ignoring Conversations
Downloading Embedded Images And Using The Trust Center
Managing Junk Mail - Lesson 1
Managing Junk Mail - Lesson 2
Flagging For Follow-Up And Setting Reminders
Replying To And Forwarding Messages
Marking And Viewing Read And Unread Messages
Taking Advantage Of Quick Steps
Tracking Resending And Recalling Sent Messages
Setting Automatic Out Of Office Replies

Managing Outlook Folders
Searching Through Outlook
Leveraging Search Folders
Creating Additional Folders
Sorting Outlook Folders
Managing And Moving Messages: Trash It, Flag It, Or File It
Moving Messages Using Rules
Using Folder And Mailbox Cleanup
Working With Deleted Items
Archiving Outlook Items - Lesson 1
Archiving Outlook Items - Lesson 2

Staying Organized With The Calendar
Using Outlooks Default Calendar Views
Consulting The Weather Bar
Creating Basic Appointments And Events
Setting Appointment Options
Leveraging The Reminders Window
Creating And Managing Recurring Items
Assigning And Customizing Color Categories
Organizing And Scheduling Meetings
Responding To, Managing, Tracking, And Canceling Meetings

Keeping Tabs With The People Hub
Creating Contacts - Lesson 1
Creating Contacts - Lesson 2
Editing Contacts And Accessing The Full Contact Window
Customizing And Sending Business Cards
Creating Contact Groups
Linking People From Other Accounts With The Social Connector
Taking Action With Contacts

Getting Things Done With Tasks
Creating Tasks And Reviewing To-Do Items
Configuring Recurring Tasks
Assigning Tasks And Sending Progress Reports
Converting Emails To Tasks
Adding Tasks To The Calendar

Odds And Ends
Keeping Notes
Creating Custom Views
Printing Outlook Items
Sharing Calendars And Outlook Items
Modifying Default Outlook Options - Lesson 1
Modifying Default Outlook Options - Lesson 2

Working Remotely And Offline
Enabling Cached Exchange Mode
Downloading The Address Book
Controlling Downloads
Accessing Outlook Via The Web App

Using Outlook In The Big Picture
Creating A Word Mail Merge Using Outlook
Emailing Files From Other Office Applications
Connecting Share Point Calendars To Outlook
The Outlook 2013 Windows 8 Connection

About The Trainer
Closing Words
About The MS Outlook Tutor
Contents from the Microsoft Word 2013 Course
Getting Started
Welcome To Word 2013
Word 2013 Interface Tour
Available Views And Document Navigation
Account Options And SkyDrive
New Resume Reading
The Quick Access Toolbar
Using The Working Files

Creating Documents
Creating A New Document With Or Without A Template
Entering Text Into A Word Document
Save And Save As
Opening An Existing Document
Saving The Document For People Without Word
Setting Altering Document Properties
Using The Non-Printing Characters
Password Protection To Open And Or Modify A Document
Restricting Editing For Parts Of A Word Document
Recently Used Documents And Folders

Working With Word Documents
How To Select Text
Deleting Text
Undo And Redo Options
Inserting A Space, Line, Or Break
Inserting Mathematical Symbols And Special Characters
Changing Typeface Font Size And Case
Make Text Important With Bold, Italics, Or Underlining
Highlighting, Strikethrough, Superscript, And Subscript
Paragraph Alignment And Indentation
Paragraph Spacing And Controlling Indents
The Format Painter In Action
Paragraph Borders And Background Colour
Bullets And Numbering
Customizing Bullet Shapes And Numbers
Cut, Copy, And Paste In So Many Ways
Finding And Replacing Text
Checking Your Spelling And Grammar

Page Setup And Print Preview
Paper Size, Orientation, And Margins
Controlling Hyphenation
Page Watermarks
Page Borders And Background Colours
Combined Preview, Print, And Setup
Printing Part Of A Document

Tables
Inserting And Removing A Table
Entering Data And Adding Or Removing Rows And Columns
Increase And Decrease Row Height And Column Width
Merging And Splitting Table Cells
Adding Colours To Tables
Formatting Cell Borders
Cell Margin Text Alignment And Direction
Aligning And Text Wrapping A Table In A Document

AutoText
Create, Save, And Use An AutoText Entry
Editing Or Deleting An AutoText Entry

Advanced Paragraph Formatting
Applying And Using Multilevel Bullets
Define Your Own Multilevel List
Using Drop Caps For Effect
Default Tab Stops And Adding Your Own
Two Clever Tabs: Decimal And Bar
Using The Tab Dialog Box
Use Of Tab Leaders
Using Columns In A Word Document
Adding And Removing A Column Break
Use Of Themes

Automatic Features
Overview Of AutoCorrect
Disable Or Undo An AutoCorrect Feature
Adding And Removing Words From The AutoCorrect List

Header And Footers
Adding A Header Or Footer
Editing A Header Or Footer
Using Different Headers And Footers On Page One
Different Headers And Footers On Odd And Even Pages
Page Numbering Customization

Advanced Tables
Tabs Within Tables
Adding A Formula To A Table
Refresh A Formula Result And View The Formula
Editing Formulas And Deactivating Formulas
Repeating Column Headings On Multiple Pages
Control Whether A Row Splits Across A Page Boundary
Sorting Columns Of Data In Word

Mail Merge
What Is Mail Merge
Step By Step Mail Merge
Mail Merge From Data Held In Word
Mail Merge From Data Held In Excel
Changing The Source Data File
Address Blocks And Greeting Lines
Filter And Sort The Data Before Merging
Reconnecting A Moved Data Source
Ignoring Duplicates In The Mailing Data
Editing The Data Source From Within Word
Dynamic Mail Merge With If Fields
Mail Merge To Labels
Mail Merge To Email

SmartArt, Images, And The Drawing Tools
Inserting A Shape
Resize, Move, Rotate, And Delete Existing Shapes
Adding Text Boxes And Text To Existing Shapes
Styling And Formatting Your Shape
Shape Layers And Groups
Interaction Of Text And Shapes
Exploring WordArt
Inserting Images From The Web Or Your Computer
Formatting An Inserted Image
Exploring The Image Crop Tool
Using SmartArt Graphics
Full Or Part Screen Capture
Image Transparency

Charts
Inserting A Chart
Customizing Chart Elements
Change Chart Type And Apply Styles
Filtering And Editing The Data
Handling Pie Charts

Word To The Web
Editing Word Documents Online
Blog Publishing With Word
Publish Word Documents On Social Networks
Using The New Office Apps

Conclusion
Edit PDFs In Word
About The MS Word Tutor
Onwards And Upwards
Contents from the Microsoft PowerPoint 2013 Course
Understanding PowerPoint
What You Will Learn
Using The Working Files
What Is The Point Of PowerPoint
Making Really Bad PowerPoint Presentations
Navigating Through PowerPoint
Understanding PowerPoint Views

Getting Right To It
0201 Making A Photo Album
Getting A Jump Start Using Templates
Creating Presentations In Two Steps
Running A Basic Slide Show

Starting Presentations From Scratch
Creating A New Blank Presentation
Setting Slide Size
Adding Text To Slides
Adding, Duplicating And Deleting Slides
Reusing Slides
Changing And Resetting Slide Layout
Adding Online Pictures To Placeholders

Customizing PowerPoint Design
Understanding Masters
Selecting A Theme
Using Theme Variants
Modifying Masters And Layouts
Working With Multiple Masters
Modifying Backgrounds
Adding Layouts
Saving And Accessing Personal Templates

Using Outlines In PowerPoint
Importing Outlines - Lesson 1
Importing Outlines - Lesson 2
Working In The Outline Pane - Lesson 1
Working In The Outline Pane - Lesson 2
Exporting Outlines To Word

Working With Text
Working With Text On Slides
Formatting Paragraphs And Fonts
Working With Headers And Footers
Getting Fancy With WordArt

Working With Objects
Selecting Objects On Slides
Moving, Sizing And Rotating Objects - Lesson 1
Moving, Sizing And Rotating Objects - Lesson 2
Aligning And Distributing Objects
Enabling Gridlines And Guides
Layering Objects
Making Work Easier With The Selection Pane
Grouping Objects

PowerPoint Drawing Tools And Shapes
Creating Shapes
Working With Flowchart Shapes
Formatting Shapes
Adding Text To Shapes
Merging Shapes
Using Save As Picture

Enhancing With Images
Inserting Your Own Images
Finding Images Online
Capturing Screenshots
Using Picture Tools - Lesson 1
Using Picture Tools - Lesson 2

Communicating Clearly With SmartArt
Inserting A SmartArt Graphic
Adding Descriptive Text To SmartArt
Adjusting SmartArt Design And Formatting - Lesson 1
Adjusting SmartArt Design And Formatting - Lesson 2

Using Tables To Organize Information
Creating Tables
Formatting Tables
Using Excel Spreadsheets In PowerPoint

Simplifying Data With Charts
Creating New Charts
Creating Charts From Existing Excel Data
Formatting Charts

Using Multimedia In Presentations
Adding Online Audio And Your Own Files
Recording Narration
Modifying Playback Options
Bringing Presentations To Life With Video
Customizing Video Properties
Ensuring Multimedia Works

Organizing Complex Presentations
Inserting And Working With Sections
Arranging And Hiding Slides
Adding Hyperlinks - Lesson 1
Adding Hyperlinks - Lesson 2

Polishing Presentations With Animation And Transitions
Adding Slide Transitions
Adding Built In Animations
Creating Motion Paths
Using The Animation Pane
Controlling Animation Execution

Sharing Presentations With Others
Finalizing Files For Distribution
Sharing Presentations
Printing Presentations And Creating Handouts
Packaging Presentations For CD
Creating Videos
Saving To Alternate File Types

Presenting PowerPoint Positively
Enhancing Presentation Skills With Notes
Creating Custom Shows
Setting Up Slide Shows
Making Masterful Presentations
Presenting Slide Shows Online

Course Wrap-Up
PowerPoint 2013 Closing Comments

About The Tutor
About The Tutor
A professionally created, self-study video training course
Includes 38 hours of easy to follow Microsoft Office 2013 - 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 2013 - Production Bundle tutorial videos by clicking a blue link below:
  • Tutor: Guy Vaccaro & Erin Olsen
  • Duration: 38 hours
  • Video lessons: 416
  • Product code: 01837
  • In stock: YES
  • Available on: DVD & Download
  • Work files included: YES
  • Works on: MS Windows PC & Mac
  • Also Recommended: Office 2013 Premium Bundle
Expert authors Guy Vaccaro and Erin Olsen guide you through these practical Microsoft programs with over 37 hours of comprehensive training in more than 400 tutorial videos.
Learn everything you need to know about these widely used Office Application programs, updated for 2013.

By the completion of this training bundle, you will have a full understanding of all 4 of these Microsoft programs and be able to use your real-world skills.
Working files are included from the authors, allowing you to follow along with them throughout the lessons.
What Our Customers Are Saying

"I thank you so much for the Training CD's. I've pushed my working knowledge considerably. I would recommend your materials to anybody. Thank you again for a great support relationship with Marrutt."Daniel Kiermaier, FL
 
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 416 Microsoft Office 2013 - Production Bundle training videos (listed left), lasting a total of 38 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 2013 - 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 2013 - 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 2013 - 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 thank you so much for the Training CD's. I've pushed my working knowledge considerably. I would recommend your materials to anybody. Thank you again for a great support relationship with Marrutt."Daniel Kiermaier, FL