|
|
 Microsoft Excel 2003 Basics
Courseware Training Materials
 Foundation
/ Intermediate level computer training materials for delivering training to your
students, staff or clients. A courseware site licence allows you to train
an unlimited number of people, at your training center using these teaching resources.
Training Course Outlines
USING EXCEL 2003
-
Starting Excel using the Windows Start menu
-
Closing Excel
-
Opening and closing an existing workbook
-
Selecting and opening a continuous block of files
-
Selecting and opening multiple files which are not in a continuous block
-
Creating a new default workbook
-
Saving a workbook
-
Saving a workbook (using a different name)
-
Saving a file in a format other than Excel format, such as Lotus 123
-
Saving an Excel file as a Text Only file
-
Saving a file in an earlier Excel format
-
Saving a workbook as a template file
-
Setting the User Name.
-
Setting the default folder.
-
Today's Tip
-
Displaying the Office Assistant
-
Hiding the Office Assistant
-
Using "Type in a question for help"
-
Using "F1 Help" within Excel
-
Help drop down menu options
-
Zooming the view
-
Displaying or hiding the toolbars.
SELECTION TECHNIQUES
-
Selecting a cell
-
Selecting non-adjacent cells
-
Selecting a range of cells by dragging the mouse
-
Selecting a range of adjacent cells, making up a rectangular block
-
Selecting an entire worksheet
-
Selecting several worksheets
-
Selecting all worksheets
-
Selecting a row
-
Selecting a range of adjacent rows
-
Selecting a range of non-adjacent rows
-
Selecting a column
-
Selecting a range of adjacent columns
-
Selecting a range of non-adjacent columns
INSERTING AND EDITING DATA
-
Entering numbers.
-
Entering today's date.
-
Entering text into a cell.
-
Recommended techniques when creating or editing lists
-
Inserting additional cell contents, or modifying existing cell content.
-
Replacing existing cell contents
-
Using the Undo button
-
Using the Redo button
FINDING AND REPLACING TEXT
-
Finding text in a worksheet
-
Finding and replacing text within a worksheet
SORTING DATA
-
Sorting a list in ascending alphabetic order
-
Sorting a list in descending alphabetic order
-
Sorting a list in ascending numeric order
-
Sorting a list in descending numeric order
COPYING, MOVING AND DELETING
-
Copying a cell range within a worksheet
-
Copying a row or column within a worksheet
-
Copying a cell range between worksheets
-
Copying a row or column between worksheets
-
Copying a cell range from one workbook, to a different workbook
-
Copying a row or column from one workbook, to a different workbook
-
Using AutoFill
-
AutoFill options
-
Moving a cell range within a worksheet
-
Moving a row or column within a worksheet
-
Moving a cell range between worksheets
-
Moving a row or column between worksheets
-
Moving a cell range from one workbook, to another workbook
-
Moving a row or column from one workbook, to another workbook
-
Deleting the contents of a cell or range
ROWS AND COLUMNS
-
Inserting a row into a worksheet
-
Inserting a column into a worksheet
-
Deleting a row.
-
Deleting a column.
-
Changing the width of a column using drag and drop techniques
-
Changing the width of a column to a specific value
-
Setting the column width to the optimal width
-
Setting new default column widths
-
Changing the height of a row to a specific value
-
Setting the row height to the optimal height
-
Freezing and unfreezing column titles
-
Freezing and unfreezing row titles
-
Freezing and unfreezing row titles and column titles
MANIPULATING WORKSHEETS
-
Switching between worksheets within a workbook
-
Switching between open workbooks using the Windows Status bar
-
Switching between open workbooks using the Window drop down menu
-
Switching between open workbooks using a keyboard shortcut
-
Inserting a worksheet tab
-
Renaming a worksheet tab.
-
Recommended techniques with naming worksheets
-
Deleting a worksheet (by right-clicking)
-
Copying a worksheet within a workbook (the quick way)
-
Copying a worksheet to another workbook
-
Moving a worksheet within a workbook (the quick way)
-
Moving a worksheet to another workbook
FORMULAS
-
Entering formulas into the worksheet cell
-
Entering a cell or range reference using the mouse.
-
Using divide within a formula
-
Using subtraction within a formula
-
Using multiply within a formula
-
Named cell ranges
-
Formula error messages
-
Getting help with formula error messages
-
Using relative addressing
-
Using absolute addressing
-
Taking advantage of relative addressing when using AutoFill.
FUNCTIONS
-
Common functions
-
SUM function
-
Average function
-
MAX function
-
MIN function
-
COUNT function
-
Counta function
-
Countblank function
-
IF function
-
Using comparison operators such as =, >, and <.
NUMBER AND DATE FORMATTING
-
Formatting cells to display a fixed number of decimal places
-
Applying comma separators
-
Removing comma separators.
-
Formatting date styles
-
Formatting cells using currency symbols
-
Formatting numbers as percentages
TEXT FORMATTING
-
Font size
-
Font type
-
Bold
-
Italic
-
Underlining
-
Double underlining
-
Changing the color used by the text
-
Changing the background color of a cell range
-
Applying formatting using the Format Painter
-
Wrapping text within selected cells
ALIGNMENT AND BORDER EFFECTS
-
Aligning data within a cell range, to the left, to the right or centre
-
Aligning data between the top and bottom of a cell
-
Merging and centering over a range
-
Rotating text to any angle
-
Applying a border to a cell range (using the Border button)
-
Applying a border to a cell range (using the Format Cells/Border dialog box)
-
Removing a border from cells or ranges
CHARTS
-
Using the Chart Wizard
-
Creating a column chart
-
Creating a bar chart
-
Creating a line chart
-
Creating a pie chart
-
Changing the Chart Type
-
Selecting a chart
-
Moving a chart within a worksheet
-
Moving a chart to a different worksheet within a workbook
-
Moving a chart to a worksheet within a different workbook
-
Copying a chart within a worksheet
-
Copying a chart to a different worksheet within a workbook
-
Copying a chart to a worksheet within a different workbook
-
Re-sizing a chart
-
Deleting a chart
-
Adding a title to a chart
-
Removing titles from a chart
-
Editing a chart title
-
Changing the font size of the chart title text
-
Changing the color of the chart title text
-
Changing the font size of the chart axes text
-
Changing the color of the chart axes text
-
Inserting a chart legend
-
Changing the color of the chart legend text
-
Changing the legend font size
-
Changing the background color of the chart legend
-
Changing the background color of a chart
-
Changing the color of a column within a chart
-
Changing the color of a bar within a chart
-
Changing the color of a line within a chart
-
Changing the color of a pie slice within a chart
PRINTING ISSUES
-
Modifying margin values
-
Setting orientation and page size
-
Forcing a worksheet to print on a single page
-
Using standard headers and footers
-
Creating custom headers and footers
-
Inserting fields into a header or footer
-
Always check your work prior to sending it to someone else!
-
Spell checking a workbook.
-
Checking calculations within a worksheet
-
Previewing a worksheet
-
Turning on (or off) the printing of gridlines
-
Controlling the printing of row and column headings
-
Forcing the title row(s) to print on every page of a multi-page worksheet.
-
Printing a cell range from a worksheet
-
Printing the entire active worksheet
-
Setting the number of copies to print
-
Printing a selected area of data within a worksheet
-
Printing the entire workbook (including all the worksheets within it)
-
Printing a selected chart
-
Printing a workbook to a file
|
Customisable
Courseware
