Ultimate Excel 2010 Advanced Online Bundle, 10 Certificate Courses

Learn Advanced Skills in Microsoft Office 2010

Ultimate Excel 2010 Advanced Online Bundle, 10 Certificate Courses

NOW ONLY

US$599

Save US$2091 (78%)
OFF RRP US$2690
Get Info Pack

Get Excel 2010 Advanced, Excel 2010 Essentials, Excel 2010 Expert, Word 2010 Essentials, Word 2010 Advanced, Word 2010 Expert, PowerPoint 2010 Essentials, PowerPoint 2010 Advanced, PowerPoint 2010 Expert, and Outlook 2010 Essentials in this Bundle

1. Excel 2010 Advanced: Learn Advanced Skills with Excel 2010

Learn how to use the advanced features of Excel 2010. This course is designed to teach you a basic understanding of Excel 2010 in a practical way.

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information and better information leads to better decision making!

By the end of this Course, you will be able to:

  • Insert SmartArt
  • Add text to a diagram
  • Resize and move a diagram
  • Reset a diagram
  • Understand the contextual tabs
  • Add pictures from your computer
  • Add Clip Art
  • Add text boxes
  • Draw shapes
  • Trace precedent cells
  • Trace dependents of a cell
  • Display formulas within the sheet
  • Work with comments
  • Insert a chart
  • Use the Chart Tools tab
  • Understand the parts of a chart
  • Change the chart style
  • Resize and move a chart
  • Insert a Pivot Table
  • Use the Pivot Table Tools tab
  • Choose fields and group data in a Pivot Table
  • Change Pivot Table data and refresh the view
  • Apply a Style to a Pivot table
  • Use Real-life examples in a Pivot Table
  • Create a Pivot Chart from a Pivot Table
  • Create a Pivot Chart from Data
  • Display the Developer tab
  • Record and run macros
  • Change the security level
  • Customize and Change the Quick Access Toolbar
  • Use named ranges in formulas
  • Understand formula errors
  • Trace dependents and precedents in formulas
  • Use the Trace Errors Commands
  • Evaluate formulas
  • Use Goal Seek
  • Use the Scenario Manager
  • Use a One Input Data Table
  • Use a Two Input Data Table
  • Transposing Data from rows to columns
  • Use the Text to Columns feature
  • Check for duplicates
  • Create data validation rules
  • Consolidate Data
  • Group Data
  • Add Subtotals
  • Outline Data view Grouped and Outlined Data

2. Excel 2010 Essentials: Learn the Basic Features of Excel 2010

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into useable information and better information leads to better decision making!

By the end of this Excel 2010 Essentials Online Short Course, you will be able to:

  • Open and close Excel
  • Differentiate between worksheets, workbooks, rows, columns, and cells
  • Understand the new Interface and the new Backstage View
  • Enter labels and values
  • Edit data
  • Add rows and columns
  • Check spelling
  • Open, close, and save workbooks (including publishing to PDF and sending via E-mail)
  • Switch between Excel views and create custom views
  • Use Zoom
  • Set up, Preview and print your workbook
  • Build, copy and edit formulas
  • Use absolute referencing appropriately
  • Understand the difference between Formulas and Functions
  • Understand the new Function Names
  • Use the Formulas Tab
  • Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
  • Use the status bar to perform calculations
  • Use AutoFill and AutoComplete
  • Sort and filter data
  • Use sparklines
  • Format text and numbers
  • Use alignment options
  • Merge cells
  • Apply borders
  • Use cell styles
  • Use conditional formatting
  • Change the workbook theme

3. Excel 2010 Expert: Gain Skills to Become an Expert with Excel 2010

You will learn how to use the more in-depth features of Excel 2010. This course is designed to for the advanced users of Excel 2010.

Excel is the world's premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information, and better information leads to better decision making!

By the end of this Excel 2010 Expert Online Short Course, you will be able to:

  • Mark Workbook as Final
  • Encrypt with a Password and Restrict Permissions
  • Protect the Current Sheet or the Workbook Structure
  • Add a Digital Signature
  • Set Excel Options
  • Manage Versions
  • Save a Workbook as an Excel Template
  • Inspect Documents
  • Share Workbooks
  • Edit a Shared Workbook
  • Track Changes
  • Merge Copies of a Shared Workbook
  • Use the Watch Window
  • Set Calculation Options
  • Enable or Disable Automatic Workbook Calculations
  • Use the IFERROR Function to Evaluate Formulas
  • Use Array Formulas
  • Understand a Variety of different Functions
  • Assign Macros to a Command Button on the Ribbon
  • Run a Macro by Clicking an Area of a Graphic Object
  • Configure a Macro to Run Automatically Upon Opening the Workbook
  • Change a Macro
  • Insert Form Controls
  • Use a data form
  • Use Trend Lines
  • Add a Secondary Axis
  • Use Chart Templates
  • Work with PivotTable Tools
  • Work with PivotChart Tools
  • Use the Slicer
  • Choose External Data Sets with the Slicer
  • Understand the Analysis ToolPak

4. Word 2010 Essentials: Learn the Basic Features Word 2010

You will learn how to use the basic features of Word 2010. This course is designed to teach you a basic understanding of Word 2010 in a practical way.

Word is a powerful word processing application. However, it does much more than create simple documents. It includes several desktop publishing features to make your documents look great.

By the end of this Word 2010 Essentials Online Short Course, you should be able to:

  • Open and close Word
  • Understand the Word 2010 interface
  • Use the backstage view to create a new blank document or a document from a template
  • Use the backstage view to open files and use the recent list
  • Save documents
  • Type, select, and edit text
  • Use page breaks to start a new page
  • Use cut, copy, and paste, as well as the Office Clipboard Task pane
  • Set default paste options
  • Undo and redo tasks
  • Find and replace text
  • Use the Selection pane to select pictures or objects
  • Format fonts and paragraphs with a variety of features
  • Use bullets and numbering
  • Use borders and shading
  • Understand, create and use styles
  • Use themes
  • Add headers and footers
  • Format text as columns
  • Change page orientation
  • Add a page border or color
  • Use the page setup dialog
  • Check spelling
  • Preview, print, or email a document

5. Word 2010 Advanced: Learn Advanced Skills in Word 2010

You will learn how to use the advanced features of Word 2010. This course is designed to teach you a basic understanding of Word 2010 in a practical way.

In this course, we’ll cover some of the more advanced tasks in Word 2010, like working with pictures and other objects, using generated tables of contents and indexes, and other research and review tasks.

By the end of this Word 2010 Advanced Online Short Course, you will be able to:

  • Use Zoom
  • Understand Word Views
  • Split a Document
  • Use the Navigation Pane
  • Insert ClipArt, Pictures from Files, and Screen Shots
  • Move or Delete a Picture
  • Use the Picture Tools Tab
  • Remove a Picture’s Background
  • Adding Artistic Effects
  • Changing a Picture’s Layout
  • Use SmartArt
  • Work with Tables
  • Use the Table Tools Tab
  • Apply a Style to a Table
  • Add a Cover Page
  • Add Word Art
  • Draw Shapes
  • Add a Text Box
  • Add a Table of Contents
  • Manage Sources
  • Add Footnotes, Endnotes, and Citations
  • Insert a Bibliography
  • Create an Index
  • View Synonyms
  • Use the Research Task Pane
  • Use Translation ScreenTips
  • Set Your Language
  • Use Comments
  • Track and Review Changes
  • Compare Documents
  • Minimize the Ribbon
  • Customize the Quick Access Toolbar
  • Access Word Options

6. Word 2010 Expert: Become an Expert with Word  2010

This course will help you unlock even more advanced tools and features to have you editing and developing documents like an expert.

In this Word 2010 Expert workshop, you will cover some of the more advanced tasks like Mail Merge, Tracking Documents, Working with Templates, Reusable and Linked Content, and other research and review tasks.

By the end of this Word 2010 Expert Online Short Course, you should be able to:

  • Understand document Information
  • Protect a document
  • Check for issues
  • Manage versions
  • Customize Word Options
  • Create and use customized building blocks and Autotext
  • Understand how to use, modify, create and manage templates
  • Apply a template to an existing document
  • Use sections
  • Customize page numbers in sections
  • Use multiple page formats in a document
  • Use different headers and footers in a document
  • Use text box links
  • Merge different versions of a document
  • Track comments in a combined document
  • Review comments in a combined document
  • Understand the different types of cross references
  • Insert a bookmark or cross reference
  • Update a cross reference
  • Format cross references using fields
  • Create a mail merge
  • Send personalized email messages to multiple recipients
  • Use other data sources for mail merge
  • Create labels
  • Create envelope and label forms
  • Create a master document
  • Insert or create a subdocument
  • Expand and collapse subdocuments
  • Unlink a subdocument
  • Merge and split subdocuments
  • Lock a master document
  • Record or run a macro
  • Apply macro security
  • Assign a macro to a command button or keyboard shortcut
  • Create a form
  • Use form controls
  • Lock and unlock a form
  • Add and remove fields

7. PowerPoint 2010 Essentials: Learn the Basic Features of PowerPoint 2010

You will learn how to use the basic features of PowerPoint 2010. This course is designed to teach you a basic understanding of PowerPoint 2010 in a practical way. 

PowerPoint 2010 is a powerful presentation for the presentation of visual and graphical items. You can do everything from creating simple handouts to developing an animated presentation with audio.

By the end of this PowerPoint 2010 Essentials Online Short Course, you will be able to:

  • Open and close PowerPoint
  • Understand the PowerPoint 2010 interface
  • Use the backstage view to create a new blank presentation or a presentation from a template
  • Use the backstage view to open files and use the recent list
  • Save presentations
  • Add text to a slide and use content placeholders
  • Add slides
  • Use cut, copy, and paste, as well as the Office Clipboard Task pane
  • Undo and redo tasks
  • Find and replace text
  • Format fonts and paragraphs with a variety of features
  • Use bullets and numbering
  • Use themes
  • Change the slide design, layout, or background design
  • Add headers and footers
  • Create standard or custom animations
  • Use slide transitions and other advance options
  • Prepare a slide show, including narration and timing
  • Start a presentation
  • Navigate through a presentation
  • Change a presentation pointer
  • Switch to a blank screen in a presentation

