Advanced Microsoft Excel

Duration: 1 Day

Objectives

This course is designed for those wanting to gain a greater knowledge of the more advanced features of Excel. You will learn how to create and customise your own macros and utilise Excel’s auditing tools.

Pre-requisites

Good knowledge of Excel, or previous attendance on the Intermediate Excel course.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

Course outline

    • protect>

      Expanding your functions toolbox

      • Recap on the basic IF function
      • Recap on creating & using range names
      • Nesting formulas
      • Using AND & OR
      • IFERROR
      • VLOOKUP & HLOOKUP
      • INDEX & MATCH
      • Information Functions
      • Text functions

      Effectively analysing your data

      • Creating Pivot Table
      • Changing the look of your pivot
      • Grouping your data
      • Updating Pivot Tables with new data
      • Filtering your data with a Slicer
      • Linking slicers to more than one Pivot Table
      • Using a timeline
      • Creating a Pivot chart

      Enhance your workflow

      • Setting Macro security
      • Recording Macros
      • Editing your Macro
      • Understanding the VBA edit window
      • Assigning & running a Macro from the ribbon
      • Saving & using a Macro-enabled Workbook
      • Deleting your Macro

      What If

      • Goal Seek
      • Scenarios
      • Data tables
      • Solver

      Creating Forms


  • Live Chat

    Course Dates

    London CentralLondon GreenwichBristol

    London Central

    Dates Price Book Now
    5 Mar £145 + VAT Book Now
    27 May £145 + VAT Book Now
    27 Jul £145 + VAT Book Now
    4 Sep £145 + VAT Book Now
    See more dates...

    London Greenwich

    Dates Price Book Now
    20 Apr £145 + VAT Book Now
    15 Jun £145 + VAT Book Now
    12 Aug £145 + VAT Book Now
    21 Oct £145 + VAT Book Now
    See more dates...

    Bristol

    Dates Price Book Now
    11 Mar £195 + VAT Book Now
    11 May £195 + VAT Book Now
    13 Jul £195 + VAT Book Now
    16 Sep £195 + VAT Book Now
    See more dates...


    All our courses run in London and Bristol, or can be tailored to requirements at your own offices. For alternative dates, please email or call us on 0208 269 4260
    All prices are per person and are subject to VAT
    15% discount for groups of four delegates.
    10% discount for groups of three delegates.
    (This offer applies for delegates on the same public scheduled course on the same date.)


    "Clear and concise explanations of all program capabilities, very helpful."

    Hyder Consulting Ltd

    "Very helpful, knowledgeable and responsive trainer."

    Westminster University

    "I am writing to say thank you for organising my FileMaker training day; I learned so much with my trainer, Nick, and have come away with such a great database. It delighted both the Director and my job share partner. I feel I have left with a great amount of knowledge that can help the business immensely. I learned more than I thought I would and would like to thank Transmedia for being so helpful!"

    Lucie Mills



    © Transmedia . 85 Tottenham Court Road, London, W1T 4TQ  UK . 0208 269 4260       Privacy Policy