Microsoft Excel

Discover better ways to analyze data and find solutions using Microsoft Excel and its streamlined spreadsheet creation tools, enhanced analysis tools, and powerful Web integration. Whether your an expert or a beginner we have 3 levels of training to accommodate every user.

With Three levels of training to choose from we can accommodate the beginner to advanced users

Introduction
Intermediate
Advanced

«Top»

INTRODUCTION TO EXCEL

DURATION : Half day

TARGET AUDIENCE :

Those with an elementary knowledge of the operation of micro computers who wish to learn how to create and use spreadsheets using Excel for Windows.

This is a course with a high level of practical content, aimed at those people who have not used excel for windows before. It caters for delegates with widely differing experience and skill levels.

TEACHING APPROACH :

The teaching approach contains a mix of lectures, practical and one to one work, varying according to the number of people attending. For the most part delegates are able to work at a pace which best suits them with emphasis being placed upon quality rather than quantity.

PRE REQUISITES :

Those with an elementary knowledge of the operation of micro computers. No previous experience with Excel for Windows is necessary although some experience with Microsoft Windows is an advantage, though not essential.

COURSE OBJECTIVES :

By the end of the course, delegates should be able to :

1. Understand the Excel for Windows Screen
" Title Bar
" Menu Bar
" Toolbars
" Scroll Bars
" Position Indicators
" Status/Edit Line
" Cells
2. Move around the spreadsheet
3. Use a workbook and worksheets for creating a spreadsheet
4. Understand the cancel and enter boxes
5. Understand cell referencing and basic formula building
6. Understand the meaning of a range of cells
7. Use the AutoSum button
8. Use the Fill Handle
9. Change how the worksheet looks
10. Use the currency style, decrease & increase decimal buttons
11. Create an invoice using text and numerical data
12. Use formulas to calculate the cost & VAT of the invoice
13. Replicating and filling ranges of cells

«Top»

EXCEL for WINDOWS - INTERMEDIATE LEVEL

DURATION : Half day

TARGET AUDIENCE :

Those with a well developed knowledge in the operation of micro computers who wish to learn more in-depth and advanced techniques to create and manipulate spreadsheets using Excel for Windows.

This is a course with a high level of practical content, aimed at those people who have used excel for windows before. It caters for delegates with widely differing experience and skill levels.

TEACHING APPROACH :

The teaching approach contains a mix of lectures, practical and one to one work, varying according to the number of people attending. For the most part delegates are able to work at a pace which best suits them with emphasis being placed upon quality rather than quantity.

PRE REQUISITES :

Ideally, course delegates will have attended the Excel for Windows Introduction or have a previous knowledge of the concepts of Excel and Microsoft Windows.

COURSE OBJECTIVES :

By the end of the course, delegates should be able to :

1. Compute subtotals& grand-totals using AutoSum
2. Use the Average, Maximum and Minimum Functions
3. Customise a Table
4. Use Alignment Options
5. Plot a Basic Chart
6. Enhance a Basic Charts
7. Plot Non-continuous Data-Rangers in a Chart
8. Create a Pie Chart
9. Add New Data to an Existing Chart
10. Work with Excels Database
11. Use Data components
12. Sort Database records
13. Generate subtotals& grand-totals in a Database
14. Filter Database records
15. Create & use a data form for entering records
16. Control the screen display
17. Split & freeze worksheet windows
18. Use the Zoom feature

«Top»

EXCEL for WINDOWS - ADVANCED LEVEL

DURATION : Half day

TARGET AUDIENCE :

Those with a well developed knowledge in the operation of micro computers who wish to learn more in-depth and advanced techniques to create and manipulate spreadsheets using Excel for Windows.

This is a course with a high level of practical content, aimed at those people who have used excel for windows before. It caters for delegates with widely differing experience and skill levels.

TEACHING APPROACH : The teaching approach contains a mix of lectures, practical and one to one work, varying according to the number of people attending. For the most part delegates are able to work at a pace which best suits them with emphasis being placed upon quality rather than quantity.

PRE REQUISITES : Ideally, course delegates will have attended the Excel for Windows Introduction and Excel Intermediate level course(s) and have good working knowledge of the operation of micro computers and have previous knowledge of the concepts of Excel and Microsoft Windows.

COURSE OBJECTIVES : By the end of the course, delegates should be able to :

1. Work with three dimensional worksheets
2. Create related worksheets
3. Set up a multiple worksheet file
4. Move around in related worksheets
5. Copy & edit data from one worksheet to another
6. Produce multiple worksheet calculations
7. Link multiple workbooks
8. Write formulas to link multiple files and workbooks
9. Create and use a workspace file
10. Work with absolute cell references
11. Specify an absolute column and row reference
12. Specify a partially absolute cell reference
13. Customise excel and define a custom autofil series
14. Create and use a template
15. Modify the default styles in a template
16. Create, display and switch between views
17. Create and use an outline
18. Use the Scenario Manager
19. Create a scenario using one and two variable