Excel 2003 Basic

Description

Students will learn how to enter and edit data, labels, and formulas, work with functions, format cells, print worksheets, create charts, and save a workbook as a web page.

Objectives

• Start Microsoft Excel, identify the main components of the Excel window and an Excel workbook, and use the Help feature.
• Enter and edit labels, values, and formulas in a worksheet, and find and replace a formula.
• Move and copy data, insert and delete ranges, and work with relative and absolute references when creating and copying formulas.
• Use functions such as SUM, AVERAGE, MIN, and MAX to perform calculations in a worksheet, and use the AutoSum feature.
• Format text, numbers, rows, and columns in a worksheet.
• Preview and control Page Setup options for a worksheet, print a worksheet, and set and clear a print area.
• Create, format, modify, and print charts based on worksheet data.
• Save a worksheet as a web page, use the AutoRepublish feature, insert and edit hyperlinks in worksheets, and send a workbook via e-mail.

Outline

Download PDF Outline

Excel 2003 Intermediate

Description

Students will learn how to work with large worksheets, use 3-D formulas, customize Excel's toolbars and menus, apply special cell formatting, sort and filter lists, create combination charts and trendlines, use Excel's auditing features, and work with templates.

Objectives

• Navigate large worksheets effectively by using magnification, frozen panes, and split panes; and control the printing of large worksheets.
• Navigate, manage, and print multiple worksheets; link workbooks by using 3-D formulas; and summarize data by using the Consolidate command.
• Change the View, General, and Calculation settings of Excel; and customize toolbars and menus.
• Add borders and shading; apply special formats; create, apply, and modify styles; and change the orientation of cells.
• Sort lists by columns; and filter lists based on complex criteria.
• Format data points; create combination charts and trendlines; and add and format graphic elements.
• Use auditing features; add comments and text boxes; and protect a worksheet or part of a worksheet.
• Work with Excel’s built-in templates; and create and manage custom templates.

Outline

Download PDF Outline