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

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.