Excel Certificate Program

4 hour course

Does your job require you to work with Microsoft Excel? This course provides the straightforward foundation you need to utilize a spreadsheet for business applications. Design concepts, databases, charts, and macros will be examined thoroughly along with the major built-in functions. Students will design several spreadsheets both in and out of class to solve specific business problems.

Learning Outcomes:

• Understand entry and use of the three data types, use of menus and use of commands
• Practice cell addressing and manipulation
• Demonstrate saving, creating and printing spreadsheets and graphs

4 hour course

Once you’ve mastered the basics, you’re ready to move on to our Intermediate Excel course which will introduce you to charting features and database management in Microsoft Excel 2013. You will design worksheets that meet Excel criteria for database functions such as sorting and filtering. In addition, you will cover the following: database design criteria, subtotals, PivotTables, and PivotCharts. With Excel, you’ll learn to work smarter, not harder! (Upon request, course can be divided up into Intermediate Excel 1 and Intermediate Excel 2—both 4 hour courses.)  

Learning Outcomes:

• Learn how to link sheets and files together
• Demonstrate how to use the conditional functions
• Understand how to use essential list management

4 hour course

See just how much Excel can do! In this course, you will work on creating action queries and macros, linking to and grouping worksheets to create a workspace in excel, using pivot tables and charts, integrating Excel into Word and PowerPoint and finally, working with goal seeking and more advanced formulas. You have many more possibilities with Excel than you think—taking this course will be a helpful eye-opener about a program that’s probably already on your computer!   

Learning Outcomes:

• Understand complex functions in Excel
• Demonstrate understanding of how to integrate Excel into other MS programs
• Familiarize self with more advanced formulas

4 hour course

Once you have learned some of Excel’s many features, it’s time to apply them in Excel Applications! Excel Applications is a comprehensive problem solving approach that incorporates Excel into real world applications. The case study approach helps you understand the functionality of Excel in today’s workforce. In a work environment, time is a scarce resource; by attending this class, you will not only learn better ways to use Excel, but you will also learn additional features and apply them in practical applications.

Learning Outcomes:

• Understand the underlying functionality of Excel to become more productive
• Develop an exercise-oriented approach that allows learning by doing
• Demonstrate how to use Excel in other Microsoft Office products