« Back

Course Catalog

Microsoft Excel

Learn how to create clear, effective spreadsheets and analyze data using Microsoft Excel.

Excelling at Excel: Formulas and Functions

In this half-day course, students will discover introductory, intermediate, and advanced functions/formulas in Excel.
  • The introductory functions include SUM, AVERAGE, COUNT, and TODAY functions.
  • The intermediate functions include VLOOKUP/HLOOKUP, PMT, and CONCATENATE.
  • The advanced functions include IF…THEN…ELSE, SUMIFS, COUNTIFS, AVERAGEIFS, DSUM, and DCOUNT.

Audience: This course is designed for those who are current users of Excel and want to know more about formulas and functions. This course builds on "Excelling at Excel: The FUNdamentals" and "Excelling at Excel: The 5Fs."

Software: This class is taught using Microsoft Excel 2010 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

After completing this course, you will be able to:
  1. Create and edit basic, intermediate, and advance functions
  2. Use all of the cell references in Excel – Relative, Absolute/Mixed, and 3-D
  3. Develop results with functions based on criteria
  4. Measure time in hours and minutes, days, and years
  5. Use Introductory functions – SUM, AVERAGE, COUNT, and TODAY
  6. Use Intermediate functions – VLOOKUP/HLOOKUP, PMT, and CONCATENATE
  7. Use Advanced functions – IF-THEN-ELSE, COUNTIFS, SUMIFS, AVERAGEIFS, DSUM, DCOUNT, and DAVERAGE
Section: MS-EXCEL-FORMFUN (19MAY17) -- Learn More...
Start Date: May 19, 2017 End Date: May 19, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register

Excelling at Excel: The 5Fs: Formatting, Fills, Formulas, Functions, and Filters/Sorts

In this half-day course, students will discover the important 5Fs of Excel: Formatting, Fills, Formulas, Functions, and Filters/Sorts.
  1. Formatting: Using and creating custom formatting for SSNs, phone numbers, and other special types of data.
  2. Fills: Using fills for dates, numbers, formulas/functions, and how to create your fills.
  3. Functions: Using SUM, AVERAGE, COUNT, COUNTA, TODAY, CONCATENATE, and other functions.
  4. Formulas: Using Relative, Absolute/Mixed, and 3-D references
  5. Filters/Sorts: Using Excel as a database/table for filtering and sorting data.

Audience: This course is designed for those who are familiar with Excel and want to learn to perform more complex tasks and functions. This course builds on "Excelling at Excel: The FUNdamentals."

Software: This class is taught using Microsoft Excel 2010 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

After completing this course, you will be able to:
  1. Create and use special and custom formats
  2. Employ Conditional Formatting based on various criteria
  3. Use AutoFill to save lists and for dates, text, numbers, and formulas and functions
  4. Develop formulas and functions in Excel for tables and databases
  5. Filter your information quickly for date ranges, numbers, and text lists
Section: MS-EXCEL-5FS (12MAY17) -- Learn More...
Start Date: May 12, 2017 End Date: May 12, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register

Excelling at Excel: The FUNdamentals

In this half-day course, students will discover important shortcuts and tips and tricks in navigating and selecting data in Excel. We’ll customize Excel through our Quick Access Toolbar and important options. The course teaches formatting, using Autofill, and how to create formulas and functions the right way the first time. Finally, we will print and view Excel worksheets using Freeze and Split panes, Page Layout View, and Page Break Preview.

Audience: This course is designed for those who are new to Excel and want to learn to create and work with electronic spreadsheets.

Software: This class is taught using Microsoft Excel 2010 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

After completing this course, you will be able to:
  1. Increase productivity through shortcuts and the Quick Access Toolbar
  2. Create attractive worksheets with formatting
  3. Use AutoFill to save time and input for text, numbers, dates, and formulas/functions
  4. Develop formulas and functions in Excel
  5. Understand syntax of Excel’s formulas and functions
  6. Print and view Excel worksheets the right way
Section: MS-EXCEL-FUND (12MAY17) -- Learn More...
Start Date: May 12, 2017 End Date: May 12, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register

Microsoft Excel Level 1: Introduction

This class is taught specifically for Microsoft Excel 2010 using our lab PCs. Material learned in this course may not apply to different versions of Excel (2007/2013/2016) or those for Mac.

