£175

MICROSOFT EXCEL INTERMEDIATE COURSE

Event Information

Share this event

Date and Time

Location

Location

CF34 0BQ

Office 3 Llynfi Enterprise Centre

Heol Ty Gwyn Industrial Estate

Maesteg, Wales CF34 0BQ

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

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.

Share with friends

Date and Time

Location

CF34 0BQ

Office 3 Llynfi Enterprise Centre

Heol Ty Gwyn Industrial Estate

Maesteg, Wales CF34 0BQ

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved