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?

• Excel Introduction Plus (Online)
• Excel Introduction Plus (Face-to-Face)
• Finance for non-Finance Managers (Face-to-Face)