Est. 2002

London Skyline

Home Courses Enquiries Online Training Blogs Locations Prices

Cost Calculator

Price Per Head:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

Tell Me More

Testimonials

Financial Services Organisation

"The resources are excellent and I will be able to learn independently from the notes"

Private

"Very efficient Very clear and easy to understand Simon was very accommodating in showing us functions outside the day course Easy to follow instructions Lovely lunch and snacks. Simon and Cindy are really pleasant and lovely people, I left with the feeling that I had learnt a lot Mission accomplished!"

Dent Wizard

"Very useful, definitely will recommend the training to any company. Covers key aspects used in any workplace in a simple yet effective way by breaking it down step by step. Key shortcuts also very handy to use going forward, I have definitely picked up some handy tricks which I will be able to use on a daily basis at work"

>

South Norfolk Council

"The training was exactly what I needed to enhance my self-taught skills in Power BI. To be shown the capability and understand the programming (DAX) will enable me to produce templates for use within the organisation. The pace and interactivity was great and Simon was a fantastic trainer in getting everyone involved and imparting his knowledge of the product."

Handling Information

Print & Desktop Publishing

Virtual Meetings

Locations

Microsoft Excel 2003 Training Course Intermediate

Microsoft Excel 2003 Overview

Can you use Excel for a Database? How do I create different types of charts? What do I need to so to link them to Microsoft Word or Microsoft PowerPoint?

In the Introduction training course to Excel 2003, 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 streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Other Excel training courses

Course Duration: 1 Day

Course Outline

Creating and Applying Templates using Microsoft Excel 2003

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 with Excel 2003

Create a Chart
Format Chart Items
Change the Chart Type
Create a Diagram

Working with Graphic Objects in Excel 2003

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 in Excel 2003

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 using Excel 2003

Sort Data Lists
Filter Data Lists
Create and Apply Advanced Filters
Calculate with Database Functions
Add Subtotals to a Worksheet

Using Excel 2003 with the Web

Export Excel Data
Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query

Classroom based Intermediate Excel Prices from:

If you are interested in this classroom based course but want to know the price beforehand then use the following form to calculate how much.

If you are interested in this course fill out the following form for further details:

Have a look at our range of Excel Training Courses

You may also be interested in the following training courses:

Microsoft Excel 2016 training course beginners

Microsoft Excel 2016 training course intermediate

Microsoft Excel 2016 training course advanced

Microsoft Excel Pivot Tables training course beginners

Microsoft Excel PowerPivot training course intermediate

Microsoft Excel 2003 Training Course - Advanced

Microsoft Excel VBA 2003 Training Course - Beginners

Birmingham | Brentwood | Cambridge | Coventry | Guildford | Ipswich| Leicester | Luton | Milton Keynes | Northampton | Norwich | Oxford | Peterborough | London (Chiswick) | London (Hammersmith) | London (Heathrow) | London (Kensington) | Reading

Q & A

Easy Spreadsheet Accounts

Microsoft Excel 2003 Training Course Intermediate