ACC 219 - Data Skills For Accounting

1.  Demonstrated the use of electronic spreadsheets' basic concepts.
   1. Use the features for entering values, labels, and formulas.
   2. Use the editing features.
   3. Use the basic “built-in-functions.”
   4. Discuss the terminology of electronic spreadsheets.
2.  Demonstrate electronic spreadsheets’ advanced features.
   1. Create and use named ranges.
   2. Differentiate between worksheet protection and locked cell properties.
   3. Effectively use various formatting options.
   4. Demonstrate the basic concepts of relating presentation graphics to sets of numbers.
   5. Create and manage charts on a worksheet.
3.  Use database features.
   1. Understand the basic concepts of table management.
   2. Perform sorts on table records.
   3. Perform queries within database records.
   4. Set up selection criteria and filtering of records.
   5. Manage interactive dashboards. 
   6. Implement the features of database management systems (DBMS) software.
   7. Demonstrate queries, sorting, indexes, labels, reports, updates, input forms, graphs, and calculations.
4.  Use Advanced Functions to aide in Data Analysis.
   1. Formulate advanced formulas using a variety of functions, including but not limited to, logical, financial, text, lookup, and statistical functions to solve problems.
   2. Perform a variety of what-if analyses.
   3. Use PivotTables and PivotCharts.
   4. Create macros in applications.
   5. Manage data from multiple worksheets and workbooks.
   6. Import and manage data from external sources.