8. PowerPoint 2010 Advanced: Learn Advanced Skills in PowerPoint 2010

You will learn how to use the advanced features of PowerPoint 2010. This course is designed to teach you a advanced features of PowerPoint 2010 in a practical way. 

PowerPoint 2010 is a powerful presentation for the presentation of visual and graphical items. You can do everything from creating simple handouts to developing an animated presentation with audio.

By the end of this PowerPoint 2010 Advanced Online Short Course, you will be able to:

  • Insert a picture
  • Insert screen shots
  • Insert clip art
  • Insert SmartArt
  • Insert a text box and add text
  • Insert a Table and add text
  • Resize, move, and delete a picture, text box, or SmartArt
  • Remove a picture’s background
  • Use the Picture Tools tab
  • Use the Text Box Tools tab
  • Use the SmartArt Tools tab
  • Use the Table Tools tab
  • Format a text box
  • Modify table rows and columns
  • Format a table
  • Add a movie
  • Add a sound clip
  • Create WordArt
  • Draw shapes
  • Use the Drawing Tools tab
  • Use the Grid and Gridlines
  • Rotate and flip objects
  • Align and distribute objects
  • Order objects
  • Group objects
  • Check spelling
  • Use the Research Task pane
  • Use Translation ScreenTips
  • Set the Language
  • Add Notes to Slides
  • Create a Notes Master
  • Create a Handout Master
  • Print Notes and Handouts
  • Switch to the Slide Master View
  • Use the Slide Master tab
  • Create a Slide Master
  • Apply a Slide Master
  • Edit a Slide Master
  • Insert slides from other presentations
  • Create a custom show
  • Record a presentation as a video
  • Package your presentation for CD
  • Understand the PowerPoint Viewer

9. PowerPoint 2010 Expert: Become an Expert in PowerPoint 2010

You will learn how to use the advanced features of PowerPoint 2010. This course is designed to go beyond a basic understanding and to explore the more advanced features of PowerPoint 2010 in a practical way. 

PowerPoint 2010 is a powerful presentation for the presentation of visual and graphical items. You can do everything from creating simple handouts to developing an animated presentation with audio.

By the end of this PowerPoint 2010 Expert Online Short Course, you will be able to:

  • Understand and adjust PowerPoint views
  • Work with multiple presentation windows
  • Add commands to the Ribbon or the Quick Access Toolbar
  • Configure PowerPoint Options
  • Use custom slide sizes
  • Change the slide orientation
  • Insert an outline
  • Reuse slides from the slide library
  • Reorganize slides
  • Work with sections
  • Switch to a different slide layout
  • Use footers
  • Work with slide fills
  • Modify the theme
  • Work with text box fills
  • Work with shapes and effects
  • Set text box alignment, internal margins and wrapping
  • Create a default text box
  • Use text box autofit
  • Insert or edit a photo album
  • Crop a picture
  • Change or reset a picture
  • Compress pictures
  • Use the selection pane
  • Position shapes
  • Apply shape styles or outlines
  • Add hyperlinks to graphical elements
  • Change the audio clip picture
  • Use the Audio and video formatting and playback tools
  • Work with effects
  • Work with transitions
  • Work with animation paths
  • Manipulate animations
  • Work with comments
  • Show or hide markup
  • Navigate comments
  • Compare and combine presentations
  • Save a presentation as another format
  • Save a slide or object as a picture file
  • Mark a presentation as final
  • Use passwords
  • Use annotations
  • Set up presenter view
  • Show media controls
  • Rehearse timings

10. Outlook 2010 Essentials: Learn how to use the Basic Features of Outlook 2010

You will learn how to use the basic features of Outlook 2010. This course is designed to teach you a basic understanding of Outlook 2010 in a practical way.

Outlook 2010 is a powerful e-mail application. However, it does much more than that to help you stay organized. With contacts, calendars, and tasks, Outlook can help you manage every aspect of your life.

By the end of this Outlook 2010 Essentials Online Short Course, you will be able to:

  • Open and close Outlook
  • Use the Outlook Interface, including the new Backstage view
  • Set up an e-mail account
  • View the Inbox
  • Send and Receive messages
  • View messages
  • Use Quick Steps
  • Reply to or forward messages
  • Delete e-mail
  • Ignore e-mail
  • Create and send a new message
  • Address a new message
  • Create the body of an e-mail message
  • Attach files to messages
  • Mark an item as Read or Unread
  • Print messages
  • Create folders and use them to organize messages
  • Understand and handle Junk Mail
  • Create Rules for handling messages
  • Use Categories
  • Flag items for follow-up
  • Search for items
  • Understand appointments and the calendar
  • Understand tasks and the To-Do List
  • Create and organize contacts

Receive Lifetime Access to Course Materials, so you can review at any time.

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. All courses are easy to follow and understand
  2. Only 6 to 8 hours of study is required per course
  3. Unlimited lifetime access to course materials
  4. Study as many courses as you want
  5. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  6. You can study from home or at work, at your own pace, in your own time
  7. Certificates

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

These courses are internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Receive Lifetime Access to Course Materials, so you can review at any time.

The Ultimate Excel 2010 Advanced 10 Course Bundle includes the following courses, below is a summary of each course: 

Course 1 - Excel 2010 Advanced

Module One: Getting Started

  • Course Objectives

Module Two: SmartArt and Objects

  • Lesson One: Inserting SmartArt
  • Lesson Two: Adding Text to the Diagram
  • Lesson Three: Resizing and Moving the Diagram
  • Lesson Four: Resetting the Diagram
  • Lesson Five: Adding Pictures from Your Computer
  • Lesson Six: Adding Clip Art
  • Lesson Seven: Adding Text Boxes
  • Lesson Eight: Drawing Shapes
  • Lesson Nine: About the Contextual Tabs

Module Three: Auditing

  • Lesson One: Tracing Recedent Cells
  • Lesson Two: Tracing the Dependents of a Cell
  • Lesson Three: Displaying Formulas Within the Sheet
  • Lesson Four: Adding, Displaying, Editing, and Removing Comments

Module Four:  Creating Charts

  • Lesson One: Inserting a Chart
  • Lesson Two: Overview of the Chart Tools Tab
  • Lesson Three: Understanding the Parts of a Chart
  • Lesson Four: Changing the Chart Style
  • Lesson Five: Resizing and Moving the Chart

Module Five: Creating Pivot Tables

  • Lesson One: Inserting a Pivot Table
  • Lesson Two: Choosing Fields and Grouping Data
  • Lesson Three: Overview of the Pivot Tools Tabs

Module Six: Working with PivotTables and PivotCharts

  • Lesson One: Changing the Data Displayed and Refreshing the PivotTable
  • Lesson Two: Applying a Style to Your Pivot Table
  • Lesson Three: Creating a Pivot Chart from a Pivot Table
  • Lesson Four: Creating a Pivot Chart from Data
  • Lesson Five: Some Real-life Examples

Module Seven:  Macros

  • Lesson One: Displaying the Developer Tab
  • Lesson Two: Recording and Running Macros
  • Lesson Three: Changing the Security Level
  • Lesson Four: Customizing and Changing the Quick Access Toolbar

Module Eight: Solving Formula Errors

  • Lesson One: Using Named Ranges
  • Lesson Two: Understanding Formula Errors
  • Lesson Three: Using the Trace Errors Commands
  • Lesson Four: Using Error Checking

Module Nine: Using What If Analysis

  • Lesson One: Using Goal Seek
  • Lesson Two: Using the Scenario Manager
  • Lesson Three: Using a One Input Data Table
  • Lesson Four: Using a Two Input Data Table

Module Ten: Managing Your Data

  • Lesson One: Transposing Data from Rows to Columns
  • Lesson Two: Using the Text to Columns Feature
  • Lesson Three: Checking for Duplicates
  • Lesson Four: Creating Data Validation Rules
  • Lesson Five: Consolidating Data

Module Eleven: Grouping and Outlining Data

  • Lesson One: Grouping Data
  • Lesson Two: Adding Subtotals
  • Lesson Three: Outlining Data
  • Lesson Four: Viewing Grouped and Outlined Data

Module Twelve: Wrapping Up

Course 2 - Excel 2010 Essentials

Module One: Getting Started

  • Course Objectives

Module Two: Opening and Closing Excel

  • Opening Excel
  • Understanding the Interface
  • Using Backstage View
  • Understanding Worksheets
  • Understanding Workbooks

Module Three: Your First Worksheet

  • Entering Data
  • Editing Data
  • Using the Wrap Command
  • Adding Rows and Columns
  • Checking Your Spelling

Module Four: Working with Excel Files

  • Saving Files
  • Publishing Files to PDF
  • Sending Files via E-Mail
  • Closing Files
  • Opening Files

Module Five: Viewing Excel Data

  • An Overview of Excel’s Views
  • Switching Views
  • Creating Custom Views
  • Using Zoom
  • Switching Between Open Files

Module Six: Printing Excel Data

  • An Overview of the Page Layout Tab
  • Setting Up Your Page
  • Using Print Preview
  • Printing Data

Module Seven: Building Formulas

  • The Math Basics of Excel
  • Building a Formula
  • Editing a Formula
  • Copying a Formula
  • Relative vs. Absolute References

Module Eight: Using Excel Functions

  • Formulas vs. Functions
  • Using the SUM Function
  • Using Other Basic Excel Functions
  • Understanding the Formulas Tab
  • Using the Status Bar to Perform Calculations
  • Understanding the New Function Names

Module Nine: Using Time Saving Tools

  • Using AutoFill
  • Using AutoComplete
  • Sorting Data
  • Filtering Data
  • Adding Sparklines

Module Ten: Formatting Your Data

  • Changing the Appearance of Text
  • Changing the Appearance of Numbers
  • Setting Alignment Options
  • Using Merge
  • Removing Formatting

Module Eleven: Advanced Formatting Tools

  • Adding Borders
  • Adding Fill Color
  • Using Cell Styles
  • Using Conditional Formatting
  • Changing the Theme

Module Twelve: Wrapping Up

Course 3 - Excel 2010 Expert

Module One: Getting Started

  • Course Objectives

Module Two: Working with Permissions and Options

  • Marking Workbook as Final
  • Encrypting with a Password and Restricting Permissions
  • Protecting the Current Sheet or the Workbook Structure
  • Adding a Digital Signature
  • Setting Excel Options
  • Managing Versions
  • Saving a Workbook as an Excel Template

