Excel Skills for Reward Professionals: Intermediate Level
Course Information

Two-day class instructed by the world's foremost Excel for compensation expert – Dianne Auld

Date: 3-4 June 2019.
Location: central London
Duration: Two days, 9am to 5pm.
Format: Classroom course, maximum of 20 attendees.
Fees: £1,095 + VAT per delegate (includes postage and packaging of course book sent to you in advance of the class).

WorldatWork logo

E-reward.co.uk has teamed up with WorldatWork to offer its training classes in Excel skill building in the United Kingdom. We have commissioned Dianne Auld to design, develop and deliver two classroom courses focused and tailored so that we cover all of the essential Excel skills that are relevant to the needs of UK reward professionals – offering you the opportunity to enhance your learning as you progress from our Excel Intermediate level to Excel Advanced level.


Your tutor . . .

A world-leading 'Excel for reward' expert.

Dianne Auld is without doubt the most highly regarded and popular Excel for reward expert in the world. Based in South Africa, she travels worldwide demonstrating to reward professionals how to save hours and hours – some even say days – by harnessing all the power of Excel.

Two superb Excel courses tailor made for reward professionals

Dianne has worked with E-reward and WorldatWork to carefully devise a study programme to assist reward professionals with their day-to-day tasks in Excel. These Excel for Reward classroom courses – Intermediate and Advanced – include sleek visual and audio demonstrations of tasks reward professionals need to perform in their job function. During these demonstrations, students follow the instructions being highlighted by Dianne, and immediately afterwards undertake a parallel exercise on their own, with teacher guidance, to cement the learning.

You will enhance your ability to analyse mountains of data in seconds with professional looking charts and Pivot Tables. Unlike other Excel courses, our classes have been specially developed to help you master skills specific to compensation and benefits work not taught in any other general Excel course. These courses are UNIQUE.

Dianne will be visiting London once a year to lead these classroom courses. Her courses always sell out. Enrol now on our educational courses so that you can be confident about enhancing your Excel skills in the workplace. You’ll have the powerful Dianne Auld training name on your CV, as a quality mark of achievement in Excel for Reward. You can also be confident that you will possess the enhanced Excel skills for reward being sought by today’s employers.

Excel Skills for Reward Professionals: Intermediate Level

Designed for reward professionals who are using Excel on a day-to-day basis in their reward work but who want to gain a deeper understanding of the more sophisticated facilities offered in the compensation data area.

Reward professionals today require a high level of proficiency in Excel in order to effectively analyse remuneration data. They need to know how to use pivot tables, charts, advanced data and formatting techniques, lookup, if and statistical formulas. Having the required proficiency in these areas can make the difference between taking three minutes to do a job or three days. What’s more, gaining this understanding can enable reward practitioners to concentrate on extracting insights from the data rather than wasting time crunching numbers. The typical reaction from delegates attending this course is – ‘If only I'd known how to do this last week!’

Our hands-on practical course covers the essential Excel skills required to analyse market and organisation remuneration information. It has been created for reward, HR and payroll professionals who would like to enhance their Excel skills, and perform complex job tasks such as compiling and analysing data and performing calculations. For those who already have a good working knowledge in Excel, this course will provide you with the expertise and skills to use Excel at a higher level.

Level of knowledge required

A good basic to intermediate understanding of Excel is required before attending the workshop. To get the most out of this course, we recommend that:

  • Students are working with remuneration data in Excel on a regular basis in their work.
  • Students should have good navigational skills in Excel, and be able to select, copy, move, paste, edit and sort data with ease.
  • Students should be comfortable with working with large amounts of data and entering formulas.

Dianne says:

‘The ideal candidate for this course would already be familiar with some of the information covered on the agenda. But this course will greatly enhance their ability to analyse mountains of data in seconds with professional looking charts and Pivot Tables. Anyone with a good understanding of Excel will dramatically increase their productivity levels when working with remuneration data in Excel. This course is designed for compensation professionals who need to use Excel to perform complex job tasks such as compiling and analyzing compensation data and performing calculations.’

Documentation

A workbook is provided with detailed (click-by-click) instructions on how to carry out every function demonstrated. The workbook covers Excel 2007, 2010, 2013 and 2016. Excel files are also provided to each delegate complete with all the training and exercise spreadsheets used during the workshop. These Excel files will be emailed to you in advance of the course.

Requirements

This course requires you bring a Windows PC laptop (not Mac) with Microsoft Excel 2007 or later (plus charger). We recommend that you bring a mouse to the course to help with extensive on-screen navigation.

Teasers

1. Did you know that you can use Control E in Excel 2013 to separate first name and surname for the whole column at one time?

