Excel Advanced Seminar - Prof. Andrea Covini
The teaching is aimed at improving the ability of participants to use the spreadsheet program Microsoft Excel.
Advanced Excel
Microsoft Excel Advanced Seminar by Andrea Covini
The teaching is aimed at improving the ability of participants to use the spreadsheet program Microsoft Excel in a more advance way.
At the end of the course, the participants, thanks to the practical and interactive lessons, will be able to use the most important tools available in the Microsoft Excel program, such as scenarios, solvers, pivot tables, and new functions. They will also be able to collaborate online, protect the workbook and share it with others. Participants will be also introduced to the programming Excel using macros and basic VBA commands.
The lessons are practical so participants need to bring their own PC in order to follow the exercises that are given during the lesson.
Participants needs to have basic knowledge of a spreadsheet program in order to be able to follow the course.
TIMETABLE
|
TOPIC |
DATE |
TIME |
|
Data management and organizing information |
29.04.2021 |
16:00 - 20:00 |
|
Functions: date and time, math and statistical, text |
06.05.2021 |
16:00 - 20:00 |
|
Advanced charts and What-If tables |
13.05.2021 |
16:00 - 20:00 |
|
Pivot tables |
20.05.2021 |
16:00 - 20:00 |
|
Macro & VBA |
27.05.2021 |
16:00 -20:00 |
|
FINAL TEST |
03.06.2021 |
TBD |
FINAL TEST AND FREQUENCY
In order to obtain the 3 CFU credits for the extra activities, the students are required to pass a practical exam on a computer, based on 30 questions aimed to verifying the knowledge and abilities stemming from the participation to the course.
Only students attending at least 80% of the scheduled lessons will be allowed to sit for the exam in order to obtain the 3 CFUs valid for the Extra-Activities.
The lessons of the course will be delivered online
Microsoft Teams Code: qf44rst
IIMPORTANT: the maximum number of participants is around 60/70 students
CONTACTS
MSc BA Programme Office: study@mscba.uniroma2.it
Andrea Covini: andrea.covini@uniroma2.it