The Excel Certificate Program, provides a practical, hands-on approach to learning how to use a powerful productivity tool that is generally already available to employees. Courses are designed to build competency with increasingly sophisticated features in a way that allows employees to apply them immediately and effectively in the workplace. The program will consist of 5 courses: Basic Excel, Intermediate I Excel, Intermediate II Excel, Advanced Excel and Excel Applications. Each class will last 4 hours from 8AM - Noon.
JANUARY 30TH: BASIC EXCEL
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.
FEBRUARY 6TH/FEBRUARY 13TH: INTERMEDIATE EXCEL
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. 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! Intermediate Excel will be divided into 2 separate courses over a 2-day period to dive deeper into the features at a master skills level prior to the Advanced Excel course.
FEBRUARY 20TH: ADVANCED EXCEL
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!
FEBRUARY 27TH: EXCEL APPLICATIONS
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.... More >><< Less
from Thursday, January 30, 2020 8:00 AM
thru Thursday, February 27, 2020 12:00 PM