This intermediate Excel training course will help you to create effective spreadsheets and apply automated applications. 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 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 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 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

Is it for me?

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.