Microsoft Office training -  Excel Intermediate

Excel Training

Intermediate Excel Training Course

£295 + VAT for most venues (£395 + VAT for London)

1 day

Once you've got the basics of Excel, it's time to learn a little more about what you can do.  This one-day intermediate course will show you how to use range names, sort and filter lists, create decision (IF) functions and much more!

Course details

  • Locations for Excel Intermediate coursesLocations:Manchester, London
  • Next Excel Intermediate course locationNext course:Thu 08 November 2018
  • Excel Intermediate course timesTime:09.30-16.30

Course Contents

Absolute references

  • Training topicAbsolute cell references
  • Training topicUsing the $ sign

Range names

  • Training topicCreating range names
  • Training topicEditing/deleting range names

Conditional formulae

  • Training topicCreating a single =IF formula
  • Training topicUsing =SUMIFS and =COUNTIFS
  • Training topicCombining conditions (AND, OR and NOT)

Conditional formatting

  • Training topicCreating cell rules
  • Training topicManaging cell rules
  • Training topicViewing conditional formats
  • Training topicData bars and icon sets

Basic tables

  • Training topicUsing a spreadsheet as a table
  • Training topicSorting table data
  • Training topicFiltering table data
  • Training topicTable styles (a warning!)

Advanced printing

  • Training topicLayout versus Preview tab
  • Training topicPrint areas and print tiltes
  • Training topicSetting/removing page breaks
  • Training topicHeaders, footers and page numbering

Formatting numbers and dates

  • Training topicStandard number formats
  • Training topicHiding cell contents
  • Training topicDate formats

Working with dates

  • Training topicUsing series fill
  • Training topicUsing dates in formulae
  • Training topicTODAY and NOW

Covered if time allows If time

Data validation

  • Training topicSetting validation rules
  • Training topicInput and error messages
  • Training topicHighlighting validated cells
  • Training topicCircling invalid data

Protection

  • Training topicHow protection works
  • Training topicUnlocking cells
  • Training topicTurning protection on for a worksheet
  • Training topicProtecting the whole workbook

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Nicely paced with great instructor. Also, worth mentioning that the tutor went the extra mile to help me with material at the end of each day. I had seen many of his videos online which I found immensely helpful and was really pleased to find he was just as great a teacher face-to-face."

Quentin Harris (NHS North & East London CSU)

"Course was taught at a good pace. The instructor was good and always able to answer questions. Detailed manuals with fun and helpful exercises."

Lucy Onyango (PricewaterhouseCoopers Services Ltd.)

"The course content was well delivered and the support material well structured and helpful. A very enjoyable course which will be very useful in my future work."

Philip Iddon (Sellafield Ltd)

"Course was brilliant and very helpful trainer. Was very friendly and knowledgeable. Thank you."

Marcio Franco (Royal Borough of Kensington & Chelsea)

"Course manual looks really detailed and a great reference. Also glad that it includes some things that weren't necessarily covered in the course eg subscriptions. Excellent course overall. The trainer was really helpful and engaging. Used a lot of Wise Owl material online which is brilliant."

Matt Curley (NHS Digital)

There are lots more where these came from (or just refresh this page to change the quotes shown).

You shouldn't attend this course unless you're already familiar with creating formulae in Excel.

Scheduled Excel Intermediate training dates

Here are the Excel Intermediate courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Thursday 08 November 2018 1 £295 Book places
Tuesday 11 December 2018 1 £295 Book places
Friday 04 January 2019 1 £395 Book places
Wednesday 06 February 2019 1 £295 Book places
Friday 29 March 2019 1 £295 Book places
Date(s) Venue
08/11
11/12
04/01
06/02
29/03

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite Excel training at your offices (we'll even provide and set up the computers).

Other Microsoft Excel training resources

Excel exercises

Excel exercises

To help you determine if this is the right course for you, we've published all of our Excel exercises online.

View Excel, Excel VBA or PowerPivot exercises

Excel videos

Excel videos

In addition to providing classroom training, we've also created a series of online training videos on Excel.

View Excel tips, Excel VBA - Basics, Microsoft Excel, PowerPivot or Excel VBA - pivot tables/charts videos

Excel skills assessment

Excel skills assessment

You can test how well you know Excel by taking one of our skills assessment tests.

View Test your current Excel skills or Test your VBA knowledge skills assessment tests

Excel blogs

Excel blogs

We've published lots of blogs on various aspects of Excel, which make for good reading for when you have a few spare moments.

View Excel, Power BI - Excel or VBA macros blogs

This page has 0 threads Add post