Ultimate InfoPath 2010 Expert Online Bundle, 10 Certificate Courses

The Most Comprehensive InfoPath 2010 Expert Bundle

Ultimate InfoPath 2010 Expert Online Bundle, 10 Certificate Courses

NOW ONLY

AU$599

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

Get InfoPath 2010 Expert, InfoPath 2010 Advanced, InfoPath 2010 Essentials, Access 2010 Essentials , Access 2010 Advanced , Access 2010 Expert , Excel 2010 Essentials , Excel 2010 Advanced , Excel 2010 Expert and Business Writing in this Bundle

1. InfoPath 2010 Expert :Become an expert in InfoPath 2010

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

InfoPath is a powerful solution for collecting data from users on a variety of platforms. Microsoft InfoPath 2010 has new great features, such as the Office Fluent UI, and the ability to customize SharePoint list forms in just one click. Are you ready to take your organization to the next level with Microsoft InfoPath 2010?

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

  • Set options, including form submission, publishing, and advanced form options
  • Customize the Ribbon and the Quick Access toolbar
  • View form template properties
  • Understand trusted locations
  • Apply a digital signature or multiple signatures to a form
  • Set confirmation messages
  • Disable digital signatures
  • Sign form templates digitally
  • Use Properties for text box controls, list box controls, combo box controls, option buttons, check boxes, hyperlinks, calculated values, sections date pickers, and pictures
  • Modify a control
  • Set a field’s default value
  • Change a control’s binding
  • Set a field’s value using rules
  • Filter data displayed in a control
  • Understand commands and switches
  • Use a switch once
  • Make a reusable switch
  • Understand the use of formulas and functions in InfoPath
  • Use date and time functions
  • Use field functions
  • Use math functions
  • Use text functions
  • Use URL functions
  • Use the Username function
  • Create a rule to show a message
  • Create a rule to show the value of a field or formula
  • Create a rule to switch views
  • Create a rule to set a field’s value
  • Create a rule to open a new form to fill
  • Create a rule to send data to a WebPart
  • Create a rule to sign a signature line
  • Create a rule to close the form
  • Understand advanced condition scenarios
  • Use data entry patterns
  • Create a rule to query for data
  • Create a rule to submit data

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

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

In this course, you will learn how to create, manage, and fill out interactive forms. Microsoft InfoPath 2010 has new great features, such as the Office Fluent UI, and the ability to customize SharePoint list forms in just one click. Are you ready to take your organization to the next level with Microsoft InfoPath 2010?

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

  • Open and close InfoPath
  • Use InfoPath’s Available Form Templates window and the interface
  • Add rules to customized forms
  • Explain XML at a high level
  • Use InfoPath Filler 2010 to fill out forms
  • Design a form from scratch using Microsoft InfoPath Design 2010
  • Work with InfoPath tables
  • Create field labels
  • Add and modify basic controls, including picture and file attachments
  • Understand what advanced control  types can be used for
  • Format controls
  • Add data validation and conditional formatting rules to controls
  • Use the Logic Inspector and Design Checker
  • View and modify data sources, fields, and groups
  • Manually bind controls to a data source
  • Create, modify, and delete InfoPath views
  • Change the color scheme of a form
  • Check spelling
  • Preview and test a form
  • Protect a form
  • Publish or print a form

3. InfoPath 2010 Advanced : Learn Advanced Skills for InfoPath 2010

You will learn how to use the advanced features of InfoPath 2010.

InfoPath is a powerful solution for collecting data from users on a variety of platforms. Microsoft InfoPath 2010 has new great features, such as the Office Fluent UI, and the ability to customize SharePoint list forms in just one click. Are you ready to take your organization to the next level with Microsoft InfoPath 2010?

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

  • Understand various types of controls
  • Validate form data
  • Import designs from Word or Excel
  • Create cascading drop down lists
  • Work with forms that can be merged
  • Add resource files to your form template
  • Understand InfoPath Form Events
  • Manage data connections
  • Publish in various types of forms

4. Access 2010 Essentials :Learn the Basic Features of Access 2010

Microsoft’s newest version of Access uses the new ribbon interface, and offers significant improvement to its database capability. You will learn how to use the basic features of Access 2010.  Access is the world’s premier database software. You can use Access 2010 to create and edit databases, just download a ready-made database template and start typing. It’s that easy. You can create a database of contacts, expenses, household and/or business inventory. In other words, if you have data, you can create a database of that data using Access.

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

  • Understand common database terms
  • Open and close Access
  • Create a blank database or a database from a template
  • Understand the interface and the Ribbon tools
  • Understand the Backstage View
  • Use the Navigation Pane
  • Work with database objects
  • Sort and filter the view
  • Create a blank table from a template, in Datasheet view, and Design View
  • Use Lookup columns in a table
  • Add information to a table
  • Edit, delete and search records
  • Save a table
  • Create a Navigation Form
  • Create a form with the Wizard and in Layout View
  • Modify a form in Design View
  • Perform common formatting tasks on forms
  • Use Themes
  • Add or move controls on a form
  • Create reports using the Report Wizard
  • Understand the Report Design View
  • Add a Logo to a report
  • Create Queries using the Wizard
  • Execute a Query
  • Understand the Query Design View
  • Understand Access file formats and save a database as another file format
  • Print an Object
  • Back up the database
  • Email the database

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

You will learn how to use the advanced features of Access 2010. This course is designed to teach you a basic understanding of Access 2010 in a practical way. This course incorporates a hands-on approach to learning.

You can use advanced forms and tasks to do even more in Access than you have previously learned. For example, you can use Access to create mailing labels, work with SQL, and publish a Web database, among other things. By the time you finish this course, you will be able to navigate Access 2010 and create reports like a pro.

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

  • Use the Quick Start group, Property Sheet, table macros, report sections, conditional formatting, Expression Builder and logical functions.
  • Add, move, remove and format both regular and calculated controls
  • Set the Primary Key
  • Create a subform, Web form, split form, modal dialog, PivotChart, PivotTable and mailing labels
  • Group and sort data
  • Understand, view and edit relationships
  • Understand and establish referential integrity
  • Sort and filter a query
  • Add calculated fields
  • Understand what SQL is, what SQL statements are, basic SQL syntax and the uses for SQL within Access 2010
  • Link to, import and export an Excel spreadsheet, Access database, SharePoint list, text or XML file and other types of links, imports and exports
  • Use the Database Documenter, analyze table and database performance and repair and compact a database

6. Access 2010 Expert :Acquire Expert Skills in Access 2010

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

