This course is delivered over two 2.5 hour sessions on Tuesday 22nd June:

Morning: 09:30am - 12:00pm and
Afternoon: 2:00pm - 4:30pm

This course can be booked as:

a place on the live, online event for the date displayed above. Simply click the 'Tickets' button to get started
1 credit from a Virtual Learning Credit Plan, saving you 16% off the full price (call us on 01392 409 198 to buy a credit plan)
an In-Company training course just for your team on a date that suits you (call for details on 01392 409 198)

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

To view our other upcoming live, online courses, visit:

https://www.crisp-cpd.com/training-courses/open-courses

Please feel free to get in touch with our team on 01392 409 198 or email open@crisp-cpd.com to discuss;

Online open courses, including our training credit plans
In-company training
ILM accredited training
Coaching
E-Learning

... or with any other questions. We'd love to chat!

Excel Intermediate | LIVE Online Event |

Follow this organiser to stay informed on future events

Events you might like

Microsoft Excel Beginner to IntermediateMicrosoft Excel Beginner to Intermediate

Excel Mastery for Beginners to Intermediate UsersExcel Mastery for Beginners to Intermediate Users

Microsoft Excel Beginner to Intermediate

Excel Mastery for Beginners to Intermediate Users