Microsoft Office Excel 2003 Basic
|
|
MS Office |
Language Course |
ILT Classroom |
Mentored Learning |
OnLine AnyTime |
OnLive Live |
|
Excel 2003 |
Portuguese /
English |
Yes |
Yes |
Yes |
Yes |
24 HRS / 3 DAYS
Lesson 1: Getting Started with Excel
• An Overview of Excel
• Navigate in Excel
• Select Data
• Enter Data
• Save a Workbook
• Obtain Help
Lesson 2: Modifying a Worksheet
• Move and Copy Data Between Cells
• Fill Cells with Series of Data
• Edit Cell Data
• Insert and Delete Cells, Columns, and Rows
• Find, Replace, and Go To Cell Data
• Spell Check a Worksheet
Lesson 3: Performing Calculations
• Create Basic Formulas
• Calculate with Functions
• Copy Formulas and Functions
• Create an Absolute Reference
Lesson 4: Formatting a Worksheet
• Change Font Size and Type
• Add Borders and Color to Cells
• Change Column Width and Row Height
• Merge Cells
• Apply Number Formats
• Create a Custom Number Format
• Align Cell Contents
• Find and Replace Formats
• Apply an AutoFormat
• Apply Styles
Lesson 5: Developing a Workbook
• Format Worksheet Tabs
• Reposition Worksheets in a Workbook
• Insert and Delete Worksheets
• Copy and Paste Worksheets
• Copy a Workbook
Lesson 6: Printing Workbook Contents
• Set a Print Title
• Create a Header and a Footer
• Set Page Margins
• Change Page Orientation
• Insert and Remove Page Breaks
• Print a Range
Lesson 7: Customizing Layout
• Split a Worksheet
• Arrange Worksheets
• Freeze and Unfreeze Rows and Columns
• Hide and Unhide Worksheets
Lesson 8: Creating and Applying Templates
• Create a Workbook from a Template
• Create a Custom Template
• Working with Comments
• Create a Hyperlink
• Use Web-based Research Tools
Lesson 9: Creating and Modifying Charts
• Create a Chart
• Format Chart Items
• Change the Chart Type
• Create a Diagram
Lesson 10: Working with Graphic Objects
• Insert Graphics
• Create AutoShapes
• Format Graphic Objects
• Change the Order of Graphic Objects
• Group Graphic Objects
• Move, Copy, and Resize Graphic Objects
Lesson 11: Calculating with Advanced Formulas
• 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
Lesson 12: Sorting and Filtering Data
• Sort Data Lists
• Filter Data Lists
• Create and Apply Advanced Filters
• Calculate with Database Functions
• Add Subtotals to a Worksheet
Lesson 13: Using Excel with the Web
• Export Excel Data
• Publish a Worksheet to the Web
• Import Data from the Web
• Create a Web Query