Excel Trick

25 Responses to “Excel Trick”

1. MacroGeek1 on: 2 March 2010 at 11:54 pm

   Neat trick; lots of potential for quick at-a-glance analysis.
2. LegionaerGutzufus on: 3 March 2010 at 12:49 am

   boa, des is ja geil. des könnat ma sich vielleicht amal merken, des schaut recht nützlich aus.
   dankeschön für den coolen tipp.^^
3. flixmsncom on: 3 March 2010 at 1:44 am

   Seems like Adam is getting fired
4. kleindamv on: 3 March 2010 at 1:56 am

   cool
5. kongo30 on: 3 March 2010 at 2:35 am

   what is one has excel in say, norwegian?
   i tried it since repetere(Nor) =repeat (Eng), only to get an error msg.
6. pc4n62004 on: 3 March 2010 at 2:44 am

   Very cool. Nice trick when you don’t want to create an actual chart. Love it!
7. jake619 on: 3 March 2010 at 3:25 am

   yes it does, just tried it.
8. welcome499 on: 3 March 2010 at 4:12 am

   u called that a tric????? haha y don’t u just create a bar graph instead of ur iiiiiiiiiiiiiiiiiiiiiiiiiii
9. etramway on: 3 March 2010 at 4:54 am

   Outstanding! I love to learn little tricks like this. Sorting high to low (or low to high) would provide a simple sideways distribution.

   Who needs SPSS when you have Silverado31!
10. TheBatanoni on: 3 March 2010 at 5:29 am

    wow wow wow
    i love excel
11. blueboxer17 on: 3 March 2010 at 5:46 am

    Very cool.
12. rashidguled on: 3 March 2010 at 5:48 am

    Really cool cool excel trick
13. pc4n62004 on: 3 March 2010 at 6:05 am

    Very cool!! Dies this work with 2007 too? Thanks.
14. ahoefer3rd on: 3 March 2010 at 6:29 am

    To brainstorm a bit – this model shows all the attributes so that you can drill down immediately – if you have a graph, you have to find the ’10′ ten and then look at the data to find Adam – it’s all in one place this way – consider adding additional attributes (columns) and sorting to see patterns – add conditional formatting – change format of bars to center to see what the data shows – add a second set of bars for other data and compare them – add filtering, etc.
15. Noir187 on: 3 March 2010 at 6:34 am

    I have to admit that is pretty neat
16. amoignis1987 on: 3 March 2010 at 7:28 am

    Interesting, I suppose, but a bar-graph works just as well.
17. Martin060189 on: 3 March 2010 at 7:37 am

    Nice trick, thanks!

    ****
18. princevisram on: 3 March 2010 at 7:49 am

    To mrjayraj: Kyun hay yeh chodu video?!

    Thanks a buch. Really beat trick!!
19. CADwannabe on: 3 March 2010 at 8:29 am

    Thanks a bunch! Love it!
20. mrjayraj on: 3 March 2010 at 8:33 am

    ek dum chodu video…….
21. DeniskaFromRussia on: 3 March 2010 at 8:37 am

    use charts instead… good to know anyway
22. sGnAimless on: 3 March 2010 at 8:54 am

    epic
23. marcusdawg3 on: 3 March 2010 at 9:46 am

    neat!
24. TheToeProject on: 3 March 2010 at 9:50 am

    Sweet!
25. TIBO9797 on: 3 March 2010 at 10:36 am

    Thanks!