Excel intermediate level skills – A selection of best bits
LIVE

Virtual

20 July, 2021

12:30 pm - 1:30 pm BST

Event

Excel intermediate level skills – A selection of best bits

Location: Virtual

  • Format

    Event

  • Type

    Conference

  • Level

    Finance professionals who are familiar with Excel and want to build on their existing knowledge to an intermediate/advanced level.

  • Duration

    1hr

This webinar dips into a selection of the most requested Excel features; Logical, Lookup and Reference functions, Text functions, Data Analysis features such as Pivot Tables as well as an overview of automation (Macros)

Learning outcomes

  • Application of different function sets
  • Faster and easier data analysis and reporting
  • Applying automation to repetitive tasks using Macros
Full description

Product information

Overview

Professional development

All learning resources available in the CGMA Store qualify for CPD for CIMA members.

Programme level:Finance professionals who are familiar with Excel and want to build on their existing knowledge to an intermediate/advanced level.
Duration:1hr
Format:Event
Access:This is a live event. You will receive information about the location, materials, and attendance after purchasing.

Return and refund policy

Programme outline

Being the feature packed application that it is, it would be impossible to cover everything Excel does in 1 week never mind 1 hour. Our speaker Kate Watson, has put together a ‘medley’ of popular Excel functions and will be running thrrough the following during this webinar.

  • Vlookup (and Xlookup who is the new kid on the block),
  • Left, Right, Proper
  • The new andimproved Concat function
  • Pivot Tables/Charts
  • Macros

Please click here to view our Privacy Policy and learn more about the ways in which we process and secure your personal data.