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

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

Microsoft Word (Intermediate)

A hands-on instructor-led Microsoft Word training course allowing people with an existing knowledge of Word fundamentals to improve their skills and create better documents.

by Etopia Training [Claim Listing ]
Teach All About IT Logo

ICDL Advanced Access Databases

This course may be studied as a stand alone Advanced Access course with a CPD certificate of completion, or as part of the larger Advanced ICDL IT User Skills qualification.

by Teach All About IT [Claim Listing ]
NILC Training Logo

Microsoft Outlook Introduction Training Course

This Microsoft Outlook training class introduces the interface and gets students up and running quickly working with messages, calendars, and contacts.

by NILC Training [Claim Listing ]
Kaplan UK Logo

Introduction To Excel Functionality

Microsoft Excel is one of the most important business tools any of us will use. It’s the tool of choice for presenting and analysing data. However, even though Excel is so widely used, much of the workforce don’t know how to apply all of the fantastic tools which are available.

by Kaplan UK [Claim Listing ]

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