You can use advanced forms and tasks to do even more in Access than you have previously learned. For example, you can use Access to create mailing labels, work with queries, and publish a Web database among other things. By the time you finish this course, you will be able to navigate Access 2010 and create reports like a pro.

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

  • Work with Database Properties
  • Encrypt a database with a password
  • Save an object
  • Set general, current database, datasheet, object designers, proofing, and language options
  • Customize the Ribbon and the Quick Access toolbar
  • Hide/unhide and freeze/unfreeze fields in a table
  • Modify field descriptions and properties
  • Append records to an existing table
  • Import data as a linked table
  • Understand linked table errors
  • Create a select query
  • Create a make table query
  • Create an append query
  • Create a cross tab query
  • Show or remove tables on the query designer window
  • Create an update query
  • Create a parameter query
  • Compare two tables using a join
  • Create a blank form
  • Use form controls
  • Create headers and footers on forms or reports
  • Use Form Design, Report Design, and Macro Design tools
  • Use background images
  • Use themes
  • Use conditional formatting
  • Create a navigation form
  • Create a blank report
  • Use the Property Sheet
  • Create a user-interface or a data macro
  • Understand the Action catalog
  • Understand the use of Visual Basic for Applications to extend Access functionality

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

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

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

10. Business Writing :Become an Expert at Writing Effective Emails, Letters, Reports and More

We all know that writing is one of the most important methods of business communication for most people, whether its e-mails, memos, proposals, or major reports. Lots of people struggle with the composition of these. Sometimes it's because they don't have to do it very often so, therefore, it doesn't flow as easily as they would like, sometimes because they are new to a role, or just because it's not their favorite thing.

This Business Writing Online Short Course will provide:

  • A quick refresher on basic writing concepts (such as spelling, grammar, and punctuation) the things that we often miss especially when completing work under pressure; and
  • An overview of some the typical business documents, letters, reports, proposals that you may have to deal with, with tips on structure, style etc.

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

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 InfoPath 2010 Expert 10 Course Bundle includes the following courses, below is a summary of each course: 

Course 1 - Certificate In InfoPath 2010 Expert Online Course

Module One: Getting Started

  • Course Objectives

Module Two: Working with the InfoPath Environment

  • Lesson One: Setting Options
  • Lesson Two: Customizing the Ribbon
  • Lesson Three: Customizing the Quick Access Toolbar
  • Lesson Four: Setting Form Submission Options
  • Lesson Five: Setting Advanced Form Options
  • Lesson Six: Viewing Form Template Properties

Module Three: Working with Digital Signatures

  • Lesson One: About Trusted Locations
  • Lesson Two: Applying a Digital Signature to a Form
  • Lesson Three: Adding Multiple Signatures to a Form
  • Lesson Four: Setting Confirmation Messages
  • Lesson Five: Disabling Digital Signatures
  • Lesson Six: Digitally Signing Form Templates

Module Four: Doing More with Controls

  • Lesson One: Modifying a Control
  • Lesson Two: Setting the Default Value for a Control
  • Lesson Three: Changing the Binding
  • Lesson Four: Filtering Data Displayed in a Control

Module Five: Working with Control Properties, Part 1

  • Lesson One: Working with Text Box Properties
  • Lesson Two: Working with List Box Properties
  • Lesson Three: Working with Combo Box Properties
  • Lesson Four: Working with Option Button Properties
  • Lesson Five: Working with Check Box Properties

Module Six: Working with Control Properties, Part 2

  • Lesson One: Working with Hyperlink Properties
  • Lesson Two: Working with Picture Properties
  • Lesson Three: Working with Date Picker Properties
  • Lesson Four: Working with Calculated Value Properties
  • Lesson Five: Working with Section Properties

Module Seven: Using Commands and Switches

  • Lesson One: About Commands and Switches
  • Lesson Two: Types of Commands and Switches
  • Lesson Three: Using a Switch Once
  • Lesson Four: Making a Reusable Switch

Module Eight: Using Formulas and Functions

  • Lesson One: About Formulas and Functions in InfoPath
  • Lesson Two: Using Date and Time Functions
  • Lesson Three: Using Field Functions
  • Lesson Four: Using Math Functions
  • Lesson Five: Using Text Functions
  • Lesson Six: Using URL Functions
  • Lesson Seven: Using the Username Function

Module Nine: Using Action Rules

  • Lesson One: Creating a Rule to Show a Message
  • Lesson Two: Creating a Rule to Show the Value of a Field or Formula
  • Lesson Three: Creating a Rule to Switch Views
  • Lesson Four: Creating a Rule to Set a Field's Value
  • Lesson Five: Creating a Rule to Open a New Form to Fill

Module Ten: Using More Action Rules

  • Lesson One: Creating a Rule to Sign a Signature Line
  • Lesson Two: Creating a Rule to Close the Form
  • Lesson Three: Creating a Rule to Send Data to a WebPart
  • Lesson Four: About Advanced Condition Scenarios

Module Eleven: Using Queries and Data Submission

  • Lesson One: Using Data Entry Patterns
  • Lesson Two: Creating a Rule to Query for Data
  • Lesson Three: Creating a Rule to Submit Data

Module Twelve: Wrapping Up

Course 2 - Certificate In InfoPath 2010 Essentials Online Course

Module One: Getting Started

Module Two: Opening and Closing InfoPath

  • Lesson One: Opening InfoPath
  • Lesson Two: Using the Available Form Templates Window
  • Lesson Three: Exploring the InfoPath's Interface
  • Lesson Four: An XML Primer
  • Lesson Five: Closing InfoPath

Module Three: Using the InfoPath Filler 2010

  • Lesson One: Launching Microsoft InfoPath Filler 2010
  • Lesson Two: Entering Data
  • Lesson Three: Checking Your Spelling
  • Lesson Four: Printing Form
  • Lesson Five: Saving the Form

Module Four: Designing a Form Framework 

  • Lesson One: Creating a Blank Form
  • Lesson Two: Adding a Table
  • Lesson Three: Adding a Table
  • Lesson Four: Adding and Removing Rows or Columns
  • Lesson Five: Merging and Splitting Cells
  • Lesson Six: Formatting Tables
  • Lesson Seven: Changing Table Properties

Module Five: Adding Labels

  • Lesson One: Adding Labels
  • Lesson Two: Changing the Font Color
  • Lesson Three: Adding Effects
  • Lesson Four: Using the Font Task Pane
  • Lesson Five: Aligning Text

Module Six: Adding Controls

  • Lesson One: Adding a Standard Controls
  • Lesson Two: Adding Repeating and Optional Controls
  • Lesson Three: Adding File Controls
  • Lesson Four: Adding Picture Controls
  • Lesson Five: Advanced Types of Controls

