BUS134-B Excel in Managerial Accounting

This online course gives a basic introduction to Microsoft Excel, an essential computer tool used in businesses. When the students have learned the basic skills in Excel, the lectures will focus on Excel as a tool in Managerial Accounting.

Basic training in the use of formulas, functions and data tables.

An introduction to basic principles and methods for Managerial Accounting, and demonstrations and practical exercises in making adequate financial models.

Presentation of models using formatting and graphics. Analysis and management of data, including external data, filtering and use of pivot tables.

Knowledge:

The candidate has:

• knowledge of the different components of Excel
• knowledge of how to build models to support business decisions

The candidate can:

• Gather data for use in a model - register, cut and paste, import data
• Structure base data - adjust formats, quality assurance, split data strings, use names in Excel
• Analyze data - the four basics, simple statistical functions, sorting
• Present data - format, adjust and make charts

Skills:

The candidate masters:

• develop efficient and structured models in Excel
• work efficiently with Excel