Excel Tips & Tricks ITT

Discussion in 'Totally Off-Topic' started by Fingolfin, Oct 27, 2014.

Help Support TalkBeer Community by donating:

  1. Fingolfin

    Fingolfin

    Joined:
    Apr 10, 2013
    Likes Received:
    97,744
    Location:
    Squat Rack
    Use this space to discuss your love/hate relationship with all things MS Excel.

    Ask fellow TBers for advice on using different functions/formulas, spice up your reports or whatever else you need.

    Respect beer.
     
  2. MordorMongo

    MordorMongo

    Joined:
    Apr 10, 2013
    Likes Received:
    187,394
  3. quirkzoo

    quirkzoo

    Joined:
    Apr 10, 2013
    Likes Received:
    33,838
    Location:
    The Misty Mountains
    I personally got nothin' but these two dudes know how to manipulate a cell.

    cc: Rempo, trxxpaxxs
     
  4. pjs234

    pjs234

    Joined:
    Oct 6, 2013
    Likes Received:
    16,175
    Location:
    The land of steady habits
    why did I just watch this thread.....
     
  5. MordorMongo

    MordorMongo

    Joined:
    Apr 10, 2013
    Likes Received:
    187,394
    [​IMG]

    ??
     
    jivex5k, Fingolfin, mcaulifww and 2 others like this.
  6. MarkIntihar

    MarkIntihar Moderator Staff Member

    Joined:
    Apr 5, 2013
    Likes Received:
    55,254
    Location:
    San Jose, CA
    I've been looking for new ideas on how to spice up my reports lately. My manager tells me that my reports are fine and that he really enjoys reading them, but I'm just not feeling it from him. At the end of the day he's not lusting for more, he just closes down his laptop and packs up to head home. I've thought about introducing some "Choose Your Own Adventure" type reports, where he can set the theme of the report and target the specific areas of the report that he wants to focus on. I've even tried staying late after work to show him that I'm putting in the extra effort, and he says he's noticed but I still don't feel like I'm special to him. If anyone has any ideas that might help me stand out a bit more to him, please send me a PM so that we don't clutter up the board with smut. TY.
     
  7. trxxpaxxs

    trxxpaxxs

    Joined:
    Apr 5, 2013
    Likes Received:
    2,551
    Location:
    Buffalo, New York
    Conditional formatting for days! Can't wait for this convo to heat up!




    Srs.
     
    daniel, ilovestouts, Rempo and 4 others like this.
  8. RedCoffee

    RedCoffee

    Joined:
    Dec 21, 2013
    Likes Received:
    68,397
    Location:
    FIB
    VLOOKUP is god
     
  9. Fingolfin

    Fingolfin

    Joined:
    Apr 10, 2013
    Likes Received:
    97,744
    Location:
    Squat Rack
    This is why I love you.
    What types of reports do you produce? The automated KPI indicators are quite useful and look excellent.
     
    Stubs, quirkzoo, mcaulifww and 3 others like this.
  10. lurchingbeast

    lurchingbeast

    Joined:
    Apr 11, 2013
    Likes Received:
    303,195
    Two words, man thong.

    Or this:
    [​IMG]
     
    Rau71, kirbmeist, Pneill316 and 35 others like this.
  11. Fingolfin

    Fingolfin

    Joined:
    Apr 10, 2013
    Likes Received:
    97,744
    Location:
    Squat Rack
    You really should drop the headers and gridlines. Much more life-like!
     
  12. trickytunadicky

    trickytunadicky

    Joined:
    Jan 30, 2014
    Likes Received:
    87,078
    Location:
    Chicagoish
    I hope to god I am not the most experienced Excel person here.
     
    Beerontwowheels likes this.
  13. Fingolfin

    Fingolfin

    Joined:
    Apr 10, 2013
    Likes Received:
    97,744
    Location:
    Squat Rack
    I've found that most people can teach me something new in Excel. It all depends on the type of work you do. For example, I have a coworker who has been teaching me new macro techniques. I am certainly more "experienced" than she is. But I spend more time querying our EDW directly and merging data sources and interpreting for report consumers while she is a pro gamer at making slick reports for our leadership.

    Tldr, I'm sure you'll learn something if you want to.
     
    Stubs and mcaulifww like this.
  14. trickytunadicky

    trickytunadicky

    Joined:
    Jan 30, 2014
    Likes Received:
    87,078
    Location:
    Chicagoish
    Anyone have intimate knowledge with conversion to Excel 2010 from older versions? That is the current bane of my existence as my office upgrades from 2003.
    EDIT: Access, too, but I will save that for the Access tips and tricks forum.
     
    trxxpaxxs, Stubs, mcaulifww and 2 others like this.
  15. RedCoffee

    RedCoffee

    Joined:
    Dec 21, 2013
    Likes Received:
    68,397
    Location:
    FIB
    CTRL + A
    CTRL + C
    CTRL + V

    *shruggy guy ascii*

    I actually just save as the most recent file type. But obviously that's not it?
     
    Fingolfin, trxxpaxxs and mcaulifww like this.
  16. Fingolfin

    Fingolfin

    Joined:
    Apr 10, 2013
    Likes Received:
    97,744
    Location:
    Squat Rack
    I don't recall having any issues when we upgraded. Running 2010 now...
     
  17. mcaulifww

    mcaulifww

    Joined:
    Apr 5, 2013
    Likes Received:
    6,324
    Location:
    Pen Island
    Lysmmi
     
    Fingolfin likes this.
  18. mcaulifww

    mcaulifww

    Joined:
    Apr 5, 2013
    Likes Received:
    6,324
    Location:
    Pen Island
    Auto KPIs?? Where is dis? My excel use has decreased in favor of SharePoint but I love a good spreadsheet
     
    ilovestouts and Fingolfin like this.
  19. tehzachatak

    tehzachatak

    Joined:
    Jul 24, 2013
    Likes Received:
    38,126
    Location:
    TalkBeer.com
    Index match or GTFO

    I am a huge fucking Excel nerd and use Excel like four hours a day. HIT ME UP BOYS
     
  20. mcaulifww

    mcaulifww

    Joined:
    Apr 5, 2013
    Likes Received:
    6,324
    Location:
    Pen Island
    We're updating from 2007 to 2013. People still have 2003 at my office. Cray cray
     
    Fingolfin, trxxpaxxs and MarkIntihar like this.