« Back

Course Catalog

Microsoft Office

Microsoft Office skills are essential for any business professional. We currently offer courses in Access, Excel, PowerPoint, and Project. See below for more information about our course offerings.

Excelling at Excel: Formulas and Functions


Knowing how to work efficiently with Excel’s formulas and functions is a critical skill whether you are creating a monthly budget or working in complex worksheets at a Fortune 100 company.

Excel helps us perform very complex tasks using very simple built-in functions. In this course, you will learn different cell references—Relative, Absolute/Mixed, and 3-D—and use them to begin creating and using formulas. From there, you will begin introductory functions such as SUM, AVERAGE, COUNT, and TODAY to help track your monthly budget and expenses. We will discuss how to more efficiently create, copy, and organize worksheets before creating an annual budget using summary worksheets and Mixed and Absolute cell references to forecast your budget for the future.

We will also calculate loan payments, amortization, and repayment schedules using the Name Box, Name Manager, PMT, and CONCATENATE functions. Finally, we begin looking at different database functions like VLOOKUP/HLOOKUP and IF…THEN…ELSE to locate information in a workbook and avoid duplicate entries.

Audience: We designed this course for current, experienced users of Excel who want to know more about formulas and functions. This course builds on "Excelling at Excel: The FUNdamentals" and “Excelling at Excel: The 5 Fs.”

Software: We teach this course using Microsoft Excel 2016 on our lab PCs, but the content should also apply to Excel 2007, 2010, and 2013 for Windows. Material learned in this course may not apply to Excel for Mac.

After completing this course, participants will be able to:
  • Prepare formulas using basic, intermediate, and advance functions
  • Differentiate between cell references in Excel – Relative, Absolute/Mixed, and 3-D
  • Optimize budgeting with introductory functions including SUM, AVERAGE, COUNT, and TODAY
  • Evaluate loan repayment options using intermediate functions – PMT and CONCATENATE
  • Construct advanced functions to find and display data with VLOOKUP/HLOOKUP and IF-THEN-ELSE.
Section: MS-EXCEL-FORMFUN (18OCT17) -- Learn More...
Start Date: Oct 18, 2017 End Date: Oct 18, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-FORMFUN (21MAR18) -- Learn More...
Start Date: Mar 21, 2018 End Date: Mar 21, 2018 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register

Excelling at Excel: More Formulas and Functions


In Part 2 of this course, we will continue to discuss VLOOKUPS/HLOOKUPS to pull together information from large, database-like workbooks. From there, we will construct logical comparisons between given and expected values using IF…THEN…ELSE statements to make data more readable.

You will discover how to formulate smarter worksheets by understanding Excel’s time format and using Date Calculations such as TODAY, YEAR, and ROUNDDOWN. Track time spent volunteering, traveling, or working by creating a worksheet that calculates the interval between time in and time out. To keep data accurate, we will also learn to use Data Validation criteria.

Using COUNTIF, SUMIF and AVERAGEIF will help us perform calculations on data meeting specific criteria to extract more meaning from our worksheets. Finally, discover how to calculate totals, averages, and counts within a database system based on certain criteria using DSUM, DAVERAGE, and DCOUNT

Audience: We designed this course for current, advanced users of Excel who want to know more about formulas and functions. This course builds on "Excelling at Excel: The FUNdamentals," “Excelling at Excel: The 5 Fs,” and “Excelling at Excel: Formulas and Functions.”

Software: We teach this course using Microsoft Excel 2016 on our lab PCs, but the content should also apply to Excel 2007, 2010, and 2013 for Windows. Material learned in this course may not apply to Excel for Mac.

After completing this course, participants will be able to:
  • Explain more uses of VLOOKUPS/HLOOKUPS
  • Establish criteria using Data Validation to more easily search for data
  • Measure time in hours and minutes, days, and years
  • Create multiple IF-THEN-ELSE statements for more efficient functions
  • Develop functions—COUNTIFS, SUMIFS, AVERAGEIFS, DSUM, DCOUNT, and DAVERAGE—that give results based on criteria

Section: MS-EXCEL-FORM2 (25OCT17) -- Learn More...
Start Date: Oct 25, 2017 End Date: Oct 25, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-FORM2 (28MAR18) -- Learn More...
Start Date: Mar 28, 2018 End Date: Mar 28, 2018 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register

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


In this half-day course, students will discover the important 5 Fs 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 2016 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 (11OCT17) -- Learn More...
Start Date: Oct 11, 2017 End Date: Oct 11, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-5FS (14MAR18) -- Learn More...
Start Date: Mar 14, 2018 End Date: Mar 14, 2018 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 2016 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 (04OCT17) -- Learn More...
Start Date: Oct 04, 2017 End Date: Oct 04, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-FUND (07MAR18) -- Learn More...
Start Date: Mar 07, 2018 End Date: Mar 07, 2018 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register

Microsoft Access: Accessing the Possibilities


