Excel 2007 Foundation Courseware

Microsoft Excel 2007 Foundation Training Materials

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

HELP WITHIN EXCEL 2007

  •     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
  •     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

MANIPULATING ROWS AND COLUMNS IN EXCEL 2007

  •     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

COPYING, MOVING AND DELETING IN EXCEL 2007

  •     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

MANIPULATING EXCEL 2007 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 color
  •     Formatting the font color

ALIGNMENT FORMATTING WITHIN EXCEL 2007

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

NUMBER FORMATTING & EXCEL 2007

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

FREEZING ROW AND COLUMN TITLES IN EXCEL 2007

  •     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

USING CHARTS WITHIN EXCEL 2007

  •     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 color
  •     Changing a column, bar, line or pie slice colors
  •     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
  •     Minimizing the Ribbon
  •     AutoCorrect options

WORKSHEET SETUP IN EXCEL 2007

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

PREPARING TO PRINT AN EXCEL 2007 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
5 (100%) 1 vote