Computerized Practice Set for Comprehensive Assurance & Systems Tool (CAST) Plus Peachtree Complete Accounting 2012

Computerized Module

2. Spreadsheet Applications Using Microsoft® Excel 2010

   2.1 Protecting the Data

   2.2 Formula Auditing

   2.3    Data Integrity

   2.4 Simple Data Analysis

   2.5 What-If Analysis

   2.6 Information Needs

   2.7 Macros

   2.8 More Advanced Macros

   2.9 Database Functions

   2.10  Introduction to PivotTable Reports

   2.11  Detail in Reporting

   2.12  Flexible Budgeting Using PivotTables

   2.13  Creating Charts From PivotTables

   2.15  Wrap-Up

 

3.  General Ledger Applications Using Peachtree Complete

  Accounting 2011®

  3.1 Setting Up a New Company

   3.2 Setting Up the General Ledger

   3.3 Setting Up Beginning Account Balances

   3.4 Setting Up User Security

   3.5 Setting Up Accounts Receivable

   3.6 Setting Up Accounts Payable

   3.7 Setting Up Inventory

   3.8 Setting Up Payroll

   3.9 Setting Up Payroll Formulas

   3.10  Entering Transactions

   3.11  Transaction Set A

   3.12  Month-End Procedures

   3.13  Year-End Procedures

   3.11  Transaction Set B

   3.11  Transaction Set C

 

4.  Database Applications Using Microsoft® Access 2010

   4.1 Creating a New Database and New Table

   4.2 Creating a Form

   4.3 Ensuring Sequential Integrity

   4.4 Creating Relations

   4.5 Integrating Forms within Forms

   4.6 Creating a Query

   4.7 Creating a Report

   4.8 Summary