BIT 200 - Spreadsheets with Business Applications

A comprehensive look at Excel and its applications in business.  The course covers the basics of spreadsheet creation, functions, and formatting through the creation of pivot tables and macros.  This is all looked at with the goal of application to business scenarios and documents.

Credits: 3
3 Class Hours
Course Profile
Learning Outcomes of the Course:

Upon successful completion of this course the student will be able to:

  1. Create workbooks and properly format text and data.
  2. Work with formulas and functions. Especially those that relate to business case problems.
  3. Be proficient with chart and graph creation. What makes a good graph and a useful chart.
  4. Creation of pivot tables, pivot charts, and tables.
  5. Work with financial tools and functions.
  6. Perform what if analysis and work with macros.
  7. Work with the basic concepts of business intelligence.

Print-Friendly Page (opens a new window)