• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   User Microsoft Office Training Courses

Excel 2003 Level 2

View course dates

Course Duration: 1 Day

Course Code: DEX03L2

Course Description:

In Microsoft® Office Excel 2003: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft® Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

 

You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

 

The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. In addition, this course helps prepare students who desire to prepare for the Microsoft Office Specialist exam in Excel or Module 2 and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

 

Upon successful completion of this course, students will be able to:

• Create and apply templates.
  
• Create and modify charts.
  
• Work with graphic objects.
  
• Calculate with advanced formulas.
  
• Sort and filter data.
  
• Use Excel with the Web.
  

Prerequisites:

To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Microsoft® Excel 2003. Students can obtain this level of skill by taking the following course: Microsoft Excel 2003: Level 1

In addition, Web browsing experience is strongly recommended.

Prerequisite courses:

Excel 2003 Level 1

Follow on courses:

Excel 2003 Level 3

Relevant Certifications:

MOS: Office 2003 Editions Track

This course includes the following modules:

Templates

• Creating a workbook from an Excel template
• Create a template
• Working with comments
• Create a hyperlink
• Create a workbook from a user-defined template

Creating and modifying charts

• Create a chart
• Format chart items
• Change the chart type
• Create a diagram

Working with graphic objects

• Insert graphics
• Create autoshapes
• Format graphic objects
• Group, move, copy and resize objects

Sorting and Filtering Data

• Sort data
• Add subtotals to a worksheet
• Filter lists
• Create and apply custom filters
• Advanced filters
• Database functions
• Subtotals

Importing and Exporting Data

• Import data from the web
• Import data from an external source
• Export data
• Save a worksheet as a web page
• Publish a worksheet to the web

Working with Advanced Formulas

• Named ranges
• Calculate across worksheets
• Calculate with date and time functions
• Calculate with financial functions
• Calculate with statistical functions
• Lookups

 

Location	Duration	RRP	Dec	Jan	Feb	Mar	Apr	May
Click on course date to make a booking, check availability, or find out about available discounts.
Aberdeen	1 days	£215				13 - 13
Altrincham	1 days	£215		16 - 16			8 - 8
Birmingham	1 days	£215	16 - 16	5 - 5 22 - 22	9 - 9	13 - 13	15 - 15	15 - 15
Bristol	1 days	£215				16 - 16
Edinburgh	1 days	£215	15 - 15	12 - 12		16 - 16		18 - 18
Exeter	1 days	£215	16 - 16			16 - 16
Glasgow (RenSt)	1 days	£215	8 - 8 22 - 22	21 - 21		18 - 18		20 - 20
Leeds	1 days	£215			6 - 6 10 - 10	27 - 27		7 - 7
London (KWS)	1 days	£215	12 - 12 22 - 22	30 - 30	5 - 5 12 - 12		14 - 14
London (Mid)	1 days	£215	5 - 5 12 - 12 15 - 15 18 - 18 19 - 19	7 - 7 15 - 15 20 - 20 26 - 26	3 - 3	10 - 10	7 - 7	5 - 5
Manchester (Exch)	1 days	£215	9 - 9	29 - 29	18 - 18	19 - 19	23 - 23	26 - 26
Manchester (Stock)	1 days	£215	8 - 8
Milton Keynes	1 days	£215	8 - 8 11 - 11	20 - 20	13 - 13	17 - 17	14 - 14	18 - 18
Newcastle	1 days	£215	22 - 22
Reading	1 days	£215		21 - 21 22 - 22	4 - 4		14 - 14
Washington	1 days	£215			5 - 5	24 - 24	7 - 7	8 - 8

<< Previous 6 Months

Next 6 Months >>

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course