Don't just take our word for it

We ask all our past delegates to rate our courses so you can decide if this course is really right for you - just click 'Hear what people say' to read ratings. If you've been on a course, log in to 'My Reed Learning' and leave your review to help others decide.

Microsoft Excel 2007 for Managerial Analysis Course

  • Duration:1 Day
  • Cost:£199 + VAT
  • Ref:EFMA

Use Excel to support managerial decision-making, and ensure you are confident of the facts

Cost £199.00 Duration 1 day Code EFMA

Course rating:

(1  vote)

  • Hear what people say
  • Send to a friend
  • Add to favourites

Who is it for

Managers required to use Microsoft Excel 2007 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 2007. Pivot tables form the cornerstone of this course. You will learn how to create and minipulate data using pivot tables and pivot charts. You will also learn how to analyse data by grouping and sorting the pivot table.


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 to automatically bring together various data
  • Experience various scenarios
  • Group and outline OLE to link Excel to other applications
  • Implement Data Validation Checks

What will I get out of it?

  • Skills to make effective managerial decisions with pivot tables
  • 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

Accredited by

This course is accredited for CPD

  • Hear what people say
  • Send to a friend
  • Add to favourites

Get in touch 

 

0800 170 7777

Email us

What's new this month >