Excel 2000
Part 3
Course Code: AD317 

This is a course for experienced Excel users. Learn how to use many advanced features and functions of the program, such as the VLOOKUP and HLOOKUP functions, database management, pivot tables and Auditing.

Objectives
Course participants will learn how to:

  • Set up worksheets within a workbook
  • Secure cell manipulation
  • Define & use a range name in a formula
  • Use the VLOOKUP function
  • Audit your figures
  • Create a Pivot table
  • Manipulate an Excel database
  • Use Excel Work Group features

What you will learn
Topics covered by this course include:

Advanced Data Entry & Formatting Techniques

  • Restricting Cell Entries

  • Applying Number Formats

  • Applying Conditional Formatting

Linking Multiple Workbooks

  • Formulas to Link Multiple Workbooks

  • Creating a Workspace

Naming Ranges

  • Defining a Range Name

    •

  • Using a Range Name in a Formula

Using LookUp Functions

  • Using the VLOOKUP Function

  • Using the HLOOKUP Function

  

Working with a Template

  • Creating & Modifying a Template

Auditing a Worksheet

  • Tracing Precedents & Dependents

  • Tracing Errors

Linking Multiple Workbooks

  • Entering A Formula to Link Multiple Workbooks

Working with a Database

  • Manipulating data in a database

Analyzing Data

  • Creating Reports

  • Using the Solver

  • Outlining a Worksheet

Importing & Exporting Data

  • Import data from other applications into Excel

Using Excel Work Group Features

  • Tracking Changes

  • Inserting Comments

  • Reviewing Comments

  • Protecting a Workbook

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

Dates and times
Courses are available either in the morning or the evening. Contact the relevant training centre for further details and enrolment information.

© Copyright The Fourth R®

 [Back to MS Office Training Courses]