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.