Excel 2000
Part 2
Course Code: AD316 

Take your spreadsheets to the next level with Intermediate functions, charts and worksheet display features.

Objectives
Upon completion of this course, participants will be able to:

  • Work with Absolute cell references
  • Create a Chart
  • Modify and enhance a basic chart
  • Add new data to a chart
  • Utilise the IF and Nesting IF functions
  • Use functions including Date, NOW, PMT and FV
  • Split the Workbook window
  • Access the World Wide Web from Excel

What you will learn
Topics covered by this course include:

Using Excel Functions

  • Using the IF and Nesting IF Function
  • Using the Date Function
  • Using the NOW Functions
  • Using the PMT and FV Functions

Creating a Custom Table

  • Using Alignment Options in the Format Cells Dialog Box
 Using Absolute Cell References
  • Entering Absolute Column and Row References into a Formula

Creating a Chart

  • Plotting a Basic Chart
  • Modifying and Enhancing a Basic Chart
  • Plotting Non-Contiguous Data Ranges
  • Plotting a Pie Chart
  • Adding New Data to a Chart

Controlling the Worksheet Display

  • Splitting the Worksheet Window
  • Freezing Window Panes
  • Displaying in Full Screen View
  • Using the Zoom Feature

Using Excel Internet Features

  • Accessing the World Wide Web from Excel
  • Linking an Excel Worksheet to a Web Page
  • Saving as an HTML Document

Prerequisites
Course participants should have completed Microsoft Excel Part 1 (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]