This highly practical one-day course builds on the basic MS Excel skills and explores ways in which data can be more effectively analysed and manipulated. It examines more advanced functions and formula, and explores how data can be managed for maximum efficiency and presentational impact

By the end of the course, you will have an understanding of the following topic areas

More Functions
COUNTIF / SUMIF
IF
TODAY

Managing Datasets
Sorts, Multiple Sorts
Filters, Data Validation

Linking
Linking Data in Worksheets
Linking Cells Between Worksheets
Workbooks and MS Word
Updating, Locking and Breaking Links 

Charts
Chart Types
Chart Elements 
Modify Chart Design 

If you wish to develop your basic skills in order to make use of MS Excels more sophisticated and complex features, then this course is for you. Those wishing to progress to learn the more advanced functions of Excel should look at the Excel Advanced 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.