Course Offerings - Microsoft Excel

Excel –Basics

Prerequisite Skills:
  • Comfortable with the Windows environment.

Course Description:
This course explores the basic skills necessary for working in Excel and creating a basic spreadsheet.

Attend this course if you want to:
  • Understand Excel.
  • Learn to create a basic workbook.
  • Learn Excel terminology.
  • Move and copy data.
  • Create a basic function and formula.
  • Print a worksheet.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Excel – Formatting in Excel

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Comfortable with the Excel environment.

Course Description:
This course explores formatting features used in Excel.

Attend this course if you want to:
  • Learn why to use formatting in Excel.
  • Adjust row height and column width.
  • Format numbers and text.
  • Apply borders and shading to cells.
  • Copy formatting.
  • Work with page setup.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Excel – Functions and Formulas

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Comfortable with the Excel environment.

Course Description:
This course introduces functions and formulas in Excel.

Attend this course if you want to:
  • Understand functions and formulas.
  • Create and edit functions and formulas.
  • Use the AutoSum function.
  • Understand absolute and relative cell reference.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Excel – Using Workbooks

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Comfortable with the Excel environment.

Course Description:
This course explores using multiple sheets within an Excel workbook file.

Attend this course if you want to:
  • Differentiate between workbooks and worksheets.
  • Organize worksheets.
  • Copy, move and delete worksheets.
  • Create 3-D references and formulas between worksheets.
  • Print workbooks.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Excel – Charts

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Comfortable with the basics within Excel.

Course Description:
This course allows the user to learn about the charting feature in Excel and how to create and manipulate a chart.

Attend this course if you want to:
  • Learn about charts and chart objects.
  • Create a chart a basic chart.
  • Learn to format a chart.
  • Create combo charts.
  • Create user-defined charts.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Excel – Maximizing Functions and Formulas

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Comfortable with the basics within Excel.
  • Understand the basics of Functions and Formulas.

Course Description:
This course allows the user to further their skills in working with functions and formulas.

Attend this course if you want to:
  • Use lookup functions.
  • Use text functions such as Left and Right.
  • Work with date and time functions.
  • Create a nested if function.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Excel – Using Database Features

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Comfortable with the basics within Excel.
  • Understand the basics of Functions and Formulas.

Course Description:
This course allows the user to learn about the database features built into Excel such as filtering and sorting.

Attend this course if you want to:
  • Learn about databases in Excel.
  • Freeze rows and columns.
  • Sort and filter data.
  • Use subtotals and nested subtotals.
  • Use outlines.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Excel – Macros

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Overall comfort level with Excel.
  • Understand the basics of Functions and Formulas.

Course Description:
This course allows the users to explore creating macros in Excel.

Attend this course if you want to:
  • Learn about macros.
  • Create a macro.
  • Add a macro to a toolbar and menu.
  • Edit a macro.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Excel – Pivot Tables

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Understand the basics of Functions and Formulas.
  • Understand the database functionality within Excel.

Course Description:
This course allows the user to explore pivot tables and pivot charts in Excel.

Attend this course if you want to:
  • Learn about pivot tables.
  • Create a pivot table.
  • Manipulate and format pivot tables.
  • Create a pivot chart.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Excel – Data Analysis Tools

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Overall comfort level in Excel.
  • Basic macro understanding in Excel.

Course Description:
This course allows the user to explore the data analysis tools within Excel including the scenario manager and what if analysis tools.

Attend this course if you want to:
  • · Understand and use the scenario manager.
  • Use goal seek and solver.
  • Create data tables.
  • Use the conditional sum wizard.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom

-----------------------------------------------------------------------------------------------------------------

Excel – Excel Tips and Tricks

Prerequisite Skills:
  • Comfortable with the Windows environment.
  • Overall comfort level in Excel.

Course Description:
This course allows the user to explore time saving tips and tricks within Excel.

Attend this course if you want to:
  • Freeze rows and columns and split the screen.
  • Use named ranges.
  • Learn additional uses of the sum function.
  • Use hyperlinks.
  • Use SmartTags.

Class Length: 90 minutes

Delivery Methods:

  • On-site instructor led
  • Virtual classroom