Or follow us:
Join now to receive our Course Deals  

Buy Any Course or Bundle This Month & Get The Personal Success Training Program FREE

Ultimate OneNote 2010 Advanced Bundle, 10 Courses

Learn How To Use The Advanced Features Of OneNote 2010


Get OneNote 2010 Advanced, OneNote 2010 Essentials, Time Management, Goal Setting & Getting Things, Word 2010 Essentials, Word 2010 Advanced, Word 2010 Expert, Excel 2010 Essentials, Excel 2010 Advanced and Excel 2010 Expert in this Bundle

1. OneNote 2010 Advanced: Learn Advanced Skills for OneNote 2010

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

Have you ever wished that you could track appointments, take meeting notes, record research, and keep to-do items all in one place? Well, you can do all that and more with OneNote 2010. In this course, we will show you how, plus we’ll explore OneNote’s new ribbon-based interface.

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

  • Understand the file and organization changes when upgrading from OneNote 2007
  • Know the new features in OneNote 2010
  • Stay organized by using the Navigation bar and drag and drop capabilities
  • Sort and view pages
  • Work with Page Versions
  • Create hyperlinks to web locations, other files, or other OneNote pages
  • Use the Translator tools
  • Use tables
  • Understand the calculator capabilities
  • Work with Equations
  • Format text using the Mini Tool bar
  • Select a page template for a new page
  • Select a default page template
  • Create a new template
  • Understand the use of the drawing and pen tools
  • Understand how OneNote works on a Tablet PC
  • Create a custom pen to use when drawing or handwriting
  • Specify a pen as drawing or handwriting
  • Convert ink to text
  • Attach files to notes pages
  • Insert Files as Printouts
  • Use scanned pages
  • Print to OneNote from Other Applications
  • Send to Word and other formats
  • Use the Side Note Window
  • Send Web Pages to OneNote
  • Use the Research task pane
  • Make text in pictures searchable
  • Start and finish a Linked Notes session
  • Work with Linked Notes
  • Disable and Re-enable linked notes
  • Understand Universal Access to Notebooks
  • Share notebooks with other computers and other authors
  • Understand notebook synchronization
  • Find notes by author
  • Assign a password to a section.
  • Understand audio and video options.
  • Use the search tools.

2. OneNote 2010 Essentials: Learn the Basic Features of Onenote 2010!

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

OneNote is a program that helps you collect notes about anything. You can store all of your notes in a variety of formats, in one place. Then you can organize and share your notes. OneNote 2010 provides all of these features and can make your everyday business a lot easier.

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

  • Open and close OneNote
  • Dock OneNote to Desktop Mode
  • Understand the OneNote 2010 interface and the OneNote icon
  • Use the backstage view to create a new notebook
  • Use the backstage view to save, print, or share notebooks
  • Understand notebooks
  • Open, close, save, and search a notebook
  • Add pages and sub-pages and move, rename, and delete them
  • Insert a variety of notes, including typewritten, handwritten, linked files, audio, and video
  • Use cut, copy, and paste
  • Format text and use styles
  • Add extra writing space
  • Undo and redo tasks
  • Check spelling
  • Insert lists, tables, pictures, and screen clippings
  • Search your notes
  • Use OneNote to perform calculations
  • Link to Outlook Meetings and Tasks
  • Draw, format, and rotate shapes
  • Use Tags
  • Understanding the Unfiled Section
  • Understanding the History
  • Use links to make finding information easy
  • Add, move, rename, or delete sections or section groups
  • Use time stamps
  • Understand different views
  • Use Password protection
  • Backup, e-mail, or print your notes

3. Time Management: How To Manage Your Time And Get Things Done

Personal time management skills are essential skills for effective people. People who use these techniques on a regular basis are the highest achievers in all walks of life, from business to sport to public service. Making these skills part your daily routine will enable you to function exceptionally well, even under intense pressure.

As you master these skills you'll find that you take control of your workload, saying goodbye to the often intense stress of work overload. At the heart of time management is an important shift in focus: Concentrate on results, not on being busy. Many people spend their days in a frenzy of activity, but achieve very little, because they're not concentrating their effort on the things that matter the most.

Time management training begins with setting goals. These goals are recorded, prioritized and may be broken down into a project, an action plan, or a simple task list. This entire process is supported by a skill set that should include personal motivation, delegation skills, organization tools, and crisis management. We'll cover all this and more during this Time Management Online Short Course.

Course Topics:

  • The SMART Way
  • Urgent Important Matrix
  • The 80/20 Rule
  • Eat That Frog
  • The Glass Jar

By the end of this Time Management Online Short Course you will be able to: 

  • Plan and prioritize daily activities efficiently and in a productive manner.
  • Triumph over procrastination.
  • Effectively deal with crises.
  • Organize your workspace and workflow.
  • Efficiently delegate.
  • Ritualize your workload.
  • Plan effective meetings.

4. Goal Setting & Getting Things: Become a Productivity Pro & Blaze Through Your To-Do Lists

Goal Setting is one of the most basic and essential skills someone can develop. We touch on goal characteristics, time management, and what to do when setbacks occur. This course will provide the knowledge and skills you need to complete more tasks, and get things done.

