Accounting and Payroll Specialist

Business Math

Develop an understanding of the fundamentals of everyday math - the kind used most frequently in the workplace and at home. Learn practical applications for dealing with percentages, formulas, and the graphics and statistics that are present in everyday activity. Perfect even if you only need a refresher.

Accounting Essentials

Master basic record-keeping procedures including: journalizing transactions, posting to a ledger, and preparing a trial balance and financial statement. The accounting cycle will also be covered in detail. You will gain an understanding of key financial and operational measures.

Payroll Preparation Essentials

This hands-on course will lead you through the complete payroll process cycle. You will calculate earnings and deductions, analyze payroll transactions, record accurate journal entries, and complete necessary forms. This course is also for the existing payroll professional as a way to refresh your knowledge and bring you up to date. Prerequisite: Accounting Essentials or equivalent knowledge of basic accounting principles.

QuickBooks

This course is an introduction to the desktop version of QuickBooks. Students will learn to set up a general ledger and chart of accounts, customize forms, create invoices, and learn how QuickBooks can assist with automating your payroll. Prerequisites: Accounting Essentials and Payroll Preparation Essentials or equivalent knowledge of basic accounting principles.

Excel, Introduction

Learn how to create effective and efficient worksheets using formulas, common functions, formatting and printing.

Excel, Intermediate

Learn specialized functions, like IF, COUNTIF, and DSUM and how to effectively analyze, sort, filter data, create outlines, subtotals, range names, and work with tables. Display data more visually in charts, Pivot tables and charts and work with slicers and templates.

Outlook, Introduction

Make the most of your email communications. Learn to work with contacts and distribution lists. Find out how Outlook tasks can help with organization, and use the Outlook calendar to keep up with your busy schedule.

Organizing Computer Files

Do you have trouble organizing digital photos, documents, and downloads on your computer? Learn to use file management in the Windows environment. The topics include creating and working with folders, finding files, cut, copy, paste, and more.

Excel, Advanced

In this course, you will work with multiple worksheets, use LOOKUP functions and formula auditing, share and protect workbooks, automate workbook functionality with data validation and macros, create spark lines, and map data, and work with data tables, scenarios, goal seek, and forecasting data trends.