This Level 3 course is designed for experienced and highly proficient users of Excel and builds on the concepts learned in ‘Excel Level 2: Beyond the Basics’.

We aim to develop a range of more advanced skills to become true “power” users. Revolutionise the way you manage, present, or otherwise run your department or business! This course prepares delegates for the ‘Excel Level 4 – Pro User’ course.

To avoid booking a course that is either too hard or too easy, too fast or too slow, we ask that all delegates complete a pre-course checklist to assess their current level of Excel knowledge. This will enable us to ensure that all delegates are on the right course and able to follow the training at a similar pace:

Excel Assessment: Are you a beginner or pro? Find out here

If we feel that you are “beyond” the elements and concepts discussed in this course – we will recommend which level we feel would most benefit you. This assessment can save both time and money!

What we will cover:

  • Review of Excel Basic Formulas and Functions
  • Using Multiple Workbooks
  • Working with Large Worksheets
  • Using Logical and Date Functions (IF, TODAY, NOW, MONTH, YEAR, TEXT)
  • ‘Nesting’ functions
  • Using the SUMIF/COUNTIF functions
  • Advanced Formatting Features
    • Styles
    • Auto-format
    • Sparklines
    • Conditional formatting and Data bars
  • Linking Worksheets and workbooks
  • Working with Data Lists and Tables (Sorting, Filtering, Sub-Totals)
  • Using more detailed Charts in Excel

This course is instructor led and involves useful examples and exercises in a workshop environment to enable delegates to work ‘smarter’ with Excel as well as learn useful techniques, tips, and tricks.

Please Note: Delegates should bring a laptop with Excel 2016 or newer installed (unfortunately not an Apple laptop or a ‘web based’ version of Excel). Whilst not essential, the laptop should have a mouse attached as this can be quicker for users during the course.

IMPORTANTThe trainer will need to install exercise files on your laptop should you choose to use your own. Some company laptops are not suitable as they have certain features disabled which prohibit the loading of files.

We do have a few laptops that can be hired for use during the course but should be arranged in advance.

We have an 8 delegate maximum per course so please book early to avoid disappointment.

Book Your Place Now

FLEXIBLE TRAINING:
You can arrange to have this training onsite at your facility on a date and time that is most convenient to your team. Contact us to discuss a bespoke or on-site offering today.

Price :
Members: £139; Affiliate: £169; Non-Members: £189
Book your place

Time:

09:30 - 16:00

Venue:

1 Lockheed Court
Amy Johnson Way, Blackpool
Lancashire, FY4 2RN

To book your appointment please contact the Chamber on:

01772 653 000

Email us