Microsoft Excel - Intermediate

Who is it for?

Suitable for people who have attended the introduction course or have sufficient knowledge and understanding of the basics of Excel and are looking to expand this

What is it about?

A natural progression from our introductory courses that provides expert guidance through more complex functions and plenty of practice and examples to build confidence using them

What do I get out of it?

  • Know how to protect your data using the security features
  • Achieve automation of worksheets using excel look up features
  • Improved interpretation of data by learning to create and customise graphs, including plotting trend lines
  • Learn how Excel can make decisions using the ‘If’ function and conditional formatting
Course Overview:
  • Review of Excel fundamentals
  • Building 3-dimensional worksheets
  • Worksheet templates
  • Protection and security
  • Grouping worksheets 
  • Data tables and lookup functions
  • Introduction to the ‘If’ function 
  • Group and outline functions 
  • Building graphs and using trend lines 
  • Database features including sorting and filtering data 
  • Methods to validate data
  • Colours based on values (getting Excel to change the formatting characteristics based on the cell contents)

Guide Price: £275 + VAT

Delivery: Classroom
Category: Intermediate Microsoft Excel »

Search for intermediate microsoft excel courses in