This basic course shows you how to create and edit spreadsheets and how to use a workbook to analyse a wide range of numerical data. The course is designed for beginners, so there’s no jargon to confuse you - just simple, step-by-step instructions and demonstrations to help you feel comfortable using Excel 2010.
You will learn how to create a new spreadsheet, entering text and numbers and saving the data you input. You will use formulas to add, subtract, multiply and divide numbers, learn how to analyse the information in your spreadsheet and how to print off different pieces of information or view it on the screen.
A series of handy printouts and practice exercises throughout the course will ensure you have understood all the learning.
Introduction Microsoft Excel 2010.
Outcomes, on completion of this course you will be able to:
- Open, navigate and close Microsoft Excel
- Create, layout and save a simple spreadsheet
- Enter and format numbers and text in a spreadsheet
- Copy, insert and delete data
- Create basic formulas
- Apply relative and absolute cell addressing
- Create basic charts
- Print a spreadsheet