Microsoft Office 2003 Courses

• Master the Excel interface and fundamentals, such as mouse controls, keyboard shortcuts, toolbars, and dialog boxes.

• Select, retrieve, view, and chart data.

• Discover how to use Excel as a database and understand how and why we use spreadsheets.

• Review sorting & filtering, formulas, functions, charts, and graphs.

• Enter labels and values into a workbook.

• Navigate, name, and save a workbook.

• Enter and work with date values and AutoComplete.

• Edit, clear, replace cell contents, and use the Clipboard.

• Cut, Copy, Paste, Paste Special, and move cells.

• Insert and delete cells, rows, and columns, and adjust row height and column width.

• Use Undo, Redo, and Repeat.

• Find and replace information.

• Understand and effectively incorporate Smart Tags.

• Insert cell comments.

• Format fonts and values with the Formatting toolbar and menus.

• Use the Format Painter to copy formatting.

• Work with AutoFormat, create a customer number format, find and replace formatting, and use conditional formatting.

• Create, apply, and modify a Style.

• Merge cells, align a cell's contents, add borders and colors, and rotate text.

• Preview and print worksheets and use advanced print options.

• Create charts, format objects in charts, change a chart’s source data and chart type, and work with a 3-D chart and custom charts.

• Work with and understand Absolute and Relative cell references.

• Hands-on exercises with time set aside to practice what you have learned.