Excel (a further selection of ‘best bits’)
LIVE

Virtual

30 November, 2021

12:30 pm - 1:30 pm GMT

Event

Excel (a further selection of ‘best bits’)

Location: Virtual

  • Format

    Event

  • Type

    Conference

  • Duration

    1 hour

This 1hr webinar dips into a selection from the most requested Excel features; From the function stable, Logical, Lookup and Reference and Text functions along with Data Analysis features such as Pivot Tables as well as an overview of automation (Macros).

Book with partner

Product information

Overview

Professional development

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

Prerequisites:Please view our Privacy Policy and learn more about the ways in which we process and secure your personal data: https://www.cimaglobal.com/Privacy-Policy/
Duration:1 hour
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

Excel is always improving, and we continue to love it (most of the time lol). This webinar looks at more ‘best bits’ such as Vlookup, Xlookup who is the new kid on the block), Left, Right, Proper and the new and improved Concat function as well as how to stop Pivot Tables ‘Going Rogue’ with a billy bonus of an overview of Macros/VBA as a finale.

Learning outcomes include:

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

  • Kate Watson

    alt text

    Kate Watson of CMLW Consulting is a Data Privacy and Digital Skills Specialist with a 30+ year history in technology and business. Her current job involves supporting businesses in areas such as software and system implementation, communication and presentation, data protection compliance as well as training across a range of technical and soft skill topics. She works with a range of clients and organisations from micro to global and speaks on a variety of topics at events throughout the UK.