Online Microsoft Excel Intermediate Training Course

Our one day Online Microsoft Excel Intermediate training course will provide slightly more advanced knowledge of the use and functions of Microsoft Excel.

microsoft excel fundamentals training course

Intermediate

Many of us need to use Microsoft Excel in our jobs to produce a range of spreadsheets to show a wide range of business data.

Our Microsoft Excel Intermediate Training Course is designed to provide those that attend with slightly more advanced knowledge of how to use this very much used software.

Course Delivery Options

Online Course

Our Online Microsoft Excel Intermediate Training Course is only delivered as a one-day virtual online training course.

In-House

Great News! We can deliver our Online Microsoft Excel Intermediate Training Course as an in-house Virtual Course

Online Course Details

We run our Microsoft Excel Intermediate course as a virtual online training course. The course provides a practical toolkit and is delivered across one day. Despite being online, we try to keep these sessions as interactive as our classroom based courses.

Virtual Online Courses are delivered live by one of our trainers via our online conference system and form part of our online and virtual training service Skills Garage.

Here’s our current online Microsoft Excel Intermediate training course schedule. To book, select a date below and click Book Now. We’ll send the details of how to connect to your course a few days before the course date.

1 Delegate
£195.00 + VAT

2 Delegates
£185.25 + VAT

3 + Delegates
£165.75 + VAT

Timing
9.30am to 4.00pm

Price per delegate. Includes delegate course materials.

You can see the full schedule of open courses that we deliver by clicking here.

Please note. Our pricing is per person and not connection. As such, buying one space extends one person to take the course. If we suspect that more than one person is using a connection when only one place has been purchased, we reserve the right to terminate the connection without refund.

Please book the correct number of spaces for those taking the course.

Click a Tab, Get More Details

Here’s all of the details you need about our online Microsoft Excel Intermediate training course. We’re here to help if you have any other questions. You can see all of the ways to get in touch here.
  • Basic PC knowledge is required and a basic understanding of your operating system (Windows or MacOS)
  • The software installed on your PC
  • Access to Zoom via the Zoom app or your browser

Those who attend this Microsoft Excel Intermediate Training Course will be able to:

  • Produce multiple sheet workbooks
  • Use logical functions
  • Sort, filter and subtotal data in the spread sheet
  • Create graphs and charts to show data

Naming Cell Ranges

  • Naming individual and ranges of cells
  • Amending and deleting ranges
  • Using named ranges in formula’s as a navigation aid

Conditional Functions

Using a range of conditional functions such as:

  • IF
  • SUMIF
  • SUMIFS
  • AVERAGE
  • AVERAGEIFS
  • COUNTIF
  • COUNTIFS
  • IFFEROR
  • ISERROR

Conditional Formatting

  • Data bars
  • Colour Scales
  • Icon Sets

Linking Sheets and Files

  • Linking different Excel sheets and sheets in the same file
  • Viewing different files on one screen
  • Windows split and freeze panes
  • Watch window

List Management

  • Sorting and filtering data using a range of values
  • Multi-column sort and filter
  • Advanced filter
  • Adding sub-totals
  • Freeze Panes
  • Group and Outline
  • Data Form
  • Format As Table Feature
  • Data Consolidation

Auditing Formula Review

  • Tracing precedents and dependents
  • Go to special
  • Watch window

Advanced Charts and Graphs

  • Creating Chart Using Shortcut Keys
  • Saving custom chart as a template and as default
  • Applying Trendlines
  • Formatting and Editing Series, Plot Area, Data Points Chart Area, legends, etc…
  • Using Sparklines

We can deliver this Microsoft Excel Intermediate training course as an in-house virtual course for your business.

What is a Virtual Training Course you may ask? Rather than have our trainer travel to you to deliver a course, our trainer will join you via our conference system to deliver the course.

It means you can get your team together where ever they are based. You can get the team together in the same room. Or, have individuals join from where they are based.

Our Virtual Training Courses are normally one day in length and we deliver them in all subjects that are available on our site.

Because there is no travel involved, they are very cost-effective and good for the environment too.

We’ve made sure that you don’t lose any of the benefits of having a trainer with you in the room. Our Virtual Training Courses are still interactive, come with training materials and also include exercises, case studies and discussions.

To find out more about having an in-house virtual Microsoft Excel Intermediate training course delivered for your business, fill in the form below and we’ll get back to you.  Be sure to tell us what course you are looking for.  Alternatively you can call us on 03333 444575.

The reviews below are submitted by past delegates. If you would like to see more then please get in touch. We can pull together some feedback from our evaluation forms to help you make a more informed decision about this course.

There are no reviews to show for this course.

Download a copy of the Online Microsoft Excel Intermediate course overview by clicking here.