The page uses Browser Access Keys to help with keyboard navigation. Click to learn moreSkip to Navigation

Different browsers use different keystrokes to activate accesskey shortcuts. Please reference the following list to use access keys on your system.

Alt and the accesskey, for Internet Explorer on Windows
Shift and Alt and the accesskey, for Firefox on Windows
Shift and Esc and the accesskey, for Windows or Mac
Ctrl and the accesskey, for the following browsers on a Mac: Internet Explorer 5.2, Safari 1.2, Firefox, Mozilla, Netscape 6+.

We use the following access keys on our gateway

n Skip to Navigation
k Accesskeys description
h Help
Website Catalog
SUNY Broome Community College
  Feb 17, 2018
Website Catalog
[Add to Portfolio]

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.

[Add to Portfolio]