a) Be able to manage datasets, tables and pivot tables to filter, sort and summarize data.
b) Be able to perform data analysis processes to make predictions and simulations.
c) Be able to manage a worksheet as a database making use of the proper functions to perform queries, filter, etc.
d) Be able to manage the audit, debug and trace capabilities of a spreadsheet tool.
e) Know, understand and apply functions to create logical expressions to filter data and to make decisions.
f) Know, understand and apply functions to manage text-based resources.
g) Know, understand and apply functions to generate descriptive statistics from data.
h) Know, understand and apply functions in the area of social sciences.
i) Know, understand and create different types of charts.
i) Know, understand, create and customize different types of charts.
j) Be able to manage and customize a spreadsheet for printing and data publishing.
k) Be able to create dashboards using different elements.
l) Be able to automate tasks: use of macros.