CALL FREE ON 0800 220454

Excel 2016 Expert

The Microsoft Excel 2016 Expert training course is available at the Edinburgh, Glasgow, Aberdeen and Inverness Pitman Training Centres or via Online Distance Learning through our Pitman Campus.

For those who have a basic grounding in Microsoft Excel, this course will provide you with the knowledge and skills to use MS Excel at an advanced level.

Course Duration: 18 hours

CPD Points: 18

iStock_000001425675XSmall

There are 17 modules in this course, below is a breakdown of what each one covers:

  • Data calculations, watermarks, converting text to columns and flash fill.
  • Consolidating data, paste special, custom formats and working with ranges.
  • Hyperlinks and formatting charts.
  • Applying functions in formulas.
  • Conditional formatting.
  • Sort and filter data, subtotals and database functions.
  • Macros.
  • Data validation, precedent/dependent cells, tracing errors, evaluating formulas and the watch window.
  • Protecting worksheets and workbooks, passwords and file properties.
  • Sharing and merging workbooks and grouping and ungrouping data.
  • Pivot tables.
  • Pivot charts.
  • VLOOKUP, HLOOKUP, embedding and linking objects.
  • Scenario manager and data tables.
  • MATCH and INDEX, NOW and TODAY and COUNTA, COUNTBLANK and COUNTIF functions.
  • Using financial, nested and the CONCATENATE functions.
  • Create and modify custom workbook elements.

This advanced Excel course will help advance your understanding of the 2016 version of this renowned Microsoft Office programme to an expert level.

You will find this online advanced Excel course to be advantageous if you spend a good deal of your time working on Microsoft Excel and want to enhance your abilities and understanding of the programme.  It’s also a great follow-on from our Excel 2016 course.

Working knowledge of the Excel 2016 program, ideally having completed the Excel 2016 course

SDS Funding has been withdrawn for the foreseeable future. Please contact us for further information or other funding options.

For more information on this or any of our courses complete the form

Course Enquiry

Choose Centre (required)

Name (required)

Email (required)

Telephone (required)

Which course are you interested in? (required)

Enquiry

Terms & Conditions: We will only use the information you have provided to contact you regarding your enquiry about our courses.

Tick here to accept the term of this form submission

Future ContactTick here to also allow us to keep in touch with you about available funding, new courses and future dates

You are human aren't you?