Tag Archives: Excel

‘You Suck at Excel’ video with Joel Spolsky

If you are a business analyst, you probably use Excel.  And if you use Excel, there is a REALLY good chance that you don’t use most of its capabilities and don’t know all of the ways to use it most efficiently.  I know that is true for me.  🙂

That’s why I want to recommend you watch this video.  It was private session done by Joel Spolsky to employees of Trello, Fog Creek Software, and Stack Exchange.  And if you weren’t aware of it already; besides founding or co-founding all three of those companies, Joel Spolsky used to be a program manager at Microsoft back in the early to mid-1990’s and he worked a lot on Excel.

He moves quick in this video, but there are a ton of good tips and tricks for using Excel the way most BA’s do.  That is, NOT for rigorous data analysis.  🙂

It’s only 54 minutes long and it might worth your time to watch.

Enjoy!

Excel Tip – Formula to Convert Name Order in Single Cells

I haven’t posted anything new to the site in a while both because I’ve been busy with other things, and because the main articles I am working on are ones that will probably take me quite a while to research and write up to my satisfaction.  I have several in the works (including a few smaller ones I can turn to if necessary) so hopefully I’ll have at least one new wiki article up in August.

But in order to make sure the site gets at least a bit of new content each month, I want to share a quick software tip in the form of a couple of Excel formula’s that I wrote.

These formulas convert single cells with names in [Last Name], [First Name] order to [First Name] [Last Name] order.  The first version leaves in middle initials and suffixes. The second version trims everything after the first name.

Continue reading