Advanced Excel Training Course

Excel Course for Advanced Users

Our virtual and face-to-face Excel training courses for advanced users will empower your team to boost productivity.

About this Course

The skills and knowledge acquired in Microsoft Excel Advanced enable users to expand their knowledge and skills beyond building simple workbooks by using analytical and productivity tools.

Assumed Knowledge

This course assumes the learner has previously attended an Excel Intermediate course or has equivalent working knowledge as well as confidence with the use of personal computers and the Windows operating system environment.

Duration

3.5 hours

Cost

Please view our Pricing page or complete the form below to obtain a quote. The cost will depend on the number of participants and whether training is to be conducted on your site or at one of our recommended training room locations.

Main Topics

  • create Nested Functions including IFS, AND, OR, NOT, IFERROR
  • save time with Array formulas
  • learn to use the XLOOKUP function and understand the benefits compared to VLOOKUP
  • manipulate data in a worksheet with Outlining or Grouping
  • summarise your spreadsheets using Subtotals
  • combine data from several workbooks using Data Consolidation
  • build scenarios with the Scenario Manager
  • use Goal Seek
  • create advanced filters to analyse data in a list
  • validate data using a variety of validation techniques
  • create recorded macros in Excel

 

More Excel Training Courses

Microsoft Excel is a helpful and powerful program for data analysis and documentation. It is a spreadsheet program, which contains a number of columns and rows, where each intersection of a column and a row is a “cell.” Each cell contains one point of data or one piece of information.

Excel Beginners Course: This is a beginner’s course and aims to give the new spreadsheet user a thorough preparation in the basics of creating and working with spreadsheets using Microsoft Excel 365. Emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

Excel Intermediate Course: The skills and knowledge acquired in Microsoft Excel Intermediate enable users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques as well as charting.

Excel Pivot Tables Course: A pivot table is a tool in Microsoft Excel that will help efficiently create a summary including only the data that you need it to. If you have an overwhelming spreadsheet that you need to make sense of, pivot tables are a great option.

More Computer Training Courses

At CJ Computer Training, we offer a full cache of computer courses and our friendly computer software trainers can teach you how to confidently and efficiently use a wide range of computer apps from Microsoft apps and Office 365Adobe Design softwareAtlassian and more.

microsoft training courses excel

microsoft training courses powerpoint

microsoft training courses word

microsoft training courses onenote

microsoft training courses sharepoint

microsoft training courses teams

illustrator training courses

photoshop training courses

indesign training courses

confluence training courses

jira training courses

atlassian training courses