Microsoft Excel Advanced Training

by Bristol Business College Claim Listing

This advanced Microsoft Excel training course will teach you to use the advanced features of Excel in any version to their full extent. By the end of this course, you will be able to report on data in a list using PivotTables, edit and analyse complex data using advanced features.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Bristol Business College Logo

img Duration

1 Day

Course Details

This advanced Microsoft Excel training course will teach you to use the advanced features of Excel in any version to their full extent. By the end of this course, you will be able to report on data in a list using PivotTables, edit and analyse complex data using advanced features such as Scenarios, Goal Seek and Solver, incorporate built-in functions into a worksheet, work with controls and record macros.

This workshop is delivered by a highly experienced Excel trainer with many years of experience. This is a hands-on course which is limited in numbers to ensure each delegate receives training tailored to meet their needs. 

Each person will leave with lots of practical Excel experience ready to put into immediate effect in their workplace. Once you have completed this course you will be ready to go on to our Microsoft Excel Advanced Extra course.

This course is instructor led, involving the use of numerous examples and exercises in a workshop environment in order to allow you plenty of time to practice and consolidate your learning.

 

Course Objectives:

Learn to use the advanced features of Excel to their full extent. By the end of this course, delegates will be able to report on data in a list using PivotTables, edit and analyse complex data using advanced features such as Scenarios, Goal Seek and Solver, incorporate built-in functions into a worksheet, work with controls and record macros.

We recommend that you have reached the level of Introduction and Intermediate Excel training before attending this course.

 

Delegates Will Learn:

  • Review exercise labels and names
  • Logical Functions
  • Validating Data
  • Lookup Functions
  • Summarising Data
  • Group and Outlining
  • Pivottables
  • Pivottable Techniques
  • Data Consolidation
  • Custom Views
  • Scenarios
  • Goal Seeking
  • Data Tables
  • Solver
  • Recorded Macros
  • Extra Features
  • Bristol Branch

    Engineers' House The Promenade Clifton Down, Bristol

Check out more MS Excel courses in UK

Etopia Training Logo

Microsoft PowerPoint (Advance)

A hands-on instructor-led Microsoft Word PowerPoint course allowing people based in Scotland to upskill from an already good existing knowledge of PowerPoint to become more expert.

by Etopia Training [Claim Listing ]
AMP Information Systems Ltd Logo

Microsoft Office Training

Most people know the basics of Microsoft Office applications: Word, Excel and PowerPoint. However, the Microsoft suite of applications is much more extensive than that, and it offers a host of features that help to improve business efficiency.

by AMP Information Systems Ltd [Claim Listing ]
CCW Training Academy Logo

MS Visio

MS Visio course is offered by CCW Training Academy. Our training courses are conducted by professionals with practical experience in their expert area of works. Our course modules are designed to suit clients’ requirements.

by CCW Training Academy [Claim Listing ]
I Train Scotland Logo

Microsoft PowerPoint Comprehensive

Whether you are a new user or have been using PowerPoint for years, this course will vastly increase your understanding of PowerPoint. Existing users will learn how to get the most out of PowerPoint, break any bad habits, learn shortcuts and discover a massive range of hints and tips from our exper...

by I Train Scotland [Claim Listing ]
AKU Training Logo

Ms Word Intermediate

This MS Word training is designed to improve your knowledge and to enable you to produce professional documents that are relevant for your particular line of work.

by AKU Training [Claim Listing ]

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy