CS 399 - Advanced Usage of Spreadsheets

1. Introduction to MS Excel. Getting Started. Some tips. 

2. Excel Formulas. 

3. Conditional Statements and logical operators 

4. Common Excel statistical functions 

5. Lookup and reference functions 

6. Text functions. 

7. Date and time functions 

8. Formula-Based formatting 

9. Dynamic Array Formulas 

10. Create and modify tables. Table references. 

11. Charts: Radar, Bar, Column, Line, pie, XY SCATTER, Stock, Smart Art, Sparklines. 

12. Introduction to pivot table. 

13. Introduction to Macros.