Excel Certificate, Level 2


Understanding the technology in any office environment is an important skill that helps improve employee performance.  The goal of this training is to achieve long-term improvements in the way employees do their jobs.  Teaching participants how to work effectively in Microsoft Excel so that they can easily create the formulas, functions and reports they need.  This program is best suited for the companies that want to have their staff at (or around) the same level of competency while boosting their staff’s performance and confidence.

Level 2 Learning Module

In this module the agenda is as follows:

Fundamental Short-Cuts
Review of Formulas

Using built-in Function Wizards
Mathematical functions such as Round
Use Financial functions to calculate a loan payment
Logical functions using IF
Create formulas using Date & Time functions
Automatically display information from another spreadsheet using Table Lookups

Add data together using Paste Special
Linking worksheets within the same workbook Linking worksheets with another file.

Creating an embedded chart in a Worksheet
Moving & Sizing an embedded chart
Modifying your Chart quickly and easily

Custom Sorts
Filter out specific records using AutoFilter
Create instant Subtotals & Grand Totals

Outcomes:  Participant will have will be able to create, manipulate and extract data easily with Microsoft Excel.

Instruction will be hands-on.
Hours: 3 to 4 hours
Large Groups may need 7 hours


  • Course Manuals or Notes are included with training.
  • Certificate of Completion given to each participant.
  • Connie Clark, instructor and facilitator for training.
  • Support on topics is included throughout the program.
  • Participants learning will be accessed and evaluated based on their hands-on experiences in the training.
  • Training can include client examples for exercises in learning.
  • Video Recording of Course
  • Course Exercise provided for practice


  • Total Training duration:  1 day.
  • Total Training Hours: 7 hours.
  • Course Investment per person: $350
  • Minimum of 12 people and maximum of 20 people per session.
  • Price if 6 or 7 or 8 students: $395.00 each
    Half Day Training option:
  • Half Day Training duration
  • Total Training hours: 4 hours.
  • Course Investment per person:  $175.00
  • Minimum of 8 people and maximum of 20 people per session.
  • Price if 6 or 7 students: $230.00 per person

The Full Small Office solution

Becoming self sufficient and more efficient.

error: Content is protected !!
Call Now Button