- Docente: Francesco Bergamaschi
- Language: English
- Teaching Mode: In-person learning (entirely or partially)
- Campus: Forli
- Corso: First cycle degree programme (L) in Economics and business (cod. 9202)
Learning outcomes
This crash course provides the basis for the Computational Tools course: the basics of spreadsheets and data management, mostly in MS Excel.
Course contents
Important information: this crash course provides the basis for the Computational Tools course: the basics of spreadsheets and data management, mostly in MS Excel. It is mandatory to attend, in order to be able to succeed in the Computational Tools course.
MS Excel spreadsheets, general functions, primary keys, calculated fields, vlookup and pivoting techniques.
Basics of Accounting for business decisions: variable and fixed costs, break-even point, contribution margin.
Readings/Bibliography
McFedries / Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets, Wiley, 2010 (2nd edition).
Teaching methods
Lectures and practical applications in laboratory.
Assessment methods
No formal final test is scheduled, as this is a crash course.
Teaching tools
Blackboard, slides, practical applications in laboratory.
Office hours
See the website of Francesco Bergamaschi