CS 399 - Advanced Usage of Spreadsheets

  1. Introduction to MS Excel. Getting Started. Some tips. 2. Excel Formulas.
  2. Conditional Statements and logical operators
  3. Common Excel statistical functions
  4. Lookup and reference functions 6. Text functions.
  5. Date and time functions
  6. Formula-Based formatting
  7. Dynamic Array Formulas
  8. Create and modify tables. Table references.
  9. Charts: Radar, Bar, Column, Line, pie, XY SCATTER, Stock, Smart Art, Sparklines. 12. Introduction to pivot table.
  10. Introduction to Macros.

Course Information

Discipline(s):

Computer Science

Term(s) Offered:

Fall
Spring

Credits:

3

Language of instruction:

English

Contact Hours:

45

Prerequisites:

None

Browsing Courses?

To keep track of the courses, programs, blogs, destinations, and news that you're interested in, create an account and start favoriting. Already have an account? Log in.

Create an Account