North Staffordshire Chamber of Commerce and Industry

CourseIntermediate Excel

Course Details

Venue:       Commerce House, Stoke-on-Trent  
Duration:   One Day (9.30am - 4.30pm)  
Trainer:     Eileen Venables   
Cost:          £175.00+VAT - Members                   £220.00+VAT - Non-Members  

Course Objectives

This one-day training course aims to give basic users of Excel 2003 knowledge of commands and functions that will make them more proficient in spreadsheet design and development. How to apply these tools to solving their own business problems and good spreadsheet practice will also be covered.

Pre-Requisites
Delegates should have some knowledge of Microsoft Excel or should have attended the introductory course to Microsoft Excel 2003.

Outline  
Hints & Tips
File Management; Advanced Search;Alternative Views; Deleting Files;Deleting Multiple Documents; Renaming Documents;Creating a New Folder; File Properties;Quick Navigation; Hiding Columns & Rows;Freeze Panes & Split Panes; Printing Titles;Creating Range Names; Protecting Worksheets.

Managing WorkBooks
3D Cell Addresses; Managing Workbook Sheets;Selecting Multiple Sheets; Moving & Copying Sheets;Managing Worksheets; Entering 3-D References;Switching Between Workbooks.

Introduction to Charts
Data Points & Series; Legend;Using Chart Wizard; Selecting the Chart;Editing the Chart; Printing & Saving Charts.

Data Lists
Creating Lists; Sorting Lists;Sort Order; Custom Sorts;Using Data Forms; Filtering Lists;Setting Criteria in Forms; Using AutoFilters;Working with Custom Filters.

Further Calculations
Further Functions; Using the Function Wizard;Round; IF;Hlookup, Vlookup; Concatenate.

Course Details

Course Date: 9 December 2010 Cost For Members: £175.00 + VAT Cost For Non-Members: £220.00 + VAT

Shopping Basket

Your Shopping Basket is empty

Event Calendar

Mouse over dates to view events