- Docente: Francesco Bergamaschi
- Language: English
- Teaching Mode: Traditional lectures
- Campus: Bologna
- Corso: Second cycle degree programme (LM) in Business Administration (cod. 0897)
Learning outcomes
The Crash Excel aims to the aligne competences in the professional and advanced use of Excel in relation to the management of big data.
Course contents
Basic Data Management: VLOOKUP, primary keys, Excel standard pivot tables, calculated fields, graphs automations
Advanced Data Management: Power Pivot for Excel, measures, KPI, pivot table design, advanced calculations
Border Line Data Management and Data Science: Power BI Desktop stand alone and in conjunction with R for Statistics
Readings/Bibliography
McFedries / Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets, Wiley, 2010 (2nd edition).
Collie, Singh / Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016, 2016 (2nd edition).Teaching methods
Practical lectures in lab
Assessment methods
No final test, this is a crash course
Teaching tools
PC, slides, blackboard
Office hours
See the website of Francesco Bergamaschi