HBI College Course Outline - Excel 2003

Microsoft Excel 2003 - Level 2

COURSE DESCRIPTION

Excel, one of the most widely used business applications, facilitates the management of enormous amounts of numbers and data. Excel skills are desired by employees, businesses and home owners alike. In this course you will learn to calculate advanced formulas, build complex calculations, work with graphic objects, and sort and filter data using forms and templates.

PREREQUISITES

Microsoft Excel 2003 - Level 1

CORE TOPICS
Creating and Applying Templates		Calculating with Advanced Formulas
Create a workbook from a template Create a custom template Working with comments Create a hyperlink Use web-based research tools		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
Creating and Modifying Charts		Sorting and Filtering Data
Create a chart Format chart items Change the chart type Create a diagram		Sort data lists Filter data lists Create and apply advanced filters Calculate with database functions Add subtotals to a worksheet
Working with Graphic Objects		Using Excel with the Web
Insert graphics Create AutoShapes Format graphic objects Change the order of graphic objects Group graphic objects Move, copy and resize graphic objects		Export Excel data Publish a worksheet to the web Import data from the Web Create a Web query

Your partner in customized corporate education.

Call 905 949 9900 Extension 2474
to talk about your training needs,
or email
corporatetraining@hbicollege.com