Module Seven: Formatting Controls

  • Lesson One: Changing the Visual Properties of a Control
  • Lesson Two: Using the Control Properties Dialog
  • Lesson Three: Adding Data Validation Rules
  • Lesson Four: Applying Conditional Formatting
  • Lesson Five: Running the Logic (Rule) Inspector

Module Eight: Working with Data Sources

  • Lesson One: Viewing Data Source Information
  • Lesson Two: Managing Fields and Groups
  • Lesson Three: Adding a Data Connection
  • Lesson Four: Manually Binding Controls

Module Nine: Creating a View

  • Lesson One: Creating a Custom View
  • Lesson Two: Creating a Print View
  • Lesson Three: Setting a View as Default
  • Lesson Four: Deleting Views

Module Ten: Finishing the Form

  • Lesson One: Changing the Color Scheme
  • Lesson Two: Checking Your Spelling
  • Lesson Three: Using the Design Checker
  • Lesson Four: Protecting Your Form
  • Lesson Five: Previewing the Form

Module Eleven: Distributing Your Form

  • Lesson One: Understanding Saving vs. Publishing
  • Lesson Two: Using the Publishing Wizard
  • Lesson Three: Printing the Form

Module Twelve: Wrapping Up

Course 3 - Certificate In InfoPath 2010 Advanced Online Course

Module One: Getting Started

  • Course Objectives

Module Two: Types of Controls

  • Lesson One: Insert Controls on a Form Template
  • Lesson Two: Understanding Controls and the Data Source
  • Lesson Three: Input Controls
  • Lesson Four: Object Controls
  • Lesson Five: Container Controls
  • Lesson Six: Custom Controls
  • Lesson Seven: Remove a Control from a Form Template

Module Three: Repeating and Optional Controls

  • Lesson One: Using Repeat Tables
  • Lesson Two: Using Repeating Sections
  • Lesson Three: Creating an Optional Section

Module Four: Control Tool Properties and Table Tools Tab

  • Lesson One: Control Tool Properties Tabs
  • Lesson Two: Using the Control Properties Dialog Box
  • Lesson Three: Table Tools Tab

Module Five: Actions

  • Lesson One: Creating an Action Based on User Input
  • Lesson Two: Using Buttons to Switch Views
  • Lesson Three: Applying Conditional Formatting
  • Lesson Four: Calculating Fields
  • Lesson Five: Validating Your Form Input Data

Module Six: Importing Form Designs

  • Lesson One: Importing Designs from Other Applications
  • Lesson Two: Importing Word Forms
  • Lesson Three: Importing Excel Forms

Module Seven: Advanced Topics

  • Lesson One: Cascading List Box
  • Lesson Two: Merging Forms
  • Lesson Three: Adding Resource Files to Your Form Template

Module Eight: Understanding Code

  • Lesson One: How InfoPath uses XML Technologies
  • Lesson Two: InfoPath Form Events
  • Lesson Three: Working with Data Connections
  • Lesson Four: Using an Add - In
  • Lesson Five: The Developer Tab

Module Nine: Publishing Forms

  • Lesson One: Understanding Form Security
  • Lesson Two: Setting Form Template Security Level
  • Lesson Three: Network Location
  • Lesson Four: Hosting InfoPath Forms

Module Ten: SharePoint Integration

  • Lesson One: Form Libraries
  • Lesson Two: Promoting Field Properties
  • Lesson Three: Email Enabling Document Libraries
  • Lesson Four: SharePoint Workflow

Module Eleven: Publishing Forms for Use with SharePoint

  • Lesson One: Publishing To a Sharepoint Form Library
  • Lesson Two: Publishing To a SharePoint Site as a Content Type
  • Lesson Three: Browser Capable Forms
  • Lesson Four: Installable Form Template

Module Twelve: Wrapping Up

Course 4 - Certificate In Access 2010 Essentials Online Course

Module One: Getting Started

  • Course Objectives

Module Two: Getting Started With Access

  • Lesson One: Common Database Terms
  • Lesson Two: Opening Access
  • Lesson Three: Understanding the Access New File Screen
  • Lesson Four: Creating a Blank Access Database
  • Lesson Five: Creating a Blank Database from a Template

Module Three:  Using the Access Interface

  • Lesson One: Understanding Security Warnings
  • Lesson Two: Interface Overview
  • Lesson Three: Overview of the Ribbon Interface
  • Lesson Four: Working With the Backstage View
  • Lesson Five: Using the Navigation Pane

Module Four:  Working with Database Objects

  • Lesson One: Viewing Database Objects
  • Lesson Two: Exporting an Object
  • Lesson Three: Renaming an Object
  • Lesson Four: Sorting and Filtering Your View
  • Lesson Five: Understanding Application Parts

Module Five: Creating Tables

  • Lesson One: Understanding Data Types
  • Lesson Two: Creating a Blank Table in Datasheet View
  • Lesson Three: Understanding Lookup Columns
  • Lesson Four: Creating a Blank Table Using Design View
  • Lesson Five: Saving Your Table
  • Lesson Six: Key Table Tools

Module Six: Working with Tables

  • Lesson One: Adding Information to a Table
  • Lesson Two: Editing Records
  • Lesson Three: Deleting Records
  • Lesson Four: Searching for Records

Module Seven: Creating Forms

  • Lesson One: Types of Controls
  • Lesson Two: Creating a Form with the Wizard
  • Lesson Three: Creating a Form in Layout View
  • Lesson Four: Modifying Your Form in Design View
  • Lesson Five: Key Features on the Form Tools Tab
  • Lesson Six: Creating a Navigation Form

Module Eight: Working with Forms

  • Lesson One: Common Formatting Tasks
  • Lesson Two: Using Themes
  • Lesson Three: Adding Controls
  • Lesson Four: Moving Controls
  • Lesson Five: Deleting Records

Module Nine: Creating Reports

  • Lesson One: Using The Report Wizard
  • Lesson Two: Using Design View
  • Lesson Three: Adding a Logo
  • Lesson Four: Working with Controls
  • Lesson Five: Key Features on the Report Tools

Module Ten: Creating Queries

  • Lesson One: Types of Queries
  • Lesson Two: Creating a Query with the Wizard
  • Lesson Three: Executing a Query
  • Lesson Four: Viewing the Query
  • Lesson Five: Key Features on the Query Tools Tab

Module Eleven: Managing Your Database

  • Lesson One: Using Alternate File Formats
  • Lesson Two: Printing an Object
  • Lesson Three: Backing Up Your Database 
  • Lesson Four: Emailing Database Objects

Module Twelve: Wrapping Up

Course 5 - Certificate In Access 2010 Advanced Online Course

Module One: Getting Started

  • Course Objectives

