24 Hour CPE Support. Call or Text Msg 24/7/365. (813) 638-5985.

QuickBooks Pro 2012 [12 CPE Credits]
Category: Specialized Knowledge & Computer Applications
Summary: Author: L. Keith Jordan, CPA

Experience Level: Basic – Covers fundamental principles and skills. This level is for participants with little or no exposure to the subject matter.
Prerequisites: Some knowledge of QuickBooks is helpful but not required
Delivery Method: Interactive Self-Study
Course Formats: Online / CD-ROM / Textbook / Audio

Course ID: SK-107
CPE Credits: 12

Course Description:

Upon completion of QuickBooks Pro 2012, the student will be able to: identify, compare, and evaluate QuickBooks editions and versions, determine if QuickBooks meets company needs, and recommend the correct setup in single and multi-user environments; use QuickBooks to set up a new company file; identify basic elements of the QuickBooks Home page, define the role of lists and forms, and determine preference settings; identify features of the Chart of Accounts list, distinguish between accounts and subaccounts, locate non-posting accounts and contrast them to posting accounts; demonstrate how to classify and organize the Items list; describe QuickBooks payroll features and recommend from alternatives, employ user-defined fields to customize information, and demonstrate how to setup payroll information in QuickBooks; identify the basic elements of modifiable QuickBooks forms, and demonstrate how to use form options to modify and design these forms so that they better meet the needs of the entity; illustrate how to enter transactions in QuickBooks, use QuickBooks Fixed Asset and Loan control features, and demonstrate how to memorize and print transactions in QuickBooks; explain how to use the QuickBooks bank reconciliation feature, describe the options available, and determine the best approach for entering credit card transactions into QuickBooks; and utilize reports and graphs features available in QuickBooks, demonstrate how to export report data, and describe QuickBooks file maintenance utilities.
Start Date:  Monday, 06 February 2012
Enrolment duration: Unlimited

You need to log in to request this course

Specialized Knowledge & Applications

Customizing the Ribbon in Microsoft Excel 2007/10 [SK-101]

Course ID: SK-101

CPE Credits: 2

Cost: $29.99

Course Description:

The following training introduces you to Microsoft Excel 2007 and 2010 Ribbon customizations. You will learn how to add customized tabs and groups to Excel 2007 and 2010. You will learn to edit XML while working with the Custom UI Editor. You will also learn how to create and insert a Visual Basic Application (VBA) command into the Ribbon using the Visual Basic Editor.

More>>

Excel 2007 Pivot Tables and Pivot Charts [SK-105]

Course ID: SK-105

CPE Credits: 2

Cost: $29.99

Course Description:

This training document introduces you to using Pivot Tables and Pivot Charts within Excel 2007. You will learn how to use pivots to manipulate data available in an Excel spreadsheet. You will work with columns and rows, and learn how to summarize data, such as the Sum and Average functions. You will learn how to open and use PivotChart Tools, including chart types, chart designs, and add chart titles. This training will also instruct how to import data from an external source.

More>>

Microsoft Word 2007 [MS-923]

Course ID: MS-923

CPE Credits: 10

Cost: $149.99

Course Description:

The Smart way to Learn Microsoft Office Word 2007 One Step at a Time Experience learning made easy - and quickly teach yourself how to create impressive documents with Word 2007. With Step by Step, you set the pace - Building and Practicing the skills you need, just when you need them.

More >>

Outlook 2007 [SK-104]

Course ID: SK-104

CPE Credits: 7

Cost: $89.99

Course Description:

In this training document you will learn about Outlook 2007, and its components. You will learn the steps to setup Outlook for a POP3 mail server. This document will teach you about the components of Outlook, including Mail, Calendar, Contacts, Tasks, Notes and Jouran.

More>>

Using Microsoft Excel for Financial Analysis [SK-102]

Course ID: SK-101

CPE Credits: 3

Cost: $49.99

Course Description:

Upon Completing this Course you will be able to:
1. Learn what a formula is.
2. Learn how to use Relative References.
3. How and when to use Absolute References.
4. How Excel uses Operator Precedence when calculating formulas.

More>>

Using SQL View in Microsoft Access 2007 [SK-106]

Course ID: SK-106

CPE Credits: 3

Cost: $49.99

Course Description:

In this course you will learn to work with Design View and SQL View within Access 2007 to create queries. This course will also show how to calculate within the Access database using aggregate functions and operators for computation. This course is designed for moderate to intermediate users of databases.

More>>

Visual Basic for Applications in Excel 2007 [SK-103]

Course ID: SK-103

CPE Credits: 3

Cost: $49.99

Course Description:

This training is designed as an introductory course to Visual Basic for Applications (VBA) for Excel 2007. You will learn what VBA is, and how it is used in Excel to create programs that will enhance your daily grind. You will learn how to write the code to create a calculator, how to add new worksheets to a workbook that duplicates an existing worksheet, and you will learn how to create a time logging application (DayLogger) that allows you to start and end time as you work on a client’s job, and then calculates the time spent and logs it to a spreadsheet.

More>>