Course Calendar

Scroll down to see the list of available courses and detailed curriculum

Software Training Outlines

Microsoft Excel (2010, 2013 or 2016) Level 1

In this introductory course to Excel, participants will explore Excel activities that go beyond the basic. After successful completion of this session, participants can expect to have the skills required to work efficiently in an existing worksheet and to also create new worksheets from a template and from scratch.

Topics Include:

  • discuss the advantages of electronic spreadsheets.
  • create a basic worksheet by entering text, values, and formulas.
  • create formulas by using some of Excel's built-in functions.
  • move and copy data by using shortcut menus, drag-and-drop editing, and toolbar buttons.
  • change the appearance of worksheet data by using a variety of formatting techniques.
  • prepare a document for printing by using a variety of printing options.
  • use the three-dimensional aspect of the Excel workbook environment by creating formulas that refer to cells on multiple worksheets.
  • Save an Excel workbook as a Web page.

Microsoft Excel (2010, 2013 or 2016) Level 2

In Excel Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use more of Excel's built-in functions to perform complex calculations. You will also create charts, use graphics, and data management skills in an Excel database.

Upon successful completion of this course, students will be able to:

  • locate and use some of the more complex Excel functions.
  • create and modify charts.
  • work with graphic objects.
  • use range names to identify data
  • sort and filter data.
  • use other Excel database functions.

Microsoft Excel (2010, 2013 or 2016) Level 3

You have used Excel to perform tasks such as running calculations on data and sorting and filtering numeric data. You would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. This session includes all of these skills.

Performance-based Objectives: 
Upon successful completion of this course, participants will be able to:

  • use intermediate data management tools such as filters and advanced filters.
  • audit worksheets and use a watch window.
  • analyze data using a number of tools such as a subtotal report and a pivot table.
  • import and export data and link to the Web.
  • create web pages of Excel data.

Microsoft Excel (2010, 2013 or 2016) Level 4

In this course, we do not really do much Excel. We use the Excel software as a basis for examining the creation of custom functions using Visual Basic programming. These skills are then transerable to other applications such as Word or PowerPoint.

As a power user, you may find that the functions available in Excel fall a bit short of your own requirements. By using the Visual Basic module that is included with Microsoft Office products (VBA) you will create new functions that elicit interaction from users, perform automated tasks and sequential activities. Your new functions will be controllable by hotkeys, toolbar icons and command buttons.

This course is not for the faint of heart and is intended for advanced Excel users.

Version: 2.8.0