Our Goal Setting and Getting Things Done course will cover strategies to help you deal with distractions and overcome procrastination. These skills will translate into increased satisfaction in your professional and personal life. You will learn the Goal Setting characteristics of successful people and in turn will become happier and more productive.

By the end of this Goal Setting online short course, you will be able to:

  • Overcome procrastination
  • Manage time effectively
  • Accomplish important tasks
  • Self-motivate
  • Create SMART goals

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

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

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

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

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

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

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 (IAOTS Accredited)

Course Delivery

Upon enrolment an automated email will be sent, advising you of our enrolment process (please check your junk email inbox if not received as this is an automated email), in order for you to access your online material, which is Available 24/7 on any computer or smart mobile device.

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.

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

Course 1 - Certificate In OneNote 2010 Advanced Online Course

Module One: Getting Started

  • Course Objectives

Module Two: Upgrading from OneNote 2007 or 2003?

  • Lesson One: What You Need to Know About the New File Format
  • Lesson Two: New Features in OneNote 2010

Module Three: Staying Organized

  • Lesson One: The Navigation Bar
  • Lesson Two: Drag and Drop
  • Lesson Three: View Recent Edits
  • Lesson Four: Working with Page Versions

Module Four: Note Taking Tools

  • Lesson One: Hyperlinks
  • Lesson Two: Translating Words or Phrases
  • Lesson Three: Table Editing Tools
  • Lesson Four: Understand the Calculator Capabilities
  • Lesson Five: Working with Equations

Module Five: Text and Page Formatting

  • Lesson One: Format Using the Mini Toolbar
  • Lesson Two: Select a Page Template
  • Lesson Three: Select a Default Template
  • Lesson Four: Create a New Template

Module Six: Drawing and Handwriting Notes

  • Lesson One: The Drawing and Pen Tool Bars
  • Lesson Two: OneNote Basics on a Tablet PC
  • Lesson Three: Specifying Pen Mode
  • Lesson Four: Convert Ink to Text

Module Seven: Office Integration

  • Lesson One: Attach Files to Your Notes
  • Lesson Two: Insert Files as Printouts
  • Lesson Three: Print to OneNote from Other Applications
  • Lesson Four: Send to Word and Other Formats

Module Eight: Researching a Topic

  • Lesson One: Side Note Window
  • Lesson Two: Send Web Pages to OneNote
  • Lesson Three: The Research Task Pane
  • Lesson Four: Make Text in Pictures Searchable

Module Nine: Linked Notes

  • Lesson One: Starting and Finishing a Linked Notes Session
  • Lesson Two: View or Remove Linked Notes
  • Lesson Three: Disable and Re-enable Linked Notes

Module Ten: Collaborating

  • Lesson One: About Universal Access to Notebooks
  • Lesson Two: Sharing Notebooks with Other Computers and Other Authors
  • Lesson Three: Understanding Notebook Synchronization Status
  • Lesson Four: Find By Author

Module Eleven: Other Tools

  • Lesson One: Password Protection
  • Lesson Two: Audio and Video Options
  • Lesson Three: Search Tools

Module Twelve: Wrapping Up

Course 2 - Certificate In OneNote 2010 Essentials Online Course

Module One: Getting Started

  • Course Objectives

Module Two:  Opening and Closing OneNote

  • Lesson One: Opening OneNote
  • Lesson Two: Understanding the Interface
  • Lesson Three: Using the Backstage View
  • Lesson Four: About the OneNote Icon
  • Lesson Five: Docking OneNote
  • Lesson Six: Closing OneNote

Module Three: Working with Notebooks

  • Lesson One: Understanding Your Notebook
  • Lesson Two: Creating a New Notebook
  • Lesson Three: Saving Notebooks
  • Lesson Four: Searching Notebooks
  • Lesson Five: Closing Notebooks
  • Lesson Six: Opening Notebooks

Module Four: Working with Pages and Sections

  • Lesson One: Adding Pages
  • Lesson Two: Adding Sub-Pages
  • Lesson Three: Moving, Renaming, and Deleting Pages
  • Lesson Four: Using the Templates Pane
  • Lesson Five: Adding Sections
  • Lesson Six: Adding Section Groups
  • Lesson Seven: Working with Sections and Section Groups

Module Five: Your First Notebook

  • Lesson One: Typing Text
  • Lesson Two: Handwriting Text
  • Lesson Three: Using Copy and Paste
  • Lesson Four: Adding Extra Writing Space
  • Lesson Five: Using the Formatting Toolbar
  • Lesson Six: Applying Styles

Module Six: Adding Objects to Your Notebook

  • Lesson One: Creating Lists
  • Lesson Two: Creating Tables
  • Lesson Three: Inserting Pictures
  • Lesson Four: Inserting Screen Clippings
  • Lesson Five: Researching in OneNote

Module Seven: Basic Editing Tasks

  • Lesson One: Using the Page Setup Group
  • Lesson Two: Resizing Objects
  • Lesson Three: Moving Objects
  • Lesson Four: Using Undo and Redo
  • Lesson Five: Checking Your Spelling

