Excel Intermediate
Aims:
Looks deeper into Excel, including analytical and data retrieval formulas and Pivot tables
Prerequisites:Must have attended the Microsoft Excel Introduction or have a good working knowledge of the product
Duration:One Day
Fees:Course fees for this particular course will depend on your chosen Training solution. Please click on the links below for corresponding course fees:
PDF Course Download
You can download a PDF version of the course.
Download Excel Intermediate course outline.
If you don't have Adobe Acrobat Reader, this can be downloaded from the www.adobe.com web site.
If you are interested in our Excel Intermediate course call us on
0113 243 2226
Enquire about
this course Now
Course Dates
| Available dates |
|---|
| 6th August 2008 |
| 4th September 2008 |
| 6th October 2008 |
| 5th November 2008 |
| 3rd December 2008 |
Linking
- Understanding the concepts of Linking
- Using formulas to link sheets
- Linking files using formulas
- Using Paste Link to link files
- Linking to other Microsoft Office programs
Range Names
- What is a Range Name?
- Creating and defining Range Names
- Deleting Range Name
- Using Range Names for navigation
- Using Range Names in formulas
Further Functions
- Writing formulas using Paste Function
- Basic statistical functions
Conditional Functions
- An introduction to Conditional Functions
- Using the IF function
Lookup Functions
- What is a Lookup Function?
- Using LOOKUP to extract information
- Looking up with VLOOKUP and HLOOKUP
Workbook Templates
- Templates vs. workbooks
- Creating and saving a Template
- Modifying a Template
Protecting Data
- Protect cells within a workbook
- Hiding worksheets within a file
- Protecting the structure of a workbook
- Password protecting Excel files
Pivot Tables
- What is a Pivot Table?
- Using Pivot Tables to display Data Lists
- Creating a Pivot Table
- Modifying the structure of a Pivot Table
Further Pivot Tables
- Formatting a Pivot Table
- Producing Drilldown Reports
- Grouping and Ungrouping Pivot Table data
- Showing and Hiding data in a Pivot Table
