Course Overview and Aim

By the end of this Excel course attendees will have gained an enhanced skill level; giving them a greater understanding of advanced Excel formulas, and tools to increase their day to day working knowledge and improve their Excel productivity.

This course covers using more complex functions and formulas, the ability to manipulate text by formula, creating array and database formulas, how to create and use pivot tables and pivot charts, using text to columns tool, using advanced Paste Special features and a brief overview of Excel Macros.

The Course Tutor, after taking into account course time constrains, may be able to assist you with any specific Excel challenges you might have.

Attendees

This Excel course is designed for attendees with good working knowledge of Microsoft Excel to a level equivalent to having completed the Microsoft Excel Intermediate course and who now wish to gain the skills necessary to employ more advanced features of Microsoft Excel.

Course Type

In-House, Expert Instructor led and guided.

Please note: Microsoft Excel 2016 is used as the primary application during the course for demonstration purposes. However all training content is usable in Excel 2010 / 2013.

Please note, a specially created attendee Excel course file is provided and is practically used throughout the course.

Post course this file is retained by the attendee as ongoing reference material.

Duration

1 day course – Start time 9.00 a.m. Finish 5 p.m.

It is recommend all attendees to aim to arrive, at least 15 mins, before the start of the course, to ensure all pre-course administration and set-up is completed in a timely manner.

Course Content

Familiarisation including using Quick Access Toolbar
=IF, Nested =IF’s, =IF’s AND, =IF’s OR
=COUNTIF, =SUMIF
&, =CONCATENATE
= RIGHT, = LEFT, = LEN, = MID
= FIND, = TRIM
=LOWER = UPPER = PROPER
Array formulas
Database Formulas
Working with Pivot Tables
Text to Columns
Flash Fill – Splitting, Combining, Formatting, Spacing, Text to Dates
Paste Special – Skip Blanks, Transpose, Operation
How to create and why use Template Files
Dashboarding Made Simple
A brief overview of VBA Macros
Also included throughout the day practical hints and tips on spreadsheet design

Practical Application

This a “hands on” course as it includes a number of practicals to be completed to reinforce what has been learnt. Of note during Day Two a Practical Exercise task is to be completed by the attendees to put into practice what they have learnt on Day One.

Contact Us For More Details

For more details please contact us on +44 (0)1865 515255 or email enquiries@oxfordpeg.com

Find Your Nearest Study Centre

Cyberessentials Certification