image

Advanced Excel Training

A good understanding of using Microsoft Excel is essential for a number of positions. Whether you have never used Excel before, or you are looking to improve your Excel skills, we at KBM TR provides you advanced Excel training courses that will help you to gain expertise on this application. This training is widely recognized as the world’s leading set of software applications for document creation, communication, and business information analysis. In the office environment today, proficient skills in advanced Excel are must for all staff. Therefore, high-quality training is a vital part of any organization’s staff training and development strategy.

KBM TR know exactly what it takes to help you get the formula for success with Excel! These days the ability to use Microsoft Excel efficiently and effectively is a prerequisite for any office based role. Employers across London recruiting staff who have good command in managing data on computers, therefore advanced Excel training always has a good impact on your CV.

What is included in this course?

Advanced Excel course will teach you to use the advanced features of Excel software in any version to their full extent. After completing the advanced excel course you will be able to report on data list using PiovtTables, edit and analyze complex data with the use of advanced features such as Goal Seek and Solver, Scenarios, work with controls and macros.

Prerequisites

If you are a complete beginner to Excel, have no fear as Excel training will take you from start to finish and have you navigating spreadsheets like a professional in no time. Alternatively, if you are reasonably Excel savvy, but just want to maximize the potential of the software then our expert course is the one for you!

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

Course Objectives:

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

  • 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.
  • Advanced Excel Training Course Content

  • Absolute Cell Addressing
  • Working with Data Lists
  • Data Validation and Data Consolidation
  • Naming Cells and Ranges
  • Conditional Formatting and Conditional Functions
  • Data Tables and Pivot Tables
  • Conditional Functions and Lookup Functions