Module Two: Advanced Table Tasks

  • Lesson One: Using the Quick Start Group
  • Lesson Two: Using the Property Sheet
  • Lesson Three: Adding, Moving, and Removing Controls
  • Lesson Four: Formatting Controls
  • Lesson Five: Setting the Primary Key
  • Lesson Six: Using Table Macros

Module Three: Advanced Form Tasks

  • Lesson One: Creating a Sub Form
  • Lesson Two: Creating a Web Form
  • Lesson Three: Creating a Split Form

Module Four: Advanced Reporting Tasks 

  • Lesson One: Using Report Sections
  • Lesson Two: Using Conditional Formatiting
  • Lesson Three: Grouping & Sorting Data
  • Lesson Four: Adding Calculated Controls
  • Lesson Five: Creating Labels

Module Five: Understanding Relationships

  • Lesson One: Types of Relationships
  • Lesson Two: Viewing Relationships
  • Lesson Three: Editing Relationships
  • Lesson Four: About Referential Integrity
  • Lesson Five: Establishing Referential Integrity

Module Six: Advanced Query Tasks

  • Lesson One: Sorting and Filtering a Query
  • Lesson Two: Adding Calculated Fields
  • Lesson Three: Using the Expression Builder

Module Seven: Working with SQL

  • Lesson One: What is SQL?
  • Lesson Two: Basic SQL Syntax

Module Eight: Linking Data

  • Lesson One: Linking to an Excel Spreadsheet
  • Lesson Two: Linking to an Access Database
  • Lesson Three: Linking to a SharePoint List

Module Nine: Importing Data

  • Lesson One: Importing From an Excel Spreadsheet
  • Lesson Two: Importing From an Access Database
  • Lesson Three: Importing from a SharePoint List

Module Ten: Exporting Data

  • Lesson One: Saving an Object as a PDF
  • Lesson Two: Exporting To an Excel Spreadsheet
  • Lesson Three: Exporting to a SharePoint List

Module Eleven: Advanced Database Tools

  • Lesson One: Using the Database Documenter
  • Lesson Two: Analyzing Table Performance
  • Lesson Three: Analyzing Database Performance
  • Repairing a Database
  • Compacting a Database

Module Twelve: Wrapping Up

Course 6 - Certificate In Access 2010 Expert Online Course

Module One: Getting Started

  • Course Objectives

Module Two: Working with the Access Environment

  • Lesson One: Working with Database Properties
  • Lesson Two: Encrypting a Database with a Password
  • Lesson Three: Using Save Object As

Module Three: Working with Access Options (I)

  • Lesson One: Setting General Options
  • Lesson Two: Setting Application Options
  • Lesson Three: Setting Navigation and Other Options
  • Lesson Four: Setting Datasheet Options

Module Four: Working with Access Options (II)

  • Lesson One: Setting Object Designers Options
  • Lesson Two: Setting Proofing and Language Options
  • Lesson Three: Setting Client Settings Options
  • Lesson Four: Customizing the Ribbon
  • Lesson Five: Customizing the Quick Access Toolbar

Module Five: Working with Tables

  • Lesson One: Hiding and Unhiding Fields
  • Lesson Two: Freezing and Unfreezing Fields
  • Lesson Three: Modifying Data Types
  • Lesson Four: Modifying Field Descriptions
  • Lesson Five: Modifying Field Properties

Module Six: Importing Table Data

  • Lesson One: Appending Records to an Existing Table
  • Lesson Two: Importing Data as a Linked Table
  • Lesson Three: About Linked Table Troubleshooting

Module Seven: Working with Queries (I)

  • Lesson One: Creating a Select Query
  • Lesson Two: Creating a Make Table Query
  • Lesson Three: Creating an Append Query
  • Lesson Four: Creating a Cross Tab Query

Module Eight: Working with Queries (II)

  • Lesson One: Showing or Removing Tables
  • Lesson Two: Creating an Update Query
  • Lesson Three: Creating a Parameter Query
  • Lesson Four: Comparing Two Tables by Using a Join

Module Nine: Working with Forms

  • Lesson One: Creating a Blank Form
  • Lesson Two: Using Form Controls
  • Lesson Three: Creating a Header and Footer
  • Lesson Four: Using the Form Design Arrange and Format Tools
  • Lesson Five: Using a Background Image
  • Lesson Six: Using Themes
  • Lesson Seven: Using Conditional Formatting
  • Lesson Eight: Creating a Navigation Form

Module Ten: Using Reports

  • Lesson One: Creating a Blank Report
  • Lesson Two: Creating a Header and Footer
  • Lesson Three: Using the Property Sheet
  • Lesson Four: Using the Report Layout Tabs

Module Eleven: Using Macros and Code

  • Lesson One: About Macros
  • Lesson Two: Creating a User-Interface Macro
  • Lesson Three: Creating a Data Macro
  • Lesson Four: Working With the Macro Tools Design Tab
  • Lesson Five: Working with the Action Catalog
  • Lesson Six: About Visual Basic
  • Lesson Seven: About Modules

Module Twelve: Wrapping Up

Course 7 - 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 8 - 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 9 - 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

Course 10 - Certificate In Business Writing Online Course

PART ONE – THE BUILDING BLOCKS

Section One: Getting Started

  • a quick refresher on basic writing concepts (such as spelling, grammar, and punctuation) – the things that we often miss especially when completing work under pressure; and
  • an overview of some the typical business documents – letters, reports, proposals – that you may have to deal with, with tips on structure, style etc. 

Section Two: Spelling and Grammar

  • Spelling
  • Grammar

Section Three: Language and tone

  • Clarity
  • Conciseness
  • Formality
  • Focus
  • Tone

Section Four: Sentences and Paragraphs

  • Parts of a Sentence
  • Sentence Length
  • Punctuation
  • Paragraphs

Section Five: Organization and Structure

  • Organisation Approach

Section Six: Tools and Techniques

  • The Reader
  • The Requirement
  • Write faster – effective writing
  • Templates
  • Proofreading
  • Review/Peer Review
  • The Appearance - Printing and Publishing

PART TWO – THE DOCUMENTS

Section Seven: Meeting Agendas

  • The Basic Structure

Section Eight: E-mails

  • Addressing your mails
  • Brevity
  • Formality
  • Attachments
  • Forwarding/replying

Section Nine: Business Letters

  • The Basic Structure
  • Writing the Letter

Section Ten: Proposals

  • The Basic Outline
  • Key information
  • Sequence
  • Choosing a Format
  • Proposal Structure and Content
  • Executive Summaries

Section Eleven: Reports

  • Report Structure and format

Section Twelve: Requests for Proposal

  • Requests for Proposals

Section Thirteen: Business Cases

  • Business Cases

