Excel 2003

Introduction to Excel 2003:

• Starting Excel
• What is a Worksheet?
• What is a Workbook?
• Identifying Parts of the Screen
• The Task Pane
• Identifying the Toolbars
• Getting Help from the Office Assistant
• Using Selection Techniques
• Selecting a Range of Cells
• Selecting Nonadjacent Cells and Ranges
• Selecting an Entire Worksheet
• Entering Data
• Entering Text Data into a Cell
• Entering Values
• Entering Data into a Range
• Quickly Adjusting a Column Width
• Finishing a Workbook
• Saving a Named Workbook
• Saving the Workbook in HTML Format
• Printing a Worksheet
• Closing a Workbook and Exiting from Excel

• Opening a workbook
• Creating a new workbook
• Opening a recently used workbook
• Creating Simple Formulas
• Creating a formula by pointing
• Using Functions
• Using the Autosum Button
• Using the Formula Palette
• Editing data on the worksheet
• Editing the data in a cell
• Editing a formula
• Clearing the contents from a cell or range
• Using Undo and Redo

• Navigating in a worksheet
• Using the scroll bars and boxes
• Changing Worksheets
• Using Go to
• Changing the worksheet structure
• Deleting cells, rows and columns
• Performing a simple sort
• Creating and using named ranges
• Automatically naming ranges
• Navigating with named ranges

• Creating Charts.
• Moving and Copying Data
• Copying Data
• Copying Data with AutoFill
• Creating a Series with AutoFill
• Defining Relative, Mixed, and Absolute References
• Copying Formulas
• Changing the Appearance of Data
• Changing Row Height
• Applying Fonts
• Adding Enhancements
• Aligning Data in Cells
• Merging and Centering Cells
• Rotating and Indenting Text
• Adding Borders and Shading
• Using Drawing Tools
• Creating Graphic Objects
• Editing a Graphic Object
• Creating and Editing 3-D Objects
• Using Other Drawing Tool

Intermediate Excel 2003:

• Using Multiple Worksheets
• Inserting New Worksheets
• Renaming Worksheets
• Deleting Worksheets
• Creating Multiple Views
• Freezing Panes
• Viewing and Arranging Multiple Worksheet Windows
• Navigating in Multiple Workbooks
• Selecting and Viewing Multiple Workbooks
• Creating and Opening a Workspace
• Managing Multiple Worksheets and Workbooks
• Selecting Multiple Worksheets
• Moving and Copying Data between Worksheets
• Linking Data Between Worksheets
• Creating a 3-D Formula

• The Chart Facility.
• Using Charts
• Creating a Chart
• Specifying the Chart Source Data
• Selecting Chart Options
• Selecting a Chart Location
• Managing Chart Objects
• Moving and Resizing Chart Objects
• Deleting Chart Object
• Adding Data Series' and Objects to a Chart
• Enhancing the Chart
• Changing the Chart Type
• Formatting Chart Objects
• Adding Text to a Chart
• Printing Charts

• Creating and Using Functions
• Using Built-in Functions
• Working with Arguments: The PMT Function
• Using Dates and Times
• Using Dates in Calculations
• Using Nested Functions
• Auditing Worksheets
• Identifying the Auditing Commands
• The Watch Window
• The Formula Evaluator
• Tracing and Correcting Worksheet Errors

• Using Comments in a Worksheet
• Reviewing, Showing, and Hiding Comments
• Deleting a Comment
• Working with Styles
• Applying a Style
• Redefining and Modifying Existing Styles
• Using Format Painter
• Creating Custom Number Formats
• Applying an AutoFormat
• Applying a Conditional Format
• Using Templates
• Creating a Template
• Editing a Template
• Verifying Your Work
• Using AutoCorrect

Advanced Excel 2003 (database):

• Database definitions
• Creating and sorting data
• Multiple criteria
• Autofilter
• Custom autofilter
• Advanced Filter
• Three or more conditions

• Add Sub-totals
• Summary functions in sub-total lists
• Use of outlines in sub-totals
• Nested sub-totals
• Remove sub-totals
• Consolidating data by position
• Consolidating data by category
• Change references to Source Area
• Create links to consolidated data
• Summarise data by outlining
• Ungroup rows or columns manually
• Show / Hide the detail

• Functions
• Statistical functions (Average, Max, Min, Count, StDev, Var, Forecast, Intercept, Slope)
• Lookup and reference formulas (Hlookup, Vlookup)
• Logical Functions

• Error checking
• Trace precedents / dependants
• Identify incorrect values in cells
• Add conditional formatting to cells
• Cell comments - add, hide, edit, delete
• The Range finder
• Track changes

• Analysising statistics
• ANOVA -single-factor analysis tool
• Correlation analysis tool

• Creating Charts
• Editing charts - change the chart type or attributes
• Print charts
• Change the tick-mark labels
• Change the axis scales
• Add or delete data
• Combination charts
• Plot missing data
• Formatting Charts
• Custom Charts and Formats

• Pivot tables
• Custom calculations in Pivot tables
• Show / hide items in Pivot table
• Add / remove fields
• Number format
• Group / ungroup data
• Pivot table pages
• Pivot chart