Find out other quick ways to separate columns, combine columns, and change case for the whole column at one time.

2. Did you know that you can press the F11 key to create a chart?

Find out other time-saving tips for creating great looking column charts, bar charts, line charts and pie charts.

3. Did you know that you can use the Pivot Table Report Filter function to create one pivot table per division or manager at the click of a button?

Find out how to harness the power of pivot tables for analysing and reporting on data at this course.

4. Did you know that you can enter today’s date in a worksheet by pressing Control and semi-colon or typing =TODAY()?

Find out how to master tricky dates in Excel, how to format them to sort correctly, and how to calculate age, length of service or time in job using one simple date formula at this course.

5. Did you know that you can prevent Mail Merge showing lots of decimals like this – 485.6789 – by using a simple ROUND formula in the Excel source data?

Master rounding formulas, and the most important and time-saving formulas in Excel: Vlookup and If formulas, by attending this course. As a bonus, also learn Hlookup, If(And), If(Or) and Iferror!

Here is what some of Dianne's recent students in London told us about their learning experience . . .

'Absolutely fabulous course. I learned so much. Dianne was so knowledgeable and shared so well. I've saved days and days now!'
'Fantastic course.'
'Very informative course, explaining the possibilities of Excel. My life will be so much easier now I understand the capability of Excel in terms of compensation and reward.'
'Dianne was great and extremely knowledgeable.'
'Excellent instructor, very clear, good pace, always ensuring everyone is up to speed and keeping up with the rest of the class.'
'Good Central location. Course content was well put together, very relevant to work and was made interesting by Dianne. I would highly recommend the course to anyone wanting to save time and understand Excel functions. Really pleased I attended.'
'The instructor was very friendly and informative, no improvements needed!'
'Great food, spacious rooms, not too many in a class, friendly smart staff, great facilities.'
'The stuff you need to know as a comp professional. Very helpful and presented in an easily accessible manner.'
'Great course, full of tips and techniques.'
'Valuable course, fantastic knowledge of the trainer. Very helpful, small group, learnt lots of quick short cuts and extremely valuable time-saving techniques.'
Dianne Auld, GRP, CCP, CSCP
Dianne Auld, GRP, CCP, CSCP
Senior Consultant

A WORLD-LEADING 'EXCEL FOR REWARD' EXPERT

Dianne is without doubt the most highly regarded and popular ‘Excel for Reward’ expert in the world. Well respected and distinguished in the compensation field and Excel, her skills and expertise are in high demand. Based in Cape Town, South Africa, she travels worldwide showing reward professionals how to save hours and hours (some even say days!) by harnessing all the power of Excel.

Dianne has partnered with WorldatWork to develop a wide-ranging educational programme to assist reward professionals with their day-to-day tasks in Excel. In conjunction with WorldatWork, she has developed a series of Excel learning products including: Excel Skills for Compensation Professionals; Excel Tips; Compensation Excel Dashboards; and a series of Sales Compensation Excel Dashboards. Dianne is also a faculty member at WorldatWork and a reviewer for the WorldatWork Journal. Since 2012, she has presented each year at the Worldatwork US Total Rewards conference.

Dianne owns a consulting practice, Auld Compensation Consulting, in South Africa. She consults to a wide range of organisations across Africa and the Middle East in all areas of total rewards: reward strategy, base pay management, remuneration surveys, job evaluation, broadbanding, pay structuring, incentive design and sales compensation. She has developed and taught courses in Africa, the Middle East, the Far East, Europe, and the United States.

VENUE AND ADMIN. DETAILS

The venue

The Cumberland, Great Cumberland Place, Marble Arch, London W1H 7DL.

London airports

London is served by five main airports, from the UK's main gateway at London Heathrow to London City Airport in the Docklands. For information on getting to and from London airports to Holborn in central London, visit Transport for London at www.tfl.gov.uk

Special requirements

Please let us know if you have any special requirements as soon as possible so we can plan accordingly.

Hotel accommodation

Delegates are responsible for their own accommodation.

Do you need a visa?

A questionnaire on the UK Border Agency web site will help you to decide whether you need to obtain a visa before you travel to the UK. It also contains guidance on the type of visa that you might need. The questionnaire is for all foreign nationals who want to come to or transit the UK. ('Transit' means to pass through the UK on your way to another country without staying here.)

Please visit: www.ukba.homeoffice.gov.uk/visas-immigration/do-you-need-a-visa/

Dress code

Casual.

Documentation

You will receive your course materials on arrival for the class.

Refreshments

At registration we will serve you complimentary teas and coffees. Mid-morning break of teas and coffees are served at around 11.00am. Lunch will be served at approx 12.00pm.

