Microsoft Excel 2013

/Tag: Microsoft Excel 2013

Microsoft Excel Tip #6

  Microsoft Excel Tip #6 In this blog we will discuss multiplying arrays. First, set up your arrays with the data to be used. Then, you will want to select the 4x4 box (in this example) where you would want the matrix result to end up.         In the formula bar, you [...]

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

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 2013 Tip #3

  Tip #3 Welcome Back to our Excel Tips Series. This week's tip has us pretty excited over here at Complete Software! Do you need to know the number of unique item combinations in a given set of data? You’ll be happy to know that Microsoft has added distinct count of values to Pivot Tables [...]

Microsoft Excel 2013 Tip #32014-06-02T18:13:44-04:00

Microsoft Excel 2013 Tip #2

  Microsoft Excel 2013 Tip #2 Did you know that the dollar sign ($) can be used for more than just currency in Excel? When you need to use the same formula repeatedly, the dollar sign can help make your life easier. As part of a formula, the dollar sign will tell excel not to [...]

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

Microsoft Excel 2013 Tip #1

Microsoft Excel 2013 Tip #1 Are you looking for a change? Bored of the same old Excel look? Here’s a quick fix! Change the color. We only have two extra options to change to, but that is better than none. Choose File | Options to display the Excel Options dialog box. Click the General tab [...]

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