You are here:

87980 - CRASH EXCEL

Academic Year 2018/2019

                
                        Docente:
                        Francesco Bergamaschi
                    
                        Language:
                        English
                    
                        Teaching Mode:
                        Traditional lectures
                        
                            Campus:
                            Bologna
                        
                            Corso:
                            Second cycle degree programme (LM) in
                            Business Administration (cod. 0897)

                            Teaching resources on Virtuale

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