Section Fourteen: General Documentation

  • General Documentation

Section Fifteen: 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 InfoPath 2010 Expert, InfoPath 2010 Advanced, InfoPath 2010 Essentials, Access 2010 Essentials , Access 2010 Advanced , Access 2010 Expert , Excel 2010 Essentials , Excel 2010 Advanced , Excel 2010 Expert and Business Writing in this Bundle

1. InfoPath 2010 Expert :Become an expert in InfoPath 2010

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

InfoPath is a powerful solution for collecting data from users on a variety of platforms. Microsoft InfoPath 2010 has new great features, such as the Office Fluent UI, and the ability to customize SharePoint list forms in just one click. Are you ready to take your organization to the next level with Microsoft InfoPath 2010?

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

  • Set options, including form submission, publishing, and advanced form options
  • Customize the Ribbon and the Quick Access toolbar
  • View form template properties
  • Understand trusted locations
  • Apply a digital signature or multiple signatures to a form
  • Set confirmation messages
  • Disable digital signatures
  • Sign form templates digitally
  • Use Properties for text box controls, list box controls, combo box controls, option buttons, check boxes, hyperlinks, calculated values, sections date pickers, and pictures
  • Modify a control
  • Set a field’s default value
  • Change a control’s binding
  • Set a field’s value using rules
  • Filter data displayed in a control
  • Understand commands and switches
  • Use a switch once
  • Make a reusable switch
  • Understand the use of formulas and functions in InfoPath
  • Use date and time functions
  • Use field functions
  • Use math functions
  • Use text functions
  • Use URL functions
  • Use the Username function
  • Create a rule to show a message
  • Create a rule to show the value of a field or formula
  • Create a rule to switch views
  • Create a rule to set a field’s value
  • Create a rule to open a new form to fill
  • Create a rule to send data to a WebPart
  • Create a rule to sign a signature line
  • Create a rule to close the form
  • Understand advanced condition scenarios
  • Use data entry patterns
  • Create a rule to query for data
  • Create a rule to submit data

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

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

In this course, you will learn how to create, manage, and fill out interactive forms. Microsoft InfoPath 2010 has new great features, such as the Office Fluent UI, and the ability to customize SharePoint list forms in just one click. Are you ready to take your organization to the next level with Microsoft InfoPath 2010?

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

  • Open and close InfoPath
  • Use InfoPath’s Available Form Templates window and the interface
  • Add rules to customized forms
  • Explain XML at a high level
  • Use InfoPath Filler 2010 to fill out forms
  • Design a form from scratch using Microsoft InfoPath Design 2010
  • Work with InfoPath tables
  • Create field labels
  • Add and modify basic controls, including picture and file attachments
  • Understand what advanced control  types can be used for
  • Format controls
  • Add data validation and conditional formatting rules to controls
  • Use the Logic Inspector and Design Checker
  • View and modify data sources, fields, and groups
  • Manually bind controls to a data source
  • Create, modify, and delete InfoPath views
  • Change the color scheme of a form
  • Check spelling
  • Preview and test a form
  • Protect a form
  • Publish or print a form

3. InfoPath 2010 Advanced : Learn Advanced Skills for InfoPath 2010

You will learn how to use the advanced features of InfoPath 2010.

InfoPath is a powerful solution for collecting data from users on a variety of platforms. Microsoft InfoPath 2010 has new great features, such as the Office Fluent UI, and the ability to customize SharePoint list forms in just one click. Are you ready to take your organization to the next level with Microsoft InfoPath 2010?

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

  • Understand various types of controls
  • Validate form data
  • Import designs from Word or Excel
  • Create cascading drop down lists
  • Work with forms that can be merged
  • Add resource files to your form template
  • Understand InfoPath Form Events
  • Manage data connections
  • Publish in various types of forms

4. Access 2010 Essentials :Learn the Basic Features of Access 2010

Microsoft’s newest version of Access uses the new ribbon interface, and offers significant improvement to its database capability. You will learn how to use the basic features of Access 2010.  Access is the world’s premier database software. You can use Access 2010 to create and edit databases, just download a ready-made database template and start typing. It’s that easy. You can create a database of contacts, expenses, household and/or business inventory. In other words, if you have data, you can create a database of that data using Access.

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

  • Understand common database terms
  • Open and close Access
  • Create a blank database or a database from a template
  • Understand the interface and the Ribbon tools
  • Understand the Backstage View
  • Use the Navigation Pane
  • Work with database objects
  • Sort and filter the view
  • Create a blank table from a template, in Datasheet view, and Design View
  • Use Lookup columns in a table
  • Add information to a table
  • Edit, delete and search records
  • Save a table
  • Create a Navigation Form
  • Create a form with the Wizard and in Layout View
  • Modify a form in Design View
  • Perform common formatting tasks on forms
  • Use Themes
  • Add or move controls on a form
  • Create reports using the Report Wizard
  • Understand the Report Design View
  • Add a Logo to a report
  • Create Queries using the Wizard
  • Execute a Query
  • Understand the Query Design View
  • Understand Access file formats and save a database as another file format
  • Print an Object
  • Back up the database
  • Email the database

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

You will learn how to use the advanced features of Access 2010. This course is designed to teach you a basic understanding of Access 2010 in a practical way. This course incorporates a hands-on approach to learning.

You can use advanced forms and tasks to do even more in Access than you have previously learned. For example, you can use Access to create mailing labels, work with SQL, and publish a Web database, among other things. By the time you finish this course, you will be able to navigate Access 2010 and create reports like a pro.

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

  • Use the Quick Start group, Property Sheet, table macros, report sections, conditional formatting, Expression Builder and logical functions.
  • Add, move, remove and format both regular and calculated controls
  • Set the Primary Key
  • Create a subform, Web form, split form, modal dialog, PivotChart, PivotTable and mailing labels
  • Group and sort data
  • Understand, view and edit relationships
  • Understand and establish referential integrity
  • Sort and filter a query
  • Add calculated fields
  • Understand what SQL is, what SQL statements are, basic SQL syntax and the uses for SQL within Access 2010
  • Link to, import and export an Excel spreadsheet, Access database, SharePoint list, text or XML file and other types of links, imports and exports
  • Use the Database Documenter, analyze table and database performance and repair and compact a database

6. Access 2010 Expert :Acquire Expert Skills in Access 2010

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

