Courses that have matched your search criteria

Online Half day | Price: £119 + VAT

Finance & IT:

Excel Intermediate (Online)

Get more for your money with our Learning Passport.  Find out more here


Timings

This online course runs in 2 sessions over the day.  Morning session from 9:30am - 12:00noon; afternoon session from 2:00pm to 4:30pm with breaks included. You will need to be available to attend both.

* Please note that this course is for PC users only, we do not currently offer Excel training for Macs.


Course overview

Our Excel intermediate course is ideal for the reasonably experienced user of Excel who wants to improve their skills when using Microsoft Excel. This Excel training course will develop your knowledge and teach you how to use more complicated functions.

You will train on the version of Excel that you use in your office or at home. Our courses are highly practical and interactive. We limit the class size to 8 to ensure the tutor has time to deal with any specific queries you may have. All Open courses take place in our Exeter training suite, we supply laptops for use during the session and your materials will be provided to you on a USB drive.

This course will build on your existing Excel skills and develop your knowledge to undertake more complicated tasks.

Who is it for?

A proficiency in basic Excel use is assumed. This course is designed for those who want to build on their existing Excel skills and learn the more complicated commands in Excel. This course is ideal for people who have been using Excel, but wish to gain a better understanding of the capabilities of this powerful application.

Anyone who has successfully completed our Excel Introduction Plus and feels ready to progress their skills will enjoy this course.

What will you learn?

You will develop more complex spreadsheets, use more advanced formulae and develop skills in data analysis techniques. You will learn how to work with multiple spreadsheets and how to link other spreadsheet and other workbooks. You will also learn how to link Excel with other Microsoft applications such as Microsoft Word.

Course Content

  • Customizing Quick Access Toolbar
  • Autofill – Fill By Example & Custom Lists
  • Working With Sheets, Links & Group Mode
  • Using IF, SUMIF, COUNTIF and other logical functions
  • Statistical functions, Rounding
  • Logical functions - Nesting, SUMIF & COUNTIF
  • Range Names
  • Linking to Word & External Workbooks
  • Short Cuts
  • Pivot Tables
  • Database Functions, Multiple Sorts & Filters
  • Date Arithmetic
  • Conditional Formats
  • Charting
  • Lookup Tables
  • Manipulating Data
  • Formatting and Display techniques
  • Sorting and Querying Data
  • Protection and Security

A note about attending a 'Virtual' training session

This course will be run on the Zoom video conferencing platform.

If you've never used Zoom - or any other video conferencing platform - before don't worry, it's quite straightforward!

Before the session, we'll send you instructions to help you get started. The key thing is to ensure that your video and audio settings are working, which you can test before the session.

All you'll need is a laptop/PC with audio and video capability, a good internet connection and somewhere quiet to sit and share a 'virtual learning space' with us.

Who is the trainer?

Sue Biggs – Senior Crisp Associate

 You may also be interested in?

Download a PDF of this course

Thank you, your email has been sent.

Sorry, there was a problem sending, please try again.

Benefits of the course

By the end of the session you will feel……

…..that you have expanded your knowledge of Excel and that you are able to undertake more complicated tasks with ease, saving you precious time.

Other people like you who attended this course commented:

  • Great course, Excellent Trainer”
  • “A really useful course with lots of Excellent hints and tips”
  • “Very informative and useful – really enjoyable too”

Date Thu 11 November 2021

Venue The Crisp Virtual Classroom (directions)

working...

I would like to book for person

Can't make these dates? Express an interest in the course and we will let you know when new dates become available

Please double check the form and try again

Thank you for letting us know!

Please enter your name

Please enter your email

Please enter your phone number

This is also available as an in house course - (for prices please contact us)