MS Tips and Tricks | Microsoft Excel 2007 | Consolidate Data {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 Access Tips and Tricks for beginners

19) Configure the filtering options.

Illustration 16: Format chart options.

20) Quit the Pivot char filter pane and see the results.

Illustration 17: Filtered Table. Click here to view larger image.

21) Change the sumarize operation to average and see the results.

Illustration 18: Change the summarize operator.

Dynamic Formulas

22) Select F17 cell.

23) Select the Logical command from the Function Library Group in the Formulas menu in the Options Tape.

Illustration 19: Change the summarize operator.

24) Create a formula to show the comparison results between space used by table A and table B.

25) Click on Logical_Test text box in the Formula editor. Then click in cell B2. Write a > sign and then click in cell B3. Click in Value_if_true text box.

Illustration 20: Create an If function.

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