Module Eight: Advanced OneNote Objects

  • Lesson One: Using the Calculator
  • Lesson Two: Using OneNote with Outlook Tasks and Meetings
  • Lesson Three: Inserting Audio
  • Lesson Four: Inserting Video
  • Lesson Five: Attaching Files

Module Nine: Drawing in OneNote

  • Lesson One: Drawing Shapes
  • Lesson Two: Selecting Shapes
  • Lesson Three: Formatting Shapes
  • Lesson Four: Rotating Shapes
  • Lesson Five: Using the Eraser

Module Ten: Managing Notes

  • Lesson One: Tagging Notes
  • Lesson Two: Using the Unfiled Section
  • Lesson Three: Using History
  • Lesson Four: Linking Link a Wiki

Module Eleven: Adding the Finishing Touches

  • Lesson One: Time Stamping Items
  • Lesson Two: Using OneNote Views
  • Lesson Three: Password Protecting Your Notebook
  • Lesson Four: Using OneNote Backups
  • Lesson Five: E-Mailing Your Notes
  • Lesson Six: Printing Your Notes

Module Twelve: Wrapping Up

Course 3 - Certificate In Time Management Online Course

Section One: Getting Started

Section Two: SMARTER Goals

  • The Three P’s
  • Create SMARTER Goals
  • Prioritizing Your Goals
  • Visualize your Goals-Visualization

Section Three: Prioritizing Your Time

  • The 80/20 Rule
  • Prioritizing with the Urgent-Important Matrix
  • Being Assertive...Saying “NO” to Requests you can’t meet.

Section Four: Planning

  • Using To Do List
  • The Glass Jar: Rocks, Pebbles, Sand, and Water
  • Ready, Fire, Aim!

Section Five: Procrastination

  • Why We Procrastinate
  • Nine Ways to Overcome Procrastination
  • Eat That Frog!

Section Six: Managing Crisis

  • When Crisis Calls...do you have a Contingency Plan?
  • Creating a Plan
  • Executing the Plan
  • Lessons Learned

Section Seven: The Organized Workspace

  • De-Clutter
  • Managing Workflow
  • Dealing with E-mail...email etiquette
  • Using Calendars

Section Eight: Delegating

  • When to Delegate?
  • Who Should I Delegate to?
  • Monitoring the Results

Section Nine: The Power of Ritual...Habits

  • What is a Ritual/Routine?
  • Example Rituals
  • Using Rituals to Maximise Time

Section Ten: Meetings

  • Deciding if a Meeting is Necessary... Is the meeting necessary?
  • Using the PAT Approach
  • Effective Agenda Writing
  • Staying on Track
  • Was the Meeting Worthwhile?

Section Eleven: Meeting Alternatives

  • Instant Messaging and Chat Rooms
  • Teleconferencing
  • E-mail Lists and Online Groups
  • Collaboration Applications

Section Twelve: Wrapping Up

Course 4 - Certificate In Goal Setting & Getting Things Done Online Course

Module One - Getting Started

Module Two - Overcoming Procrastination (Part 1)

  • Eat that frog
  • Just do it
  • The 15 minute rule
  • Chop it up

Module Three - Overcoming Procrastination (Part 2)

  • Remove distractions
  • Start small and build
  • Reward yourself
  • Set realistic deadlines

Module Four - Four P's of Goal Setting

  • They need to be positive
  • They need to be personal
  • They need to be possible
  • They need to be prioritised

Module Five - Improving Motivation

  • Remember peak moments
  • Write down your goals
  • Use gamification
  • Track your progress

Module Six - Wise Time Management

  • Urgent/important matrix
  • The 80/20 rule
  • Utilise a calendar
  • Create a ritual

Module Seven - Tips for Completing Tasks

  • One minute rule
  • Five minute rule
  • Break up large tasks
  • Utilise technology

Module Eight - Increase your Productivity

  • Repeat what works
  • Get faster
  • Remove "should" from your dictionary
  • Build on your successes

Module Nine - "To Do"List Characteristics

  • Focus on the important
  • Chunk, Block, Tackle
  • Make it a habit
  • Plan ahead

Module Ten - Smart Goals

  • Specific
  • Measurable
  • Attainable
  • Realistic
  • Timely

Module Eleven - Mistakes will Happen

  • Accept it
  • Bouncing back
  • Adapt and learn from them
  • If needed, ask for help

Module Twelve - Wrapping Up

Course 5 - Certificate In Word 2010 Essentials Online Course

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 6 - Certificate In Word 2010 Advanced Online Course

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 7 - Certificate In Word 2010 Expert Online Course

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 8 - Certificate In Excel 2010 Essentials Online Course

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 9 - Certificate In Excel 2010 Advanced Online Course

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 10 - Certificate In Excel 2010 Expert Online Course

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

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

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

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.: 020ON10CB
Delivery Mode: Online
Course Access: Unlimited lifetime access to course material
Time required: Study at your own pace
Course Duration: 60-80 Hours
Assessments: Yes
Qualification: Certificates (IAOTS Accredited)

Learn More With Course Bundles