THE Information Solution Provider P.O Box : 705 Westville 3630
Tel : (031) 266 8130
Fax : (031) 266 9610
Microsoft® Certifications End User Technical Programming Database
Booking Form
Services Queries
Services Support Pricing Queries Web Mail - Netsolution Web Mail - TC
Vista Versions Windows Media Center Thin Client VOIP
Contact Us
Subscribe Unsubscribe

Skip Navigation LinksACB South Africa > Training > Excel Level 3

Microsoft Accreditations: Advanced Infrastructure Solutions(amongst others) Our Microsoft accreditations: Microsoft Certified Learning Solution Provider(amongst others)

Microsoft® Office Excel 2003: Advanced
Course length: 1.0 day(s)
Certification: Microsoft Office Specialist: Microsoft® Excel 2003

Course Description:
This course is designed to help you to develop spreadsheets in which data on different sheets can be linked, consolidated, summarised, and analysed using a variety of tools. You will learn to apply different formatting options to sheets and charts and how to use LOOKUP functions to extract data from a table. You will also learn to distribute data in different formats, such as publishing an interactive spreadsheet on the web.

Target Audience:
Those wanting to develop their skills in using Excel to design spreadsheet solutions and use tools for creating and formatting more complex spreadsheets, that solve more difficult problems and incorporate data from a wider range of sources.

You should be competent with the objectives required for Excel at Microsoft Office Specialist Core Level. You should be able to use formulas confidently and create charts.

With its companion course, Microsoft Excel Professional, you can use this course to prepare for Microsoft Office Specialist Excel Expert Objectives.

Course Content:
Excel 2003 - Application Options and File Properties
View and change application options • View and change workbook properties

Excel 2003 - Using Named Ranges
Apply a name to a range of cells • Apply a name to a constant value • Modify and delete range names • Print a list of range names • Use a range names and labels in formulas • Define and modify a list range

Excel 2003 - Custom Number and Conditional Formatting
Use formatting options with Paste Special • Create a custom number or date format • Use scientific and fractional number formats • Use conditional formatting

Excel 2003 - Linking Worksheets and Workbooks
Create a formula to link worksheets and workbooks • Consolidate data using 3D references in common functions • Use Paste Special to link worksheets and workbooks • Use Paste Special to manipulate data • Manage and update linked workbooks

Excel 2003 - Consolidating Data
Use Consolidate to summarise data in multiple lists

Excel 2003 - Summarising a List
Extract data using advanced filters • Group and subtotal data using the outlining tools • Use Dfunctions to perform calculations on a data list

Excel 2003 - PivotTable and PivotChart Reports
Create a PivotTable Report • Modify PivotTable field layout • Modify field settings and grouping intervals • Use PivotTable AutoFormat • Create a PivotChart Report

Excel 2003 - Lookup Functions
Use VLOOKUP and HLOOKUP to get values from multi-column tables • Sort values in rows or from left-to-right • Use other lookup functions (LOOKUP, MATCH, INDEX, OFFSET) • Prevent lookup errors

Excel 2003 - Customising a Chart
Change the source data for a chart and modify data series • Explode segments of a pie chart • Insert an image into a chart • Add a text box to a chart • Store a custom chart as a chart template

Excel 2003 - Importing Text Data
Import data from a text file

Office 2003 - Inserting Spreadsheets and Charts
Insert a worksheet from Microsoft Excel • Insert a chart from Microsoft Excel

Excel 2003 - Publishing to a Web Page
Save a worksheet or chart as a web page • Use Web Page Preview

Office 2003 - Working with Objects
Select, position, and delete an object • Resize an object • Move or copy an object

Email the webmaster with questions or comments about this web site
Terms and Conditions
Copyright © 2006 A.C.B South Africa