Canadian MVP Day 2014
Last Friday, I was invited to attend the MVP Open Day at the Microsoft Canada headquarters. We had a full day of meetings, and I presented a couple of sessions about Excel.
That lovely pink pen was made for me by Anthony LoBello, as a thanks for some Excel help. It’s a good idea to bring a distinctive pen to meetings, so nobody tries to wander off with it.
In the Meeting Room
We had to sign a non-disclosure agreement to attend the meeting, but there was a leak at our table, as you can see below.
There were about 100 MVPs in attendance, based on my highly scientific rough estimate, and a few more people who joined the meeting online.
We all got a MVP Canada sweatshirt, and everyone got the same number – 14. That should confuse our opponents, if we play in the big game!
There were 4 Excel MVPs there, and it was great to see everyone. He here is a picture of me, with Eduardo Pineiro.
My Excel Presentations
I did presentations on “Excel 2013 Tips”, and “Excel Tables and Pivot Tables”.
One of the Excel tips that I shared was showing a total for the visible rows only – using the SUBTOTAL function. Most people didn’t realize that if you filter the list first, then click the AutoSum button, a SUBTOTAL function is inserted, instead of a SUM function.
Do you ever use that trick? There are more SUM and SUBTOTAL tips on my website: Sum Cells in Excel