Training - Course Catalog

Training - Course Catalog
Class Schedule

Course Title	CPE Hours Awarded	Skill Level
Business Writing		Beginning
Financial Planning 101	2 hours other	Beginning
Inventory in Quickbooks	2 hours Accounting	Beginning
Microsoft Excel	2 hours other		Advanced
Advanced Formulas in Excel			Advanced
Microsoft Outlook	2 hours other		Advanced
Quickbooks	3 hours Accounting	Beginning	Advanced
Quickbooks for Non-Accountants	2 hours Accounting	Beginning
Understanding Financial Statements	2 hours A&A	Beginning

Financial Planning 101

This comprehensive introduction to Financial Planning for Individuals will provide attendees the opportunity to learn constructive and useful principles that can be applied to their own financial situations. Issues ranging from retirement and education planning, to asset allocation and risk management will be discussed. The focus will be on helping attendees learn how to quantify macro financial goals and begin to determine tactical strategies that can help those goals become reality.

A detailed presentation along with handouts and workbooks will be provided. There will also be ample time for Q & A with professional staff of our financial planning group.

Cost: $95 per attendee or $150 per couple

Class Location: HA&W Offices (Atlanta)

Inventory in Quickbooks

Purpose: To teach setup, correct use, correct adjustments, and accurate reporting.

Audience: Only for clients who use weighted average cost. Not for first in/first out and last in/first out (LIFO/FIFO).

Topics Covered:

Tracking inventory with QB
Activating the Inventory Function
Setting up Inventory Items Parts
Setting up Group Items

Calculating Average Cost of Inventory
Invoicing for Inventory Items
Using Purchase Orders
Receiving Inventory

Entering Bills for Received Inventory
Adjusting inventory (main emphasis in class)
Inventory Assemblies
Creating Inventory Reports (main emphasis in class)

Class Location: HA&W Offices (Atlanta)

Advanced Microsoft Excel

Session Description: This session’s focus will introduce the Excel user to the structure of a formula and the common functions.

At the completion of this session the team member will:

be able to use formulas to perform calculations
know how to use cell names to perform calculations
be familiar with relative and absolute references
be familiar with the following functions and recognize the format of a formula:
- =sum – add cells together
- =max – find the highest value of selected cells
- =min – find the lowest value of selected cells
- =average – find the average value of selected cells
be able to copy a formula to adjacent cells
know how to display formulas in a worksheet
know how to enter functions using the formula palette
be able to use the now date function
know how to use the logical if function
be able to use the financial functions fv and pmt
be familiar with the auditing feature for formulas
be able to link objects in worksheets and consolidate data
know how to hide and unhide rows and columns
be able to freeze and unfreeze rows and columns
be familiar with the zoom setting in a worksheet

Class Location: HA&W Offices (Atlanta)

Advanced Formulas in Excel

Session Description: This session’s focus will introduce the Excel user to the array formula and nested formulas.

At the completion of this session the team member will:

be able to use formulas to perform calculations
know how to use cell names to perform calculations
be familiar with relative and absolute references
know how to use the logical if function

Class Location: HA&W Offices (Atlanta)

Microsoft Outlook

Topics Covered:

Calendar
Tasks
Automatic Signature

Journal
Rules Wizard
Mailing Labels

Setting Home Page
Voting Options

Class Location: HA&W Offices (Atlanta)

Business Writing

Session Description: This session will work on improving the individual’s writing skills.

At the completion of this session the team member will:

identify active/passive voice
be more aware of rules of capitalization
have a cheat sheet of phrases
know more ways of editing
be able to check sentences for parallelism
be able to prewrite
be more aware of punctuation rules
be able to write better

Who should attend? Anyone needing help with writing

Class Location: HA&W Offices (Atlanta)

Beginning Quickbooks

Topics Covered:

What's New in QuickBooks?
QuickBooks Look and Feel
How Transactions Work in QuickBooks
Using QuickFill to speed up data entry
Managing Revenue (Sales)
The Steps Involved with Tracking Revenue Transactions
Setting up Customers and Jobs
Custom Fields
Recording Cash Sales and Invoices
Recording Payments from Customers
Recording Customer Discounts
Applying Payments to Customer Invoices
Undeposited Funds Recording Customer Returns and Credits
Refunding Customers by Check or Credit Card
Customer Statements
Writing off Bad Debts
Making Deposits

Transferring Money Between Accounts
Managing Expenditures Setting up Vendors in the Vendor List
Using Classes to Separate Income and Expenses
Managing Accounts Payable
Entering Bills
Job Costing in QuickBooks
Paying Vendors by Check or Credit Card
Partial Payments of Bills
Taking a Discount when Paying a Bill
Printing Checks
Voiding Checks
Creating and Applying Vendor Credits
Tracking Petty Cash
Tracking Credit Cards
Bank Accounts and Reconciliation
Reconciling with your Bank Statement
Finding Bank Reconciliation Errors
Correcting Errors in the Checking Account

