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


"I just wanted to let you know that I've managed to replicate the steps you showed me in FileMaker on my organisation's database and have managed to get my invoicing layouts to work perfectly. Thank you very much! I've also been able to use some of the other things you showed me to good effect too so the course has already helped enormously. Just thought you should know :-)"

Julian Support

"I just wanted to say a big thank you for yesterday. I really enjoyed the training and we got a lot done. The database looks really amazing, specially with the starter page and the logo. Thanks to Megan & Debra for sorting out the admin side and looking after me. "

Paresh Dudhaiya

"The whole experience was great. Trainer and staff were extremely helpful and approachable."

Faithful & Gould



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