Objectives
After completing the course, participants will be able to:

• Importing and Exporting Data to and from Excel

• Use various functions including VLOOKUP and HLOOKUP

• Create a workbook based on a template

• Utilise different Protection options

• Audit Workbooks

• Create a Pivot Table and Pivot Chart

• Link Multiple Workbooks through Formulas

• Save Excel Workbooks in various Formats

What you will learn
Topics covered by this course include:

Advanced Data Entry & Formatting Techniques

• Restricting Cell Entries

• Applying Custom Number Formats

• Applying Conditional Formatting

Naming Ranges

• Defining a Range Name

• Using a Range Name in a Formula

• Selecting a Named Range

Using LookUp Functions

• Using the VLOOKUP Function

• Using the HLOOKUP Function

Creating a Custom Workbook Template

• Creating & Modifying a Template

• Basing a New Workbook on a Custom Workbook Template

Auditing a Worksheet

• Tracing Precedents & Dependents

• Tracing Errors

Linking Multiple Workbooks

• Entering A Formula to Link Multiple Workbooks

• Creating a Workspace

Reordering and Summarizing Worksheet Data

• Manipulating data in a database

• Sorting Records and Applying Custom filters

• Outlining a Worksheet

Analyzing Data

• Creating a Pivot Table and Pivot Chart

• Creating and Displaying a Scenario

Importing & Exporting Data

Working with Excel and other Excel Users

• Tracking Changes

• Sharing and Protecting Workbooks

• Merging Revised copies of Workbooks

Additional Advanced Excel Features

• Using the Consolidation Feature

• Adding a Trendline to a Chart

• Saving an Excel Workbook as XML

Prerequisites
Course participants should have completed Excel 2002 Part 2 (or equivalent).

Dates and times
Please refer to your Fourth R centre for dates and times.

© Copyright The Fourth R^®