Module Three: Sharing Workbooks

  • Inspecting Document
  • Sharing a Workbook
  • Editing a Shared Workbook
  • Tracking Changes
  • Merging Copies of a Shared Workbook

Module Four: Performing Advanced Formula and Function Tasks

  • Using the Watch Window
  • About the Excel Calculation Process
  • Setting Calculation Options
  • Enabling or Disabling Automatic Workbook Calculations
  • Using the IFERROR Function to Evaluate Formulas

Module Five: Working with Array Formulas

  • About Array Formulas
  • Creating One-Dimensional and Two-Dimensional Constants
  • Creating a Simple Array
  • Creating an Advanced Array

Module Six: Working with Functions

  • Working with Math and Trigonometry Functions
  • Using a SUMIF Function
  • Working with Date and Time Functions
  • Working with Financial Functions
  • Working with Text Functions
  • Working with Cube Functions
  • Working with Statistical Functions

Module Seven: Working with Macros

  • Assigning a Macro to a Command Button
  • Running a Macro by Clicking an Area of a Graphic Object
  • Configuring a Macro to Run Automatically Upon Opening the Workbook
  • Changing a Macro

Module Eight: Working with Forms

  • About Excel Forms, Form Controls, and Active X Controls
  • Using a Data Form
  • Using a List Box Control
  • Using a Combo Box Control
  • Using a Spin Button Control
  • Using a Scroll Bar Control

Module Nine: Applying Advanced Chart Features

  • About Trend Lines
  • Add a Trend Line
  • Using Secondary Axes
  • Using Chart Templates

Module Ten: Working with PivotTables and PivotCharts

  • Working with PivotTable Tools
  • Working with PivotChart Tools
  • About Slicers
  • Creating a Slicer in an Existing PivotTable
  • Creating a Standalone Slicer
  • Formatting a Slicer
  • Sharing Slicers with Another PivotTable
  • Disconnect or Delete a Slicer

Module Eleven: Using the Automated Analysis Tools Add-In

  • Loading the Analysis ToolPak
  • About the Analysis ToolPak Options (I)
  • About the Analysis ToolPak Options (II)
  • About the Analysis ToolPak Options (II)

Module Twelve: Wrapping Up

Course 4 - Word 2010 Essentials

Module One: Getting Started  

  • Course Objectives 

Module Two: Opening and Closing Word  

  • Opening Word  
  • Understanding the Interface  
  • Using Backstage View   
  • Creating a Blank Document 
  • Closing Word  

Module Three: Working with Documents 

  • Saving Files 
  • Opening Files 
  • Closing Files 
  • Creating a Document from a      Template  
  • Using the Recent List 

Module Four: Your First Document 

  • Typing Text 
  • Selecting Text with the Mouse or      Keyboard  
  • Dragging and Dropping Text 
  • Starting a New Page  

Module Five: Basic Editing Tasks

  • Using Cut, Copy, and Paste  
  • Using the Office Clipboard  
  • Using Undo and Redo  
  • Finding and Replacing Text 
  • Setting Paste Options 
  • Using the Selection Pane  

Module Six: Basic Formatting Tasks 

  • Understanding Levels of      Formatting 
  • Changing Font Face and Size  
  • Changing the Font Color 
  • Adding Font Enhancements 
  • Adding a Visual Effect 
  • Clearing Formatting 

Module Seven: Advanced Formatting Tasks 

  • Highlighting Text 
  • Changing Case  
  • Using the Format Painter 
  • Using the Font Dialog 
  • Setting Open Text Options 

Module Eight: Formatting Paragraphs 

  • Changing Spacing 
  • Setting the Alignment 
  • Adding Bullets and Numbering 
  • Adding Borders and Shading 

Module Nine: Working with Styles 

  • About Styles 
  • Applying a Style  
  • Changing the Style Set 
  • Changing the Theme  
  • Changing Theme Elements 

Module Ten: Formatting the Page  

  • Adding Headers and Footers 
  • Formatting Text as Columns 
  • Changing Page Orientation  
  • Changing the Page Color 
  • Adding a Page Border 
  • Using the Page Setup Dialog 

Module Eleven: Adding the Finishing Touches 

  • Checking Your Spelling 
  • Previewing Your Document 
  • Printing Your Document
  • E-Mailing Your Document 

Module Twelve: Wrapping Up 

Course 5 - Word 2010 Advanced

Module One: Getting Started 

  • Course Objectives

Module Two: Working with the Word Window  

  • Using Zoom  
  • An Overview of Word’s Views
  • Arranging Windows
  • Splitting a Document
  • Using the Navigation Pane 

Module Three: Adding Pictures 

  • Inserting Clip Art
  • Inserting a Picture from a File 
  • Inserting a Screenshot
  • Moving or Deleting a Picture 

Module Four: Formatting Pictures 

  • Using the Picture Tools Tab 
  • Removing a Picture’s Background 
  • Adding Artistic Effects
  • Changing Picture Layout

Module Five: Adding SmartArt

  • Inserting SmartArt
  • Adding Text to SmartArt
  • Using the SmartArt Tools Tabs
  • Moving and Deleting SmartArt

Module Six: Adding Tables 

  • Inserting a Table 
  • Adding Text to a Table 
  • About the Table Tools Tab 
  • Altering Rows and Columns
  • Applying a Style 
  • About Quick Tables

Module Seven: Inserting Special Objects 

  • Adding a Cover Page 
  • Adding WordArt
  • Drawing Shapes
  • Adding a Text Box 

Module Eight: Adding In Document References 

  • Adding a Table of Contents
  • Adding Footnotes, Endnotes, and Citations
  • Managing Sources
  • Inserting a Bibliography 
  • Creating an Index 

Module Nine: Advanced Research Tasks 

  • Viewing Synonyms
  • Using the Research Task Pane 
  • Using Translation ScreenTips
  • Setting the Language 

Module Ten: Reviewing a Document

  • Adding a Comment
  • Reviewing Comments
  • Tracking Changes
  • Reviewing Changes
  • Comparing Documents

Module Eleven: Customizing Word 

  • Minimizing the Ribbon 
  • Customizing the Quick Access Toolbar
  • Accessing Word’s Options
  • Changing Word’s Color Scheme

Module Twelve: Wrapping Up 

Course 6 - Word 2010 Expert

Module One: Getting Started

  • Course Objectives

Module Two: Working with Document Information and Word Customization

  • Understanding Document Information
  • Password Protecting a Document
  • Checking for Issues
  • Managing Versions
  • Customizing Word Options

Module Three: Working with Reusable Content

  • Saving Selection as Autotext
  • Inserting a Quick Part
  • Creating Customized Building Blocks
  • Editing a Building Block

Module Four: Working with Templates

  • About Templates
  • Modifying an Existing Template
  • Creating a New Template
  • Applying a Template to an Existing Document
  • Managing Templates

Module Five: Working with Sections and Linked Content

  • Using Sections
  • Customizing Page Numbers in Sections
  • Using Multiple Page Formats in a Document
  • Using Different Headers and Footers in a Document
  • Linking and Breaking Links for Text Boxes

Module Six: Managing Versions and Tracking Documents

  • Merging Different Versions of a Document
  • Tracking Comments in a Combined Document
  • Reviewing Comments in a Combined Document

Module Seven: Using Cross References

  • Types of Cross References

Inserting a Bookmark

  • Inserting a Cross Reference
  • Updating a Cross Reference
  • Formatting Cross References Using Fields

Module Eight: Working with Mail Merges

  • Creating a Mail Merge
  • Sending Personalized Email Messages to Multiple Recipients
  • About Other Data Sources for Mail Merge
  • Creating Labels
  • About Envelope and Label Forms

Module Nine: Working with Master Documents

  • Creating a Master Document
  • Creating Subdocuments
  • Inserting a Subdocument
  • Expanding and Collapsing Subdocuments
  • Unlinking a Subdocument
  • Merging and Splitting Subdocuments
  • Locking a Master Document

Module Ten: Working with Macros

  • Recording a Macro
  • Running a Macro
  • Applying Macro Security
  • Assigning a Macro to a Command Button or Shortcut Key

Module Eleven: Working with Forms

  • Creating a Form
  • Using Form Controls
  • Locking and Unlocking a Form
  • Adding and Removing Fields
  • Linking a Form to a Database

Module Twelve: Wrapping Up

Course 7 - PowerPoint 2010 Essentials

Module One: Getting Started

  • Course objectives

Module Two: Opening and Closing PowerPoint

  • Lesson One: Opening PowerPoint
  • Lesson Two: Understanding the Interface
  • Lesson Three: Using Backstage View
  • Lesson Four: Creating a Blank Presentation
  • Lesson Five: Closing PowerPoint

Module Three: Working with Presentations

  • Lesson One: Saving Files
  • Lesson Two: Opening Files
  • Lesson Three: Closing Files
  • Lesson Four: Creating a Presentation from a Template
  • Lesson Five: Using the Recent List

Module Four: Your First Presentation

  • Lesson One: Adding Text to a Slide
  • Lesson Two: Adding Slides
  • Lesson Three: Using a Content Placeholder
  • Lesson Four: Using the Slides Tab

Module Five: Working with Text

  • Lesson One: Using Cut, Copy, and Paste
  • Lesson Two: Using the Office Clipboard
  • Lesson Three: Using Undo and Redo
  • Lesson Four: Finding and Replacing Text

Module Six: Formatting Text

  • Lesson One: Changing Font Face and Size
  • Lesson Two: Changing the Font Color
  • Lesson Three: Changing Character Spacing
  • Lesson Four: Adding Font Enhancements
  • Lesson Five: Clearing Formatting
  • Lesson Six: Using the Font Dialog

Module Seven: Formatting Paragraphs

  • Lesson One: Adding Bullets and Numbering
  • Lesson Two: Changing Alignment
  • Lesson Three: Adjusting the Indent
  • Lesson Four: Using Indents and Tabs
  • Lesson Five: Changing Line Spacing

Module Eight: Advanced Formatting Tasks

  • Lesson One: Using the Format Painter
  • Lesson Two: Changing Slide Layout
  • Lesson Three: Changing Slide Design
  • Lesson Four: Changing the Theme
  • Lesson Five: Changing the Background Design

