Excel 100x100

Excel 2013 Core Level 3

This course is for anyone who has been using Excel for budgets or other data that needs calculations and would like to learn more features to improve their ability to organise and analyse data.  Learners must have used Excel before to create calculations that include absolute cell references (e.g. $B$4) and IF statements.

Course Dates:

20th Oct 2016 (fully booked)

17th Nov 2016 (spaces available)

13th Dec 2016 (spaces available)

9th Jan 2017 (spaces available)

10th Feb 2017 (spaces available)

8th Mar 2017 (spaces available)

5th Apr 2017 (spaces available)

2nd May 2017 (spaces available)

31st May 2017 (spaces available)

28th Jun 2017 (spaces available)

Course Length: 1 day

Course Costs:

Standard Price: £300 (+VAT)

Public Sector: £245 (+VAT)

Charity: £200 (+VAT)

Book now

Course Location

Happy, Alie Street – view map & directions

Course Requirements

Learners should be confident creating basic IF functions and Pivot Tables as well as simple bar charts.

What You Will Learn

In particular you will be able to:

  • Create Partial Absolute Cell References to lock just the Column or just the Row reference in a formula
  • Move around a spreadsheet speedily using range names and use them in formula to improve accuracy and readability
  • Accurate data entry by using Data Validation. e.g. a dropdown list to choose from to avoid errors
  • Advanced Conditional Formatting – using ‘If Formula Is’ to format cells other than the one that contains the value you are testing
  • Create calculations based on single or multiple conditions. For example, calculate a discount for those over a specific age or ordering a high volume (IF with AND and OR)
  • Use ISERROR and ISNA to tidy up your results
  • Cross reference data using an Hlookup or Vlookup function. For example, look up a National Insurance Number to find other personal details from another sheet or book
  • Use Formula Auditing tools to check for errors and make nested formulas easier to fix
  • Create charts that include a secondary axis and trendlines
  • Create Pivot Charts
  • Create macros to automate your work and assign it to a toolbar button to to make it easier to use
Book now

Timetable

Session 1

Recap; Partial Absolute Cell References; Using Paste Function; Good Design Principles; Range Names; Data Validation.

Session 2

Conditional Processing – Using the If Function with AND and OR; Nesting Ifs with ISERROR and ISNA, Vlookup or Hlookup to categorise and find an exact match, Auditing and Error Spotting.

Session 3

Charts with Trendlines, Adding a Secondary Axis, Pivot Charts.

Session 4

Introduction to Macros – Running and recording macros; Assigning a macro to a button on a toolbar.


SMALL PRINT

The course will run from 10am to 4:45pm (light cold buffet 1pm to 1:45pm). Please be careful to arrive by 9.45am for registration and refreshments. The course will start precisely on time and it may not be possible to go back over material missed by late arrivals. If you arrive over 30 minutes late you may be asked to leave and attend another day.

Your Course Trainers

Ed Lepre

Ed Lepre

Ed has been an IT trainer with Happy for nearly 11 years. His favourite package is Excel - which he trains to advanced level. He is also the new IT Helpline Manager (when he's not training).

Darren Andrews

Darren Andrews

Darren manages the IT helpline, as well as training almost every IT course on the Happy computers programme. He has been with Happy for nearly 9 years.

Rachael Worral

Rachael Worral

Rachael is the Happy Computers Product Development Manager, as well as being our lead IT trainer. She is responsible for making sure all our courses are of the highest quality.