Microsoft Excel 2003 Level 2 Course
Course DescriptionIn 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 Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
|
£235 1 day course Scheduled Dates: 17 January 2012 14 February 2012 13 March 2012 10 April 2012 08 May 2012 06 June 2012 Location: PTR's Training Centre Wokingham, Berkshire. |
Course pre-requisites:
To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Excel 2003. Students can obtain this level of skill by taking the following PTR course:
- Excel 2003 - (Level 1)
This course is rated as an Intermediate Course, suitable for accomplished computer users.
Topics covered on the 1 day Microsoft Excel 2003 Level 2 course
Creating and Applying Templates
- Create a Workbook from a Template
- Create a Custom Template
- Working with Comments
- Create a Hyperlink
- Use Web-based Research Tools
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
- Change the Order of Graphic Objects
- Group Graphic Objects
- Move, Copy, and Resize Graphic Objects
Calculating with Advanced Formulas
- Create and Apply a Name for a Range of Cells
- Calculate Across Worksheets
- Calculate with Date and Time Functions
- Calculate with Financial Functions
- Calculate with Statistical Functions
- Calculate with Lookup and Reference Functions
- Calculate with Logical Functions
Sorting and Filtering Data
- Sort Data Lists
- Filter Data Lists
- Create and Apply Advanced Filters
- Calculate with Database Functions
- Add Subtotals to a Worksheet
Using Excel with the Web
- Export Excel Data
- Publish a Worksheet to the Web
- Import Data from the Web
- Create a Web Query
Course Classification:
Applications Training Course
This is an instructor led training course taught in a classroom based environment.
Scheduled course dates
17 January 2012 to 17 January 2012
14 February 2012 to 14 February 2012
13 March 2012 to 13 March 2012
10 April 2012 to 10 April 2012
08 May 2012 to 08 May 2012
06 June 2012 to 06 June 2012
View full schedule of Microsoft Excel courses
View full schedule of Microsoft Excel 2003 courses
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Microsoft Excel Training and bespoke Microsoft Excel courses