Course Details
Country:
Spain
Institution:
Universidad Carlos III de Madrid
Course Title:
Advanced Knowledge of Spreadsheets
Course Number:
17639
Course Description:
Teaching Unit 1: A first contact
1.1-Structure of a spreadsheet: book, sheets and cells.and basic operations
1.2-Working with cells and sheets, data import and references.
1.3-Task automation for this unit
Teaching unit TU2: Building, understanding and exploiting data.
2.1-Formula and functions
Boolean operators and functions
Text
Database
Descriptive statistics
2.2-Tables and pivot tables
2.3-Data analysis
2.4-Task automation for this unit
Teaching unit TU3: Representation of data and information, task automation and applications
3.1-Visualization (pivot charts)
3.2-Spreadsheet applications: forms, mail merge, printing, document generation, etc.
3.3-Task automation for this unit
Language:
English
Approved Equivalent:
INTS 399
Attachment Files:
Spreadsheets.pdf
