Course Overview and Aim

By the end of this course delegates will have gained skills in how to work with ranges, control viewing spreadsheet information, enhanced formatting, using Excel Tables, sorting and filtering data, logical and lookup functions, create 3D formulas, linking data, working with charts, time and date functions, protecting your work as well as various practical hints and tips on how to use Excel more effectively.

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 delegates with working knowledge of Microsoft Excel to a level equivalent to having completed the Microsoft Excel Introduction course and who now wish to gain further knowledge of the more advanced features such as data tables, creating charts.

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

Named Range(s), Formulas using Named Range(s)
Freeze Panes
Split View
Hide / Unhide Rows, Columns and Sheets
Comments
Format Painter
Conditional Formatting
Data Validation
Tables and Sorting
Tables and Filters, Advanced Filters
Subtotals
=IF, =VLOOKUP, =IFERROR
3D Formulas
Linking Cells, Sheets, Files and to other Applications
Charts, Advanced Charting
Working with Dates and Date Formulas
Using and creating Custom Lists
Excel Options, How to display Formulas, Gridlines On Off, and Hyperlinks
Also included throughout the day practical hints and tips on spreadsheet design

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