Great news! GHC has a brand new website. For the most current news and information please visit our new site at www.highlands.edu.
Home > Continuing Education > Microsoft Excel Proficiency Certificate
Printer Friendly Version

 

Microsoft Excel Proficiency Certificate

 

Microsoft Excel is one of the most heavily used software programs in the business environment.  It offers tremendous capability to users who need to calculate, analyze, and present numerical data.  Extensive knowledge of this software program will increase your chances for a career with better pay and increased job security.

The Center for Continuing Education at Georgia Highlands College now offers a proficiency certificate in Microsoft Excel for those adults who wish to become skilled in this application program’s broad array of features that simplify working with numerical data.

This certificate program is 36 hours in length, consisting of six (6) 6-hour courses that must be completed within six months (6) of start.  All courses must be completed before the certificate is awarded.  The certificate requires that three (3) fundamental courses be taken first, and the remaining three courses can then be selected from six (6) more advanced courses that are available.

The courses available for the certificate are:

Required Courses (3)

Excel Level I

Excel Level II

Excel Level III

Optional Advanced Courses (any 3)

Excel Data Analysis

Excel Charts

Excel Tables & Pivot Tables

Excel Functions

Excel VBA I

Excel VBA II

Excel VBA III

Excel Power Pivot I

Excel Power Pivot II

 

Course Details

Excel I—Beginning

You want to record numeric data faster? Now you can. In this course you will learn to create well-designed spreadsheets to store your important numeric data.  You will learn to automate repetitive data entry using Autofill and customized lists. Don’t like math? That’s OK. Excel will help you simplify your “number crunching” tasks.  Using time saving functions and formulas, you’ll be able to calculate your budget and forecast totals quickly.

This course covers the fundamental rules of relative cell addressing and Order of Precedence--essential knowledge for efficient use of formulas and functions, which will also be introduced.

Prerequisite: General ability to use a computer

 

Excel II—Intermediate

This course introduces Excel functionality for enhancing your worksheets for presentation purposes or for printing.  Students will learn how to use the Page Setup tools to adjust their worksheets with custom margins, page orientation, page breaks, and headers and footers. They will learn how to sort large spreadsheets; how to filter data and create advanced filters; how to group and summarize data; and how to insert subtotals. How to manage data within multiple worksheets and workbooks and how to link that data with formulas and named cells will also be covered, as well as a few more functions, including the IF function and the DATE and PMT functions.

Prerequisite:  Excel I or equivalent knowledge

 

Excel III—Extended Intermediate

This course continues to explore Excel functionality and introduces the student to the extensive variety of Excel templates that are available. The student will learn how to use macros to handle repetitive activities and how to attach them to buttons using the Developer Tab.  Enhancing a spreadsheet with conditional formatting and graphics will be covered, as well as features such as formula auditing; calculation options, comments; and how to protect a worksheet. A few more functions will also be covered, including the VLOOKUP function and ARRAY functions.

Prerequisite: Excel I and II or equivalent knowledge

 

Excel Data Analysis

This course teaches experienced Excel users how use Excel’s What-If tools: Goal Seeker, Solver, Scenario Manager, and Data Tables.  The student will learn how to install Excel’s add-in tool AnalysisPak that comes with  Excel but is not loaded, and  will explore using  it to create complex analyses such as Histograms, Rank and Percentile Analysis, and Descriptive Statistics.

Great course for managers who need to analyze data to make management  decisions!

Prerequisite: Excel I, II, and III or equivalent knowledge

 

Built-in Functions

Built-in Functions are formulas that Excel has predefined.  These functions are designed to quickly perform calculations with a minimum of effort on the part of the user.  Excel has already determined the necessary mathematical steps required and only needs to be given the arguments in order to complete the calculation—that is, the cell addresses or ranges where pertinent information is stored.  There are over 200 built-in functions in Excel 2007 and over 300 in Excel 2010. While a few commonly used functions were covered in Excel I, II, and III, this course covers a broader spectrum and introduces the student to a wide range of useful and versatile functions that most users haven’t discovered yet. 

Prerequisite: Excel I and II or equivalent knowledge

 

Excel Tables, Pivot Tables & Pivot Charts      

In this course the student will learn how to convert rows and columns of data into a table, and then use an Excel Table to manage that data independently from the data in other rows and columns on the worksheet. Table features include: sorting and filtering; formatting table data; inserting and deleting table rows and columns; using a calculated column; and displaying and calculating table data totals.

Pivot Tables are another powerful tool that can be used to summarize thousands of rows of data in a matter of seconds. You can then change your analysis on the fly by simply moving data from one area of the pivot table to another area.  You can group, sort, and filter pivot table data, perform calculations within the pivot table, and add and remove subtotals and grand totals with ease.  And finally, you can create charts that can be filtered on the fly just like the pivot table.

 Prerequisite: Excel I and II or equivalent knowledge

 

 Excel Visual Basic Application I

This course is designed to introduce the use of VBA programming within the Excel environment.  Programming basics, including logical concepts and the language of syntax, will be discussed as well as the basics of Excel’s Visual Basic Editor and the VBE windows.  Topics will include module design, function procedures, and decision loop statements.  Students will create custom messages and input boxes, and create custom Macros that make decisions and take action based on those decisions. 

Prerequisite:  Excel I & II or equivalent knowledge

 

Excel Visual Basic Application II

This course takes the student’s knowledge of VBA within Excel to the next level.  You will learn more about the VBA toolkit—the Visual Basic Editor, the Object Browser, and the Object Library, as well as how to debug and troubleshoot the programs you have designed through error handling and error trapping protocol.  Topics will include working with object properties, methods, and events to modify the appearance, behavior, and actions performed by Excel objects. Students will also learn how to create custom function procedures.

Prerequisite: Excel Visual Basic Application I

 

Excel 2013 PowerPivot I

PowerPivot is an Add-In that comes with Microsoft Office Professional Plus and Microsoft Office 365. If you are using these versions, you will now have the capability to perform powerful data analysis and create sophisticated data models. With PowerPivot, you can mash up large volumes of data from various sources that are stored in relational tables, perform information analysis rapidly, and share insights easily.

PowerPivot is stored in an analytical database inside the Excel workbook, and a powerful local engine loads, queries, and updates the data in that database. All data presentation and interactivity are provided by Excel 2013.  PowerPivot supports files up to 2GB in size and enables you to work with up to 4GB of data in memory.

This course will introduce the student to PowerPivot, Data Models, and DAX Formulas.  Hands-on exercises will be used to create a Data Model, which will then be used to create a PivotTable report.  The student will learn how to use DAX formulas to create two very useful expressions—calculated columns and calculated fields, which will then be used in the pivot table to assist in further analysis.

Prerequisite: Excel 2013 Pivot Tables

 

Excel 2013 PowerPivot II

This course continues to build the student’s knowledge of PowerPivot.  Many more DAX formulas will be covered and a variety of pivot tables will be used to create PowerView Reports.  PowerView Report is a new feature in Excel 2013 that is an interactive data exploration, visualization, and presentation tool.  You can create reports using your related tables in your Data Model as a source and add charts and maps, create a variety of visualizations, and add Key Performance Indicators (KPIs).

Prerequisite: Excel 2013 PowerPivot I

 

 

For further information on any class or to register, please call
678-872-8240 or E-mail gwhite@highlands.edu
Georgia Highlands College
The University System of Georgia
Rome, Cartersville, Acworth, Dallas, Douglasville and Marietta, Georgia
AA/EE/EEO Institution, ADA

Page last updated: April 18, 2016