Basic and advanced knowledge and applications in the use of Microsoft Excel, to learn about the most common and most requested functions by the job market (i.e., statistics, financial decisions, budgeting and controlling, ...).
Teaching Methods
Lectures, exercises and assignments to be discussed in class.
Assessment Methods
Written exam/Final assessment with Excel application.
Contents
The course will be divided into the following topics: Data entry and basic functions; Data integration; Filters, pivot tables and conditional formatting; Statistical-mathematical and financial functions; Data representation.