Login
Student authentication

Is it the first time you are entering this system?
Use the following link to activate your id and create your password.
»  Create / Recover Password

Syllabus

EN IT

Updated A.Y. 2021-2022

Microsoft Excel is a spreadsheets program that, due to its extreme versatility and power, has become one of the most-used software programs in the business world since its launch in 1985.

This course introduces the student to all the important fundamental and advanced features of Microsoft Excel and it is structured to give maximum “hands-on” experience to the students. In order to attain this, participants are asked to bring their own personal computer to work on. Microsoft Excel has to be installed on the computer.

This course requires no prerequisite knowledge in Excel but a Knowledge of Windows/MAC OsX and experience with a computer is essential.

What is a spreadsheet and what you can do with it
Create your first table
Working on workbooks
Selection
Formatting
Formulas and Functions
Error messages
Charts
Printing
Advanced formatting of data and spreadsheets
Data management: link, sort, filter and sub-totals
Protection of cells, spreadsheets and workbooks
Advanced functions and charts
What-if tables and scenarios
Pivot tables
Auditing and solver tool
Macro and VBA