This one-day Intermediate Excel course based in South Wales follows on from our Beginners to Excel course and will guide you through all the new features. It covers more complex formulas and functions, such as the improved conditional formatting features, lookup functions and filtering options.

Course Content

• Absolute cell references

• Naming cells and ranges

• Referring to named cells and ranges

• Editing named cells and ranges

• Setting up workbooks with group editing

• Using VLOOKUP & HLOOKUP statements

• Editing lookups and ensuring accuracy

• Linking spreadsheets and workbooks

• Utilising 'If' statements

• If statements and calculations

• Analysing data with conditional formatting

• Databases in Excel

• Sorting data numerically and alphabetically

• Filtering data for range & precision analysis

• Setting up data validation

• Attaching security to a spreadsheet

• Selective protection

• Setting up and utilising templates

• Creating and formatting charts

• Adding trend lines to the chart

• Utilising custom chart types

Who is this course for?

This Intermediate Excel course is designed for users who have attended the beginners level course or are already confident in the basic features of Microsoft Excel.