Welcome to the Excel Theatre Blog

The big excitement in Twitter this week is that AC/DC released an ASCII art video that runs within Excel. And what band could be more appropriately named for this type of work? I guess SUM 41 could do an Excel video too. Any others? Anyway, here are some of the interesting Twitters from this week,…

Yes, you can sort by colour in Excel now, but in exchange, the chart features are worse, and the macros are stupid. But life in Excel is never dull! Excel took away "I can’t sort on yellow" as a way to scold bad spreadsheet design. On the plus(?) side, I can sort by yellow cells….

If you don’t know the difference between a pivot table and an Excel table, just read the article. Don’t let your frustration lead to regrettable acts, like cheating on Excel, or insulting your co-workers. Wish I was an Excel genius. I could open a file and do some work then. I don’t know if my…

People must have worked with Excel formulas all weekend, because there were several tweets about brackets. There was probably lots of pivoting too. Oh my DAYS I am obscenely happy with this color coded production schedule I just made in #excel – it’s almost TOO sexy for safe consumption. In VBA used "Dim i,j as…

No April Fools in Excel – everyone who uses Excel is a superior person, who makes wrangling lots of data look easy! Just ignore that person curled up in the corner, gently rocking. Transcribing names from a sign-in sheet to a spreadsheet…people have unbelievably messy handwriting!! I’m at that time at work where quickbooks, peachtree,…

Alex Kerin’s sparklines don’t show up for me in TweetDeck, but you can see them in Twitter. Very interesting! 70,998 line spreadsheet. That is all. Can’t believe I just said to my boss "I’ll fiddle with it & see if i can make it any bigger"… I was talking about a spreadsheet!! Create sparklines in…