Excel 2007 Foundation Courseware Materials

Microsoft Excel 2007 Foundation Training Materials for IT Trainers

Computer Training Courseware Materials for Office 2007

Training Course Outline

A FIRST LOOK AT EXCEL 2007

  • Starting the Excel program
  • What is the Active Cell?
  • The Excel cell referencing system
  • Entering numbers and text
  • Default text and number alignment
  • Adding a column of numbers
  • Worksheets and Workbooks
  • Saving a workbook
  • Closing a workbook
  • Creating a new workbook
  • Opening a workbook
  • Switching between workbooks
  • Saving a workbook using another name
  • Saving a workbook using a different file type

EXCEL 2007 HELP

  • Getting help
  • Searching for Help
  • The Help ‘Table of Contents’
  • Printing a Help topic
  • Alt key help

EXCEL 2007 – SELECTION TECHNIQUES

  • Why are selection techniques important?
  • Selecting a cell within Excel 2007
  • Selecting a range of connecting cells
  • Selecting a range of non-connecting cells
  • Selecting the entire worksheet
  • Selecting a row
  • Selecting a range of connecting rows
  • Selecting a range of non-connected rows
  • Selecting a column
  • Selecting a range of connecting columns
  • Selecting a range of non-connecting columns

EXCEL 2007 – MANIPULATING ROWS AND COLUMNS

  • Inserting rows into a worksheet
  • Inserting columns into a worksheet
  • Deleting rows within a worksheet
  • Deleting columns within a worksheet
  • Modifying column widths
  • Modifying column widths using ‘drag and drop’
  • Automatically resizing the column width to fit contents
  • Modifying row heights

EXCEL 2007 – COPYING, MOVING AND DELETING

  • Copying the cell or range contents
  • Deleting cell contents
  • Moving the contents of a cell or range
  • Editing cell content
  • Undo and Redo
  • AutoFill
  • Sorting a cell range
  • Searching and replacing data in Excel 2007

EXCEL 2007 – MANIPULATING WORKSHEETS

  • Switching between worksheets
  • Renaming a worksheet
  • Inserting a new worksheet
  • Deleting a worksheet
  • Copying a worksheet within a workbook
  • Moving a worksheet within a workbook
  • Copying or moving worksheets between workbooks

EXCEL 2007 – FONT FORMATTING

  • Font type
  • Font size
  • Bold, italic, underline formatting
  • Cell border formatting
  • Formatting the background colour
  • Formatting the font colour

EXCEL 2007 – ALIGNMENT FORMATTING

  • Aligning contents in a cell range
  • Centring a title over a cell range
  • Cell orientation
  • Text wrapping
  • Format painter

EXCEL 2007 – NUMBER FORMATTING

  • Number formatting
  • Decimal point display
  • Comma formatting
  • Currency symbol
  • Date styles
  • Percentages

EXCEL 2007 – FREEZING ROW AND COLUMN TITLES

  • Freezing row and column titles

EXCEL 2007 – FORMULAS

  • Creating formulas
  • Easy way to create formulas
  • Copying formulas
  • Operators
  • Formula error messages

EXCEL 2007 – CELL REFERENCING

  • Relative cell referencing within in formulas
  • Absolute cell referencing within formulas

EXCEL 2007 – FUNCTIONS

  • What is a function?
  • Common functions
  • Sum function
  • Average function
  • Max function
  • Min function
  • Count function
  • What are ‘IF functions’?
  • Using the IF function

EXCEL 2007 – USING CHARTS

  • Inserting a column chart
  • Inserting a line chart
  • Inserting a bar chart
  • Inserting a pie chart
  • Resizing a chart
  • Deleting a chart
  • Chart title or labels
  • Chart background colour
  • Changing a column, bar, line or pie slice colours
  • Changing the chart type
  • Modifying Charts using the Layout tab
  • Copying and moving charts within a worksheet
  • Copying and moving charts between worksheets
  • Copying and moving charts between workbooks

CUSTOMIZING EXCEL 2007

  • Modifying basic options
  • Minimising the Ribbon
  • AutoCorrect options

EXCEL 2007 – WORKSHEET SETUP

  • Worksheet margins
  • Worksheet orientation
  • Worksheet page size
  • Headers and Footers
  • Header and footer fields
  • Scaling your worksheet to fit a page(s)

EXCEL 2007 – PREPARING TO PRINT A WORKSHEET

  • Visually check your calculations
  • Gridline display when printing
  • Printing titles on every page when printing
  • Printing the Excel row and column headings
  • Spell checking
  • Previewing a worksheet
  • Comparing Workbooks side by side
  • Zooming the view
  • Printing options

 

Excel 2007 Foundation Courseware Materials
4 (80%) 1 vote