1-Day Instructor-led classroom based training

This course can be delivered as a scheduled open course, a company private closed course or as a one to one consultancy. We can run this course either at our training schools in Aberdeen, your premises or using our portable training school. Download full course profile below:

For pricing, click here

Course Overview

Microsoft Excel is a spreadsheet application that incorporates tools for assisting in the recording and analysis of numerical data and which has the ability of turning numerical data into charts and graphs.  This functionality, combined with many powerful and sophisticated features allow the creation, manipulation, editing, printing and storage of workbooks.

Excel Intermediate will allow you to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web.

Course Pre-requisites

Any user who has completed our MS Excel 2010 Foundation Course shall benefit from this course.  However, knowledge of Windows and experience with a PC will be presumed, therefore, it is advisable to register participants on our “Introduction to Computing” or “Microsoft Windows” course prior to attending, should this experience be lacking.

Course Ouline

Module 1: Named Ranges

Module 2: Cell Formatting

Module 3: Manipulating Worksheets

Module 4: Templates

Module 5: Paste Special Options

Module 6: Hyperlinks

Module 7: Sorting & Filtering Data

Module 8: Linking & Embedding

Module 9: Charts

Module 10: Importing Text Files

Module 11: Security

Course Completion

You will have the ability to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web.  The course is also a pre-requisite to attending more advanced levels of training in MS Excel 2010. 

On completion of the course you will receive a certificate.

Solutions, training your business