Demystify the numbers and master Excel

Bite-sized Management Development Courses delivered by MDHUB for companies looking to support their management teams...

Demystify the numbers and master Excel

A Gentle Introduction to Finance

Understanding basic finance is one of the key roles an MD, Director or Senior Manager require.  You may have been promoted for your talents or be busy running your own business, but have not had basic training in understanding the numbers.  This is surprisingly common and you will be in good company!


This will be an excellent opportunity to spend two half days demystifying the financial side of your business and you will leave feeling more in control of the numbers and able to interpret what they mean.

  • How to read a set of accounts
  • Working with cost and budget
  • Financial forecasting
  • Managing cashflow 


This is a two-part course being run twice during 2016


Course 1 dates
Part One: Thursday25th February,  9am - 12.30pm
Part Two: Thursday 3rd March, 9am - 12.30pm


Course 2 dates
Part One: Thursday 7th April, 9am to 12.30pm
Part Two: Thursday 14th April, 9am - 12.30pm


Venue
The Boardroom - VW Heritage Parts Centre Ltd, 47 Dolphin Road, Shoreham-By-Sea, West Sussex BN43 6PB


What will it cost?
£250.00 plus VAT per 2 part course for MDHUB Members
£350.00 plus VAT per 2 part course for Non Members
Prices include all training and refreshments.
Places are limited to 8 people for these courses.

____________________________________________________________________________________

Getting to grips with Excel

This course is broken down into three parts and you can elect to attend all three parts or select a part (or parts) according to your knowledge level. Each part is a one-day course and you will need to provide your own laptop or tablet at the session.


Part 1 - Introduction

  • Understanding the Excel screen and elements
  • Customising the Quick Access Toolbar 
  • Creating/saving and printing workbooks
  • Using multiple sheets
  • The importance of named ranges
  • Using dates and times
  • Moving and copying and autofill
  • Entering basic formula
  • Relative and absolute cell referencing
  • Professional formatting

Part 2 - Intermediate

  • Recap on Excel principals
  • Splitting/freeze panes, custom views
  • Working with multiple workbooks
  • Creating and merging styles
  • Conditional formatting & conditional statements
  • Autofiltering and advanced filtering, automatic subtotalling
  • Hyperlinking to web pages/other excel workbooks
  • Using the outline facility, charting feature and creating sparklines
  • Working with pivottables
  • 3D formula

 Part 3 - Advanced

  • Recap on Intermediate Excel course
  • Validating of data
  • Consolidation of Multiple spreadsheets
  • Scenarios and scenario manager
  • Simple macros and assigning to QAT
  • Creating and using templates
  • Data tables & lookup functions
  • Goal setting


Dates
Part 1 Introduction
Friday 15th April, 10am to 4.30pm
Part 2 Intermediate
Thursday 21st April, 10am to 4.30pm
Part 3 Advanced
Thursday 28th April, 10am to 4.30pm


Venue
The Boardroom - VW Heritage Parts Centre Ltd, 47 Dolphin Road, Shoreham-By-Sea, West Sussex BN43 6PB
What will it cost?


£250 plus VAT for MDHUB Members per day
£350 plus VAT for Non-members per day
 
Prices include all training and lunch/refreshments. 
Places are limited to 8 people for these courses.

To book a place or to find out more, please contact ruth.maddison@mdhub.co.uk


Categories: Training