Intermediate Microsoft Excel

Duration: 1 Day

Objectives

To build on attendees’ existing knowledge of the application, with tuition in the more advanced or less obvious features to a level that will provide a deeper understanding and increased efficiency in the use of the software.

Pre-requisites

A working knowledge of Excel, or previous attendance on the Introduction to Excel course.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

Course outline

Workbooks and worksheets

  • Linking worksheets
  • Data consolidation
  • Using Group Edit to input data into more than one place

Conditional formulae

  • The IF() function
  • Using IF to produce a result with multiple possibilities using just one formulae
  • Using operators such as AND, OR and NOT
  • SUMIF, COUNTIF
  • More Formulae
  • VLookup

Reducing your Audit Risk

  • Data Validation
  • Using Trace Precedents
  • Using Trace Dependents
  • Removing Arrows
  • Error checking
  • Evaluate Formula
  • Watch Window

Using Range names

  • Overview of working with Range names
  • Naming cell ranges in efficient ways
  • Changing and deleting Range name
  • Jumping quickly to a named Range
  • Using Range names in formulae
  • Using Range Finder

Brief introduction to Macro recording

  • Recording simple Macros
  • Playing back Macros
  • Assigning Macros to buttons
  • The limitations of recorded Macros; considering further development with VBA

Tables

  • Working with Tables

Charts

  • Creating and editing Charts
  • Using

Miscellaneous

  • Cell and document protection
  • Customising Excel

Live Chat

Course Dates

London CentralLondon GreenwichBristol

London Central

Dates Price Book Now
25 Mar £145 + VAT Book Now
22 May £145 + VAT Book Now
15 Jul £145 + VAT Book Now
23 Sep £145 + VAT Book Now
See more dates...

London Greenwich

Dates Price Book Now
27 Feb £245 + VAT Book Now
3 Apr £145 + VAT Book Now
8 Jun £145 + VAT Book Now
14 Aug £145 + VAT Book Now
See more dates...

Bristol

Dates Price Book Now
18 Mar £195 + VAT Book Now
4 May £195 + VAT Book Now
6 Jul £195 + VAT Book Now
9 Sep £145 + VAT Book Now
See more dates...


All our courses run in London and Bristol, or can be tailored to requirements at your own offices. For alternative dates, please email or call us on 0208 269 4260
All prices are per person and are subject to VAT
15% discount for groups of four delegates.
10% discount for groups of three delegates.
(This offer applies for delegates on the same public scheduled course on the same date.)


"Probably the best course I have been on. Very thorough and entertaining."

Cancer Research UK

"The trainer's knowledge was very strong and he was able to answer all my questions. Admin staff were very friendly and helpful."

VCCP

"Excellent. The right pace, the right style- great overall!"

Goldsmiths University of London



© Transmedia . 85 Tottenham Court Road, London, W1T 4TQ  UK . 0208 269 4260       Privacy Policy