Results 1 to 10 of 10

Thread: Ms Excel 2007 Tutorial: Lesson plan

  1. #1

    Getting Started

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

    Customize Excel

    • Popular
    • Formulas
    • Proofing
    • Save
    • Advanced
    • Customize

    Working with a Workbook

    • Create a Workbook
    • Save a Workbook
    • Open a Workbook
    • Entering Data

    Manipulating Data

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

    Modifying a Worksheet

    • Insert Cells, Rows and Columns
    • Delete Cells, Rows and Columns
    • Find and Replace
    • Go To Command
    • Spell Check

    Performing Calculations

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

    Macros

    • Recording a Marco
    • Running a Macro





  2. #2
    Sort and Filter

    • Basic Sorts
    • Custom Sorts
    • Filter

    Graphics

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

    Charts

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

    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

    Developing a Workbook

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

    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

    Customize the Layout

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




  3. #3

  4. #4

  5. #5

  6. #6

  7. #7
    Thank you very much.. Really informative.

  8. #8

  9. #9
    Thanks for the effort to put this online

  10. #10
    I am looking forward to see the link for using the great tutorial. pl. help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •