Pre-requisites
Basic keyboard and PC skills and a knowledge of the windows environment is assumed
Objectives
The aim of this course is to have the participant `up and running' immediately following a one day basic programme based upon their existing skills and future needs. At the end of the course the participant should be able to create a good selection of spreadsheets. This course will assist users to prepare for the Excel 2010 Core Microsoft Office User Specialist Exam.
- What is a Spreadsheet?
- The Excel Screen
- The Ribbon
- Moving around the screen
- Selecting cells and ranges
- Creating a Spreadsheet
- Opening workbooks
- Entering text and numbers
- Saving workbooks/Save as PDF
- Preview and print workbooks
- Closing workbooks
- Views
- Normal
- Page Layout
- Editing a Spreadsheet
- Deleting cell contents
- Editing text and numbers
- Copying/moving data/Pasting Options
- AutoFill
- Inserting and deleting rows and columns
- Hiding rows and columns
- Inserting, deleting, copying and moving worksheets
- Inserting Symbols
- Formatting
- Apply font formats
- Formatting ranges (currency, fixed etc)
- Rotate and indent text
- Modify cell size and alignment
- Apply borders and shading
- Formulae
- Simple calculations
- Copying formulae
- Editing formulae
- Absolute & Relative Formulae
- AutoCalculate
- Range Finder
- Statistical Functions
- AutoSum
- Analysing Data using AVERAGE, MIN, MAX, COUNT and COUNTA
- Function Wizard