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


"Extremely friendly and helpful. Excellent knowledge and presentation."

Just Digital

"Staff were helpful and the course was relevant to my needs. A great course!"

VCCP

"Our trainer was calm, reassuring and passionate about the course."

Torpedo Group



 

 

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