Category: Excel tips

Today is the 30th anniversary of the first release of Microsoft Excel. To celebrate this auspicious occasion, I invited you to share your memories of getting started with Excel, and thank you for your contributions!

In 2005 there was a 20th anniversary celebration, and I wasn’t invited to the party, but I was at Microsoft that day. There was a party that night at Seattle’s Experience Music Project, and we formed a band – Excelerongs – for a special one-night appearance. That’s Dick Kusleika at the left, and I’m 3rd from the right.

So take time to celebrate today, and form your own band to sing the praises of Excel.

Continue reading “Happy 30th Anniversary Excel!”

In this week’s roundup, Excel history, Office 2016 reviews, add-ins to reduce Excel errors, and much more.

Continue reading “Excel Roundup 20150928”

Next Wednesday is the 30th anniversary of Excel’s first release, and I’d love to hear your Excel memories, and share them here next week. The more the merrier, so please take a few minutes to jot down a few memories.

Here are some questions, to help you get started:

Continue reading “When Did You Start Using Excel?”

In this week’s roundup, avoid nested IF formulas, understand circular references, see bad charts, and much more.

Continue reading “Excel Roundup 20150921”

In this week’s roundup, create a seating plan, do case sensitive lookups, learn Excel from Joel Spolsky, and more.

Continue reading “Excel Roundup 20150914”

In this week’s roundup, see the results from the last roundup’s pivot table survey, build a better dashboard, see some new chart types, and much more.

We’re almost at the end of our summer schedule now, and the next roundup will be published on Monday, Sept 14th.

Continue reading “Excel Roundup 20150831”

It can be a real pain to find a specific sheet, if an Excel file has lots of worksheets. If I’m making a big file for a client, I’ll often colour groups of sheet tabs, to they’re easier to find. Then, if you want the admin lists sheets, look for the red group.

Continue reading “Excel Worksheet Navigation Tips”

In this week’s roundup, see the results from last week’s Excel survey, find a seat for everyone, compare Excel and Power BI, and more.

We’re on our summer schedule now, so the next roundup will be published on Monday, August 17rd.

Continue reading “Excel Roundup 20150803”