Search

10 December 2019

After work Excel - evening bite size focus session

Category: MASTER COURSE

This hands-on evening course offers an in-depth take on some of the key areas of Excel in business, and provides tricks to speed up processing of Excel Workbooks. Discover best practice in writing complex formulae, manipulating lookup functions to extract diverse data, and lots of tips and tricks to help speed up processing.

Designed to complement the knowledge gained from attending Data analysis with Excel - intermediate or Data analysis with Excel - advanced, this course will help you build on those techniques to widen your skill-set and have better control over  working models.

This hands-on evening bite size session takes a focused look at some of the key areas of concern with Excel in business, and provides fast tricks to enhance processing of Excel Workbooks. The session covers lots of tips and tricks in formula writing, fast calculation techniques, getting back control of spreadsheets, and building integrity into Excel models.

This session is very hands-on and provides solutions to many day-to-day data problems faced in today’s businesses. We examine a range of Excel's lesser known techniques and functions that are not covered on our other courses. 

Who should attend?
This course will benefit those using Excel on a regular basis and wanting to learn more about performing various forms of analysis and exploring more complex functions and calculations. Also support staff, finance professionals and analysts wanting to increase their functional knowledge of Excel.

What you will gain
Discover how to:

  • apply more complex calculations to your spreadsheets
  • achieve greater flexibility and control while building integrity
  • manipulate formulae to do what you want them to do
  • use a variety of tricks in processing with speed.

Programme outline

Analyse some common business problems / limitations

  • Manipulate formulae for extra power
  • Data imports and update issues
  • Find the ‘nth’ instance in a range
  • Using CHOOSE as an array for greater flexibility
  • Fixing PivotTable issues

Tackle the top 5 dangers of using Excel in business and finance

  • Healthy solutions for streamlined spreadsheets
  • Reduce risk and take back control
  • Precision settings
  • Always making your charts dynamic
  • Restrict data input
  • Security

Tips and tricks

  • Shortcuts and hotkeys
  • Intro to Flash Fill
  • Intro to Sparklines
  • Tips for evaluating and reviewing calculations

Bonus section

  • Build a lightning quick dashboard
  • Fast techniques for expandable / flexible data ranges

The course starts at 6.00pm and finishes at 9.15pm. Refreshments are included.
3 CPD hours (where applicable)

CIMA work in partnership with BPP Professional Education to offer CPD training courses

Booking Information

Date Location Price
10 December 2019 - 18:00 London - evening session Price: GBP 315.00
Member price: £284. Plus VAT on all prices.


Related Events

11/12/2019 09:30:00

Data analysis with Excel - advanced

MASTER COURSE

  • Cost:
    GBP 634.00
    Member price: £571. Plus VAT on all prices.
  • Location:
    London
  • Speaker(s):

Discover how to use the more advanced functions of Excel - including structured references, dynamic listing techniques, scenario modelling - to create dynamic and expandable spread sheets.

Find out more

10/12/2019 09:30:00

Data analysis with Excel - intermediate

MASTER COURSE

  • Cost:
    GBP 634.00
    Member price: £571. Plus VAT on all prices.
  • Location:
    London
  • Speaker(s):

Harness the power of Excel. Discover how to: interpret, present and search for data from large quantities of information, synthesise information into a logical framework for analysis and summarise it in a meaningful format.

Find out more

09/12/2019 09:30:00

Data analysis with Excel - introduction

MASTER COURSE

  • Cost:
    GBP 634.00
    Member price: £571. Plus VAT on all prices.
  • Location:
    London
  • Speaker(s):

Excel essentials: quick tips to improve functionality, formatting techniques, data searching and calculations amongst large data sets within Excel. This course will provide an introduction to data analysis, reporting tools, data manipulation and searching, plus an insight into the simple automation of tasks using macros.

Find out more

After work Excel - evening bite size focus session

CIMA members and students should log in to MY CIMA before booking to receive the appropriate discount.

Book Now

In-house training 
We can develop tailored training programmes to enhance the finance and business skills of staff across your organisation. To discuss how we can meet your learning and development needs please email us.

Find out more 
If you have any queries please email cima@bpp.com or phone us on: +44 (0)3300 603400.

The venue for this course will be confirmed 14 days before the scheduled date. 

CIMA work in partnership with BPP Professional Education to offer CPD training courses.  

This course will be delivered by BPP Professional Education Limited (“BPP”).  Accordingly, when you sign up for this course, CIMA will pass on the contact details you have provided to BPP so that they can contact you to complete your booking and process payment.  BPP will process any personal information it collects about you in accordance with its privacy policy, which is available at: http://www.bpp.com/professional-education/privacy

The information provided to BPP will not be used by BPP for marketing purposes.

CIMA on demand 

Our catalogue of online CPD training courses designed to fit around your schedule.

Get any 5 courses for just £99 +VAT - limited time only.  

Find out more