Last week I went over some useful Excel functions in the first of two parts about analysis in Excel. For part two I thought I’d go over some other tools available within Excel, including some examples of how to use them.

Last week I promised to post the first of two parts on using Excel for analysis. With the first post, I thought I’d list some useful functions in Excel, and provide some examples on how to use them. Please note that this list isn’t comprehensive - there are numerous other functions that can and should be learned to complement what is included here.

This week I thought I’d discuss using Excel for analysis. I also wanted to mention something I recently heard at work.