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:London, Manchester
  • Next Excel Intermediate course locationNext course:Fri 02 March 2018
  • Excel Intermediate course timesTime:09.30-16.30

Course Contents

Better spreadsheet design

  • Training topicAbsolute cell references using the $ sign
  • Training topicUsing 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

"Very good course covered everything we asked for in the time we had, hopefully it will be put into practice soon."

Cathy Northall (Marley Eternit Ltd.)

"Great course, very well presented. Balance of structure, off topic and catering for experience levels was excellent. Training materials top drawer."

Brendan Thomas (Sherwood Compliance Services)

"I was very impressed with the course, and the trainer made the content of the course easy to follow and understand. I have already recommended colleagues to the same course as I know they also share an interest in this topic. I would also be interested in follow up courses in the future, once I’ve allowed this recent topic to sink in. "

Matt Cooke (ISS Mediclean Ltd)

"Interesting and relevant content. Good pace. Friendly trainer. Thanks."

Michelle France (Pinsent Masons LLP)

"Really good course, a lot of good examples, knowledgeable trainer. Very glad to attend. I would recommend the course to anyone interested in SSIS and its capabilities. "

Aiste Luksyte (Gain Theory)

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.

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 2013, 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 VBA, Microsoft Excel or Excel 2013 Power BI Tools videos

Excel skills assessment

Excel skills assessment

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

View Excel skills assessment or Excel VBA skills assessment 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