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 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 ]
Acuity Training Logo

Excel Training: Intermediate Course

Expand your Excel skills on this 1-Day Intermediate Excel training course.

by Acuity Training
Smartthink Training Ltd Logo

Microsoft Visio 2013 Essentials

Microsoft Visio 2013 Essentials is offered by Smartthink Training Ltd

by Smartthink Training Ltd [Claim Listing ]
Prospect IT Training Logo

Microsoft Outlook Training

Microsoft Outlook is a personal information manager software system from Microsoft, available as a part of the Microsoft Office suite.

by Prospect IT Training [Claim Listing ]
Keys Training Logo

Microsoft Access Training (Intermediate)

This one-day instructor led course is designed for existing users of Microsoft Access who need to be able to create databases and manage data more effectively.

by Keys Training [Claim Listing ]

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