May 9
A while back, one of the guys at work came to me with an Excel problem… He had a matrix of data, and wanted a formula that would, given row and column criteria, return the appropriate value:
I initially thought about combining lookups with IF statements but it got *really* messy. A little digging revealed a pretty handy solution, which I thought I’d share with you all…
Jan 26
Geekery Excel, Microsoft, MOS, work Comments Off
Today, I passed my Microsoft Excel 2003 Expert certification; part of the MOS suite of exams. And pretty chuffed I am too at getting 93.8%, too.
This is the first real step on my road to justification… I’ve been training MS products for years but have only now started to get the appropriate piece of paper that says I know what I’m talking about!
Since changing jobs a month ago, I’ve really developed a renewed enthusiasm for training again – can’t wait to get the other exams under my belt so I can legitimately be called “Microsoft Office Specialist Master Instructor”.
Twitter
Facebook
Flickr
RSS