ICT696 Excel 2003 Essential skills in spreadsheets
Description
This opportunity will build upon the skills covered in 'Excel 2003 - Getting started with spreadsheets' developing the essential skills needed to create more advanced spreadsheets. You will learn how to set up your spreadsheet to make it easier to use as well as understanding the terms relative and absolute addressing. If you have ever tried copying a formula and ended up getting errors then this opportunity is for you. The course will also look at creating more advanced formulae and at some of the standard functions that come with Excel e.g. Average Max Min and Count.
Content:
Creating a spreadsheet with multiple worksheets
Freezing rows and columns
Sorting information
Cell referencing
Creating a formula
Using standard functions
Level: Beginner
Audience: All education staff
Pre Skills: Competence in the basic skills in a Windows environment
