Excel help

/Tag: Excel help

Microsoft Excel Tip #5

  Tip #5 An IF formula is one of the most useful terms in Excel. It’s a conditional formula that allows you to calculate one way if something is true and another if something is false. =IF(condition, [value_if_true], [value_if_false]) The condition is the value that you want to test.  The value_if_true is the value that [...]

Microsoft Excel Tip #52017-08-02T13:58:01-04:00

Microsoft Excel Tip #4

Tip #4 In order to generate a list of worksheet names: Open the workbook you would like a list of worksheet names for. Insert a new worksheet to hold the list of sheet names or navigate to the worksheet you want them to be listed on. Chose Formulas | Define Name to display the New [...]

Microsoft Excel Tip #42014-06-09T14:02:29-04:00