Module Nine: Customizing Slide Elements 

  • Lesson One: Adding a Header or Footer
  • Lesson Two: Creating a Standard Animation
  • Lesson Three: Creating a Custom Animation
  • Lesson Four: Using the Animation Painter
  • Lesson Six: Adding a Slide Transition
  • Lesson Seven: Setting Slide Advance Options

Module Ten: Setting Up Your Slide Show

  • Lesson One: Working with Sections
  • Lesson Two: Using the Set Up Show Diaglog
  • Lesson Three: Recording a Narration
  • Lesson Four: Timing Your Show
  • Lesson Five: Hiding Slides

Module Eleven: Showtime!

  • Lesson One: Our Top Five PowerPoint Tips
  • Lesson Two: Starting a Show
  • Lesson Three: Navigating Through the Show
  • Lesson Four: Changing Your Pointer
  • Lesson Six: Switching to a Blank Screen

Module Twelve: Wrapping Up

Course 8 - PowerPoint 2010 Advanced

Module One: Getting Started

  • Course Objectives

Module Two: Adding Pictures

  • Lesson One: Inserting a Picture from a File
  • Lesson Two: Adding Screenshots
  • Lesson Three: Inserting Clip Art
  • Lesson Four: Using the Picture Tools Tab
  • Lesson Five: Resizing, Moving, and Deleting a Picture
  • Lesson Six: Removing a Picture's Background

Module Three: Working with Text Boxes

  • Lesson One: Inserting a Text Box
  • Lesson Two: Adding Text
  • Lesson Three: Using the Drawing Tools Tab
  • Lesson Four: Resizing, Moving, and Deleting a Text Box
  • Lesson Five: Formatting a Text Box

Module Four: Adding SmartArt

  • Lesson One: Inserting SmartArt
  • Lesson Two: Using the SmartArt Tools Tab
  • Lesson Three: Adding Text to SmartArt
  • Lesson Four: Resizing, Moving, and Deleting SmartArt

Module Five: Adding Tables

  • Lesson One: Inserting a Table
  • Lesson Two: Adding Text to a Table
  • Lesson Three: Using the Table Tools Tab
  • Lesson Four: Modifying Rows and Columns
  • Lesson Five: Formatting a Table

Module Six: Inserting Advanced Objects

  • Lesson One: Adding a Movie
  • Lesson Two: Adding a Sound Clip
  • Lesson Three: Creating Word Art
  • Lesson Four: Drawing Shapes
  • Lesson Five: About the Drawing Tools Tab

Module Seven:  Advanced Drawing Tasks

  • Lesson One: Using the Grid and Guides
  • Lesson Two: Rotating and Flipping Objects
  • Lesson Three: Aligning and Distributing Objects
  • Lesson Four: Ordering Objects
  • Lesson Five: Grouping Objects

Module Eight: PowerPoint's Research Tools

  • Lesson One: Checking Spelling
  • Lesson Two: Using the Research Task Pane
  • Lesson Three: Using Translation Screen Tips
  • Lesson Four: Setting the Language

Module Nine:  Creating Notes and Handouts

  • Lesson One: Adding Notes to Slides
  • Lesson Two: Creating a Notes Master
  • Lesson Three: Creating a Handout Master
  • Lesson Four: Printing Notes and Handouts

Module Ten: Using Slide Masters

  • Lesson One: Switching to Slide Master View
  • Lesson Two: Using the Slide Master Tab
  • Lesson Three: Creating a Slide Master
  • Lesson Four: Applying a Slide Master
  • Lesson Five: Editing a Slide Master

Module Eleven: Advanced Presentation Skills

  • Lesson One: Inserting Slides from Other Presentations
  • Lesson Two: Creating a Custom Show
  • Lesson Three: Recording Your Show as a Video
  • Lesson Four: Packaging Your Presentation for CD
  • Lesson Five: About the PowerpPoint Viewer

Module Twelve: Wrapping Up

Course 9 - PowerPoint 2010 Expert

Module One: Getting Started

  • Course objectives

Module Two: Working with the PowerPoint Environment

  • Lesson One: About PowerPoint Views
  • Lesson Two: Adjusting the View
  • Lesson Three: Configuring the PowerPoint Options
  • Lesson Four: Adding a Command to the Ribbon
  • Lesson Five: Adding a Command to the Quick Access Toolbar
  • Lesson Six: Working with Multiple Presentation Windows

Module Three: Working with Presentations

  • Lesson One: Using Custom Slide Sizes
  • Lesson Two: Changing the Orientation
  • Lesson Three: Inserting an Outline
  • Lesson Four: Reusing Slides from the Slide Library
  • Lesson Five: Reorganizing Slides

Module Four:  Formatting Presentations

  • Lesson One: Working with Sections
  • Lesson Two: Switching to a Different Slide Layout
  • Lesson Three: Using Footers
  • Lesson Four: Working with Slide Fills
  • Lesson Five: Modifying the Theme

Module Five: Formatting Text Boxes

  • Lesson One: Working with Text Box Fills
  • Lesson Two: Working with Shapes and Effects
  • Lesson Three: Setting Text Box Alignment, Internal Margins, and Wrapping
  • Lesson Four: Using Autofit
  • Lesson Five: Creating a Default Text box

Module Six: Creating a Photo Album

  • Lesson One: Inserting a Photo Album
  • Lesson Two: Editing Photo Albums
  • Lesson Three: Cropping a Picture
  • Lesson Four: Changing and Resetting a Picture
  • Lesson Five: Compressing Pictures

Module Seven: Working with Graphical Elements

  • Lesson One: Using the Selection Pane
  • Lesson Two: Positioning Shapes
  • Lesson Three: Applying a Shape Style
  • Lesson Four: Using Shape Outline
  • Lesson Five: Editing Shape Points
  • Lesson Six: Adding Hyperlinks

Module Eight: Working with Audio and Video Content

  • Lesson One: Changing the Audio Icon Picture
  • Lesson Two: Using the Audio Tools Format Tab
  • Lesson Three: Adjusting Audio Playback Options
  • Lesson Four: Using the Video Tools Format Tab
  • Lesson Five: Adjusting Video Playback Options

Module Nine: Working with Transitions and Animations

  • Lesson One: Working with Effects
  • Lesson Two: Working with Transitions
  • Lesson Three: Working with Paths
  • Lesson Four: Manipulating Animations

Module Ten: Collaborating on Presentations

  • Lesson One: Working with Comments
  • Lesson Two: Showing or Hiding Markup
  • Lesson Three: Navigating Comments
  • Lesson Four: Comparing and Combining Presentations

Module Eleven: Delivering Presentations

  • Lesson One: Saving a Presentation as a Picture Presentation,, XPS, or OpenDocument
  • Lesson Two: Saving a Slide or Object as a Picture File
  • Lesson Three: Protecting a Presentation
  • Lesson Four: Setting up Presenter View
  • Lesson Five: Showing Media Controls
  • Lesson Six: Using Annotations
  • Lesson Seven: Rehearsing Timings

Module Twelve: Wrapping Up

Course 10 - Outlook 2010 Essentials

Module One: Getting Started

  • Course Objectives

Module Two: Opening and Closing Outlook

  • Lesson One: Opening Outlook
  • Lesson Two: Understanding the Interface
  • Lesson Three: Using Backstage View
  • Lesson Four: Setting up an E-mail Account
  • Lesson Five: Viewing Your Inbox
  • Lesson Six: Closing Outlook

Module Three:  Working with E-mail

  • Lesson One: Sending and Receiving Mail
  • Lesson Two: Viewing an E-mail
  • Lesson Three: Replying To or Forwarding an E-mail
  • Lesson Four: Deleting an E-mail
  • Lesson Five: Ignoring E-mail
  • Lesson Six: Using Quick Steps

Module Four:  Creating a New E-mail

  • Lesson One: Creating an E-mail
  • Lesson Two: Addressing an E-mail
  • Lesson Three: Creating the Body
  • Lesson Four: Attaching a File
  • Lesson Five: Sending the Message

Module Five: Managing E-mail

  • Lesson One: Marking an Item as Read or Unread
  • Lesson Two: Printing a Message
  • Lesson Three: Creating Folders
  • Lesson Four: Moving Messages to Folders
  • Lesson Five: Renaming, Moving, and Deleting Folders

Module Six: Managing Junk Mail

  • Lesson One: About the Junk Mail Filter
  • Lesson Two: Enabling Junk Mail Filtering
  • Lesson Three: Enabling the Phishing Filter
  • Lesson Four: Modifying Safe and Blocked Senders Lists
  • Lesson Five: Marking a Message as Junk or Not Junk

Module Seven: Outlook's Organization Tools

  • Lesson One: Creating a Basic Rule
  • Lesson Two: Creating an Advanced Rule
  • Lesson Three: Using Categories
  • Lesson Four: Flagging an Item for Follow-Up
  • Lesson Five: Viewing Favorite Folders

Module Eight: Searching for Items

  • Lesson One: Understanding Search Folders
  • Lesson Two: Setting Up and Using Search Folders
  • Lesson Three: Using Instant Search
  • Lesson Four: Using Advanced Search
  • Lesson Five: Using Contact Search

Module Nine: An Introduction to the Calendar

  • Lesson One: Getting Started
  • Lesson Two: Creating an Appointment
  • Lesson Three: Changing Your Calendar View
  • Lesson Four: Editing an Appointment
  • Lesson Five: Managing Reminders

Module Ten: An Introduction to Tasks

  • Lesson One: Getting Started
  • Lesson Two: Creating a New Task
  • Lesson Three: Editing a Task
  • Lesson Four: Updating Task Status
  • Lesson Five: Basic Task Views

Module Eleven: An Introduction to Contacts

  • Lesson One: Getting Started
  • Lesson Two: Creating a New Contact
  • Lesson Three: Editing a Contact
  • Lesson Four: Organizing Contacts
  • Lesson Five: Basic Contact Views

Module Twelve: Wrapping Up

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

About this Course

Get Excel 2010 Advanced, Excel 2010 Essentials, Excel 2010 Expert, Word 2010 Essentials, Word 2010 Advanced, Word 2010 Expert, PowerPoint 2010 Essentials, PowerPoint 2010 Advanced, PowerPoint 2010 Expert, and Outlook 2010 Essentials in this Bundle

