1	Welcome to Excel 2003 Judy Rosella Edwards judy@judyrosellaedwards.com www.judyrosellaedwards.com
2	EXCEL 2003 Level 1
3	Using Basic Workbook Skills Entering Text into Cells Saving a New Workbook Using AutoComplete Using Pick From List Entering Numbers into Cells Editing Cell Entries
4	Working with Ranges Selecting Ranges with the Keyboard Selecting Ranges with the Mouse Selecting Non-Adjacent Ranges Entering Values into a Range Using AutoFill
5	Creating Simple Formulas Entering Formulas Using the AutoSum Button Using Functions Using Formula AutoCorrect Using Formula Palette Using the Paste Function Button
6	Copying and Moving Data Copying, Cutting, Pasting Creating an Absolute Reference Filling Cells Using Drag-and-Drop Editing Using Undo and Redo Using the Undo and Redo Lists
7	Printing Worksheets Previewing a Worksheet Zooming the Preview Window Printing a Worksheet Printing a Selected Range Printing Multiple Copies Printing a Page Range
8	Using Page Setup Changing the Page Margins Centering the Worksheet Changing the Page Orientation
9	Editing Headers and Footers Customizing Headers and Footers Printing without Gridlines Repeating Row and Column Labels Using Page Break Preview Setting/Removing a Print Area
10	Formatting Numbers Using the Number Formats Using the Currency Style Using the Percent Style Using the Comma Style Changing Decimal Places Decreasing Decimal Places
11	Formatting Text Using the Font & Font Size Lists Using the Formatting Buttons Bold Italic Underline Using the Font Color Button Rotating & Wrapping Text in a Cell Shrinking Text in a Cell Merging Cells into One Cell Increasing the Indent of Text Decreasing the Indent of Text
12	Working with Columns & Rows Selecting Columns and Rows Changing Width and Height Adjusting Columns Automatically Hiding & Unhiding Columns & Rows Inserting or Deleting a Column Inserting or Deleting a Row
13	Formatting Cells Using the Merge-and-Center Button Using the Align Buttons Splitting Cells Using the Center Button Using the Borders Button Using the Fill Color Button Using the Format Painter Button Copying Formats to Non-Adjacent Cells Clearing Formats Inserting & Deleting Cells
14	Automatic Formatting & Styles Using Auto Formatting Features Extending List Formats & Formulas Creating Styles
15	Getting Help Microsoft Help Help Task Pane Online Help …take Excel Level 2!
16	EXCEL 2003 Level 2
17	Using Large Worksheets Increase & Decrease Magnification Switching to Full Screen view Splitting the Window Removing Split Windows Freezing and Unfreezing the Panes
18	Working with Multiple Worksheets Navigating Between Worksheets Selecting and Renaming Worksheets Coloring Worksheet Tabs Inserting and Deleting Worksheets Printing Selected Worksheets
19	Managing Worksheets Copying and Moving Worksheets Using Grouped Worksheets Moving & Copying Data Between Worksheets Creating 3-D Formulas
20	Using Range Names Using Range Names in Formulas Creating Range Names from Headings Applying and Deleting Range Names Using Range Names in 3-D Formulas Using 3-D Range Names in Formulas
21	Using Other Functions Using Function Arguments Using Financial Functions Using Logical Functions Using Date Functions
22	Managing Data Sorting in ascending/descending order Finding and Replacing data Finding and Replacing cell formats
23	Using AutoFilter Using AutoFilter to Filter a List Clearing AutoFilter Criteria Creating a Custom AutoFilter
24	Creating Charts Creating Charts with Chart Wizard Moving and Resizing Charts Changing Chart Type and Sub-Type Changing the Plot Direction Removing or Adding a Legend Charting Non-Adjacent Ranges Changing the Chart Range Changing the Data Source
25	Formatting Charts Adding Chart Titles Formatting Chart Objects Changing the Text Orientation Creating an Exploded Pie Chart Adjusting the 3-D View
26	Drawing an Object Selecting Filled and Unfilled Objects Adding Text to an Object Resizing an Object Changing & Removing the Fill Color Changing the Font Color
27	Using Additional Effects & Objects Adding a 3-D Effect Adding a Shadow Inserting Pictures
28	Using AutoShapes and Diagrams Drawing Callouts and Basic Shapes Drawing Connectors Drawing FlowChart Shapes Drawing a Block Arrow Inserting a Diagram
29	Use HTML Files Previewing a Web Page Creating a Hyperlink Saving a Worksheet as a Web Page Opening an HTML file
30	Working with Comments Creating & Viewing Comments Using the Reviewing Toolbar Printing Comments Responding to Discussion Comments
31	EXCEL 2003 Level 3
32	Working with Labels in Formulas Using Labels to Define a Range Using Multiple Stacked Labels Using Labels to Refer to Cells
33	Working with Outlines Working with Outlines Collapsing Expanding Clearing Modifying Outline Settings Using Auto Outline
34	Working with Databases Creating & Modifying a Database Sorting Records by Multiple Fields Using & Removing Data Validation Creating a Custom Error Message Creating & Removing List Subtotals
35	Working with the Data Form Data Form Records Viewing Adding Editing Defining Criteria Clearing Data Form Criteria
36	Working with Advanced Filters Using a Criteria Range Showing All Records Using Comparison Criteria Using Advanced And/Or Conditions Using Database Functions
37	Using List Features Creating, Sorting, Filtering a List Using the List Menu Creating a Total Row
38	Exporting and Importing Data Exporting to XML Changing External Data Range Properties Importing Data from Other Applications Importing Dynamic Data from the Web
39	Advanced Charting Formatting Gridlines Axes Data Series Adding Data - Different Worksheets Adding a Trendline Creating and Applying User-defined Charts
40	Using Multiple Workbooks Opening Multiple Workbook Windows Comparing Workbooks Side by Side Copying Data between Workbooks Saving a Workspace Linking Workbooks
41	Using Conditional and Custom Formats Applying and Changing Conditional Formats Adding or Deleting Conditional Formats Creating a Custom Format
42	Using Templates Saving a Workbook as a Template Editing a Template Inserting a New Worksheet Creating Default Templates Finding Online Templates
43	Using Paste Special Copying Values & Formulas between Worksheets Performing Mathematical Operations
44	Customizing Excel Preferences Setting View and Edit Options Setting Manual and Automatic Calculation Setting General Options
45	Using Worksheet Protection Unlocking Cells in a Worksheet Protecting & Unprotecting Worksheets Creating & Deleting Allow-Editing Ranges Protecting & Unprotecting Workbook Windows Assigning & Removing a Password
46	Sharing Workbooks Saving a Shared Workbook Viewing Users Sharing a Workbook Viewing Shared Workbook Changes Changing the Update Frequency Highlighting Changes Resolving Conflicting Changes Adding a History Worksheet Reviewing Tracked Changes Merging Shared Workbook Files
47	EXCEL 2003 Level 4
48	Working with Data Series Using the Series command Creating a linear or date series Using a stop value
49	Using Advanced Functions Using lookup functions Using VLOOKUP and HLOOKUP functions Using IF and nested IF functions Using the ISERROR function Using an AND condition with IF Using an OR condition with IF Using the ROUND function Limiting the precision of numbers
50	Using Scenarios & Goal Seeking Creating a scenario Displaying and editing a scenario Using goal seek
51	Using Data Tables Placing Formulas in data tables Creating one- and two-variable tables
52	Using Auditing Tools Displaying and Removing dependent arrows Displaying and Removing precedent arrows Tracing cells causing errors
53	Consolidating Worksheets Consolidating by category or position
54	Solving Problems Saving a solution as a scenario Restoring the original values Creating a Solver report
55	Working with Views Creating a normal or Custom view Displaying & Deleting a view
56	Using Macros Running a macro Using a shortcut key Using the Visual Basic toolbar Opening the Visual Basic Editor window Using the Visual Basic Editor window
57	Recording Macros Assigning a shortcut key Using relative references Assigning a macro to a menu
58	Editing Macros Entering macro comments Copying and Editing macro commands Running a macro from the Code window
59	Using Custom Toolbars & Buttons Adding a button to a toolbar Assigning a macro to a button Attaching a custom toolbar
60	Creating a Macro Button Using a macro button Copying and Formatting a macro button
61	Creating & Revising PivotTables Adding PivotTable report fields Selecting a page field item Refreshing a PivotTable report Changing the summary function Adding PivotTable report fields Creating a page field report Creating a PivotChart report Creating interactive PivotTables-Web
62	Using XML in Excel 2003 Working with XML in Excel Attaching a Schema Map to Workbooks Setting XML Source Task Pane Options Mapping XML Elements to Worksheets Importing and Exporting XML Data Mapping Repeating Data Viewing XML Map Properties Appending XML Data