Microsoft Excel XP Level 2 |
|
| |
Overview
This course introduces you to Excel's linking features and the IF function. You will also find out how to protect your worksheet data and manage large amounts of information on one screen. Excel is also a Database program; so the course will show you how to set up an Excel database and extract information from that database. |
| |
Prerequisites
You should be able to enter formulae manually and by using Excel's Function feature.You should be able to select, copy, move and change the appearance of text and numerical data in an Excel worksheet.You should be confident creating, opening and saving documents in Excel. If you are unfamiliar with these topics, you may be interested in our Excel Level 1 course. |
| |
Objective
To understand how to name cells/ranges. To understand how to link information across
worksheets and workbooks. To be able to build an IF formula. To be able to protect a worksheet. To understand the process of creating and
extracting data from an Excel database.By the end of the course, you will have named
cells and linked information across worksheets/books.You will have written an IF formula. You will build a small database and extract
information from the database. |
| |
| Available Platforms: PC only | Duration: 1 day |
| |
Price of Course £195.00 ex VAT
(Full payment must be received prior to the course commencing) |
| |
| |
| Course Outline: |
 |
|
Using names
• Defining names
• Using names in formulae
Percentages and constants
• Using percentages in formulae
• Absolute cell references
Linking Data
• Linking across worksheets
• Linking across workbooks
• Consolidation IF formulae
• Building a simple IF formula
• More complex IF formula |
|
Splitting and Protecting
• Split screens
• Freezing panes
• Protecting an Excel file
• Passwords
Excel Databases
• Excel database overview
• Sorting data
• Filters
• Database functions |
|
| |
|
|
If you are confident using all these features, your next step would be our 
