Microsoft Excel 2003 - Intermediate

Computer Training Solutions
London, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Microsoft Excel 2003 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.

This course is designed to help you to develop your skills in using the spreadsheet tool Microsoft Excel. You will learn to use more advanced functions and create more complex formulas. You will learn to manage and link together multiple worksheets.

You will also learn to apply more advanced formatting to charts and use basic reviewing tools, such as the spelling checker and comments.

Target audience

Those wanting to develop their skills in using Excel to design spreadsheets to solve basic accounting and data analysis tasks.



Data Lists

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

Linking Worksheets and Workbooks

Create a formula to link worksheets and workbooks • Consolidate data using 3D references in common functions • Use Paste Special to link worksheets and workbooks • Use Paste Special to manipulate data • Manage and update linked workbooks

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)

Excel 2003 - 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 and Database Functions

Use counting functions • Use averaging functions • Use other statistical functions (MIN, MAX, MEDIAN, MODE, STDEV) • Use Dfunctions to perform calculations on a data list

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)

Publishing to a Web Page

Create and edit hyperlinks • Save a worksheet or workbook as a web page • Use Web Page Preview

...''

Phone:08456 44 1234

School Address:

Aurora House, 5-6 Carlos Place, Mayfair, London W1K 3AP, UK
Telephone: 08456 44 1234
Email: training@it-uk.com


Jobs & Resumes: London
Houses & Roommates: London

Cascading Style Sheets
DHTML/DOM
Macromedia Dreamweaver MX
Macromedia Dreamweaver MX Advanced
Macromedia Dreamweaver MX 2004
Microsoft Excel 2002 (XP) - Introduction
Microsoft Excel 2002 (XP) - Intermediate
Microsoft Excel 2002 (XP) - Intermediate Plus
Microsoft Excel 2002 (XP) - Advanced
Microsoft Excel 2003 - Introduction
Microsoft Excel 2003 - Advanced
Microsoft Excel VBA (Visual Basics for Applications)
Macromedia Fireworks 4 - Introduction
Macromedia Fireworks 4 - Intermediate/Advanced
Macromedia Fireworks MX - Introduction
Macromedia Fireworks MX - Intermediate/Advanced
Macromedia Flash MX - Introduction
Macromedia Flash MX Intermediate/Advanced
Macromedia Flash MX 2004

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.