Filter by Subcategory
Computer Applications
MS Excel - Level 1
with Michael Stephens

Excel - Level 1 teaches the basic concepts and skills needed for you to start being productive with Microsoft Excel, and it’s a strong start on the journey towards becoming an Excel Expert. We’ll cover how to create and format worksheets that contain calculations with formulas and functions, including how to use proper reference types. Moving and copying data correctly, basic chart creation and various other tips and tricks are also covered. Books are provided, along with classroom hands-on-keyboard activities. For students who might be considering the optional Microsoft Office Specialist Excel Associate and Expert exams, this course along with Excel 2 and Excel 3, map to the objectives of both exams.
MS Excel - Level 2
with Michael Stephens

Excel - Level 2 is a continuation of the journey into an Excel Expert. We’ll cover more advanced tools for analysis, rearrangement, and presentation of more complex, yet realistic data. We’ll also delve into managing workbooks with more elaborate functions, ranges, tables, validation and summarizing tools like consolidation and subtotaling. The very popular and powerful feature of PivotTables and conditional formatting, along with more advanced charts will be taught. Books are provided, along with classroom hands-on-keyboard activities. For students who might consider the optional Microsoft Office Specialist Excel Associate and Expert exams, this course along with Excel 1 and Excel 3, map to the objectives of both exams. Excel 1 is strongly recommended prior to taking this class, but it is not required.
QuickBooks Online
with Bridgette White

This face-to-face course will cover the online version of QuickBooks, Intuit's accounting software for small businesses. There will be a teaching component and opportunities for hands-on practice. You’ll learn about setting up and creating a company, modifying the chart of accounts, working with multiple lists, invoicing, processing payments, working with bank accounts and bank/credit card reconciliation, entering and paying bills, customizing forms, creating reports and graphs, tracking and paying sales tax and preparing payroll. A basic understanding of computers and accounting knowledge is recommended for this class.