Introduction to Engineering and Technology

Excel 2007 Tutorials Tutorial -2

1. Go to the following Florida Coast University website:

http://www.fgcu.edu/support/office2007/Excel/index.asp

 2. Complete the tutorials in the following order:	

1. Getting Started

    * Spreadsheets
    * Microsoft Office Button
    * Ribbon
    * Quick Access Toolbar
    * Mini Toolbar

2. Working with a Workbook

    * Create a Workbook
    * Save a Workbook
    * Open a Workbook
    * Entering Data

3. Manipulating Data

    * Select Data
    * Copy and Paste
    * Cut and Paste
    * Undo and Redo
    * Auto Fill

4. Modifying a Worksheet

    * Insert Cells, Rows and Columns
    * Delete Cells, Rows and Columns
    * Find and Replace
    * Go To Commant
    * Spell Check

5. Performing Calculations

    * Excel Formulas
    * Calculate with Functions
    * Function Library
    * Relative, Absolute, & Mixed Functions
    * Linking Worksheets


6. Graphics

    * Adding a Picture
    * Adding Clip Art
    * Editing Pictures and Clip Art
    * Adding Shapes
    * Adding SmartArt

7. Charts

    * Create a Chart
    * Modify a Chart
    * Chart Tools
    * Copy a Chart to Word

8. Formatting a Worksheet

    * Convert Text to Columns
    * Modify Fonts
    * Format Cells Dialog Box
    * Add Borders and Colors to Cells
    * Change Column Width and Row Height
    * Hide or Unhide Rows and Columns
    * Merge Cells
    * Align Cell Contents

10. Developing a Workbook

    * Format Worksheet Tabs
    * Reposition Worksheets in a Workbook
    * Insert and Delete Worksheets
    * Copy and Paste Worksheets

11. Page Properties and Printing

    * Set Print Titles
    * Create a Header and a Footer
    * Set Page Margins
    * Change Page Orientation
    * Set Page Breaks
    * Print a Range

12. Customize the Layout

    * Split a Worksheet
    * Freeze and Unfreeze Rows & Columns
    * Hide and Unhide Worksheets

13. Sort and Filter

    * Basic Sorts
    * Custom Sorts
    * Filter

14. Macros

    * Recording a Marco
    * Running a Macro

 	

15. Customize Excel

    * Popular
    * Formulas
    * Proofing
    * Save
    * Advanced
    * Customize