You can use advanced forms and tasks to do even more in Access than you have previously learned. For example, you can use Access to create mailing labels, work with queries, and publish a Web database among other things. By the time you finish this course, you will be able to navigate Access 2010 and create reports like a pro.

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

  • Work with Database Properties
  • Encrypt a database with a password
  • Save an object
  • Set general, current database, datasheet, object designers, proofing, and language options
  • Customize the Ribbon and the Quick Access toolbar
  • Hide/unhide and freeze/unfreeze fields in a table
  • Modify field descriptions and properties
  • Append records to an existing table
  • Import data as a linked table
  • Understand linked table errors
  • Create a select query
  • Create a make table query
  • Create an append query
  • Create a cross tab query
  • Show or remove tables on the query designer window
  • Create an update query
  • Create a parameter query
  • Compare two tables using a join
  • Create a blank form
  • Use form controls
  • Create headers and footers on forms or reports
  • Use Form Design, Report Design, and Macro Design tools
  • Use background images
  • Use themes
  • Use conditional formatting
  • Create a navigation form
  • Create a blank report
  • Use the Property Sheet
  • Create a user-interface or a data macro
  • Understand the Action catalog
  • Understand the use of Visual Basic for Applications to extend Access functionality

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

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

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

10. Business Writing :Become an Expert at Writing Effective Emails, Letters, Reports and More

We all know that writing is one of the most important methods of business communication for most people, whether its e-mails, memos, proposals, or major reports. Lots of people struggle with the composition of these. Sometimes it's because they don't have to do it very often so, therefore, it doesn't flow as easily as they would like, sometimes because they are new to a role, or just because it's not their favorite thing.

This Business Writing Online Short Course will provide:

  • A quick refresher on basic writing concepts (such as spelling, grammar, and punctuation) the things that we often miss especially when completing work under pressure; and
  • An overview of some the typical business documents, letters, reports, proposals that you may have to deal with, with tips on structure, style etc.

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

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 InfoPath 2010 Expert 10 Course Bundle includes the following courses, below is a summary of each course: 

Course 1 - Certificate In InfoPath 2010 Expert Online Course

Module One: Getting Started

  • Course Objectives

Module Two: Working with the InfoPath Environment

  • Lesson One: Setting Options
  • Lesson Two: Customizing the Ribbon
  • Lesson Three: Customizing the Quick Access Toolbar
  • Lesson Four: Setting Form Submission Options
  • Lesson Five: Setting Advanced Form Options
  • Lesson Six: Viewing Form Template Properties

Module Three: Working with Digital Signatures

  • Lesson One: About Trusted Locations
  • Lesson Two: Applying a Digital Signature to a Form
  • Lesson Three: Adding Multiple Signatures to a Form
  • Lesson Four: Setting Confirmation Messages
  • Lesson Five: Disabling Digital Signatures
  • Lesson Six: Digitally Signing Form Templates

Module Four: Doing More with Controls

  • Lesson One: Modifying a Control
  • Lesson Two: Setting the Default Value for a Control
  • Lesson Three: Changing the Binding
  • Lesson Four: Filtering Data Displayed in a Control

Module Five: Working with Control Properties, Part 1

  • Lesson One: Working with Text Box Properties
  • Lesson Two: Working with List Box Properties
  • Lesson Three: Working with Combo Box Properties
  • Lesson Four: Working with Option Button Properties
  • Lesson Five: Working with Check Box Properties

Module Six: Working with Control Properties, Part 2

  • Lesson One: Working with Hyperlink Properties
  • Lesson Two: Working with Picture Properties
  • Lesson Three: Working with Date Picker Properties
  • Lesson Four: Working with Calculated Value Properties
  • Lesson Five: Working with Section Properties

Module Seven: Using Commands and Switches

  • Lesson One: About Commands and Switches
  • Lesson Two: Types of Commands and Switches
  • Lesson Three: Using a Switch Once
  • Lesson Four: Making a Reusable Switch

Module Eight: Using Formulas and Functions

  • Lesson One: About Formulas and Functions in InfoPath
  • Lesson Two: Using Date and Time Functions
  • Lesson Three: Using Field Functions
  • Lesson Four: Using Math Functions
  • Lesson Five: Using Text Functions
  • Lesson Six: Using URL Functions
  • Lesson Seven: Using the Username Function

Module Nine: Using Action Rules

  • Lesson One: Creating a Rule to Show a Message
  • Lesson Two: Creating a Rule to Show the Value of a Field or Formula
  • Lesson Three: Creating a Rule to Switch Views
  • Lesson Four: Creating a Rule to Set a Field's Value
  • Lesson Five: Creating a Rule to Open a New Form to Fill

Module Ten: Using More Action Rules

  • Lesson One: Creating a Rule to Sign a Signature Line
  • Lesson Two: Creating a Rule to Close the Form
  • Lesson Three: Creating a Rule to Send Data to a WebPart
  • Lesson Four: About Advanced Condition Scenarios

Module Eleven: Using Queries and Data Submission

  • Lesson One: Using Data Entry Patterns
  • Lesson Two: Creating a Rule to Query for Data
  • Lesson Three: Creating a Rule to Submit Data

Module Twelve: Wrapping Up

Course 2 - Certificate In InfoPath 2010 Essentials Online Course

Module One: Getting Started

Module Two: Opening and Closing InfoPath

  • Lesson One: Opening InfoPath
  • Lesson Two: Using the Available Form Templates Window
  • Lesson Three: Exploring the InfoPath's Interface
  • Lesson Four: An XML Primer
  • Lesson Five: Closing InfoPath

Module Three: Using the InfoPath Filler 2010

  • Lesson One: Launching Microsoft InfoPath Filler 2010
  • Lesson Two: Entering Data
  • Lesson Three: Checking Your Spelling
  • Lesson Four: Printing Form
  • Lesson Five: Saving the Form

Module Four: Designing a Form Framework 

  • Lesson One: Creating a Blank Form
  • Lesson Two: Adding a Table
  • Lesson Three: Adding a Table
  • Lesson Four: Adding and Removing Rows or Columns
  • Lesson Five: Merging and Splitting Cells
  • Lesson Six: Formatting Tables
  • Lesson Seven: Changing Table Properties

Module Five: Adding Labels

  • Lesson One: Adding Labels
  • Lesson Two: Changing the Font Color
  • Lesson Three: Adding Effects
  • Lesson Four: Using the Font Task Pane
  • Lesson Five: Aligning Text

Module Six: Adding Controls

  • Lesson One: Adding a Standard Controls
  • Lesson Two: Adding Repeating and Optional Controls
  • Lesson Three: Adding File Controls
  • Lesson Four: Adding Picture Controls
  • Lesson Five: Advanced Types of Controls

Module Seven: Formatting Controls

  • Lesson One: Changing the Visual Properties of a Control
  • Lesson Two: Using the Control Properties Dialog
  • Lesson Three: Adding Data Validation Rules
  • Lesson Four: Applying Conditional Formatting
  • Lesson Five: Running the Logic (Rule) Inspector

