[ Back to courses ] [ Word part 1] [ Word part 2 ] [ Word part 3 ]

---

Microsoft Excel 2002 – Advanced Part 3

Course Duration: One day

(Training can be tailored)

Location: Northampton, Milton Keynes, Leicester, London, or in-company.

Mobile Classroom:  We have a mobile classroom fully configured that can be set up onsite.

Prerequisites: A good working knowledge of Excel. Attended Microsoft Excel Part 1 & 2 or have gained the equivalent knowledge.

Course Aims: To give the students the ability to create advanced spreadsheets using the full range of Microsoft Excel’s 2002 tools and features. Students will learn to apply custom formatting and use templates to import and export data in different formats, to use LOOKUP functions and to create customised charts. Students will also learn how to customize and automate Excel using macros and toolbars.

Course content:

§ Custom number and conditional formatting

§ Using Named Ranges

§ Importing and Exporting Data in Excel: Use paste special to import and manipulate text. Export worksheet data to other applications. Import data from a text file, from an HTML web page. Round trip HTML data in Excel.

§ Work Templates & Add-Inns

§ Working with multiple workbooks

§ Printing workbooks and reports

§ Lookup and reference functions

§ Customizing Excel toolbars

§ Using Macros in Excel

§ Customising Excel charts

Contact JCS training for full course details.

Further training available:  Microsoft Office XP including Excel 2002 Part 1, 2 & Professional. Tailored, and Further Advanced training –consultancy.

For full course details, available dates and costs contact JCS training:

Free phone:  0800 542 5150 or telephone 01604 495252 Email:training@JCS-computing.co.uk