Excel Level 1 2010

This course covers the fundamental areas of Microsoft Excel focusing on creating, editing and navigating simple spreadsheets which incorporate formulas and charts. The course is designed for anyone new to Excel as well as users who wish to improve their skills to create, edit and understand spreadsheets.

At the end of the course delegates will be able to produce professional spreadsheets, understand and use formulas, charts and graphs to analyse and manipulate data. This course is available for Microsoft Office 2003, 2007 and 2010.

An introdction to Microsoft Excel
Understanding the Version Interface
Creating and Saving a Spreadsheet
Entering Data
Understanding and Using Formula
Using Autosum to Calculate Totals
Hiding Rows and Columns
Merging and Splitting Cells
Formatting Cells
Adding Borders and Shading
Create a Chart using the Chart Wizard
Adding a Chart Legend
Moving and Resizing Charts
Changing the Chart Type
Chart Options
Adding a Chart Title
Add an Axis Label to a Chart
Add a Data Label to a Chart
Formatting the Chart Area
Copying your Chart into Microsoft Word
The Sum, Average, Min and Max Functions
Date Functions including Now() and Today()
Date and Number Series
Using the Fill Handle
Absolute and Relative References