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.

Course Information

Discipline(s):

Computer Science

Term(s) Offered:

Fall
Spring

Credits:

1

Language of instruction:

English

Contact Hours:

15

The World is Your Classroom

Take courses at our Centers abroad, directly enroll at a local partner university, or build a schedule with courses from both. Use the Course Finder to explore all the courses offered at our IES Abroad Centers. Additional course options at prestigious local universities are available on the program page and partner university websites.

Browse Our Courses