MS Tips and Tricks | Microsoft Excel 2007 | Advanced 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

20) Select the Insert Function command from the Functions library group in the Formulas Tab.

Illustration 10: Function Library.

21) Select the IF function from the function list in Logical Category. Press the Ok Button.

Illustration 11: Function categories.

22) Configure the logical test.

Is Avg Space * 1.5 < (Data + Indexes) >>> (Data + Indexes).

Else >>> Avg Space * 1.5.

Illustration 12: Logical test.

23) In the bottom left corner you will set the result. Press the OK Button.

24) Select cell K1. Write vlOOK as new column name.

25) Select cell K2.

26) Select the Insert Function command from the Functions library group in the Formulas Tab.

Illustration 13: Function Library.

27) Searches for a value in the first column of a table array and returns a value in the same row from another column in the table array.

28) Select the TRANSPOSE function from the function list in Lookup & Reference Category. Press the Ok Button.

Illustration 14: Function categories.

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