Microsoft Excel Getting Started

Duration: 
1 days

Overview

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. You connect live with our trainer.

Audience

Each participant will leave with a recognised certificate

Course Outline

  • by the end of this course you will have learnt 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 and MAX functions.
  • Insert and delete table rows. Quickly adjust multiple table column widths.
  • Navigate tables using keyboard shortcuts.
  • Use Freeze Panes to lock parts of a table on screen while scrolling.
  • Apply Filters to extract row data based on text and number criteria.

Run reports with Excel's Table feature.

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Midlands
Birmingham1 750 £750 2019-10-04
Edinburgh
Edinburgh1 750 £750 2019-10-04
Bristol
Bristol1 750 £750 2019-10-04
Devon
Exeter1 750 £750 2019-10-04
Midlands
Birmingham1 750 £750 2019-12-06
Edinburgh
Edinburgh1 750 £750 2019-12-06
Bristol
Bristol1 750 £750 2019-12-06
Devon
Exeter1 750 £750 2019-12-06