Saturday, November 17, 2012

How to Analyze data quickly in Excel 2007

When I have free time, I browse for some useful information which can be shared with others, as that is the main purpose of this blog.
Just now found an interesting useful tip in MS Excel 2007.

The status bar in Excel shows handy statistics when multiple cells are selected. In Excel 2007, the status bar shows the selected cells' average, count, and sum. This is an easy way to quickly analyze data without working on formulas.
Posted by at
Labels: , ,

9 comments:

  1. UnknownNovember 17, 2012 at 11:53 AM

    Finally a good explanation how to use excell charts.
    nikola

    ReplyDelete
  2. AnonymousNovember 17, 2012 at 1:11 PM

    would like a format a cell in Microsoft Excel 2007 in hexadecimal but am not finding how to do this.

    Is there a built-in way to change the base from 10 to 16 for a cell?


    hamoraby99

    ReplyDelete
    Replies
    1. Anuradha RaghuramNovember 17, 2012 at 6:12 PM

      If you want to format a cell so that you can type in a decimal number and automatically have it displayed as a hexadecimal number, then that's not possible. You can either format the cell as text and enter hexadecimal numbers directly (but note that Excel cannot use those for calculations), or use the DEC2HEX() and HEX2DEC() functions to convert between base 10 and base 16.
      If the cell to be converted is A1 use =DEC2HEX(A1).

      Delete
  3. Dil siNovember 18, 2012 at 2:44 AM

    Thats really very helpful for me in my MBA research

    ReplyDelete
  4. joker1993November 19, 2012 at 7:59 AM

    nice post..its a big help to other...2 thumbs up

    ReplyDelete
  5. AnonymousNovember 20, 2012 at 2:24 AM

    nice policy post for MBA research

    ReplyDelete
  6. Paid from onlineFebruary 10, 2013 at 10:26 PM

    Good and useful information for us.It analyzing data on Microsoft Excel base cell .I also like it.I thing everybody like it.
    Thank you ,
    Anuradha Raghuram..
    KEEP IT upppp..

    ReplyDelete
  7. aniketMarch 25, 2014 at 1:16 AM

    thanks for sharing ur idea.

    ReplyDelete

Subscribe to: Post Comments (Atom)