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 one-day 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, 2010, 2016 and 365

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 and Columns and Worksheets
Series and Lists

Formatting
Styles and Format Painter
Conditional Formatting
Validation

Manipulating Data
Freezing Panes, Filters and Sorts
Charts

Formula
Further Functions; Auditing Formulas

Functions
Printing
Page Setup and Headers/Footers

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 Excel Expert training course.

Please note that the cancellation policy for our public training courses is as follows:

NON-ACCREDITED TRAINING

More than 3 weeks prior to the course start date - No cancellation fee payable.

Less than 3 weeks prior to the course start date - 100% of total fees payable or free transfer.

ACCREDITED TRAINING

More than 6 weeks prior to the course start date - No cancellation fee payable.

Less than 6 weeks prior to the course start date - 100% of total fees payable or free transfer.

Substitute delegates will be accepted at any time at no cost.

Full joining instructions for the course will be emailed to you at least five working days prior to the course. In the meantime, if you have any queries please contact a member of our team on 028 9016 0587 or via email kate@aku.training.

Download a copy of our standard Terms and Conditions for course bookings.