Microsoft Excel Training Courses

Enliten IT have an extensive range of Microsoft Excel training courses to give you the skills to ‘Excel’ at work! Whether you are new to Excel, are self-taught or you think you know a fair bit, we've got a course for you.

We have certified Microsoft Excel trainers and consultants throughout the UK, so why not take advantage of our, cost effective, tailored onsite training options (we come to you!). Alternatively, you can come to one of our training centers.

We train on ALL versions of Microsoft Excel and to All levels!

Microsoft Excel Intermediate course

1 day

This Microsoft Excel Intermediate course looks at some of the more sophisticated features needed to simplify (and speed up) working with large amounts of data in terms of formatting, formulae and security. We also cover useful analysis tools required when working in working with lists of data such as sorting, filters and pivot tables.

Download PDF

What will you learn?

At the end of this Microsoft Excel Intermediate course, delegates will be able to take advantage of Excel’s features to better manage and protect their spreadsheets and to analyse data quickly and efficiently.

Audience?

Users needing to move to the next stage of Excel mastery to simplify their day to day usage of the product (and to save time) by using more advanced features including 3-d formulae, data handling and working with large sheets.

Course Contents

3d Worksheets

Copy, Move, Rename, Hide worksheets
Group editing and formatting
3d calculations & 3d Autosum

Linking Workbooks

View multiple sheets simultaneously
Creating & Managing links

Range Names

Why use them?
Assigning names
Using names (in formulae and Go To)
Named constants

Data Validation

Controlling data entry
Customising messages and Error alerts
Creating Drop-down Lists (with range names)

Protection

Adding passwords to files
Protecting cells from being altered
Go To function for cell selection

Working with Data

Highlighting data blocks quickly
Sorting – Quick sort, multi field sort, colour sort
Autofilter
- Using logical parameters
Subtotals – to summarise data

Pivot Tables / Charts

Understanding how they work
Manual report v Quick report
Adding & Moving fields
Summary functions inc. %
Formatting fields and reports
Filtering data
Charts
Editing and changing data
Refreshing data
Slicers

Sparklines

Optional Topics (time permitting)

Tables - Create, Modify and Format

Course Materials

Enliten IT will provide each delegate with a workbook and other useful reference materials where applicable. These may be either paper based or in Adobe pdf format or a combination thereof.

“Excellent course really easy to follow, interactive. I’m quite excited about using the programme and the trainer made it feel very easy. Az and Lina, BDP”I’m quite excited about using the programme and the trainer made it feel very easy.

Additional Information

Enliten IT reserves the right to modify course content and materials as required in the interests of continuous course improvement, at any time, without notification.

The suggested course duration is a guideline. Course topics and duration may be modified by the instructor based upon the knowledge and skill level of the course participants.

Contact us to discuss your training needs...