CS 399 - Advanced Usage of Spreadsheets
- Introduction to MS Excel. Getting Started. Some tips. 2. Excel Formulas.
- Conditional Statements and logical operators
- Common Excel statistical functions
- Lookup and reference functions 6. Text functions.
- Date and time functions
- Formula-Based formatting
- Dynamic Array Formulas
- Create and modify tables. Table references.
- Charts: Radar, Bar, Column, Line, pie, XY SCATTER, Stock, Smart Art, Sparklines. 12. Introduction to pivot table.
- Introduction to Macros.
Course Information
Discipline(s):
Computer Science
Term(s) Offered:
Fall
Spring
Credits:
3
Language of instruction:
English
Contact Hours:
45