Excel for Managerial Analysis

Who is it for?

Managers required to use Microsoft Excel in decision making, for presenting financial or business results, or those who would like to feel more confident of their management information systems. An understanding of how to use excel formulas and functions is required.

What is it about?

This course equips you with the technical skills, understanding and confidence to produce meaningful information using Microsoft Excel. You will learn how to create Excel graphs, use links and advanced functions to summarise management or financial data more effectively and with greater accuracy.

What will I get out of it?

• Skills to make effective managerial decisions supported by Excel
• The ability to achieve targets through Goal Seeking
• Better organisation of data through grouping and outlining
• Competence in analysis of large worksheets using Pivot Tables
• Confidence in producing Excel graphs that get the message across

Course Overview

• Use Excel graphs to represent data
• Understand advanced editing procedures of graphs
• Use pivot tables to summarise data effectively
• Produce trend lines
• Learn Goal Seeking
• Build data tables to display a variable range
• Undertake consolidation
• Experience various scenarios
• Group and outline OLE to link Excel to other applications
• Implement Data Validation Checks

Click here to download:

MS Excel for Managerial Analysis