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

I Train Scotland Logo

Microsoft Publisher (Level 1)

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

by I Train Scotland [Claim Listing ]
London Training Institute Logo

Microsoft Word Training

Our instructors are highly skilled with?industry experience of? many ?years, working in best and renowned organization.

by London Training Institute
Mulan Technology Logo

Microsoft Excel

At The End Of This Course You Will Have A Good Working Knowledge Of Excel Basics. You Will Feel More Confident Using Excel And Be Able To Create A Spreadsheet From Scratch.

by Mulan Technology [Claim Listing ]
Teach All About IT Logo

PowerPoint

Tailored for beginners or occasional computer users, the Level 3 ICDL course units aim to elevate you to a professional standard of computer proficiency.

by Teach All About IT [Claim Listing ]
Act Training and Testing Logo

MS Access

Students will learn the skills necessary to begin using Access, including designing and creating databases, tables, queries, forms, and reports.

by Act Training and Testing [Claim Listing ]

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