Feel comfortable with Excel basics but want to advance to an intermediate level? In this 7-hour in-person class in our hands-on computer lab, you’ll learn advanced tools for analysis, organization and presentation of more complex data. Practice using more elaborate functions, creating ranges and tables, data validation, conditional formatting and advanced charts. A highlight is learning to wield the popular and powerful feature of PivotTables, a highly effective tool for dynamic data summarization. Coursebooks, practice files used during class and dozens of additional test worksheets with solutions are also provided for further practice, or even as templates in your future builds. Excel 1 is strongly recommended but not required.

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.