Create and manage your own Access database! Join us as we build and edit queries, tables, forms and reports for data manipulation. Explore various database objects, relationships, and primary keys while learning how to properly and efficiently utilize various Access functionalities. Course is best suited for current Access or intermediate Excel users with knowledge in database and/or table sorting/filtering functions. Homework is assigned between the classes.

After completing this course, students will be able to:

  • Create an Acces database with tables, forms, queries and reports
  • Understand Database Objects including tables, forms, queries and reports
  • Construct tables with text, date, numerical, and other fields
  • Use input masks to aid in entering and editing data for SSN, date, and other fields
  • Build queries for data manipulation and working with various types of criteria
  • Create forms for editing, deleting, viewing, and inputting data
  • Establish primary keys for our tables and appropriate relationships
  • Edit tables and fields, queries, forms, and reports to add functionality and customization
Section: MS-ACCESS (01DEC17) -- Learn More...
Start Date: Dec 01, 2017 End Date: Dec 15, 2017 Tuition: $675.00
Campus: Executive Park Instructor: Greg Creech Register

Microsoft Excel Level 1: Introduction


Excel is one of the most powerful and frequently used tools in an office environment. Get the most out of Excel 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.

This class is taught specifically for Microsoft Excel 2016 using our lab PCs. Material learned in this course may not apply to different versions of Excel (2007/2010/2013) or those for Mac.
Section: MS-EXCEL-LVL1 (13OCT17) -- Learn More...
Start Date: Oct 13, 2017 End Date: Oct 13, 2017 Tuition: $375.00
Campus: Executive Park Instructor: Karen Maddox-Jones Register
Section: MS-EXCEL-LVL1 (07FEB18) -- Learn More...
Start Date: Feb 07, 2018 End Date: Feb 07, 2018 Tuition: $375.00
Campus: Executive Park Instructor: Karen Maddox-Jones Register
Section: MS-EXCEL-LVL1 (05JUN18) -- Learn More...
Start Date: Jun 05, 2018 End Date: Jun 05, 2018 Tuition: $375.00
Campus: Executive Park Instructor: Karen Maddox-Jones Register

Microsoft Excel Level 2: Excelling at Excel


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 (04AUG17) -- Learn More...
Start Date: Aug 04, 2017 End Date: Aug 11, 2017 Tuition: $495.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-LVL2 (10OCT17) -- Learn More...
Start Date: Oct 10, 2017 End Date: Oct 17, 2017 Tuition: $495.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-LVL2 (05DEC17) -- Learn More...
Start Date: Dec 05, 2017 End Date: Dec 12, 2017 Tuition: $495.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-LVL2 (09FEB18) -- Learn More...
Start Date: Feb 09, 2018 End Date: Feb 16, 2018 Tuition: $495.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-LVL2 (19APR18) -- Learn More...
Start Date: Apr 19, 2018 End Date: Apr 26, 2018 Tuition: $495.00
Campus: Executive Park Instructor: Greg Creech Register

