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