image

Advanced Excel Training

A good understanding of using Microsoft Excel is essential for several positions. You will learn essential tips, tricks, shortcuts, functions and formulas to become an Excel power user. It will also help those users who want to perform financial modelling and financial analysis. Whether you have never used Excel before or looking to improve your Excel skills, we at KBM will provide you with advanced Excel training courses to help you gain expertise on this application.

Microsoft Excel training is widely recognised as the world's leading set of software applications for document creation, communication, and business information analysis. Proficient Excel skills are essential for all staff, especially for accountants. High-quality training is an important part of the organisation's staff training and development strategy.

KBM know what it takes to help you get the formula for success with Excel! These days, using Microsoft Excel efficiently and effectively is a prerequisite for any office-based role. Employers across the world hiring staff who have a good command of managing data on computers; hence, advanced Excel training always has a good impact on your CV.

Overview of Advanced Excel training course

Advanced Excel course will teach you to use Excel software's advanced features in any version to their full extent. After the advanced excel course, you will report on a data list using edit, PiovtTables, and analyse complex data using advanced features like Solver and Goal Seek, Scenarios, work with controls and macros.

What are the contents of the course?

You will learn through the following main contents:

  • Absolute cell addressing
  • Working with data lists
  • Data consolidation and validation
  • Ranges and naming cells
  • Conditional functions and formatting
  • Data and pivot tables
  • Conditional functions and lookup functions
  • Nested IF Functions
  • V LOOKUP and H LOOKUP tables.
  • Creation of Macros and Active Buttons.
  • Combining functions and formulas with buttons.
  • Data Analysis using Scenarios, Data Tables and Goal Seek.

What will you learn?

At completion, you will be able to:

  • use nested IF Functions to return one of 4 possible outcomes
  • use both Absolute and Relative cell referencing in spreadsheet formulas
  • set up a spreadsheet with active buttons that perform a series of steps with one click: Macros, Spinners
  • to use Excel VLOOKUP and HLOOKUP tables to build a single formula to produce multiple results to operate on a group of arguments arranged in columns or rows
  • present specific Data using Excel tools: Pivot Tables, Charts, and Analyse Data with ''What if'' Tools
  • Prerequisites

    If you are a beginner to Excel, want to gain Excel training from start to finish or have you navigating spreadsheets like a professional in no time. Alternatively, if you are reasonably Excel savvy but want to maximise the software's potential, then our expert course is the one for you!

    Our Advanced Excel Courses led by industry experts involve lots of examples and exercises in a working environment. Our highly experienced trainers have years of experience providing hands-on training that will leave you with lots of practical experience and provide you with useful tips and tricks to use Excel effectively.

What People say About Us