1. Excel 2010 Advanced: Learn Advanced Skills with Excel 2010

Learn how to use the advanced features of Excel 2010. This course is designed to teach you a basic understanding of Excel 2010 in a practical way.

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information and better information leads to better decision making!

By the end of this Course, you will be able to:

  • Insert SmartArt
  • Add text to a diagram
  • Resize and move a diagram
  • Reset a diagram
  • Understand the contextual tabs
  • Add pictures from your computer
  • Add Clip Art
  • Add text boxes
  • Draw shapes
  • Trace precedent cells
  • Trace dependents of a cell
  • Display formulas within the sheet
  • Work with comments
  • Insert a chart
  • Use the Chart Tools tab
  • Understand the parts of a chart
  • Change the chart style
  • Resize and move a chart
  • Insert a Pivot Table
  • Use the Pivot Table Tools tab
  • Choose fields and group data in a Pivot Table
  • Change Pivot Table data and refresh the view
  • Apply a Style to a Pivot table
  • Use Real-life examples in a Pivot Table
  • Create a Pivot Chart from a Pivot Table
  • Create a Pivot Chart from Data
  • Display the Developer tab
  • Record and run macros
  • Change the security level
  • Customize and Change the Quick Access Toolbar
  • Use named ranges in formulas
  • Understand formula errors
  • Trace dependents and precedents in formulas
  • Use the Trace Errors Commands
  • Evaluate formulas
  • Use Goal Seek
  • Use the Scenario Manager
  • Use a One Input Data Table
  • Use a Two Input Data Table
  • Transposing Data from rows to columns
  • Use the Text to Columns feature
  • Check for duplicates
  • Create data validation rules
  • Consolidate Data
  • Group Data
  • Add Subtotals
  • Outline Data view Grouped and Outlined Data

2. Excel 2010 Essentials: Learn the Basic Features of Excel 2010

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into useable information and better information leads to better decision making!

By the end of this Excel 2010 Essentials Online Short Course, you will be able to:

  • Open and close Excel
  • Differentiate between worksheets, workbooks, rows, columns, and cells
  • Understand the new Interface and the new Backstage View
  • Enter labels and values
  • Edit data
  • Add rows and columns
  • Check spelling
  • Open, close, and save workbooks (including publishing to PDF and sending via E-mail)
  • Switch between Excel views and create custom views
  • Use Zoom
  • Set up, Preview and print your workbook
  • Build, copy and edit formulas
  • Use absolute referencing appropriately
  • Understand the difference between Formulas and Functions
  • Understand the new Function Names
  • Use the Formulas Tab
  • Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
  • Use the status bar to perform calculations
  • Use AutoFill and AutoComplete
  • Sort and filter data
  • Use sparklines
  • Format text and numbers
  • Use alignment options
  • Merge cells
  • Apply borders
  • Use cell styles
  • Use conditional formatting
  • Change the workbook theme

3. Excel 2010 Expert: Gain Skills to Become an Expert with Excel 2010

You will learn how to use the more in-depth features of Excel 2010. This course is designed to for the advanced users of Excel 2010.

Excel is the world's premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information, and better information leads to better decision making!

By the end of this Excel 2010 Expert Online Short Course, you will be able to:

  • Mark Workbook as Final
  • Encrypt with a Password and Restrict Permissions
  • Protect the Current Sheet or the Workbook Structure
  • Add a Digital Signature
  • Set Excel Options
  • Manage Versions
  • Save a Workbook as an Excel Template
  • Inspect Documents
  • Share Workbooks
  • Edit a Shared Workbook
  • Track Changes
  • Merge Copies of a Shared Workbook
  • Use the Watch Window
  • Set Calculation Options
  • Enable or Disable Automatic Workbook Calculations
  • Use the IFERROR Function to Evaluate Formulas
  • Use Array Formulas
  • Understand a Variety of different Functions
  • Assign Macros to a Command Button on the Ribbon
  • Run a Macro by Clicking an Area of a Graphic Object
  • Configure a Macro to Run Automatically Upon Opening the Workbook
  • Change a Macro
  • Insert Form Controls
  • Use a data form
  • Use Trend Lines
  • Add a Secondary Axis
  • Use Chart Templates
  • Work with PivotTable Tools
  • Work with PivotChart Tools
  • Use the Slicer
  • Choose External Data Sets with the Slicer
  • Understand the Analysis ToolPak

4. Word 2010 Essentials: Learn the Basic Features Word 2010

You will learn how to use the basic features of Word 2010. This course is designed to teach you a basic understanding of Word 2010 in a practical way.

Word is a powerful word processing application. However, it does much more than create simple documents. It includes several desktop publishing features to make your documents look great.

By the end of this Word 2010 Essentials Online Short Course, you should be able to:

  • Open and close Word
  • Understand the Word 2010 interface
  • Use the backstage view to create a new blank document or a document from a template
  • Use the backstage view to open files and use the recent list
  • Save documents
  • Type, select, and edit text
  • Use page breaks to start a new page
  • Use cut, copy, and paste, as well as the Office Clipboard Task pane
  • Set default paste options
  • Undo and redo tasks
  • Find and replace text
  • Use the Selection pane to select pictures or objects
  • Format fonts and paragraphs with a variety of features
  • Use bullets and numbering
  • Use borders and shading
  • Understand, create and use styles
  • Use themes
  • Add headers and footers
  • Format text as columns
  • Change page orientation
  • Add a page border or color
  • Use the page setup dialog
  • Check spelling
  • Preview, print, or email a document

5. Word 2010 Advanced: Learn Advanced Skills in Word 2010

You will learn how to use the advanced features of Word 2010. This course is designed to teach you a basic understanding of Word 2010 in a practical way.

In this course, we’ll cover some of the more advanced tasks in Word 2010, like working with pictures and other objects, using generated tables of contents and indexes, and other research and review tasks.

By the end of this Word 2010 Advanced Online Short Course, you will be able to:

  • Use Zoom
  • Understand Word Views
  • Split a Document
  • Use the Navigation Pane
  • Insert ClipArt, Pictures from Files, and Screen Shots
  • Move or Delete a Picture
  • Use the Picture Tools Tab
  • Remove a Picture’s Background
  • Adding Artistic Effects
  • Changing a Picture’s Layout
  • Use SmartArt
  • Work with Tables
  • Use the Table Tools Tab
  • Apply a Style to a Table
  • Add a Cover Page
  • Add Word Art
  • Draw Shapes
  • Add a Text Box
  • Add a Table of Contents
  • Manage Sources
  • Add Footnotes, Endnotes, and Citations
  • Insert a Bibliography
  • Create an Index
  • View Synonyms
  • Use the Research Task Pane
  • Use Translation ScreenTips
  • Set Your Language
  • Use Comments
  • Track and Review Changes
  • Compare Documents
  • Minimize the Ribbon
  • Customize the Quick Access Toolbar
  • Access Word Options

6. Word 2010 Expert: Become an Expert with Word  2010

This course will help you unlock even more advanced tools and features to have you editing and developing documents like an expert.

In this Word 2010 Expert workshop, you will cover some of the more advanced tasks like Mail Merge, Tracking Documents, Working with Templates, Reusable and Linked Content, and other research and review tasks.

By the end of this Word 2010 Expert Online Short Course, you should be able to:

  • Understand document Information
  • Protect a document
  • Check for issues
  • Manage versions
  • Customize Word Options
  • Create and use customized building blocks and Autotext
  • Understand how to use, modify, create and manage templates
  • Apply a template to an existing document
  • Use sections
  • Customize page numbers in sections
  • Use multiple page formats in a document
  • Use different headers and footers in a document
  • Use text box links
  • Merge different versions of a document
  • Track comments in a combined document
  • Review comments in a combined document
  • Understand the different types of cross references
  • Insert a bookmark or cross reference
  • Update a cross reference
  • Format cross references using fields
  • Create a mail merge
  • Send personalized email messages to multiple recipients
  • Use other data sources for mail merge
  • Create labels
  • Create envelope and label forms
  • Create a master document
  • Insert or create a subdocument
  • Expand and collapse subdocuments
  • Unlink a subdocument
  • Merge and split subdocuments
  • Lock a master document
  • Record or run a macro
  • Apply macro security
  • Assign a macro to a command button or keyboard shortcut
  • Create a form
  • Use form controls
  • Lock and unlock a form
  • Add and remove fields

7. PowerPoint 2010 Essentials: Learn the Basic Features of PowerPoint 2010

You will learn how to use the basic features of PowerPoint 2010. This course is designed to teach you a basic understanding of PowerPoint 2010 in a practical way. 

PowerPoint 2010 is a powerful presentation for the presentation of visual and graphical items. You can do everything from creating simple handouts to developing an animated presentation with audio.

By the end of this PowerPoint 2010 Essentials Online Short Course, you will be able to:

  • Open and close PowerPoint
  • Understand the PowerPoint 2010 interface
  • Use the backstage view to create a new blank presentation or a presentation from a template
  • Use the backstage view to open files and use the recent list
  • Save presentations
  • Add text to a slide and use content placeholders
  • Add slides
  • Use cut, copy, and paste, as well as the Office Clipboard Task pane
  • Undo and redo tasks
  • Find and replace text
  • Format fonts and paragraphs with a variety of features
  • Use bullets and numbering
  • Use themes
  • Change the slide design, layout, or background design
  • Add headers and footers
  • Create standard or custom animations
  • Use slide transitions and other advance options
  • Prepare a slide show, including narration and timing
  • Start a presentation
  • Navigate through a presentation
  • Change a presentation pointer
  • Switch to a blank screen in a presentation

8. PowerPoint 2010 Advanced: Learn Advanced Skills in PowerPoint 2010

You will learn how to use the advanced features of PowerPoint 2010. This course is designed to teach you a advanced features of PowerPoint 2010 in a practical way. 

PowerPoint 2010 is a powerful presentation for the presentation of visual and graphical items. You can do everything from creating simple handouts to developing an animated presentation with audio.

