Excel 2003 Intermediate

Computer Training Solutions
London, United Kingdom

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

Course Description:

'' 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
...''

Elements of this syllabus are subject to change.

Phone:08456 44 1234

School Address:

Aurora House, 5-6 Carlos Place, Mayfair, London W1K 3AP UK

Jobs & Resumes: London
Houses & Roommates: London
Travel Agencies: London

Search other schools for Excel 2003 Intermediate training resources.

CSS with XML
XLST & XPATH
XML
Acrobat
ASP Intermediate/Advanced
ASP
CorelDraw 12 Advanced
CorelDraw 12
DHTML/DOM
Excel 2003 Advanced
Flash
FrontPage 2003 Intermediate/Advanced
FrontPage 2003
Illustrator Advanced
Illustrator Intermediate
Illustrator
InDesign CS Intermediate/Advanced
InDesign CS
PageMaker

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.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.