Microsoft Excel 2003 Training Course Intermediate

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

Intermediate Excel Prices from:

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

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