NOTE: This module is included in the "Master of Financial Analysis" Course, but also available here as a standalone module.

This module is for business analysts who work with large and complex accounting systems, and are expected to extract data subsets and make recommendations to operating decision makers.

Database management is the role of IT professionals, but use and interpretation of the data is for business professionals.

In this module you will learn:

• Database Fundamentals
• How to use Excel’s powerful Pivot Tables, Pivot Charts and related functions to manipulate data

You will also gain insights into data interpretation and get a better sense of when to switch to Access and when to call in the IT pros.

The features of this module are:

• An explanation of the purpose and use of data bases and data arrays
• Step-by-step user instruction: as you navigate, the correct Excel worksheet is displayed
• Paced examples and use cases
• Access to “Help” at all times: extensive help for working with Excel and VBA and dealing with financial and accounting concept