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 - Next Class begins January 2018
· Excel 2013 Intermediate 9 hours - $80 - Next Class begins January 2018
· Excel 2013 Advanced9 hours - $80 - Next Class begins January 2018
· Please check starting dates for all classes.
Excel 2013 Beginner
9 hours - $80 - Next Class January 2018
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 January 2018
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.
Excel 2013 Advanced
9 hours - $80 Next Class January 2018
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.
(18 Hours - 6 weeks) - $115 plus registration fee - Next Class begins January 2018
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 - Next Class begins January 2018
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.