Excel Advanced 22 Nov 2021 & 14 Dec 2021

Advanced Microsoft Excel

This is a 1-day course helping you to continue to unlock the maximum potential of this popular data-analysis tool. After completing the course, you will have increased understanding of the Excel toolset and Advanced Techniques allowing you to know which function or feature is the best for what you wish to achieve, not just for tomorrow but next month and next year.

If you are not sure , contact us to assist you choosing the relevant level of training and we can work with your live files in order to achieve maximum productivity.

Prerequisites:

  • Create, edit and format spreadsheets
  • Navigate within worksheets and books
  • Use Insert Function to create built-in functions
  • Work with absolute references
  • Create named ranges
  • Create Tables within Excel
  • Sort and filter data

Refreshing the Intermediate


Advanced Functions

  • IF Statements
  • Multiple IF Statements
  • Nested Functions
  • Index & Match versus VLOOKUP
  • Date Calculations
  • Information Functions
  • SUMIF, COUNTIF
  • Text Functions
  • LOOKUPs

Working with Lists

  • Data Validation
  • Tables

Templates & Auditing

  • Creating Templates
  • Conditional Formatting
  • Adding Comments
  • Sharing Workbooks
  • Drawing & Graphics
  • Diagrams & Organisation Charts

Advanced Pivot Tables

  • Summarising data using pivot tables
  • Formatting
  • Slicers
  • Creating a Pivot Table Chart

Introduction to Macros

  • Recording and running a Macro
  • Creating a Macro
  • Comparing Relative and Absolute Macros
  • Running a Macro
  • Editing a Macro
  • Assigning Shortcuts to Macros
Delivery: Online (live)
Level: Expert
Day & Time:
Week Days
Weekend
Daytime
Evening
What is included:
VAT
Breakfast
Lunch
Refreshments
Digital courseware
Digital Recording
Printed courseware
Accommodation
Extra revision sessions
Style:
Authoritative
Challenging
Inspiring
Methodical
Starts: October 2021
Duration: 1 day or less

Public discussion (0)

You must log in to send a new comment.