Follow Us :

Microsoft Excel For Managerial Analysis

Course_Reference: 
REEEFMA
Manufacturer: 
0
Training_Provider: 
35
Summary: 

Managers required to use Excel in decision making, or those who would like to feel more confident of their management information systems. An understanding of formulas and functions is required.

Audience: 

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

Objectives: 

  • 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

  • Use 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

Description: 

Managers required to use Excel in decision making, or those who would like to feel more confident of their management information systems. An understanding of formulas and functions is required.

Keywords: 
Microsoft,Microsoft Excel,Excel for Managerial Analysis,Managerial Analysis

Software Vendor

IT Technical

Business Skills