Comprehensive Excel 2013 Certificate - See Classes and Schedule Below
In today’s competitive environment, most organizations rely heavily on Microsoft Excel to consolidate, analyze, and report financial information. By learning these advanced techniques, you can become more valuable to your organization or a prospective employer. You may sign up for an individual class or all three classes. To earn this certificate, you will need to successfully complete the following:
· Excel 2013 Beginner 9 hours - $80 - Wednesdays - February 1st ,February 8th, February 15th
· Excel 2013 Intermediate 9 hours - $80 - Wednesdays March 1st, March 8th, March 15th
· Excel 2013 Advanced 9 hours - $80 - Wednesdays - March 29th, April 5th, April 12th
Please check starting dates for all classes.
Excel 2013 Advanced
9 hours - $80 Class Begins Wednesday March 29th
- Prerequisite: Excel 2013 Intermediate or equivalent experience
Learn advanced Excel 2013 skills by creating, sorting, and filtering tables, generating subtotals and using outlining tools, utilizing advanced functions including lookups, analyzing data with pivot tables, and creating and running macros.
Wednesdays 6:00-9:00PM Online Registration
Advanced QuickBooks 2015
(18 Hours - 6 weeks) - $115 plus registration fee - Class Begins Monday March 27th
Prerequisite: QuickBooks experience or BEGINNING QUICKBOOKS
Learn how to create QuickBooks accounting reports, business management reports, graphs, custom reports, and how to export reports to Excel. Modify templates. Track inventory, work with purchase orders, adjust inventory, and create inventory reports. Learn about QuickBooks payroll. Set up a new QuickBooks company file and setup users and passwords.
Mondays March27th, April 3rd, 10th, 24th, May 1st, May 8th - 6 until 9PM Online Registration
Excel 2013 Beginner
9 hours - $80 - Next Class September 2017
Learn introductory Excel 2013 skills by creating spreadsheets in a logical step-by-step manner, formatting and editing worksheets, working with formulas and functions, designing and formatting cell contents, and learning time-saving shortcuts.
Excel 2013 Intermediate
9 Hours - $80 - Next Class September 2017
Prerequisite: Excel 2013 Beginner or equivalent experience
Learn intermediate Excel 2013 skills by creating and modifying charts, working with themes and cell styles, applying conditional formatting, working with date functions, navigating with cell names, and linking and sorting multiple worksheets.
Beginning QuickBooks 2015
(18 Hours - 6 weeks) - $115 plus registration fee - Next Class September 2017
QuickBooks is a powerful accounting system for small businesses. Learn how to manage and enter business transactions, track company sales, setup customers, receive payments from customers, make bank deposits, write off bad debt, create customer statements, and produce sales reports. Manage expenses by setting up and paying vendors, printing checks, tracking company credit cards, paying sales tax, and producing accounts payable reports. Reconcile bank and credit card accounts and learn how to handle bounced checks.
30 HOURS (10 Weeks) - $210.00 plus registration fee - Class Closed for Spring 2017
This is an entry level course designed to gain theory and hands-on experience using AutoCAD 2016. Students will learn the fundamentals and various components of a computer graphic system including how to draw and edit lines, circles, complex shapes and set-up and plan two dimensional drawings.