Excel Intermediate (Live Session)

From £150.00 +VAT
eLearning Screen to Screen
Course duration: 1 Day
eLearning Screen to Screen

What will I learn?

This course takes charting a step further on from our Introductory course and seeks to improve proficiency with Microsoft Excel.  It includes working with multiple worksheets, adding database capabilities, split screens, the use of passwords and other Excel functions.

Key Topics

  • Creating, renaming and deleting worksheets
  • Navigating between worksheets
  • Using 3D formula
  • Using links in Excel
  • How to edit existing charts
  • Select and format chart elements
  • Using chart elements and options
  • Creating Sparklines
  • How to use IF function
  • How to use the VLOOKUP and HLOOKUP functions
  • How to name cells and use named cells
  • Sorting and filter tables
  • Introduction to data forms
  • Using database functions
  • Introduction to Pivot Table

As a requirement of this course you will require the use of 2 monitors so thet you can watch and complete the set tasks. You will access and undertake this on our elearning platform - of which log in details and how to access the course will be sent to participants, via email once booking has been confirmed.

There are currently no courses available. Please contact us to find out when the next available course dates are.

Need something answering about this course?

Online Training FAQs

Click here

Can’t find what you’re after in our FAQ’s? Drop us a message. We’d be happy to help!