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
Formtting
Cells
Formatting Toolbar
Format Cells Dialog
Box
Dates and Times
Styles
Style Dialog Box
Create a New Style
Format Painter
AutoFormat
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
Graphics
Charts
Page
Properties
Keyboard
Shortcuts
Download
Examples
Formula
Exercises
Charting
Exercises
Mail
Merge Exercises
Popularity: 2% [?]
Related Posts:15 Microsoft Excel Lessons with ExercisesMicrosoft Excel Workshop Training HandoutsFree Microsoft Excel Video TrainingSofware Help Guides for Word, Excel, and PowerPointFree Microsoft Excel Ebook
Tags for this post>>
Excel