Module Eight: Working with Data Sources

  • Lesson One: Viewing Data Source Information
  • Lesson Two: Managing Fields and Groups
  • Lesson Three: Adding a Data Connection
  • Lesson Four: Manually Binding Controls

Module Nine: Creating a View

  • Lesson One: Creating a Custom View
  • Lesson Two: Creating a Print View
  • Lesson Three: Setting a View as Default
  • Lesson Four: Deleting Views

Module Ten: Finishing the Form

  • Lesson One: Changing the Color Scheme
  • Lesson Two: Checking Your Spelling
  • Lesson Three: Using the Design Checker
  • Lesson Four: Protecting Your Form
  • Lesson Five: Previewing the Form

Module Eleven: Distributing Your Form

  • Lesson One: Understanding Saving vs. Publishing
  • Lesson Two: Using the Publishing Wizard
  • Lesson Three: Printing the Form

Module Twelve: Wrapping Up

Course 3 - Certificate In InfoPath 2010 Advanced Online Course

Module One: Getting Started

  • Course Objectives

Module Two: Types of Controls

  • Lesson One: Insert Controls on a Form Template
  • Lesson Two: Understanding Controls and the Data Source
  • Lesson Three: Input Controls
  • Lesson Four: Object Controls
  • Lesson Five: Container Controls
  • Lesson Six: Custom Controls
  • Lesson Seven: Remove a Control from a Form Template

Module Three: Repeating and Optional Controls

  • Lesson One: Using Repeat Tables
  • Lesson Two: Using Repeating Sections
  • Lesson Three: Creating an Optional Section

Module Four: Control Tool Properties and Table Tools Tab

  • Lesson One: Control Tool Properties Tabs
  • Lesson Two: Using the Control Properties Dialog Box
  • Lesson Three: Table Tools Tab

Module Five: Actions

  • Lesson One: Creating an Action Based on User Input
  • Lesson Two: Using Buttons to Switch Views
  • Lesson Three: Applying Conditional Formatting
  • Lesson Four: Calculating Fields
  • Lesson Five: Validating Your Form Input Data

Module Six: Importing Form Designs

  • Lesson One: Importing Designs from Other Applications
  • Lesson Two: Importing Word Forms
  • Lesson Three: Importing Excel Forms

Module Seven: Advanced Topics

  • Lesson One: Cascading List Box
  • Lesson Two: Merging Forms
  • Lesson Three: Adding Resource Files to Your Form Template

Module Eight: Understanding Code

  • Lesson One: How InfoPath uses XML Technologies
  • Lesson Two: InfoPath Form Events
  • Lesson Three: Working with Data Connections
  • Lesson Four: Using an Add - In
  • Lesson Five: The Developer Tab

Module Nine: Publishing Forms

  • Lesson One: Understanding Form Security
  • Lesson Two: Setting Form Template Security Level
  • Lesson Three: Network Location
  • Lesson Four: Hosting InfoPath Forms

Module Ten: SharePoint Integration

  • Lesson One: Form Libraries
  • Lesson Two: Promoting Field Properties
  • Lesson Three: Email Enabling Document Libraries
  • Lesson Four: SharePoint Workflow

Module Eleven: Publishing Forms for Use with SharePoint

  • Lesson One: Publishing To a Sharepoint Form Library
  • Lesson Two: Publishing To a SharePoint Site as a Content Type
  • Lesson Three: Browser Capable Forms
  • Lesson Four: Installable Form Template

Module Twelve: Wrapping Up

Course 4 - Certificate In Access 2010 Essentials Online Course

Module One: Getting Started

  • Course Objectives

Module Two: Getting Started With Access

  • Lesson One: Common Database Terms
  • Lesson Two: Opening Access
  • Lesson Three: Understanding the Access New File Screen
  • Lesson Four: Creating a Blank Access Database
  • Lesson Five: Creating a Blank Database from a Template

Module Three:  Using the Access Interface

  • Lesson One: Understanding Security Warnings
  • Lesson Two: Interface Overview
  • Lesson Three: Overview of the Ribbon Interface
  • Lesson Four: Working With the Backstage View
  • Lesson Five: Using the Navigation Pane

Module Four:  Working with Database Objects

  • Lesson One: Viewing Database Objects
  • Lesson Two: Exporting an Object
  • Lesson Three: Renaming an Object
  • Lesson Four: Sorting and Filtering Your View
  • Lesson Five: Understanding Application Parts

Module Five: Creating Tables

  • Lesson One: Understanding Data Types
  • Lesson Two: Creating a Blank Table in Datasheet View
  • Lesson Three: Understanding Lookup Columns
  • Lesson Four: Creating a Blank Table Using Design View
  • Lesson Five: Saving Your Table
  • Lesson Six: Key Table Tools

Module Six: Working with Tables

  • Lesson One: Adding Information to a Table
  • Lesson Two: Editing Records
  • Lesson Three: Deleting Records
  • Lesson Four: Searching for Records

Module Seven: Creating Forms

  • Lesson One: Types of Controls
  • Lesson Two: Creating a Form with the Wizard
  • Lesson Three: Creating a Form in Layout View
  • Lesson Four: Modifying Your Form in Design View
  • Lesson Five: Key Features on the Form Tools Tab
  • Lesson Six: Creating a Navigation Form

Module Eight: Working with Forms

  • Lesson One: Common Formatting Tasks
  • Lesson Two: Using Themes
  • Lesson Three: Adding Controls
  • Lesson Four: Moving Controls
  • Lesson Five: Deleting Records

Module Nine: Creating Reports

  • Lesson One: Using The Report Wizard
  • Lesson Two: Using Design View
  • Lesson Three: Adding a Logo
  • Lesson Four: Working with Controls
  • Lesson Five: Key Features on the Report Tools

Module Ten: Creating Queries

  • Lesson One: Types of Queries
  • Lesson Two: Creating a Query with the Wizard
  • Lesson Three: Executing a Query
  • Lesson Four: Viewing the Query
  • Lesson Five: Key Features on the Query Tools Tab

Module Eleven: Managing Your Database

  • Lesson One: Using Alternate File Formats
  • Lesson Two: Printing an Object
  • Lesson Three: Backing Up Your Database 
  • Lesson Four: Emailing Database Objects

Module Twelve: Wrapping Up

Course 5 - Certificate In Access 2010 Advanced Online Course

Module One: Getting Started

  • Course Objectives

Module Two: Advanced Table Tasks

  • Lesson One: Using the Quick Start Group
  • Lesson Two: Using the Property Sheet
  • Lesson Three: Adding, Moving, and Removing Controls
  • Lesson Four: Formatting Controls
  • Lesson Five: Setting the Primary Key
  • Lesson Six: Using Table Macros

