Excel 2000 - Introduction

Course Length: One Day
Fees: Training at Client Offices: One delegate: £395 per-day + VAT
Additional delegates attending: £75 each per-day + VAT

Overview: Microsoft Excel 2000 is a software application that can be used as a spreadsheet, database, or graphing program. The electronic spreadsheet portion of Excel allows you to perform sophisticated calculations and create formulas that automatically calculate answers.

The advantage of using formulas is that when data in the worksheet changes, all the formulas recalculate automatically. This feature assists you in developing budgets, forecasting models, creating sales plans, making financial projections, calculating inventories calculations, generating banking statements, and basically working with any format involving numbers. Excel can sort lists and select specific pieces of information based on specified conditions.

Exploring Excel

	Looking at the Excel Window and file structure
	Discussing and viewing Worksheet options
	Displaying & hiding Toolbars, changing options

Basic Workbook Skills

	Create, Save & Close a new Workbook
	Selecting Cells with the Keyboard and Mouse
	Entering numbers and text in a Worksheet

Working with Cell Ranges

	Selecting Cell Ranges with the Keyboard/Mouse (both adjacent and non-adjacent cells)
	Entering Values into a range of selected Cells
	Using the AutoFill feature (create a series of names/numbers for easy data entry)

Creating Simple Formulas

	Using formulas (discussion about procedure)
	Creating simple formulas (long-hand formulas)
	Using Sum/Max/Min/Average within Formulas
	AutoSum Button (automatically calculate the total of a range of cells)
	AutoCorrect (suggested help to fix formula errors)
	Paste Function Button (helps create formulas)
	AutoCalculate (on-screen calculator)

Range Finder (identify cells used in a formula)

Copying and Moving Data

	Copy, Cut and Pasting data (including pasting from the Clipboard toolbar)
	Creating an Absolute Reference
	Using Autofill (copy the contents of a single cell to adjacent cells – including formulas)
	Drag and drop editing
	Using Undo and Redo

Formatting Numbers

	Currency Style (£/$) / Percent Style (%)
	Using the Comma Style
	Changing the number of decimal places

Formatting Text

	Align Right/Left/Centre Buttons
	Using the Font List
	Using the font colour Button
	Rotating text in a cell
	Shrinking text to fit a cell automatically

Formatting Cells

	Changing the cell alignment
	Using the merge and centre button
	Using the borders and fill colour buttons
	Using the format paintbrush

Using Page Set-up

	Setting the Page Margins/ Page Orientation
	Creating/Customizing Headers and Footers
	Printing With/Without Gridlines
	Repeating Row and Column Headings
	Scaling a worksheet (adjusting the overall size)
	Using Page Break Preview
	Setting/removing a print area (for repeating rows of information on each printed page)

Working with Columns and Rows

	Selecting Inserting/Deleting Columns/Rows
	Changing the Width and Height of Columns/Rows
	Hiding/Unhiding Columns/Rows

Using AutoFormat

	Applying an AutoFormat (assign pre-set formats to a range of cells (coloured text / background etc)
	Changing the AutoFormat options
	Extending list formats and formulas
	Creating a Style by example – applying the Style
	Modifying and merging styles

Creating & Editing Charts

	Creating Charts using the Chart Wizard
	Changing the Chart Type (pie/bar/line)
	Changing the Plot Direction (column to row)
	Adding a Data Table under the Chart
	Formatting Chart Objects (colours/line styles etc)
	Changing the Chart Range (selecting new data)

	Changing the Chart Type / Sub-Type
	Adding Chart Titles / Moving the Legend
	Changing the Chart Location

Working with Multiple Worksheets

	Switching between worksheets
	Renaming Worksheet tabs
	Inserting/deleting Worksheets
	Printing selected worksheets

Managing Excel Files

	Changing Workbook properties
	Different file views

If you have other questions, please contact us at enquiry@it-uk.com or complete our response form