Microsoft Excel 2003 Intermediate

Course Overview

· Create a data list

· Use a form to view, sort, and enter records

· Perform single and multi-level sorts

· Filter a list using AutoFilter

Borders and Shading

· Apply cell borders and shading

· Apply AutoFormat

Viewing a Large Worksheet

· Go To a specific cell or named range

· Split a worksheet into different viewing panes

· Freeze and unfreeze panes as worksheet titles

· View a workbook in multiple windows

· Hide and unhide rows and columns

· Hide and unhide worksheets and workbooks

Managing Worksheets

· Switch between worksheets

· Enter and edit data on multiple worksheets

· Copy data between worksheets and workbooks

· Insert and delete worksheets

· Move and copy a worksheet

· Rename a worksheet

· Change the colour of a worksheet tab

Logical and Nested Functions

· Use the IF, AND, OR, and NOT functions in formulas

· Use nested functions

Financial Functions

· Use financial functions (PMT, FV, PV, NPV, RATE, IRR, SLN)

String, Date, and Time Functions

· Join strings (CONCATENATE, &)

· Extract text from a string (LEFT, RIGHT, MID)

· Change case (UPPER, LOWER, PROPER)

· Find and replace text within a string (FIND, REPLACE, SUBSTITUTE, TRIM, CLEAN, LEN)

· Convert between text and number values (TEXT, VALUE, FIXED, DOLLAR)

· Insert specific characters from the Windows character set (CHAR, CODE)

· Enter the date and time using functions (TODAY, NOW, DATE, TIME)

· Return selected parts of a date or time value (YEAR, MONTH, DAY, HOUR, MINUTE, SECOND)

· Perform calculations using date/time values

· Use other date functions (NETWORKDAYS, WEEKDAYS, WEEKNUM)

Statistical Functions

· Use counting functions

· Use averaging functions

· Use other statistical functions (MIN, MAX, MEDIAN, MODE, STDEV)

Creating and Applying Styles

· Define a style

· Apply a style to worksheet cells

· Remove a style from cells

· Modify an existing style

· Copy styles between workbooks

Proofing Tools

· Use AutoCorrect

· Use Find and Replace

· Check spelling across the worksheet

Adding Comments

· Add a comment

· Review, edit, and delete comments

· Print comments

Formatting a Chart

· Add, remove, move, resize, and modify chart elements (titles, labels, legend, axes, gridlines)

· Format chart elements (borders, patterns, font, values)

· Format chart axes (number format, text, line width)

· Format data series (scale, shading, spacing, width)

Inserting Pictures and Clip Art

· Understand Object Linking and Embedding

· Insert a Clip Art object

· Insert a picture from a file

· Insert a Print Screen graphic

· Insert an image from a scanner or digital camerav

· Modify a picture using the Picture toolbar

· Crop a picture

Distributing a Workbook

· Save a workbook as a plain text file

· Save a workbook for a different application

· Save a workbook as a template

Creating a Hyperlink

· Create a hyperlink to a file, place in a document, or place on the web

· Create an email hyperlink

· Use or modify a hyperlink in a worksheet

Research Tools

· Translate text to and from different languages

· Spell check text in different languages

· Research words and phrases using web reference tools

If booking for more than one delegate, please contact us on 01189 778560 for discounted prices.