By the end of this PowerPoint 2010 Advanced Online Short Course, you will be able to:

  • Insert a picture
  • Insert screen shots
  • Insert clip art
  • Insert SmartArt
  • Insert a text box and add text
  • Insert a Table and add text
  • Resize, move, and delete a picture, text box, or SmartArt
  • Remove a picture’s background
  • Use the Picture Tools tab
  • Use the Text Box Tools tab
  • Use the SmartArt Tools tab
  • Use the Table Tools tab
  • Format a text box
  • Modify table rows and columns
  • Format a table
  • Add a movie
  • Add a sound clip
  • Create WordArt
  • Draw shapes
  • Use the Drawing Tools tab
  • Use the Grid and Gridlines
  • Rotate and flip objects
  • Align and distribute objects
  • Order objects
  • Group objects
  • Check spelling
  • Use the Research Task pane
  • Use Translation ScreenTips
  • Set the Language
  • Add Notes to Slides
  • Create a Notes Master
  • Create a Handout Master
  • Print Notes and Handouts
  • Switch to the Slide Master View
  • Use the Slide Master tab
  • Create a Slide Master
  • Apply a Slide Master
  • Edit a Slide Master
  • Insert slides from other presentations
  • Create a custom show
  • Record a presentation as a video
  • Package your presentation for CD
  • Understand the PowerPoint Viewer

9. PowerPoint 2010 Expert: Become an Expert in PowerPoint 2010

You will learn how to use the advanced features of PowerPoint 2010. This course is designed to go beyond a basic understanding and to explore the more advanced features of PowerPoint 2010 in a practical way. 

PowerPoint 2010 is a powerful presentation for the presentation of visual and graphical items. You can do everything from creating simple handouts to developing an animated presentation with audio.

By the end of this PowerPoint 2010 Expert Online Short Course, you will be able to:

  • Understand and adjust PowerPoint views
  • Work with multiple presentation windows
  • Add commands to the Ribbon or the Quick Access Toolbar
  • Configure PowerPoint Options
  • Use custom slide sizes
  • Change the slide orientation
  • Insert an outline
  • Reuse slides from the slide library
  • Reorganize slides
  • Work with sections
  • Switch to a different slide layout
  • Use footers
  • Work with slide fills
  • Modify the theme
  • Work with text box fills
  • Work with shapes and effects
  • Set text box alignment, internal margins and wrapping
  • Create a default text box
  • Use text box autofit
  • Insert or edit a photo album
  • Crop a picture
  • Change or reset a picture
  • Compress pictures
  • Use the selection pane
  • Position shapes
  • Apply shape styles or outlines
  • Add hyperlinks to graphical elements
  • Change the audio clip picture
  • Use the Audio and video formatting and playback tools
  • Work with effects
  • Work with transitions
  • Work with animation paths
  • Manipulate animations
  • Work with comments
  • Show or hide markup
  • Navigate comments
  • Compare and combine presentations
  • Save a presentation as another format
  • Save a slide or object as a picture file
  • Mark a presentation as final
  • Use passwords
  • Use annotations
  • Set up presenter view
  • Show media controls
  • Rehearse timings

10. Outlook 2010 Essentials: Learn how to use the Basic Features of Outlook 2010

You will learn how to use the basic features of Outlook 2010. This course is designed to teach you a basic understanding of Outlook 2010 in a practical way.

Outlook 2010 is a powerful e-mail application. However, it does much more than that to help you stay organized. With contacts, calendars, and tasks, Outlook can help you manage every aspect of your life.

By the end of this Outlook 2010 Essentials Online Short Course, you will be able to:

  • Open and close Outlook
  • Use the Outlook Interface, including the new Backstage view
  • Set up an e-mail account
  • View the Inbox
  • Send and Receive messages
  • View messages
  • Use Quick Steps
  • Reply to or forward messages
  • Delete e-mail
  • Ignore e-mail
  • Create and send a new message
  • Address a new message
  • Create the body of an e-mail message
  • Attach files to messages
  • Mark an item as Read or Unread
  • Print messages
  • Create folders and use them to organize messages
  • Understand and handle Junk Mail
  • Create Rules for handling messages
  • Use Categories
  • Flag items for follow-up
  • Search for items
  • Understand appointments and the calendar
  • Understand tasks and the To-Do List
  • Create and organize contacts

Receive Lifetime Access to Course Materials, so you can review at any time.

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. All courses are easy to follow and understand
  2. Only 6 to 8 hours of study is required per course
  3. Unlimited lifetime access to course materials
  4. Study as many courses as you want
  5. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  6. You can study from home or at work, at your own pace, in your own time
  7. Certificates

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

These courses are internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Receive Lifetime Access to Course Materials, so you can review at any time.

The Ultimate Excel 2010 Advanced 10 Course Bundle includes the following courses, below is a summary of each course: 

Course 1 - Excel 2010 Advanced

Module One: Getting Started

  • Course Objectives

Module Two: SmartArt and Objects

  • Lesson One: Inserting SmartArt
  • Lesson Two: Adding Text to the Diagram
  • Lesson Three: Resizing and Moving the Diagram
  • Lesson Four: Resetting the Diagram
  • Lesson Five: Adding Pictures from Your Computer
  • Lesson Six: Adding Clip Art
  • Lesson Seven: Adding Text Boxes
  • Lesson Eight: Drawing Shapes
  • Lesson Nine: About the Contextual Tabs

Module Three: Auditing

  • Lesson One: Tracing Recedent Cells
  • Lesson Two: Tracing the Dependents of a Cell
  • Lesson Three: Displaying Formulas Within the Sheet
  • Lesson Four: Adding, Displaying, Editing, and Removing Comments

Module Four:  Creating Charts

  • Lesson One: Inserting a Chart
  • Lesson Two: Overview of the Chart Tools Tab
  • Lesson Three: Understanding the Parts of a Chart
  • Lesson Four: Changing the Chart Style
  • Lesson Five: Resizing and Moving the Chart

Module Five: Creating Pivot Tables

  • Lesson One: Inserting a Pivot Table
  • Lesson Two: Choosing Fields and Grouping Data
  • Lesson Three: Overview of the Pivot Tools Tabs

Module Six: Working with PivotTables and PivotCharts

  • Lesson One: Changing the Data Displayed and Refreshing the PivotTable
  • Lesson Two: Applying a Style to Your Pivot Table
  • Lesson Three: Creating a Pivot Chart from a Pivot Table
  • Lesson Four: Creating a Pivot Chart from Data
  • Lesson Five: Some Real-life Examples

Module Seven:  Macros

  • Lesson One: Displaying the Developer Tab
  • Lesson Two: Recording and Running Macros
  • Lesson Three: Changing the Security Level
  • Lesson Four: Customizing and Changing the Quick Access Toolbar

Module Eight: Solving Formula Errors

  • Lesson One: Using Named Ranges
  • Lesson Two: Understanding Formula Errors
  • Lesson Three: Using the Trace Errors Commands
  • Lesson Four: Using Error Checking

Module Nine: Using What If Analysis

  • Lesson One: Using Goal Seek
  • Lesson Two: Using the Scenario Manager
  • Lesson Three: Using a One Input Data Table
  • Lesson Four: Using a Two Input Data Table

Module Ten: Managing Your Data

  • Lesson One: Transposing Data from Rows to Columns
  • Lesson Two: Using the Text to Columns Feature
  • Lesson Three: Checking for Duplicates
  • Lesson Four: Creating Data Validation Rules
  • Lesson Five: Consolidating Data

Module Eleven: Grouping and Outlining Data

  • Lesson One: Grouping Data
  • Lesson Two: Adding Subtotals
  • Lesson Three: Outlining Data
  • Lesson Four: Viewing Grouped and Outlined Data

Module Twelve: Wrapping Up

Course 2 - Excel 2010 Essentials

Module One: Getting Started

  • Course Objectives

Module Two: Opening and Closing Excel

  • Opening Excel
  • Understanding the Interface
  • Using Backstage View
  • Understanding Worksheets
  • Understanding Workbooks

Module Three: Your First Worksheet

  • Entering Data
  • Editing Data
  • Using the Wrap Command
  • Adding Rows and Columns
  • Checking Your Spelling

Module Four: Working with Excel Files

  • Saving Files
  • Publishing Files to PDF
  • Sending Files via E-Mail
  • Closing Files
  • Opening Files

Module Five: Viewing Excel Data

  • An Overview of Excel’s Views
  • Switching Views
  • Creating Custom Views
  • Using Zoom
  • Switching Between Open Files

Module Six: Printing Excel Data

  • An Overview of the Page Layout Tab
  • Setting Up Your Page
  • Using Print Preview
  • Printing Data

Module Seven: Building Formulas

  • The Math Basics of Excel
  • Building a Formula
  • Editing a Formula
  • Copying a Formula
  • Relative vs. Absolute References

Module Eight: Using Excel Functions

  • Formulas vs. Functions
  • Using the SUM Function
  • Using Other Basic Excel Functions
  • Understanding the Formulas Tab
  • Using the Status Bar to Perform Calculations
  • Understanding the New Function Names

Module Nine: Using Time Saving Tools

  • Using AutoFill
  • Using AutoComplete
  • Sorting Data
  • Filtering Data
  • Adding Sparklines

Module Ten: Formatting Your Data

  • Changing the Appearance of Text
  • Changing the Appearance of Numbers
  • Setting Alignment Options
  • Using Merge
  • Removing Formatting

Module Eleven: Advanced Formatting Tools

  • Adding Borders
  • Adding Fill Color
  • Using Cell Styles
  • Using Conditional Formatting
  • Changing the Theme

Module Twelve: Wrapping Up

Course 3 - Excel 2010 Expert

Module One: Getting Started

  • Course Objectives

Module Two: Working with Permissions and Options

  • Marking Workbook as Final
  • Encrypting with a Password and Restricting Permissions
  • Protecting the Current Sheet or the Workbook Structure
  • Adding a Digital Signature
  • Setting Excel Options
  • Managing Versions
  • Saving a Workbook as an Excel Template

Module Three: Sharing Workbooks

  • Inspecting Document
  • Sharing a Workbook
  • Editing a Shared Workbook
  • Tracking Changes
  • Merging Copies of a Shared Workbook

Module Four: Performing Advanced Formula and Function Tasks

  • Using the Watch Window
  • About the Excel Calculation Process
  • Setting Calculation Options
  • Enabling or Disabling Automatic Workbook Calculations
  • Using the IFERROR Function to Evaluate Formulas

Module Five: Working with Array Formulas

  • About Array Formulas
  • Creating One-Dimensional and Two-Dimensional Constants
  • Creating a Simple Array
  • Creating an Advanced Array

