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

  • Using Workbooks properly
  • 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
  • Using nested IF()s

More advanced functions

  • The LOOKUP() function
  • The INDEX() function
  • The MATCH() function

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

Outlining and Pivot Tables

  • Using the Outline feature to produce a collapsible formula sheet
  • Creating an Outline manually
  • Showing and hiding detail data
  • Understanding Pivot tables
  • Creating a Pivot Table
  • Adding fields to a Pivot table
  • Charting a pivot table
  • Formatting pivot tables
  • Hiding or displaying items in a Pivot Table
  • Displaying sub-totals and totals in rows and columns

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

Miscellaneous

  • Cell and document protection
  • Customising Excel

This course is available as a private or customised course. Contact us for further information and to customise this course to your exact requirements:

Phone us: 0208 269 4260Book Now


"Really impressed! I enjoyed the training and would like to do more in the future."

Silk Pearce

"Very thorough course and enthusiastic trainer who was very helpful and responsive to individual needs."

NVIDIA

"Informative, useful, relaxed - Excellent! Will certainly use Transmedia again."

Tate & Lyle



 

 

© Transmedia . 277 Greenwich High Road London SE10 8NB  UK . 0208 269 4260
Designed by Transmedia's Web Team