Microsoft Excel Advanced

TCS Training IT Limited

Training

Online

£ 200 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Training

  • Level

    Advanced

  • Methodology

    Online

  • Duration

    1 Day

This one day Microsoft Excel Advanced training course is for those with a sound working knowledge of Microsoft Excel. For those delegates who wish to progress to use the most complicated functions and features. At the end of this course you will investigated some of the higher functions of Microsoft Excel.

About this course

Work with and Nest Functions
Nest functions IF with AND / OR, VLOOKUP, VLOOKUP with MATCH and INDEX/MATCH
Apply DATE Functions
Use and nest TEXT Functions
Use Flash Fill
Understand and manage Errors

Advanced Pivot Tables
Grouping data
Work with Filtering and Slicers
Create calculated fields
Adjust field settings
Drill down and refreshing data
What If Analysis Tools
Use Goal Seek
Create Scenarios with Scenario Manager
Create Data Tables

Macros and Excel Forms
Record a Macro
Assign a Macro to the Quick Access Toolbar
Assign a Macro to a Button
Edit Visual Basic Code
Create Excel Forms

Any delegates that have knowledge of our Intermediate level training course. We can assess your current knowledge free of charge.

Be familiar with Microsoft Excel at Intermediate level
Have Microsoft Excel installed as its hands on live training.

Certificate of Training

Engaging live online delivery by engaging trainers
A maximum of 4 delegates on a course
1 year's after course support

Once enrolled we email you a link to join the course and post your course materials.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Macros
  • Advanced pivot tables
  • Text Functions
  • Date Functions
  • Functions in Excel
  • Nesting functions
  • Goal seek
  • Scenarios
  • Data tables
  • Flash fill

Teachers and trainers (1)

Qualified Trainer

Qualified Trainer

Senior trainer

Course programme

A comprehensive one day Advanced level course teaching you how to use advanced functions, pivot tables, flash fill, working with Text and Date functions and macros (and introduction to writing VBA coding) and advanced pivot tables. The course includes lunch, refreshments, instructor led training, printed workbook, comprehensive course reference, a printed certificate and free after course support for 1 year.

Additional information

https://www.tcstraining.co.uk/microsoft-excel-office-training-southampton

See related categories

Microsoft Excel Advanced

£ 200 + VAT

The best Excel courses

See all

See all