Who Should Attend?

If you wish to learn the essentials of spreadsheet design with a view to its application in a business environment then this course is for you. Those wishing to progress to learn the more advanced functions of Excel should look at the Advanced Excel training course.

Book Now

Synopsis

This practical one day Basic Excel course is designed to enable participants to create effective spreadsheets and apply the automated applications associated with their everyday business. This course will introduce the ten best features for effective spreadsheet use that will enhance your productivity and save you time.


What Will I Learn

MS Excel is a powerful and versatile spreadsheet tool which enables users to store, manipulate and analyse data quickly and easily. It includes a variety of business features which automate many common tasks, making it an essential application for businesses of all sizes.

This Basic Excel course provides the knowledge and skills to create, edit and enhance spreadsheets. It includes a study of the automated tasks commonly used for data manipulation, calculation and data analysis. The course is designed as a practical course, allowing the participant to receive hands-on experience and guided practice of all the topics covered. The content will be relevant to both Excel 2007 and 2010.

By the end of the course you will have an understanding of the following topics:

Building and Editing Workbooks

  • Entering and Editing Data
  • Managing Cells, Rows, Columns and Worksheets
  • Series and Lists

Formatting

  • Text and Number Format
  • Conditional Formatting
  • Validation

Manipulating Data

  • Freezing Panes
  • Filters and Sorts

Formula

  • Simple Calculations and Functions

Public courses are delivered regularly but we are pleased to provide tailored in-house courses, 1:1 training and mentoring support in the UK and Ireland.

Please email or ring for further details.