Advanced Microsoft Excel 2007

Course

In London

£ 350 VAT inc.

Description

  • Type

    Course

  • Location

    London

  • Duration

    2 Days

Learn how to use advanced 'If' statements and macros to automate repetitive tasks Be able to use analysis tools to forecast figures based on a range of scenarios Ensure important data is highlighted by summarising large workbooks and sorting data into key elements. Suitable for: This course is suitable for people who have attended the intermediate course or have good knowledge and understanding of Excel 2007 and would like to explore the more complex functionality it can offer. Prerequisites A working knowledge of Microsoft intermediate topics or attendance to our Intermediate Microsoft Excel course.

Facilities

Location

Start date

London
See map
9 Kingsway, WC2B 6XF

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme



Who is it for
This course is suitable for people who have attended the intermediate course or have good knowledge and understanding of Excel 2007 and would like to explore the more complex functionality it can offer.

Prerequisites
A working knowledge of Microsoft intermediate topics or attendance to our Intermediate Microsoft Excel course.


What is it about


  • Learn how to use advanced 'If' statements and macros to automate repetitive tasks

  • Be able to use analysis tools to forecast figures based on a range of scenarios

  • Ensure important data is highlighted by summarising large workbooks and sorting data into key elements


Course overview


  • Group And Outline Features

  • Linking worksheets

  • Goal Seek to reverse calculate a formula

  • Creating Single Input Data Tables

  • Setting up and manipulating scenarios for What-If? Analysis

  • Named Ranges

  • Consolidating Data by position

  • Text Functions in Excel 2007

  • Group And Outline Features

  • Nested IfÂ' statements

  • Use of Lookup functions

  • Use of Logical functions

  • Create a Pivot Table Report

  • Analysing Data with Pivot Tables

  • Manipulate the Pivot Table

  • Formatting Pivot Tables

  • Creating Pivot Charts

  • Grouping data in Pivot Tables

  • Setting Up Database Queries

  • Connecting Excel to the Web to Import Data

  • Recording Macros

  • Edit a Macro

  • Creating Buttons to Run the Macros

  • Creating your own Menu

Advanced Microsoft Excel 2007

£ 350 VAT inc.