ADVANCED EXCEL FOR BUSINESS APPLICATIONS

 

 

Course form:

Computer lab workshops.

 

 

Course description:

The participants will learn how to use advanced components of MS Excel for the analysis of large amounts of business data and automation of repetitive tasks. Coursework covers creating complex calculation formulas, pivot tables, macros, and performing multivariate data analysis through the use of advanced analytical and computational capabilities of MS Excel.

 

 

Course outline:

 

1.    Creating complex calculation formulas.

 

2.    Modification and editing of graphical objects.

 

3.    Creating and editing pivot table reports.

 

4.    Business data consolidation.

 

5.    Scenario manager and formula auditing.

 

6.    Automating tasks with macros.

 

7.    MS Excel advanced cooperation with other applications.

 

 

Readings:

Abdulezer L., Excel. Praktyczne zastosowania w biznesie, Helion

Masłowski K., Excel. Ćwiczenia zaawansowane, Helion

Simon J., Excel. Profesjonalna analiza i prezentacja danych, Helion

Carlberg C., Excel for Accountants, CPA911 Publishing

Knight G., Analyzing Business Data with Excel, O'Reilly Media

Winston W. L., Microsoft Excel Data Analysis and Business Modeling, Microsoft Press

 

 

End of Course Assessment:

Exam involves the practical application of knowledge and skills learned in coursework.