Skip to main content

Courses for Everyone

Excel Intermediate Level 1 course

Our Excel Intermediate Level 1 course is ideal for those with a basic understanding, often using existing models not created by themselves, who want 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.

Our courses are highly practical and interactive. Our in-person courses take place in our Exeter training suite, where we supply laptops for use during the session. We limit the class size to 8 to ensure our coach has time to deal with any specific queries you may have.

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

During this course you will learn;

  • quick methods of navigating and selecting ranges in a worksheet, together with many other shortcuts which will save you a huge amount of time.
  • naming ranges and using these in formulae together with a better understanding of building and using more complex built-in functions.
  • working with Tables, Pivot Tables and Conditional Formatting.

Course Content

  • Customizing Quick Access Toolbar
  • Autofill – Fill By Example
  • Flash Fill
  • Working with Dates and Date Functions
  • Statistical functions, Rounding
  • Logical functions; IF, SUMIF, COUNTIF, IFERROR
  • Range Names
  • Linking to Word & External Workbooks
  • Short Cuts
  • Pivot Tables
  • Database Functions, Multiple Sorts & Filters
  • Working with Absolutes & Relative Cell References
  • Conditional Formats
  • Charting
  • Using Lookup Function
  • Working with Tables
  • Formatting and Display techniques
  • Viewing Techniques
  • Sorting using Cell Colour

Why upskill in Microsoft Excel?

Microsoft Excel, the spreadsheet programme included in the Microsoft Office suite of applications, is used for analysing, sorting, reporting and storing data. Often, organisations choose to use Excel because its spreadsheets are simple to use and highly visual.

Upskilling your team with Excel training will provide them with the ability to organise and manage data more efficiently, allowing them to save precious time which can then be devoted to other projects. Our Excel training courses provide effective tips, techniques and formulas that will help individuals make the best use of Excel in your organisation.

Acquiring in-depth knowledge of working with Microsoft Excel functions and formulas will enable delegates to use Excel efficiently in their daily work life.

Here at Crisp Professional Development, we offer Excel training at three levels:

  • Excel for Beginners
  • Excel Intermediate Level 1
  • Excel Intermediate Level 2

A proficiency in basic Excel use is assumed. This course is designed for those who want to build on their existing Excel skills. 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 course for Beginners and feels ready to progress their skills will enjoy this course.

Virtual event tickets

Tickets

The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Standard
£ 149.00 / 1 Credits

In-person events

Crisp Professional Development

Crisp Professional Development, Pynes Hill Business Centre,
Exeter,DevonEX2 5JL

Tickets

The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Standard
Vegetarian and meat lunch options are provided. Regrettably we are unable to cater for any other specific dietary requirements. If this applies to you, please bring your preferred choice of lunch and snacks with you.
£ 249.00 / 2 Credits

Crisp Professional Development

Crisp Professional Development, Pynes Hill Business Centre,
Exeter,DevonEX2 5JL

Tickets

The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Standard
Vegetarian and meat lunch options are provided. Regrettably we are unable to cater for any other specific dietary requirements. If this applies to you, please bring your preferred choice of lunch and snacks with you.
£ 249.00 / 2 Credits

Build your own bespoke training programme

Talk to us about building a tailored programme of learning to suit your team's unique development needs.

Call us on
01392 409 198

or click here to fill in our contact form