Microsoft Excel XP/2003

Catalyst Learning
London, United Kingdom

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

Course Description:

'' This course offers a basic understanding of the capabilities of Excel and aims to give delegates the confidence to integrate the software effectively and efficiently into their own working environment.

Pre-requisite
No prior knowledge of this package is required, although Windows experience is essential.

Course content

Day 1

Module 1 - Create Workbooks · What is a spreadsheet? The screen, workbook files. Create, open and save workbooks. Close workbooks. File properties. Enter text and numbers. Auto fill. Enter formulae. Move between worksheets and workbooks.

Module 2 - Modifying Workbooks · Inserting, moving and deleting worksheets. Modify worksheet names and positions. Worksheet Tab colour. Grouping worksheets. Relative and Absolute cell addressing.

Module 3 - Working with Cells and Cell Data · Insert, delete and move cells. Enter and edit cell data including text, numbers, and formulas. Check spelling. Find and replace cell data and formats. Cut, Copy, Paste and Paste Special. Creating Lists. Filtering lists. Adding a Total Row. Sorting lists.

Module 4 - Formatting and Printing · Apply and modify cell formats. Modify row and column settings. Modify row and column formats. Apply styles. Use automated tools to format worksheets. Modify Page Setup options for worksheets. Page breaks. Preview and print worksheets and workbooks.

Day 2

Module 5 - Managing Workbooks · Manage workbook files and folders. Create workbooks using templates. Save workbooks using different names and file formats.

Module 6 - Creating and Revising Formulas · Create and revise formulas. Use statistical, date and time, financial, and logical functions in formulas. Revision of Relative and Absolute Cell addressing. Mixed Cell addressing. Use 3-D formulas.

Module 7 - Creating and Modifying Graphics · Create, modify, position, and
print charts. Create, modify and position graphics.

Module 8 - Workgroup Collaboration · Convert worksheets into Web pages. Create hyperlinks. View and edit comments.

...''

Phone:0800 953 0387

School Address:

175 Tottenham Court Road
London, W1T 7NU
UK

Jobs & Resumes: London
Houses & Roommates: London

Negotiation
Illustrator CS
Acrobat
InDesign CS
Photoshop CS
HTML
Dreamweaver MX
Fireworks MX
Flash MX - Action Script
Microsoft Access XP/2003
FrontPage 2003
Microsoft Outlook 2003
PowerPoint XP/2003
Microsoft Project XP/2003
Publisher 2003
Visio 2003
Microsoft Word XP/2003
QuarkXPress 6.0
AIX

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: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.