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

Capital Training Logo

Microsoft Excel Intermediate

This course is designed for individuals who possess basic Excel skills and want to elevate their proficiency to an intermediate level. It caters to professionals, analysts, administrators, and anyone seeking to enhance their data analysis and spreadsheet management capabilities using Excel.

by Capital Training [Claim Listing ]
ITrain Scotland Logo

Microsoft Access Level 1

Whether you are a new user or have been using Access for years, this course will vastly increase your understanding of Access.

by ITrain Scotland [Claim Listing ]
Training 26 Logo

Microsoft Word

Microsoft Word training can be delivered for which ever version is required from 2007, 2010, 2013, or 2016, at three basic levels, Introduction, Intermediate, and Advanced.

by Training 26 [Claim Listing ]
AJ Training Logo

Microsoft OneNote Training Course

Microsoft OneNote is a computer program for free-form information gathering and multi-user collaboration. It gathers users' notes (handwritten or typed), drawings, screen clippings and audio commentaries. Notes can be shared with other OneNote users over the Internet or a network

by AJ Training [Claim Listing ]
Enliten IT Logo

Visio Course (2019 Introduction)

This Microsoft Visio 2019 Introduction course provides practical guidance on how to create a range of business and technical diagrams and layouts.  You will learn the concepts of creating various floor plans, flow charts, ideas, processes, maps etc.

by Enliten IT [Claim Listing ]

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