Module Six: Working with Functions

  • Working with Math and Trigonometry Functions
  • Using a SUMIF Function
  • Working with Date and Time Functions
  • Working with Financial Functions
  • Working with Text Functions
  • Working with Cube Functions
  • Working with Statistical Functions

Module Seven: Working with Macros

  • Assigning a Macro to a Command Button
  • Running a Macro by Clicking an Area of a Graphic Object
  • Configuring a Macro to Run Automatically Upon Opening the Workbook
  • Changing a Macro

Module Eight: Working with Forms

  • About Excel Forms, Form Controls, and Active X Controls
  • Using a Data Form
  • Using a List Box Control
  • Using a Combo Box Control
  • Using a Spin Button Control
  • Using a Scroll Bar Control

Module Nine: Applying Advanced Chart Features

  • About Trend Lines
  • Add a Trend Line
  • Using Secondary Axes
  • Using Chart Templates

Module Ten: Working with PivotTables and PivotCharts

  • Working with PivotTable Tools
  • Working with PivotChart Tools
  • About Slicers
  • Creating a Slicer in an Existing PivotTable
  • Creating a Standalone Slicer
  • Formatting a Slicer
  • Sharing Slicers with Another PivotTable
  • Disconnect or Delete a Slicer

Module Eleven: Using the Automated Analysis Tools Add-In

  • Loading the Analysis ToolPak
  • About the Analysis ToolPak Options (I)
  • About the Analysis ToolPak Options (II)
  • About the Analysis ToolPak Options (II)

Module Twelve: Wrapping Up

Course 4 - Word 2010 Essentials

Module One: Getting Started  

  • Course Objectives 

Module Two: Opening and Closing Word  

  • Opening Word  
  • Understanding the Interface  
  • Using Backstage View   
  • Creating a Blank Document 
  • Closing Word  

Module Three: Working with Documents 

  • Saving Files 
  • Opening Files 
  • Closing Files 
  • Creating a Document from a      Template  
  • Using the Recent List 

Module Four: Your First Document 

  • Typing Text 
  • Selecting Text with the Mouse or      Keyboard  
  • Dragging and Dropping Text 
  • Starting a New Page  

Module Five: Basic Editing Tasks

  • Using Cut, Copy, and Paste  
  • Using the Office Clipboard  
  • Using Undo and Redo  
  • Finding and Replacing Text 
  • Setting Paste Options 
  • Using the Selection Pane  

Module Six: Basic Formatting Tasks 

  • Understanding Levels of      Formatting 
  • Changing Font Face and Size  
  • Changing the Font Color 
  • Adding Font Enhancements 
  • Adding a Visual Effect 
  • Clearing Formatting 

Module Seven: Advanced Formatting Tasks 

  • Highlighting Text 
  • Changing Case  
  • Using the Format Painter 
  • Using the Font Dialog 
  • Setting Open Text Options 

Module Eight: Formatting Paragraphs 

  • Changing Spacing 
  • Setting the Alignment 
  • Adding Bullets and Numbering 
  • Adding Borders and Shading 

Module Nine: Working with Styles 

  • About Styles 
  • Applying a Style  
  • Changing the Style Set 
  • Changing the Theme  
  • Changing Theme Elements 

Module Ten: Formatting the Page  

  • Adding Headers and Footers 
  • Formatting Text as Columns 
  • Changing Page Orientation  
  • Changing the Page Color 
  • Adding a Page Border 
  • Using the Page Setup Dialog 

Module Eleven: Adding the Finishing Touches 

  • Checking Your Spelling 
  • Previewing Your Document 
  • Printing Your Document
  • E-Mailing Your Document 

Module Twelve: Wrapping Up 

Course 5 - Word 2010 Advanced

Module One: Getting Started 

  • Course Objectives

Module Two: Working with the Word Window  

  • Using Zoom  
  • An Overview of Word’s Views
  • Arranging Windows
  • Splitting a Document
  • Using the Navigation Pane 

Module Three: Adding Pictures 

  • Inserting Clip Art
  • Inserting a Picture from a File 
  • Inserting a Screenshot
  • Moving or Deleting a Picture 

Module Four: Formatting Pictures 

  • Using the Picture Tools Tab 
  • Removing a Picture’s Background 
  • Adding Artistic Effects
  • Changing Picture Layout

Module Five: Adding SmartArt

  • Inserting SmartArt
  • Adding Text to SmartArt
  • Using the SmartArt Tools Tabs
  • Moving and Deleting SmartArt

Module Six: Adding Tables 

  • Inserting a Table 
  • Adding Text to a Table 
  • About the Table Tools Tab 
  • Altering Rows and Columns
  • Applying a Style 
  • About Quick Tables

Module Seven: Inserting Special Objects 

  • Adding a Cover Page 
  • Adding WordArt
  • Drawing Shapes
  • Adding a Text Box 

Module Eight: Adding In Document References 

  • Adding a Table of Contents
  • Adding Footnotes, Endnotes, and Citations
  • Managing Sources
  • Inserting a Bibliography 
  • Creating an Index 

Module Nine: Advanced Research Tasks 

  • Viewing Synonyms
  • Using the Research Task Pane 
  • Using Translation ScreenTips
  • Setting the Language 

Module Ten: Reviewing a Document

  • Adding a Comment
  • Reviewing Comments
  • Tracking Changes
  • Reviewing Changes
  • Comparing Documents

Module Eleven: Customizing Word 

  • Minimizing the Ribbon 
  • Customizing the Quick Access Toolbar
  • Accessing Word’s Options
  • Changing Word’s Color Scheme

Module Twelve: Wrapping Up 

Course 6 - Word 2010 Expert

Module One: Getting Started

  • Course Objectives

Module Two: Working with Document Information and Word Customization

  • Understanding Document Information
  • Password Protecting a Document
  • Checking for Issues
  • Managing Versions
  • Customizing Word Options

Module Three: Working with Reusable Content

  • Saving Selection as Autotext
  • Inserting a Quick Part
  • Creating Customized Building Blocks
  • Editing a Building Block

Module Four: Working with Templates

  • About Templates
  • Modifying an Existing Template
  • Creating a New Template
  • Applying a Template to an Existing Document
  • Managing Templates

Module Five: Working with Sections and Linked Content

  • Using Sections
  • Customizing Page Numbers in Sections
  • Using Multiple Page Formats in a Document
  • Using Different Headers and Footers in a Document
  • Linking and Breaking Links for Text Boxes

Module Six: Managing Versions and Tracking Documents

  • Merging Different Versions of a Document
  • Tracking Comments in a Combined Document
  • Reviewing Comments in a Combined Document

Module Seven: Using Cross References

  • Types of Cross References

Inserting a Bookmark

  • Inserting a Cross Reference
  • Updating a Cross Reference
  • Formatting Cross References Using Fields

Module Eight: Working with Mail Merges

  • Creating a Mail Merge
  • Sending Personalized Email Messages to Multiple Recipients
  • About Other Data Sources for Mail Merge
  • Creating Labels
  • About Envelope and Label Forms

Module Nine: Working with Master Documents

  • Creating a Master Document
  • Creating Subdocuments
  • Inserting a Subdocument
  • Expanding and Collapsing Subdocuments
  • Unlinking a Subdocument
  • Merging and Splitting Subdocuments
  • Locking a Master Document

Module Ten: Working with Macros

  • Recording a Macro
  • Running a Macro
  • Applying Macro Security
  • Assigning a Macro to a Command Button or Shortcut Key

Module Eleven: Working with Forms

  • Creating a Form
  • Using Form Controls
  • Locking and Unlocking a Form
  • Adding and Removing Fields
  • Linking a Form to a Database

Module Twelve: Wrapping Up

Course 7 - PowerPoint 2010 Essentials

Module One: Getting Started

  • Course objectives

Module Two: Opening and Closing PowerPoint

  • Lesson One: Opening PowerPoint
  • Lesson Two: Understanding the Interface
  • Lesson Three: Using Backstage View
  • Lesson Four: Creating a Blank Presentation
  • Lesson Five: Closing PowerPoint

Module Three: Working with Presentations

  • Lesson One: Saving Files
  • Lesson Two: Opening Files
  • Lesson Three: Closing Files
  • Lesson Four: Creating a Presentation from a Template
  • Lesson Five: Using the Recent List

Module Four: Your First Presentation

  • Lesson One: Adding Text to a Slide
  • Lesson Two: Adding Slides
  • Lesson Three: Using a Content Placeholder
  • Lesson Four: Using the Slides Tab

Module Five: Working with Text

  • Lesson One: Using Cut, Copy, and Paste
  • Lesson Two: Using the Office Clipboard
  • Lesson Three: Using Undo and Redo
  • Lesson Four: Finding and Replacing Text

Module Six: Formatting Text

  • Lesson One: Changing Font Face and Size
  • Lesson Two: Changing the Font Color
  • Lesson Three: Changing Character Spacing
  • Lesson Four: Adding Font Enhancements
  • Lesson Five: Clearing Formatting
  • Lesson Six: Using the Font Dialog

Module Seven: Formatting Paragraphs

  • Lesson One: Adding Bullets and Numbering
  • Lesson Two: Changing Alignment
  • Lesson Three: Adjusting the Indent
  • Lesson Four: Using Indents and Tabs
  • Lesson Five: Changing Line Spacing

Module Eight: Advanced Formatting Tasks

  • Lesson One: Using the Format Painter
  • Lesson Two: Changing Slide Layout
  • Lesson Three: Changing Slide Design
  • Lesson Four: Changing the Theme
  • Lesson Five: Changing the Background Design

Module Nine: Customizing Slide Elements 

  • Lesson One: Adding a Header or Footer
  • Lesson Two: Creating a Standard Animation
  • Lesson Three: Creating a Custom Animation
  • Lesson Four: Using the Animation Painter
  • Lesson Six: Adding a Slide Transition
  • Lesson Seven: Setting Slide Advance Options

Module Ten: Setting Up Your Slide Show

  • Lesson One: Working with Sections
  • Lesson Two: Using the Set Up Show Diaglog
  • Lesson Three: Recording a Narration
  • Lesson Four: Timing Your Show
  • Lesson Five: Hiding Slides

