Contents
Catalog Links

CSC-212 MS Excel for Business Applications

This course offers students the opportunity to master the advanced functionality of Microsoft Excel, and to apply those skills to genuine business applications such as financial modeling, reporting, and the automation of accounting and financial tasks. Although the basic functions of Excel will be covered, areas of focus include graphs and charts, the use of advanced financial functions and analytical tools, reporting templates, linking of worksheets and workbooks, importing and manipulating data, macros (automation of tasks), auditing tools, and other features especially useful to the financial or accounting professional.

Credits

3

Cross Listed Courses

BUS-212

Prerequisite

MAT-110 or Math Level 1 Placement

Lecture Contact Hours

3

Lab Contact Hours

0

Other Contact Hours

0

Department

  • Business

Grading Scheme

  • Letter

SUNY Gen Ed Credit

  • No

Course Learning Outcomes

  1. Create a plan for effective workbook and worksheet design
  2. Manage large volumes of data through the use of Tables in Excel
  3. Explain the fundamentals of table design and create a table in Excel
  4. Determine appropriate use pivot tables to group and ungroup data in Excel
  5. Create a pivot table in Excel
  6. Explain the appropriate use of one-variable and two-variable tables in Excel
  7. Explain the appropriate use of conditional math and statistical functions in Excel
  8. Analyze and manipulate data in Excel through the use of mathematical and statistical functions
  9. Link excels workbooks to manage and combine data sets
  10. Explain the purpose and procedure for Web Query for Excel
  11. Import data into Excel from external web sources
  12. Plan, design, create and manage Excel worksheets
  13. Identify some of the various templates available for Excel and explain their appropriate use
  14. Identify and utilize the appropriate formatting for data in Excel
  15. Identify appropriate mathematical processes necessary to achieve a result in Excel
  16. Create mathematical formulas in Excel
  17. Devise formulas utilizing relative, absolute and mixed cell references in formulas in Excel
  18. Explain about specific mathematical and statistical functions in Excel and their use in cell formulas
  19. Describe how various charts can be used to represent quantitative data in in Excel
  20. Determine appropriate chart style to represent data; use date to create and revise chart in Excel