Correcting Transactions in Closed Accounting Periods
Handling Bounced Checks Reports and Graphs
QuickReports
List Reports
Analysis Reports Accounts Receivable and Accounts Payable Reports
Customizing Reports Memorizing Reports
Setting up Budgets and Using Budget Reports Exporting Reports to Excel QuickBooks Graphs
Setting up a Company File The EasyStep Interview vs. The Sleeter Group's 12-Step Setup process
Choosing a Start Date
Modifying the Chart of accounts
Understanding QuickBooks Equity Accounts
How QuickBooks Items are Used
Setting up Sales Tax and Preferences
Entering Opening Balances
Closing Opening Balance Equity to Retained Earnings
Verifying your Opening Balance Sheet
Setting Up Users of the File and Assigning Privileges
Modifying Sales Forms
Layout Designer ...and more!

Resource Materials Used: Reference book covering topics

Class Location: HA&W Offices (Atlanta)

Advanced Quickbooks

Topics Covered:

Pass Through Expenses
Reimbursable Expenses
Using Two-Sided Items in QuickBooks Pro
Custom Orders—Using Non-Inventory Parts
Tracking Subcontractors
Invoicing for Billable Time
Setting Up Payroll
Checklist for Setting up Payroll
Activating Payroll
The Payroll Setup Wizard
Payroll Items
Employee Defaults
Setting up Employees
Set up Year-To-Date Amounts
Payroll Checkup
The Accounting Behind the Scenes
Releasing and Deactivating Employees
Mid-Year Payroll Setup Payroll Processing
Updating Your Payroll Tax Tables

Paying Employees Paying Payroll Liabilities
Payroll Reports
Processing Form 941 and other Payroll Tax Returns
Using a Payroll Service
Configuring QuickBooks for Using a Payroll Service
2 Methods for Entering Transactions
Job-Costing when Using a Payroll Service
Inventory
Activating Inventory in Preferences Setting up Inventory Items
Average Cost of Inventory
Selling Inventory Items The Accounting Behind the Scenes of Inventory
Purchase Orders
Receiving Inventory Items and Linking to the PO
Entering Bills for Received Inventory Capitalizing Freight-In Adjusting Inventory
Inventory Reports
Sales Tax Setting Up Sales Tax
Sales Tax Items and Groups
Setting Sales Tax Defaults for Items and Customers

Collecting Sales Tax
Handling Non-Taxable Sales, Government Sales, Reseller Sales
Adjusting Sales Tax Paying Sales Tax
Estimates
Creating Estimates
Creating Invoice from Estimates
Viewing Reports about Estimates and Actuals
Time Tracking Setting up Time Tracking
Entering Time Sheets for Employees and/or Vendors Printing Timesheets
How Timesheets feed Payroll
Invoicing for Billable Time
Time Reports
Adjustments and Year-End Processing
Processing 1099s
Editing, Voiding and Deleting Transactions Adjustments and General Journal Entries
Tracking Asset Cost and Depreciation
Memorizing Transactions
Closing the Year
Tracking Loans
Importing and Exporting Data from QuickBooks

Resource Materials Used: Reference book covering topics

Class Location: HA&W Offices (Atlanta)

Quickbooks for Non-Accountants

Description: This session will work on teaching the non-accountant the basics of QuickBooks.

At the completion of this session the individual will:

know how to do accounts payable
know where to locate and use bank accounts
know how to take and record customer payments
know some of the most-used features

know how to record deposits
know how to entering bills
know how to handling bills
know how to run reports

know how to reconciliation
know how to record sales and invoices
know how to transfer money

Who should attend? Business owners, non-accountants

Program Length: 2 hours

Cost: $100

Location: HA&W Offices (Atlanta)

Understanding Financial Statements
What you can measure, you can manage.

Audience:
Business owners, controllers, CFOs, office managers

Scope:
Financial statement analysis for privately-owned companies

In a struggling economy, only the strong companies will survive. You can enhance your company’s position by understanding the crucial information presented within your financial statements.

Financial statements provide analytical information about a company’s financial position, changes in those positions over time, and overall performance. Owners and managers require timely financial statements to make important business decisions that impact continued operations.

Certain third parties will also extract information from your financial statements to gather insight about your company’s performance. For example, a financial institution (bank or lending company) may review your financial statements to determine whether to extend a loan or line of credit to your company.

Users of financial statement information do not necessarily need to know everything about accounting to use the information in basic statements. However, to effectively use financial statement information, it is imperative to understand a few basic concepts and to be familiar with some of the fundamental characteristics of your company’s financial statements.

Objectives:
Upon completion of this course, participants will be able to:

Interpret the information presented on the three basic financial statements and how they correlate:
- Balance sheet
- Statement of income and retained earnings
- Statement of cash flows
Analyze changes and recognize trends in your company’s financial performance
Realize the importance of consistent, accurate and timely bookkeeping
Know how third parties will utilize the information in the financial statements

Cost: Special Limited Time Offer!! $100.00

Location: HA&W Offices (Atlanta)