Excel Twitter 20141017

Have you committed any Excel crimes this week, or achieved a victory, even if it’s just a technical knockout?

Thanks to Bill Jelen for his contribution this week! If you see any Excel tweets that should be included next week, please let me know –  @ddalgleish on Twitter.

One of this week’s tweets is about Excel date formats, and this short video shows how to fix dates that won’t change format.

• At some point, the pivot table that I was working on achieved sentience. Time for a beer.
• I was born on 41897.1319444, if you use MS Excel serial date code. No word on the appropriate star date.
• Excel is mighty boring when your mind is in creative overdrive. Would work notice if i wrote a poem in the cells that nobody sees?
• I know I’m a dork because the thing I’m most excited for at work is making the date formats all same in excel. It’s bugged me for months.
• I’ve made 73 charts in excel in the last 2 days #youknowyoureaninternwhen
• Man, the extent to which knowing a couple-three stupid Excel tricks has saved me from having to learn how to code…
• I don’t do spreadsheets, but when I do…they are gonna be pretty #excel #color #spreadsheet #data
• Ppl who make a chart in Excel with default settings, then post a screenshot with the “Plot Area” tooltip still showing – drawn & quartered
• i’ve had so many people offer to teach me how to use excel & then I show them the functions I have to graph and they never talk to me again
• Will you send me a blank excel sheet? Yes youre an idiot lol just pull up excel. I cant do stupid today.
• Soo Boss is making suggestions on how Excel & Quickbooks can work together. Boss doesn’t know how to use either program.
• I’ve been wrestling with Excel’s dynamic range names & charts. After 12 rounds and 2 x 8 seconds for me got a technical victory, not a KO ;(
• The excel spreadsheet I just worked on for the past 2 hours just disappeared without a trace. So that’s enough work for today.
• Wrote a code tonight from scratch in Excel 2013 that was a foot long. The feeling was probably similar to that of a very, very proud parent.
• Such a computer nerd that voluntarily customizing an excel workbook excites me
• Spending the whole morning trying to fix a pivot table and then finally cracking it is the most satisfying thing! #sad #simplethings
• Getting my formula right in my pivot table generates the same reaction I used to have when scoring a goal playing sports. #AdultLifeSucksAss
• “I know how to create a pivot table, but it doesn’t mean I want to!” 😉 #SPSRed

______________________

Save