Course
Length: One Day
Fees: Training at Client Offices: One delegate: £395 per-day +
VAT
Additional delegates attending: £75 each per-day + VATOverview:
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
|
If you have other questions, please contact us at
enquiry@it-uk.com or
complete
our response form |
