It is a fact that Excel is essential for any business professional. Thus, when applied effectively, Excel is a very powerful tool that allows you to process huge amounts of data, automate tasks and present complex information, etc. Therefore, this course is designed to help you learn how to solve business problems with Excel 2016 (more) efficiently and promote you to be an advanced user.

In this course you will learn ...

… the basics, in particular how to

• manage spreadsheets and workbooks in Excel
• create clean and effective Excel charts and diagrams
• reference between cells and to other worksheets
• work with basic functions for calculations in Excel (SUM, COUNT, AVERAGE, MAX, MIN, IF, SUMIF, AVERAGEIF)
• change cell formatting based on cell content.

… all about functions and reporting by using

• TEXT functions (CONCATENATE, LEFT, RIGHT, MID,LOWER, ...)
• IF functions
• VLOOKUP
• Sort & Filter
• PivotTables
• Advanced Charts
• Advanced Data Analysis with Dashboards (Excel Powerview)
• Dynamic Data Exchange with external sources (databases, SAP, Powerpoint, internet).

… with practical business examples such as

• BCG Matrix
• ABC Analysis
• Break Even Point
• Contribution Margin
• Discounting Payback Method
• Form Controls (Scroll Bar; Check Box …)
• Goal Seek
• Solver.

… a lot about tips & tricks such as

• working with shortcuts
• protecting, validating and hiding information and formulas
• handling large Databases.

After this course you should be able to

• create and use defined names in a workbook
• work with logical functions in Excel
• use a variety of data validation techniques
• use a range of lookup and reference functions
• create summaries in your spreadsheets using subtotals
• understand and create PivotTables, PowerviewTables and Graphs
• perform a variety of analytical tasks using Powerview
• use the Data Consolidation feature to combine data from several workbooks into one
• use Solver to solve more complex and intricate problems
• import data into Excel and export data from Excel
• create and use a range of controls in a worksheet
• create recorded macros in Excel
• create and use a range of Excel Business Tools
• solve business tasks by using Excel more efficiently.

100 % is required

• Theoretical input by the trainer
• Excel workshop with a strong emphasis on student participation
• Learning in peer groups
• Self-directed learning with the e-learning platform
• Student presentations

• 30 % Class Participation and Peer Group Learning Participation
• 30 % Group Presentation
• 40 % Final Exam

rainer.baier@wu.ac.at