Microsoft Excel Level 3: More Excelling at Excel


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 (22AUG17) -- Learn More...
Start Date: Aug 22, 2017 End Date: Aug 22, 2017 Tuition: $375.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-LVL3 (14DEC17) -- Learn More...
Start Date: Dec 14, 2017 End Date: Dec 14, 2017 Tuition: $375.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-LVL3 (09MAY18) -- Learn More...
Start Date: May 09, 2018 End Date: May 09, 2018 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 (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


Control data without data controlling you!

In this half-day course, we will discuss how Excel can be used to manage and manipulate data in Excel, both in flat file databases and relational databases. Create and import databases and tables in Excel while handling multiple sorting and filtering tasks using a variety of criteria. We will also discuss how to format tables and databases in a professional manner while using Excel’s Format as Table feature.

Discover how to retrieve the information you need quickly and easily using multiple filters and custom views. We will also employ Excel’s terrific Name Box and Name Manager features to make data clearer and easier to reference.

We will use advanced functions to repackage data into more useful forms—such as correctly formatted addresses—using the CONCATENATE function to pull data together from two or more columns. Split data using delimiters and the Text to Columns feature to deconstruct names, dates, and other data into more useful formats.

Audience: We designed this course for current, experienced users of Excel who want to know more about managing and manipulating data

After completing this course, participants 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
  • Employ Text to Columns to separate data from one column into multiple columns
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
Section: MS-EXCEL-MGMT (15NOV17) -- Learn More...
Start Date: Nov 15, 2017 End Date: Nov 15, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register
Section: MS-EXCEL-MGMT (02MAR18) -- Learn More...
Start Date: Mar 02, 2018 End Date: Mar 02, 2018 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register

Microsoft PowerPoint: PowerPoint Power


THIS CLASS WILL COVER POWERPOINT 2007, 2010, 2013, AND 2016
Note: This is a combination soft and technical skills class; basic experience in Microsoft Office is required.


You’ll create your own PowerPoint presentation and template to help with your branding and customization of PowerPoint.

We’ll learn the new interface including the Ribbon, the Tabs, and other important new elements. As we build our presentation, we’ll learn how to present using PowerPoint’s slide show options and create interactive slides with the web and other applications. Our slides will include: Charts, Diagrams, Photos, Clip Art, Text, Bullets and Numbers, Tables, Sound, and Movies.

We’ll discuss the importance of color, animation, and presenting with PowerPoint. You’ll not only learn how to create a dynamic PowerPoint presentation from scratch but also how to present your presentation like a pro.
Section: MS-POWERPOINT (06DEC17) -- Learn More...
Start Date: Dec 06, 2017 End Date: Dec 13, 2017 Tuition: $495.00
Campus: Executive Park Instructor: Greg Creech Register

Microsoft Project Levels 1 and 2: Creating and Managing Projects


This class is taught specifically for Microsoft Project 2013 using our lab PCs, but much of the material will apply to the 2010 and 2016 versions, as well.

Learn to manage projects or participate on project teams. Then take that knowledge and apply it to hands-on exercises using Microsoft Project. This course discusses Gantt charts, tasks, critical paths, and resource management. You will also have the opportunity to work with a project plan once it has entered the project implementation phase. Learn to import and export Project data with Excel and other applications. Learn to update a Project Plan as changes occur during the project and create custom reports for project stakeholders. Finally, create templates to re-use project information in future projects.
Section: MS-PROJECT (06AUG17) -- Learn More...
Start Date: Aug 06, 2017 End Date: Aug 13, 2017 Tuition: $555.00
Campus: Executive Park Instructor: Karen Maddox-Jones Register
Section: MS-PROJECT (07OCT17) -- Learn More...
Start Date: Oct 07, 2017 End Date: Oct 14, 2017 Tuition: $555.00
Campus: Executive Park Instructor: Karen Maddox-Jones Register
Section: MS-PROJECT (14FEB18) -- Learn More...
Start Date: Feb 14, 2018 End Date: Feb 15, 2018 Tuition: $555.00
Campus: Executive Park Instructor: Karen Maddox-Jones Register

Winning Documents with Word: Word for Business


Chances are that you have used Microsoft Word at work to write reports and letters, but you might be missing out on skills that can improve your workflow. You’ve probably created tables before, but did you know that you can create tables from text and text from tables while also integrating Excel formulas like SUM and AVERAGE? If you ever get tired of changing the font and margins in a document, you will love learning how to create a new document with everything just the way you like it so you can start working without fiddling with those options. You may have used Mail Merge once or twice, but did you know it allows you to quickly create personalized letters, mailing labels, and certificates with just a couple of clicks? Finally, you’ll learn to build, edit, and secure a Word form for others to complete and save data.

Audience: This course is designed for those who are current users of Word who want to learn to perform more complex tasks and functions. It is not an introductory course and is for intermediate/advanced users of Word. This course builds on “Winning Documents with Word: Word for Writers.”

Software: The material in this course will apply to Word 2007/2010/2013/2016 with a concentration on Word 2010/2013/2016. It is not designed to apply to Word for Mac.

After completing this course, you will be able to:
  1. Create and edit Word tables for databases and forms
  2. Effectively using and modifying tabs
  3. Save and reuse documents as a template
  4. Using Mail Merge for letters, agreements, and labels
  5. Creating and editing Word forms
Section: MS-WORD-BUSINESS (02NOV17) -- Learn More...
Start Date: Nov 02, 2017 End Date: Nov 02, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register

Winning Documents with Word: Word for Writers


Most people have used Word to write letters or reports, but few people know all of the time-saving shortcuts that you will learn in this course. If you are a technical writer, novelist, or anyone responsible for creating or maintaining large documents like orientation manuals or policies and procedures, your job might get a lot easier. This course will teach you how to customize virtually every element of a Word document from the title page to the index and every header, footer, and photo in between.

Audience: This course is designed for those who are current users of Word who want to learn to perform more complex tasks and functions. It is not an introductory course and is meant for intermediate users.

Software: The material in this course will apply to Word 2007/2010/2013/2016 with a concentration on Word 2010/2013/2016. It is not designed to apply to Word for Mac.

After completing this course, you will be able to:
  1. Customize options in Word and the Quick Access Toolbar
  2. Increase productivity with shortcuts, tips, and tricks
  3. Apply best practices for creating/maintaining large documents
  4. Create and edit Word themes, colors, and fonts
  5. Save time and typing with custom AutoCorrect and AutoText entries
  6. Use Styles and headings to create the outline and structure of a large manual
  7. Insert and modify a Title Page, Table of Contents, Index, Headers/Footers, and other elements
Section: MS-WORD-WRITER (24OCT17) -- Learn More...
Start Date: Oct 24, 2017 End Date: Oct 24, 2017 Tuition: $185.00
Campus: Executive Park Instructor: Greg Creech Register