English Español Português Italiano
Tutorials Guide Help
Sitemap Adobe Autodesk Microsoft Corel Sony GNU Others

Microsoft Excel Tutorial - Quick Reference Manual


 









Microsoft Excel Tutorial - Quick Reference Manual

Microsoft Excel Tutorial - Quick Reference Manual FREE DOWNLOAD THIS TUTORIAL
Tutorial in pdf format so you can save it to your PC, e-book reader or print.


Sponsored link



Note: The tutorial you are about to download is compressed format. Rar, if you do not have a decompressor rar files you can download 7-zip and you can display the Foxit PDF Reader.



Index Microsoft Excel Tutorial - Quick Reference Manual


Microsoft Excel
A Quick Reference Manual
Excel is one of the components of Microsoft Office
It is a software program that allows users to enter and manipulate data
Data can be sorted, graphed, and merged on labels and letters when entered into Excel
Opening Excel
Microsoft Excel Icon
Parts of An Excel Spreadsheet
Cells
Rectangular area where data is entered
Row
Horizontal portion of the spreadsheet; labeled with numbers
Columns
Vertical portion of the spreadsheet; labeled with Letters
Sheets
An individual spreadsheet when into an excel document
Enter Data
Locate the cell
Type data
Change Text
Text Color
Font Style & Type
Cell Background
Orienting Text/Changing Alignment
Centering Text over Multiple Cells
Formatting Data
Wrap Text
Format --> Cell --> Alignment Tab --> Wrap Text
Changing Column Width
Click and Drag Method
Menu Method
Format --> Columns --> Width
Changing Row Height
Click and Drag Method
Menu Method
Format --> Rows --> Height
Adding Rows and Columns
Insert --> Columns
New column is added to the left of the column that was highlighted
Insert --> Row
New row is added above the row that was highlighted
Highlighting Multiple Cells
Click and Drag Method
Keyboard method
Merge Cells
Format --> Cells --> Alignment --> Merge Cells
Sorting Data
Select cells
Data --> Sort
Select method to be sorted by
Naming a Spreadsheet
Enter a Formula
Type
Type formula using Cell References
Example
Calculating a Group of Numbers Quickly
Math Operation Meaning
SUM Adds numbers
AVERAGE Takes the average of numbers
COUNT Total number of Entries with numbers
COUNTA Number of Non-blank cells with data
COUNTBLANK Total number of empty entries
MAX Indicated the largest number in a series of numbers
MIN Indicated the smallest number in a series of numbers
Fill A Column/Row with Data/Formula
Borders or Grid Lines
Show Gridlines
File --> Page Setup --> Sheet tab
Borders
Format --> Cells --> Borders
Duplicate Row Headings on all Pages
File --> Page Setup --> Sheet
Saving a Spreadsheet
First time or under another name
After Corrections are Made
File --> Save
Printing a Spreadsheet
File --> Print
Creating A Chart or Graph
Resources
Excel Classroom Activities Tutorials
Microsoft Excel Template Home Page
Excel Timelines
Excel Tutorials and Activities







Download the file decompressor 7-zip.
Download the PDF reader Foxit PDF Reader.




TutorialsPDF.com © 2008 - This work is licensed under a Creative Commons License.