Excel Essentials Webinar

What you will learn

This 2-hour webinar offers an insight into Excel’s fundamental components and aims to give attendees the confidence to effectively create and manage spreadsheets. It looks at simple formula writing as well as extracting data for reports.

Prerequisite

No previous experience of using Excel is required before attending this webinar. As it offers essential shortcuts and tips, it is also suitable for those who are self taught.

Date and time: Once you have completed purchasing a booking, we will send an email to arrange a suitable time and date for this online course, including your booking confirmation and joining instructions.

You are asked to join the meeting 5 minutes before start time to ensure a prompt start.

Can't find the course you're looking for? Please enquire about our range of virtual classroom courses.

If booking 2 people, please add the quantity in your cart.

If booking 3 or more people, get in touch for a quote.

Price: £82


If you have any questions, please complete our enquiry form.

By the end of this course you will know how to:

  • Create a spreadsheet table including calculations from scratch
  • Use AutoFill to quickly input a series of numbers or dates
  • Sort table columns in ascending or descending order
  • Use the AutoSum function to sum-up numbers
  • Run statistics with the AVERAGE, MAX and MIN functions
  • Insert and delete table columns and rows
  • Quickly adjust multiple table column widths together
  • Navigate tables using keyboard shortcuts
  • Use Freeze Panes to lock parts of a table when scrolling
  • Use Filters to extract rows containing text, number and dates
  • Run reports with Excel's Table feature
  • What is an absolute reference and when do I use it?