Comprehensive Assurance & Systems Tool (CAST) -- Computerized Practice Set

Spreadsheet Applications Using Microsoft (R) Excel 2016



Learning Objectives
Background
Download the File
Protecting the Data
Formula Auditing
Data Integrity
Simple Data Analysis
What-If Analysis
Information Needs
Macros
More Advanced Macros
Database Functions
Introduction to PivotTable Reports
Detail in Reporting
Flexible Budgeting Using PivotTables
Creating Charts From PivotTables
Wrap-Up

General Ledger Applications Using Sage 50 (R) 2018



Learning Objectives
Requirements
Setting Up a New Company
Setting Up the General Ledger
Setting Up Beginning Account Balances
Setting Up User Security
Setting Up Accounts Receivable
Setting Up Accounts Payable
Setting Up Inventory
Setting Up Payroll
Entering Transactions
Transaction Set A
Month-End Procedures
Year-End Procedures
Transaction Set B
Transaction Set C

Database Applications Using Microsoft (R) Access 2016



Learning Objectives
Background
Requirements
Creating a New Database and New Table
Creating a Form
Ensuring Sequential Integrity
Creating Relations
Integrating Forms within Forms
Creating a Query
Creating a Report
Summary