Excel is one of the most powerful and frequently used tools in an office environment. Get the most out of Excel 2010 by learning to create, edit, and print basic Excel spreadsheets with the latest version of this application! In this course, you will learn to speed up data entry, move and copy information, and create formulas to perform calculations. You'll prepare a spreadsheet for printing by setting margins, page breaks, and more. Finally, you'll learn to manage large Excel workbooks, making your data more readable and more attractive with formatting techniques.
Section: MS-EXCEL-LVL1 (26APR17) -- Learn More...
Start Date: Apr 26, 2017 End Date: Apr 26, 2017 Tuition: $375.00
Campus: Executive Park Instructor: Karen Maddox-Jones Register
Section: MS-EXCEL-LVL1 (21JUL17) -- Learn More...
Start Date: Jul 21, 2017 End Date: Jul 21, 2017 Tuition: $375.00
Campus: Executive Park Instructor: Karen Maddox-Jones Register

Microsoft Excel Level 2: Excelling at Excel

This class is taught using Microsoft Excel 2010 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

Learn the five Fs of Excel—formatting, fills, functions, formulas, and filters—tools that help you create effective and clear spreadsheets. Understand formatting and basic formulas as you begin building budget and expense spreadsheets. We go on to explore filters, fills, complex formulas, macros, charts and conditional formatting. These tools help you to create fully functional monthly and annual budget tracking spreadsheets.
Section: MS-EXCEL-LVL2 (09JUN17) -- Learn More...
Start Date: Jun 09, 2017 End Date: Jun 16, 2017 Tuition: $495.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-LVL2 (04AUG17) -- Learn More...
Start Date: Aug 04, 2017 End Date: Aug 11, 2017 Tuition: $495.00
Campus: Executive Park Instructor: Greg Creech Register

Microsoft Excel Level 3: More Excelling at Excel

This class is taught using Microsoft Excel 2010 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

Students will customize their workbooks through more functions, such as If . .. Then . . . Else and Data Validation, learn more functions, collaborate with other users, and enhance their spreadsheets using charts.
Section: MS-EXCEL-LVL3 (12APR17) -- Learn More...
Start Date: Apr 12, 2017 End Date: Apr 12, 2017 Tuition: $375.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-LVL3 (22AUG17) -- Learn More...
Start Date: Aug 22, 2017 End Date: Aug 22, 2017 Tuition: $375.00
Campus: Executive Park Instructor: Greg Creech Register

Microsoft Excel: Data Analysis Using Pivot Tables and Subtotals

This class is taught using Microsoft Excel 2010 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

This half day course covers creating and downloading databases and then how to analyze data through Pivot Tables and SubTotals. Students interested in this course should be comfortable using Excel formatting, sorting, and filter features.

Data analysis is a powerful Excel feature and we will look in depth at creating and editing Pivot Tables and Pivot Charts for analysis. We will look at other database features such as Subtotals and using the Name Manager. We will use sorting and filtering to help restrict our data and use Pivot Tables for Sum, Average, and Count functions. Using Office 2007/2010 we will use the new Format as a Table feature and learn the advantages and disadvantages of using Format as a Table.
Section: MS-EXCEL-DATA (05MAY17) -- Learn More...
Start Date: May 05, 2017 End Date: May 05, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-DATA (16AUG17) -- Learn More...
Start Date: Aug 16, 2017 End Date: Aug 16, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register

Microsoft Excel: Data Management and Manipulation

This class is taught using Microsoft Excel 2010 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

Control data without data controlling you. Create and import databases and tables in Excel while handling multiple sorting and filtering tasks using a variety of criteria. Retrieve the information you need quickly and easily using multiple filters. Learn how to format tables and databases in a professional manner and master Excel’s terrific Name Box and Name Manager features. Separate data easily using the Text-to-Column feature and bring columns together using the CONCATENATE function.

After this class, you will be able to:

  • Sort and filter data using multiple criteria in order to get needed information with little effort
  • Download databases from other applications and servers
  • Create a data table or database avoiding common pitfalls
  • Format a professional and attractive table
  • Use the Name Box and Name Manager to efficiently navigate, print select, and add other functionality for your database and tables
  • Create the CONCATENATE function to bring columns together and VLOOKUP to bring data from one table into another
  • Employ Text to Columns to separate data from one column into multiple columns
Section: MS-EXCEL-MGMT (16MAY17) -- Learn More...
Start Date: May 16, 2017 End Date: May 16, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-MGMT (25AUG17) -- Learn More...
Start Date: Aug 25, 2017 End Date: Aug 25, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register