Module Eleven: Showtime!

  • Lesson One: Our Top Five PowerPoint Tips
  • Lesson Two: Starting a Show
  • Lesson Three: Navigating Through the Show
  • Lesson Four: Changing Your Pointer
  • Lesson Six: Switching to a Blank Screen

Module Twelve: Wrapping Up

Course 8 - PowerPoint 2010 Advanced

Module One: Getting Started

  • Course Objectives

Module Two: Adding Pictures

  • Lesson One: Inserting a Picture from a File
  • Lesson Two: Adding Screenshots
  • Lesson Three: Inserting Clip Art
  • Lesson Four: Using the Picture Tools Tab
  • Lesson Five: Resizing, Moving, and Deleting a Picture
  • Lesson Six: Removing a Picture's Background

Module Three: Working with Text Boxes

  • Lesson One: Inserting a Text Box
  • Lesson Two: Adding Text
  • Lesson Three: Using the Drawing Tools Tab
  • Lesson Four: Resizing, Moving, and Deleting a Text Box
  • Lesson Five: Formatting a Text Box

Module Four: Adding SmartArt

  • Lesson One: Inserting SmartArt
  • Lesson Two: Using the SmartArt Tools Tab
  • Lesson Three: Adding Text to SmartArt
  • Lesson Four: Resizing, Moving, and Deleting SmartArt

Module Five: Adding Tables

  • Lesson One: Inserting a Table
  • Lesson Two: Adding Text to a Table
  • Lesson Three: Using the Table Tools Tab
  • Lesson Four: Modifying Rows and Columns
  • Lesson Five: Formatting a Table

Module Six: Inserting Advanced Objects

  • Lesson One: Adding a Movie
  • Lesson Two: Adding a Sound Clip
  • Lesson Three: Creating Word Art
  • Lesson Four: Drawing Shapes
  • Lesson Five: About the Drawing Tools Tab

Module Seven:  Advanced Drawing Tasks

  • Lesson One: Using the Grid and Guides
  • Lesson Two: Rotating and Flipping Objects
  • Lesson Three: Aligning and Distributing Objects
  • Lesson Four: Ordering Objects
  • Lesson Five: Grouping Objects

Module Eight: PowerPoint's Research Tools

  • Lesson One: Checking Spelling
  • Lesson Two: Using the Research Task Pane
  • Lesson Three: Using Translation Screen Tips
  • Lesson Four: Setting the Language

Module Nine:  Creating Notes and Handouts

  • Lesson One: Adding Notes to Slides
  • Lesson Two: Creating a Notes Master
  • Lesson Three: Creating a Handout Master
  • Lesson Four: Printing Notes and Handouts

Module Ten: Using Slide Masters

  • Lesson One: Switching to Slide Master View
  • Lesson Two: Using the Slide Master Tab
  • Lesson Three: Creating a Slide Master
  • Lesson Four: Applying a Slide Master
  • Lesson Five: Editing a Slide Master

Module Eleven: Advanced Presentation Skills

  • Lesson One: Inserting Slides from Other Presentations
  • Lesson Two: Creating a Custom Show
  • Lesson Three: Recording Your Show as a Video
  • Lesson Four: Packaging Your Presentation for CD
  • Lesson Five: About the PowerpPoint Viewer

Module Twelve: Wrapping Up

Course 9 - PowerPoint 2010 Expert

Module One: Getting Started

  • Course objectives

Module Two: Working with the PowerPoint Environment

  • Lesson One: About PowerPoint Views
  • Lesson Two: Adjusting the View
  • Lesson Three: Configuring the PowerPoint Options
  • Lesson Four: Adding a Command to the Ribbon
  • Lesson Five: Adding a Command to the Quick Access Toolbar
  • Lesson Six: Working with Multiple Presentation Windows

Module Three: Working with Presentations

  • Lesson One: Using Custom Slide Sizes
  • Lesson Two: Changing the Orientation
  • Lesson Three: Inserting an Outline
  • Lesson Four: Reusing Slides from the Slide Library
  • Lesson Five: Reorganizing Slides

Module Four:  Formatting Presentations

  • Lesson One: Working with Sections
  • Lesson Two: Switching to a Different Slide Layout
  • Lesson Three: Using Footers
  • Lesson Four: Working with Slide Fills
  • Lesson Five: Modifying the Theme

Module Five: Formatting Text Boxes

  • Lesson One: Working with Text Box Fills
  • Lesson Two: Working with Shapes and Effects
  • Lesson Three: Setting Text Box Alignment, Internal Margins, and Wrapping
  • Lesson Four: Using Autofit
  • Lesson Five: Creating a Default Text box

Module Six: Creating a Photo Album

  • Lesson One: Inserting a Photo Album
  • Lesson Two: Editing Photo Albums
  • Lesson Three: Cropping a Picture
  • Lesson Four: Changing and Resetting a Picture
  • Lesson Five: Compressing Pictures

Module Seven: Working with Graphical Elements

  • Lesson One: Using the Selection Pane
  • Lesson Two: Positioning Shapes
  • Lesson Three: Applying a Shape Style
  • Lesson Four: Using Shape Outline
  • Lesson Five: Editing Shape Points
  • Lesson Six: Adding Hyperlinks

Module Eight: Working with Audio and Video Content

  • Lesson One: Changing the Audio Icon Picture
  • Lesson Two: Using the Audio Tools Format Tab
  • Lesson Three: Adjusting Audio Playback Options
  • Lesson Four: Using the Video Tools Format Tab
  • Lesson Five: Adjusting Video Playback Options

Module Nine: Working with Transitions and Animations

  • Lesson One: Working with Effects
  • Lesson Two: Working with Transitions
  • Lesson Three: Working with Paths
  • Lesson Four: Manipulating Animations

Module Ten: Collaborating on Presentations

  • Lesson One: Working with Comments
  • Lesson Two: Showing or Hiding Markup
  • Lesson Three: Navigating Comments
  • Lesson Four: Comparing and Combining Presentations

Module Eleven: Delivering Presentations

  • Lesson One: Saving a Presentation as a Picture Presentation,, XPS, or OpenDocument
  • Lesson Two: Saving a Slide or Object as a Picture File
  • Lesson Three: Protecting a Presentation
  • Lesson Four: Setting up Presenter View
  • Lesson Five: Showing Media Controls
  • Lesson Six: Using Annotations
  • Lesson Seven: Rehearsing Timings

Module Twelve: Wrapping Up

Course 10 - Outlook 2010 Essentials

Module One: Getting Started

  • Course Objectives

Module Two: Opening and Closing Outlook

  • Lesson One: Opening Outlook
  • Lesson Two: Understanding the Interface
  • Lesson Three: Using Backstage View
  • Lesson Four: Setting up an E-mail Account
  • Lesson Five: Viewing Your Inbox
  • Lesson Six: Closing Outlook

Module Three:  Working with E-mail

  • Lesson One: Sending and Receiving Mail
  • Lesson Two: Viewing an E-mail
  • Lesson Three: Replying To or Forwarding an E-mail
  • Lesson Four: Deleting an E-mail
  • Lesson Five: Ignoring E-mail
  • Lesson Six: Using Quick Steps

Module Four:  Creating a New E-mail

  • Lesson One: Creating an E-mail
  • Lesson Two: Addressing an E-mail
  • Lesson Three: Creating the Body
  • Lesson Four: Attaching a File
  • Lesson Five: Sending the Message

Module Five: Managing E-mail

  • Lesson One: Marking an Item as Read or Unread
  • Lesson Two: Printing a Message
  • Lesson Three: Creating Folders
  • Lesson Four: Moving Messages to Folders
  • Lesson Five: Renaming, Moving, and Deleting Folders

Module Six: Managing Junk Mail

  • Lesson One: About the Junk Mail Filter
  • Lesson Two: Enabling Junk Mail Filtering
  • Lesson Three: Enabling the Phishing Filter
  • Lesson Four: Modifying Safe and Blocked Senders Lists
  • Lesson Five: Marking a Message as Junk or Not Junk

Module Seven: Outlook's Organization Tools

  • Lesson One: Creating a Basic Rule
  • Lesson Two: Creating an Advanced Rule
  • Lesson Three: Using Categories
  • Lesson Four: Flagging an Item for Follow-Up
  • Lesson Five: Viewing Favorite Folders

Module Eight: Searching for Items

  • Lesson One: Understanding Search Folders
  • Lesson Two: Setting Up and Using Search Folders
  • Lesson Three: Using Instant Search
  • Lesson Four: Using Advanced Search
  • Lesson Five: Using Contact Search

Module Nine: An Introduction to the Calendar

  • Lesson One: Getting Started
  • Lesson Two: Creating an Appointment
  • Lesson Three: Changing Your Calendar View
  • Lesson Four: Editing an Appointment
  • Lesson Five: Managing Reminders

Module Ten: An Introduction to Tasks

  • Lesson One: Getting Started
  • Lesson Two: Creating a New Task
  • Lesson Three: Editing a Task
  • Lesson Four: Updating Task Status
  • Lesson Five: Basic Task Views

Module Eleven: An Introduction to Contacts

  • Lesson One: Getting Started
  • Lesson Two: Creating a New Contact
  • Lesson Three: Editing a Contact
  • Lesson Four: Organizing Contacts
  • Lesson Five: Basic Contact Views

Module Twelve: Wrapping Up

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

We provide a 7 Day Money Back Refund on all Courses

Now Only US$599 Save US$2091 (78%)
OFF RRP US$2690
Delivery Method Online
Get Info Pack

Special Offer

 

Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining!  (Value $600)

 

The Personal Success Training Program Helps You Stay Focused To Achieve Your Goals!
Benefits:
  • How to layout a Success Plan.
  • Get where you want to be in life.
  • How to unclutter your mind to succeed.
  • Achieve your dreams using your imagination.
  • How to have faith in yourself.
Features:
  • 12 month online access,  24/7 anywhere.
  • Complement your individual course purchase.
  • Internationally recognized by the IAOTS.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Share this course

Course Summary

Course ID No.: 020E10A10CB
Delivery Mode: Online
Course Access: Unlimited lifetime access to course material
Time required: Study at your own pace
Course Duration: 60-80 Hours for total bundle
Assessments: Yes
Qualification: Certificate

Learn More With Course Bundles

Popular Courses and Bundles

Get a FREE Career Planner