Microsoft Excel – Advanced

by Elliott Training UK Claim Listing

Our Microsoft Excel Advanced course is a highly practical and interactive tutor-led session delivered by highly experienced Microsoft Certified Trainers. Delegate numbers are kept low to ensure individual support can be given to each participant.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Elliott Training UK Logo

img Duration

1 Day

Course Details

Our Microsoft Excel Advanced course is a highly practical and interactive tutor-led session delivered by highly experienced Microsoft Certified Trainers. Delegate numbers are kept low to ensure individual support can be given to each participant.

Courses can be delivered on your premises on dates that suit you or you can complete the course at one of our public courses in London or Bristol.

 

Course Content – Overview

  • Short overview of intermediate topics

  • Named Ranges

  • Lookup Functions – VLOOKUP, MATCH, INDEX, INDIRECT

  • Advanced Functions – OFFSET

  • Date and Text

  • Data Validation

  • File Linking

  • Protection

  • Consolidation

  • Macros

  • Goal Seek, Using Solver and Goal See

 

Outcomes

On successful completion of the course, delegates will be able to create and apply names ranges, understand Lookups, solve problems by using Goal Seek, record macros and assign to buttons and link objects between different applications.

  • Gloucester Branch

    Pure Offices Kestrel Court, Waterwells Drive, Gloucester

Check out more MS Excel courses in UK

Media Training Logo

Microsoft Excel Intro

For complete beginners who need to understand the functionality of Excel. Learn to work efficiently, producing factual and well formatted spreadsheets.

by Media Training [Claim Listing ]
Storm Training & Solutions Logo

Microsoft Word Training (Intro)

n site Microsoft Word courses tailored to your needs, designed for businesses and professionals. All Microsoft Office Word versions including 2003, 2007, 2010, 2013, 2016 and Office 365 covered.

by Storm Training & Solutions [Claim Listing ]
Best Practice Training Limited Logo

Microsoft Access Masterclass

The course enables the delegates to create complex queries, make forms and build a database with a good relational structure. During the one day course, the delegates will learn how to create basic to advanced reports, design Access databases, manage interfaces with Access Forms and automate tasks ...

by Best Practice Training Limited [Claim Listing ]
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 IT Training (LIT) Logo

Microsoft Excel Intermediate Training (MO-200)

Microsoft Excel Intermediate Training is designed for those professionals and/or individuals who are familiar with the Microsoft Office packages but do not have expert level knowledge or understanding of any particular Microsoft Office application.

by London IT Training (LIT)

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