Module Three: Advanced Form Tasks

  • Lesson One: Creating a Sub Form
  • Lesson Two: Creating a Web Form
  • Lesson Three: Creating a Split Form

Module Four: Advanced Reporting Tasks 

  • Lesson One: Using Report Sections
  • Lesson Two: Using Conditional Formatiting
  • Lesson Three: Grouping & Sorting Data
  • Lesson Four: Adding Calculated Controls
  • Lesson Five: Creating Labels

Module Five: Understanding Relationships

  • Lesson One: Types of Relationships
  • Lesson Two: Viewing Relationships
  • Lesson Three: Editing Relationships
  • Lesson Four: About Referential Integrity
  • Lesson Five: Establishing Referential Integrity

Module Six: Advanced Query Tasks

  • Lesson One: Sorting and Filtering a Query
  • Lesson Two: Adding Calculated Fields
  • Lesson Three: Using the Expression Builder

Module Seven: Working with SQL

  • Lesson One: What is SQL?
  • Lesson Two: Basic SQL Syntax

Module Eight: Linking Data

  • Lesson One: Linking to an Excel Spreadsheet
  • Lesson Two: Linking to an Access Database
  • Lesson Three: Linking to a SharePoint List

Module Nine: Importing Data

  • Lesson One: Importing From an Excel Spreadsheet
  • Lesson Two: Importing From an Access Database
  • Lesson Three: Importing from a SharePoint List

Module Ten: Exporting Data

  • Lesson One: Saving an Object as a PDF
  • Lesson Two: Exporting To an Excel Spreadsheet
  • Lesson Three: Exporting to a SharePoint List

Module Eleven: Advanced Database Tools

  • Lesson One: Using the Database Documenter
  • Lesson Two: Analyzing Table Performance
  • Lesson Three: Analyzing Database Performance
  • Repairing a Database
  • Compacting a Database

Module Twelve: Wrapping Up

Course 6 - Certificate In Access 2010 Expert Online Course

Module One: Getting Started

  • Course Objectives

Module Two: Working with the Access Environment

  • Lesson One: Working with Database Properties
  • Lesson Two: Encrypting a Database with a Password
  • Lesson Three: Using Save Object As

Module Three: Working with Access Options (I)

  • Lesson One: Setting General Options
  • Lesson Two: Setting Application Options
  • Lesson Three: Setting Navigation and Other Options
  • Lesson Four: Setting Datasheet Options

Module Four: Working with Access Options (II)

  • Lesson One: Setting Object Designers Options
  • Lesson Two: Setting Proofing and Language Options
  • Lesson Three: Setting Client Settings Options
  • Lesson Four: Customizing the Ribbon
  • Lesson Five: Customizing the Quick Access Toolbar

Module Five: Working with Tables

  • Lesson One: Hiding and Unhiding Fields
  • Lesson Two: Freezing and Unfreezing Fields
  • Lesson Three: Modifying Data Types
  • Lesson Four: Modifying Field Descriptions
  • Lesson Five: Modifying Field Properties

Module Six: Importing Table Data

  • Lesson One: Appending Records to an Existing Table
  • Lesson Two: Importing Data as a Linked Table
  • Lesson Three: About Linked Table Troubleshooting

Module Seven: Working with Queries (I)

  • Lesson One: Creating a Select Query
  • Lesson Two: Creating a Make Table Query
  • Lesson Three: Creating an Append Query
  • Lesson Four: Creating a Cross Tab Query

Module Eight: Working with Queries (II)

  • Lesson One: Showing or Removing Tables
  • Lesson Two: Creating an Update Query
  • Lesson Three: Creating a Parameter Query
  • Lesson Four: Comparing Two Tables by Using a Join

Module Nine: Working with Forms

  • Lesson One: Creating a Blank Form
  • Lesson Two: Using Form Controls
  • Lesson Three: Creating a Header and Footer
  • Lesson Four: Using the Form Design Arrange and Format Tools
  • Lesson Five: Using a Background Image
  • Lesson Six: Using Themes
  • Lesson Seven: Using Conditional Formatting
  • Lesson Eight: Creating a Navigation Form

Module Ten: Using Reports

  • Lesson One: Creating a Blank Report
  • Lesson Two: Creating a Header and Footer
  • Lesson Three: Using the Property Sheet
  • Lesson Four: Using the Report Layout Tabs

Module Eleven: Using Macros and Code

  • Lesson One: About Macros
  • Lesson Two: Creating a User-Interface Macro
  • Lesson Three: Creating a Data Macro
  • Lesson Four: Working With the Macro Tools Design Tab
  • Lesson Five: Working with the Action Catalog
  • Lesson Six: About Visual Basic
  • Lesson Seven: About Modules

Module Twelve: Wrapping Up

Course 7 - 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 8 - 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 9 - 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

Course 10 - Certificate In Business Writing Online Course

PART ONE – THE BUILDING BLOCKS

Section One: Getting Started

  • a quick refresher on basic writing concepts (such as spelling, grammar, and punctuation) – the things that we often miss especially when completing work under pressure; and
  • an overview of some the typical business documents – letters, reports, proposals – that you may have to deal with, with tips on structure, style etc. 

Section Two: Spelling and Grammar

  • Spelling
  • Grammar

Section Three: Language and tone

  • Clarity
  • Conciseness
  • Formality
  • Focus
  • Tone

Section Four: Sentences and Paragraphs

  • Parts of a Sentence
  • Sentence Length
  • Punctuation
  • Paragraphs

Section Five: Organization and Structure

  • Organisation Approach

Section Six: Tools and Techniques

  • The Reader
  • The Requirement
  • Write faster – effective writing
  • Templates
  • Proofreading
  • Review/Peer Review
  • The Appearance - Printing and Publishing

PART TWO – THE DOCUMENTS

Section Seven: Meeting Agendas

  • The Basic Structure

Section Eight: E-mails

  • Addressing your mails
  • Brevity
  • Formality
  • Attachments
  • Forwarding/replying

Section Nine: Business Letters

  • The Basic Structure
  • Writing the Letter

Section Ten: Proposals

  • The Basic Outline
  • Key information
  • Sequence
  • Choosing a Format
  • Proposal Structure and Content
  • Executive Summaries

Section Eleven: Reports

  • Report Structure and format

Section Twelve: Requests for Proposal

  • Requests for Proposals

Section Thirteen: Business Cases

  • Business Cases

Section Fourteen: General Documentation

  • General Documentation

Section Fifteen: 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 AU$599 Save AU$2091 (78%)
OFF RRP AU$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.: 020IP10EX10CB
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