MS Tips and Tricks | Microsoft Excel 2007 | Working with Formulas {Tutorial for beginners}

Affiliates

Amazon.com

Popular Microsoft Excel Books

Excel 2003 Bible

Author: John Walkenbach

Excel 2003 for Dummies

Author: Greg, PhD Harvey

Microsoft Office Excel 2003 Step by Step

Author: Curtis Frye

Excel VBA Programming For Dummies

Author: John Walkenbach

Excel 2003 Personal Trainer

Author: Inc

Microsoft Office Excel 2003 Inside Out

Author: Craig Stinson

Excel 2003 All-in-One Desk Reference for Dummies

Author: Greg Harvey

Popular MS Excel Related Websites

Microsoft Excel 2007 Tutorial for beginners

Welcome to MS Tips and Tricks

Welcome to MS Tips and Tricks - You are at the right place if you need tutorials for beginners - Online Microsoft Excel tutorials for beginners, covering the following categories - Advanced Formulas, Pivot data, Charts, Databases, Customization, Table, Forms, etc.,

Microsoft Excel Tips and Tricks for beginners

7) To sum cells range, yo need to select the target cell and press the sum button.

Illustration 4: The auto sum button.

Illustration 5: The auto sum operator takes the nearest numeric cell range.

8) To copy a formula cell Drag the black cross from the cell that contains the formula until the cell where you wish to copy it and it and release the mouse button.

Working with cell's references

9) The cell's references can indicate independent cells or ranks of cells in columns and rows.

Cell's reference

Refers to

A10	Cell in column A and row 10

A10;A20

Cell A10 and cell A20

A10:A20

Cell's range from cells in column A from row 10 to 20

B15:E15

Cell's range from cells in row 15 from columns B to E

A10:E20

Cell's range from column A row 10 to column E row 20



Illustration 6: Range A10:A20.


Illustration 7: Range A10;A20.


Illustration 8: Range B15:E15.

Advertisement

Your Ad Here

Copyright © MS Tips and Tricks
A Division of Gurijala and Company, 2006
Home - Tips and Tricks - Resources - Links - Contact - Site Map - Privacy Policy - Email Webmaster