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

Spreadsheet Applications Using Microsoft ^® Excel 2016

1. Learning Objectives
2. Background
3. Download the File
4. Protecting the Data
5. Formula Auditing
6. Data Integrity
7. Simple Data Analysis
8. What-If Analysis
9. Information Needs
10. Macros
11. More Advanced Macros
12. Database Functions
13. Introduction to PivotTable Reports
14. Detail in Reporting
15. Flexible Budgeting Using PivotTables
16. Creating Charts From PivotTables
17. Wrap-Up

General Ledger Applications Using Sage 50 ^® 2018

1. Learning Objectives
2. Requirements
3. Setting Up a New Company
4. Setting Up the General Ledger
5. Setting Up Beginning Account Balances
6. Setting Up User Security
7. Setting Up Accounts Receivable
8. Setting Up Accounts Payable
9. Setting Up Inventory
10. Setting Up Payroll
11. Entering Transactions
12. Transaction Set A
13. Month-End Procedures
14. Year-End Procedures
15. Transaction Set B
16. Transaction Set C

Database Applications Using Microsoft ^® Access 2016

1. Learning Objectives
2. Background
3. Requirements
4. Creating a New Database and New Table
5. Creating a Form
6. Ensuring Sequential Integrity
7. Creating Relations
8. Integrating Forms within Forms
9. Creating a Query
10. Creating a Report
11. Summary