Low cost IT training in St Albans & Harpenden areas
© Copyright 2021 Computer Friendly
Registered in England number 04398683 Registered Charity number 1096433
Microsoft Excel
Excel
You will learn how to create and amend Excel spreadsheets to store and manipulate data which can be used for both personal and business purposes.
Course Objectives
The purpose of this course is to introduce you to the most important features of Microsoft Excel, to reinforce what you already know about how to use a computer and to build your confidence. By the end of the course you should be able to produce and edit spread-sheets for home and office use.
You will learn:
- How to build spread sheets
- About the most frequently used features in Excel, including:
- Cells
- Simple formulae:
- addition, subtraction, multiply and divide
- ‘Drag and repeat’
- Copying formula
- Dates
- Monetary calculations
- Formatting to improve the appearance of a spreadsheet
- Templates
- Charts or graphs
- Saving files, opening existing files, printing
You will also learn about the wide range of uses that spreadsheets can be used for.
A workbook is provided containing exercises to give hands-on experience and general information. This is yours to keep.
Course Structure
Six weeks x2 hours
Lesson 1 Introduction to Excel
- Moving around in Excel
- Entering and changing data
- Addition, subtraction, multiplication and division
- Files – saving file, sheets
Lesson 2 Short cuts, Styles and Formatting
- Addition using Autosum
- Copying a formula
- Undo and redo
- Styles
- Bold, italics and Underline
- Printing
Lesson 3 Formatting numbers and
Using templates
- Number formats
- Numerical sequencing
- Wrapping text
- Deleting and clearing
- Range of templates
Lesson 4 More about formulae and the Look of the spreadsheet
- Using $ sign when copying a formula
- Using brackets in a formula
- Aligning and merging cells
- Fonts and colouring
- Borders
Lesson 5 Dates and Percentages
- Dates
- Converting to percentages
- Inserting and deleting rows and columns
- Lines
Lesson 6 Charts
- Creating a chart (graph)
- Moving charts
- Adding information to charts
- Revision
Next course
The next course, Further Excel, will extend your skills of the program.