Free Microsoft Office Training and Tutorial Resources




    



June 16, 2006

Microsoft Excel Tutorial

Excel allows you to create spreadsheets much like paper ledgers that can perform automatic calculations. Each Excel file is a workbook that can hold many worksheets. The worksheet is a grid of columns (designated by letters) and rows (designated by numbers). The letters and numbers of the columns and rows (called labels) are displayed in gray buttons across the top and left side of the worksheet. The intersection of a column and a row is called a cell. Each cell on the spreadsheet has a cell address that is the column letter and the row number. Cells can contain either text, numbers, or mathematical formulas.

This tutorial hosted by Bradley University teaches many features you will need to understand and know how to use if you are planning to use Excel in your work or at home. Included are some advanced functions, such as recording and running macros, graphics, charting, and mail merge.

Microsoft Excel Tutorial

 Basics
   Screen Elements
  Adding and Renaming
  Standard Toolbar

Customizing
  Menus
  Toolbars
  Recording Macros
  Running Macros 

Modifying a Worksheet
 Moving Through Cells
  Adding Rows and     Columns
  Resizing
  Selecting Cells
  Moving and Copying
  Freeze Panes

Formulas and Functions
  Formulas
  Linking Worksheets
  Releative, Absolute and Mixed Referencing
  Basic Functions
  Autosum

Sorting and Filling
  Ascending
  Complex Sorts
  Autofill
  Alternating TExt and Numbers with Autofill
  Autofill Functions

Charts

Page Properties

Keyboard Shortcuts

Download Examples

Formula Exercises

Charting Exercises

Mail Merge Exercises

Popularity: 2% [?]




Related Posts:
  • 15 Microsoft Excel Lessons with Exercises
  • Microsoft Excel Workshop Training Handouts
  • Free Microsoft Excel Video Training
  • Sofware Help Guides for Word, Excel, and PowerPoint
  • Free Microsoft Excel Ebook

  • Tags for this post>>

    No Comments »

    No comments yet.

    RSS feed for comments on this post.

    Leave a comment

    You must be logged in to post a comment.