Aspects covered in detail during this two-day course include the following:

  • Customising the Quick Access Toolbar/Importing and formatting remuneration data – including combining data from different columns, dividing data into different columns, changing case and text formulas
  • Rounding numbers/Custom formatting/Working with dates
  • Valuing the total reward package – including Vlookup, Hlookup and If formulas
  • Validation/checking of remuneration data (including the Data Filter, Custom Filter and removing duplicates)
  • Sub-totalling remuneration data
  • Comparing/Projecting remuneration data/Applying conditional formatting to market comparisons
  • Statistics for remuneration data
  • Graphing remuneration data
  • Scattergrams, trend lines and regression analysis
  • Pivot Tables and Goal Seek.

With this class you will:

  • Learn skills specific to compensation work not taught in any standard Excel course.
  • Save hours of work when you import, merge and format large amounts of data for analysis.
  • Learn how to analyse mountains of data in seconds with professional-looking charts and Pivot Tables.
  • Face your fear of regression analysis and easily create a pay policy line and salary predictions.
  • Perform complex calculations in minutes using the SUBTOTAL function.
  • Harness the power of VLOOKUP, HLOOKUP, IF, AND, OR and IFERROR functions.

Learning objectives

  • Customise the quick-access toolbar
  • Create charts, graphs and tables from various types of data
  • Use formulas to simplify complex calculations
  • Check data for duplications and errors
  • Calculate subtotals
  • Calculate a variety of statistics
  • Calculate linear and exponential regression.

Next class

London 03/06/2019 - 04/06/2019

TERMS AND CONDITIONS FOR E-REWARD.CO.UK COURSES

THE FOLLOWING TERMS AND CONDITIONS APPLY TO THE DELIVERY OF EDUCATION COURSES BY E-REWARD.CO.UK LTD (INCLUDING MASTERING REWARD COURSES; WORLDATWORK GLOBAL REMUNERATION PROFESSIONAL CERTIFICATION [GRP] COURSES AND EXAMINATIONS [PROGRAM]; IN-HOUSE AND CUSTOMISED TRAINING COURSES).

These terms and conditions apply between the person, firm, company or other entity specified on your booking form and E-reward.co.uk Ltd (company number: 4281768). Registered in England and Wales. Registered office 33 Denby Lane, Heaton Chapel, Stockport, Cheshire SK4 2RA, United Kingdom for delegate registrations for the course (including Mastering Reward courses, GRP courses with exam and in-house training courses) specified on your booking form (‘Course’).

Please read these terms and conditions carefully as they contain important information.

By submitting your registration to attend the Course you agree to be bound by these terms to the exclusion of all other terms. If you do not agree to be bound by these terms E-reward.co.uk Ltd will be unable to accept your registration.

Payment

You will pay E-reward.co.uk Ltd any fees specified in your booking form for the Course. Payment to E-reward.co.uk Ltd in GBP British Pounds is by BACS, wire transfer, cheque or credit card. It is a condition of booking that payment must be received by E-reward.co.uk Ltd before the start of the Course or no later than 30 days from the date of invoice, whichever is sooner.

If payment of your fees in full is not received before the Course, E-reward.co.uk Ltd may (at its sole discretion) either require such payment as a condition of your entry to the Course or refuse you entry to the Course.

Prices for each Course, where applicable, are correct at the time of publication. We reserve the right to change the prices at any time but changes will not affect registrations which have already been confirmed by E-reward.co.uk Ltd.

Each ticket covers attendance for one person only for the duration of the Course, and includes coffees, teas and light snacks during the lunch hour, as well as course materials.

All bookings are subject to value added tax (VAT) at 20%. You shall, on receipt of a VAT invoice from E-reward.co.uk Ltd, pay to E-reward.co.uk Ltd such additional amounts in respect of VAT as are chargeable on the supply of the Course.

Late payments

We understand and will exercise our statutory right to interest and compensation for debt recovery costs under the late payment legislation if we are not paid according to agreed credit terms. Under the Late Payment of Commercial Debts [Interest] Act 1998 – as amended and supplemented by the Late Payment of Commercial Debts Regulations 2002 (to incorporate the features of European Directive 2000/35/EC) – we are entitled to charge:

  • Debt recovery costs – £40 on debt up to £999.99; £70 on debt between £1,000 and £9,999.99.
  • Statutory interest – 8% above the Bank of England reference rate (fixed for the six month period within which date the invoices became overdue).
Delegate cancellations

Delegates who advise E-reward.co.uk Ltd of their cancellation in writing via email (to paul@e-reward.co.uk) 30 calendar days or more before the start of the Course will have their fees refunded – less an administration charge of 20% of the Course fees.

No refund will be made for cancellations received less than 30 calendar days before the start of the Course. Failure to attend the Course will be subject to the same terms.

You will not have any right to cancel a Contract for the booking of any customised/in-house training courses.

Delegate transfers

Transfers may be made to any other Course in the UK organised by E-reward.co.uk Ltd subject to space availability. All transfer requests must be made in writing via email (to paul@e-reward.co.uk) 30 calendar days or more before the start of the Course. There will be no fee charged for such transfers. One free transfer can be made for each course booking after which there will be a £100 administration charge for each further request.

Please note: We are unable to accept any transfer requests received less than 30 calendar days before the start of the course and no refunds will be made.

Substitutions with employees from your organisation are welcome at any time at no extra charge. You must email any substitutions (to paul@e-reward.co.uk) prior to the date of the Course.

Joining instructions

Final Course details will be emailed to delegates at least three weeks before the Course.

Course documentation

You will receive your course materials by post (First Class, Standard delivery) ahead of the Course. Participants registering 0-14 days before the start of the Course will receive their course materials on arrival for registration on Day one of the Course.

Hotel accommodation

Delegates are responsible for their own accommodation. E-reward.co.uk Ltd has arranged for delegates to receive discounted rates at Club Quarters Lincoln’s Inn Fields.

Course cancellations and amendments

The Course programme is correct at the time of going to press.

E-reward.co.uk Ltd reserves the right to change the format, speakers, venue location and programme or any other aspect of the Course at any time and for any reason, whether or not due to a Force Majeure event, in each case without liability.

‘Force Majeure Course’ means any event arising that is beyond the reasonable control of E-reward.co.uk Ltd including (without limitation) speaker or participant cancellation or withdrawal, supplier or contractor failure, venue damage or cancellation, health scares, industrial dispute, governmental regulations or action, military action, fire, flood, disaster, civil riot, acts of terrorism or war.

E-reward.co.uk Ltd reserves the right to change the date or cancel a Course at any time and for any reason without notice. Where circumstances force E-reward.co.uk to cancel a Course, E-reward.co.uk Ltd shall offer you the option of attending any rearranged Course that E-reward.co.uk Ltd chooses to organise.

If you do not wish to accept this offer, then you will (as your sole remedy) be entitled, at your discretion, to receive either a credit note or a refund in respect of your fees received by E-reward.co.uk Ltd for that particular Course.

However, where the Course is postponed for reasons due to a Force Majeure event, any of your fees received by E-reward.co.uk Ltd shall be applied to any rearranged or rescheduled Course and all these Terms and Conditions shall apply to any such transferred booking.

To the fullest extent permitted by the applicable law, E-reward.co.uk Ltd shall not be liable to you for any loss, delay, damage or other liability incurred resulting from or arising in connection with the cancellation or date change of the Course howsoever arising or any venue change.

For the avoidance of doubt, you acknowledge and agree that should the Course date be changed or cancelled, E-reward.co.uk Ltd is not liable for any travel or accommodation costs you may have incurred.

How we use your registration information

E-reward.co.uk Limited is a registered data controller under number Z7317541.

Your Course registration information will be added to our marketing database but will not be given to third parties without your prior consent.

E-reward.co.uk Ltd uses email addresses for its own purposes of keeping customers informed about Courses and providing product, service and information announcements.

If you supply us with your postal address online, you may receive periodic mailings from E-reward.co.uk Ltd with information on new products and services and upcoming Courses.

If you do not wish to receive information about products and services, please let us know by email (to paul@e-reward.co.uk).

Disclaimers

To the fullest extent permitted by the applicable law, E-reward.co.uk Ltd excludes:

  • all liability for loss, injury or damage to persons or property at the Course;
  • all indemnities, warranties, representations, terms and conditions (whether express or implied); and
  • any actual or alleged indirect loss or consequential loss howsoever arising suffered by you or any loss of profits, anticipated profits, savings, loss of business revenue, loss of business, loss of opportunity, loss of goodwill, or any other type of economic loss (whether direct or indirect).

If E-reward.co.uk Ltd is liable to you for any reason, its total liability to you in relation to the Courses (whether under these terms or conditions or otherwise) is limited to the amount of your fees received by E-reward.co.uk Ltd.

Views expressed by the Course instructors are their own. All advice provided at this course is for general guidance only. Any course delegates relying on information or advice given in the course of such training do so at their own risk.

E-reward.co.uk reserves the right to amend these terms and conditions from time to time. However, you will be subject to the terms and conditions in force at the time you submit your registration.

Last updated: 22nd June 2016.