advertisement

Microsoft excel - intermediate - IT02

Course Code - IT02

Who is this course for?

This course is for anyone who has attended the Excel Introduction course in the last 12 months and/or has attained a Level 1 qualification in Excel and/or is confident in their skills.

Please can all prospective course candidates complete the Skills Check List (located below), prior to enrolling on this course.

Aims

The course will further your knowledge with functions eg (logical) IF, SUMIF, COUNTIF and LOOKUP's and the use of Mathematical operators such as 'more than', 'less then' etc. The software functionality of SUBTOTALS, ADVANCED FILTERS and FORMULA AUDITING. You will also be able to compare functions and formulas that produce the same result.

Objectives

Upon completion of the course you should be able to:
• Use of Advanced filters and Subtotals.
• Formatting, Conditional, Paste Special and Table Formatting
• Working with relative and absolute references and assigning names to cell(s) and managing the Name Manager
• Use of the Auditing Bar
• Use logical (IF) functions, conditional, countif and sumif.
• Comparison between using a Formula and Function produce the same results
• Use lookup functions to return values from a table
• Use of hyperlinks, linking worksheets/workbooks by using formulas.
• Introduction to Data Validation

Trainer

The programme is taught by a Skills, Learning and Development IT Trainer.

Cost

The cost of this course is £100.00 per delegate £120 including VAT.

Delivery Dates & Venue

Venue
Pit Street
County Hall
Conference Training Facility 
Preston. PR1 8XJ

  • 16 December 2019 -  9.30am – 4.30pm
  • 28 January 2020 -  9.30am – 4.30pm
  • 3 February 2020 - 9.30am – 4.30pm
  • 9 March 2020 -  9.30am – 4.30pm
  • 7 April 2020 -  9.30am – 4.30pm
  • 5 May 2020 -  9.30am – 4.30pm
  • 8 June 2020 -  9.30am – 4.30pm
  • 7 July 2020 -  9.30am – 4.30pm
  • 3 August 2020 -  9.30am – 4.30pm
  • 1 September 2020 -  9.30am – 4.30pm
  • 29 September 2020 -  9.30am – 4.30pm
  • 26 October 2020 - 9.30am to 4.30pm
  • 24 November 2020 -  9.30am – 4.30pm
  • 25 January 2021 -  9.30am – 4.30pm
  • 22 February 2021 -  9.30am – 4.30pm
  • 23 March 2021 -  9.30am – 4.30pm

Venue
White Cross Neighbourhood Centre
Lancaster
LA1 3SE

  • 18 February 2020 - 9.30am – 4.30pm
  • 15 June 2020 -  9.30am – 4.30pm
  • 22 September 2020 -  9.30am – 4.30pm

Venue
The Exchange Burnley
Barden Lane
Burnley
BB10 1JDd

  • 27 January 2020 - 9.30am – 4.30pm
  • 27 April 2020 -  9.30am – 4.30pm
  • 21 July 2020 -  9.30am – 4.30pm
  • 13 October 2020 -  9.30am – 4.30pm
  • 1 February 2021 -  9.30am – 4.30pm

Click here to obtain our course Booking Form