BIT 200 - Spreadsheets with Business Applications


This course provides a comprehensive introduction to Microsoft Excel. Students learn foundational spreadsheet skills including formatting, formulas, functions, and chart creation, and progress to more advanced tools such as PivotTables and macros. Emphasis is placed on applying Excel techniques to real-world business scenarios and producing professional, data-driven documents.

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

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

  1. Create and format workbooks, text, and data effectively.
  2. Use formulas and functions to solve business-related problems.
  3. Create and interpret charts, graphs, PivotTables, PivotCharts, and data tables.
  4. Apply financial tools and functions, perform what-if analysis, and use macros.
  5. Work with foundational business intelligence concepts.
  6. Apply artificial intelligence tools and techniques to solve real-world problems, enhance decision-making, and improve efficiency within a business or professional context, while demonstrating awareness of ethical considerations and data integrity.




Print-Friendly Page (opens a new window)