Excel: Acquiring Critical Skills For Data Manipulation (short course)

Add to my prospectus Why study this course? More about this course Entry requirements Course structure How to apply Meet the team Visit us

Why study this course?

This course is about mastering critical Excel skills the nature of which gives delegates a clear edge in the current job market. The course is aimed at all city workers and other potential business users. 

More about this course

The course will enable participants to understand how to use Excel to analyse and manipulate financial workbook data. Participants will learn how to: employ sophisticated data manipulation tools; use ready-made macros; create macros from scratch; embed macros in the worksheet; and develop a worksheet application. The course is aimed at a wide audience including all city workers and other potential business users.


In-class mini tests and exercises

Fees and key information

Course type Short Course
Entry requirements View
Apply now

Entry requirements

This course will appeal to a wide audience including all city workers and other potential business users.

Course structure

Topics covered include:

  • Lookup tables, pivot tables, goal seek analysis and scenario reports
  • Recording macros, embedding macros and Conditional Formatting
  • Functions: max, min, average, sum, count and IF
  • The macro programming environment

How to apply

If you wish to apply for this course, download the Short Course Application Form . Once complete please return to Chris Luenen at professionaldevelopment@londonmet.ac.uk

As soon as your application has been processed and accepted, you will be contacted by the course organiser in order to arrange payment and obtain further information about the course.

When to apply