Afternoon Session - Part 2

Wow...amazing. We have been doing vlookups this afternoon - thankfully I am familiar with vlookups. I have been helping a few of my colleagues (we are in the back row so we don't see the formulas very well).

Excel is even more powerful than I had originally thought - go figure - learning something new every single day!! Cleaning up date into columns using month, day, time so I can chart trends, patterns, etc. from ILLiad was also very cool to see. I'm just in amazement that there is so much more data in ILLiad than I ever thought. Of course, using filters and sorting and the usual things are always helpful but using the pivot table feature is going to make this data really sing & dance. I can't wait to get home to see if I can put some of this new found knowledge into practice! Watch out Al & Alex! LOL

Until tonight (if I decide to blog about the social time) or tomorrow after the morning sessions...from sunny (and currently warm) Virginia Beach! Out of here early - lots of information in a short period of time. Time to find the fitness equipment!!

Afternoon Session

Collette rocks (she's from Notre Dame)! She is the Excel Queen!! I've learned more about Pivot Tables & Charts in the two and a half hours here than I ever knew. I thought I knew Excel but she knows it upside down & backwards! Thanks Atlas for getting her in on this training.

I made a pivot chart that actual showed how many hours each status (faculty, staff, etc.) were using ILLiad. It was truly amazing. Look out Al & Alex - you'll be inundated with useful (I hope anyway) charts and data. I know this isn't much information but we're fixin' to start the last part of our afternoon and I don't want to miss a second.

Until later....