Microsoft Excel Advanced

Take the ultimate deep dive into Excel. Learn advanced features such as pivot tables and VLOOKUP to help analyse and summarise large datasets. Perform more complex data analysis to help you make informed business decisions. Discover techniques to reduce audit risk by ensuring data accuracy and integrity. Enhance your ability to manage and manipulate data effectively, saving time and increasing productivity. This course will give you the advanced Excel skills necessary to excel in your professional career

Description

Expanding your functions toolbox
  • Using Nesting formulas
  • Using AND & OR
  • VLOOKUP
  • IFERROR/IFNA
  • INDEX & MATCH

Reducing your audit risk

  • Data validation
  • Using Trace Precedents
  • Using Trace Dependents
  • Removing Arrows
  • Error checking
  • Evaluate Formula 

Effectively analysing your data

  • Creating Pivot Tables
  • Changing the look of your pivot
  • Grouping your data
  • Updating Pivot Tables with new data
  • Filtering your data with a Slicer
  • Linking slicers to more than one Pivot Table
  • Using a timeline
  • Creating a Pivot chart

Using What If Analysis

  • Goal Seek
  • Scenarios

Prerequisites

Delegates are recommended to have a good working knowledge of Excel Or Attended the Excel intermediate training course 

Similar events

This course builds on learners’ existing knowledge and covers a variety of topics, from how to create slide decks quickly and more efficiently, work with graphics and multimedia elements to create striking presentations, special effects, and some of the more advanced presentation delivery tools PowerPoint has to offer.

More Information

This training course builds upon basic Excel knowledge and increases user confidence in using Excel. It provides more of an understanding of working with formulas and functions and demonstrates how Excel can be applied in various business applications.

More Information

Delegates will be introduced to spreadsheet concepts and gain an appreciation of the main features of Excel and what it has to offer. 

More Information

This course has been designed for users who are new to Microsoft Project, and covers navigating around the application, starting a new project, setting up a project schedule, calendars, task lists, task dependencies, Gantt charts and more.

More Information

Quickly and easily create professional, engaging presentations using PowerPoint. Learn tips and tricks from experts to make your presentations shine.

More Information

Dramatically improve your productivity when using Microsoft Word. Discover techniques for working faster and more efficiently.

More Information