Well folks, it’s officially the year 2012. And even though the Mayans have put a stigma on 2012 with all their “end of the world” mumbo jumbo, I’m very excited about the...

continue reading...

In my life-changing post, Running a SQL-Stored Procedure from Excel, I showed you how to make Excel interact with a SQL server Stored Procedure. . Since that post, I've had several requests to cover...

continue reading...

On this Friday, I'd like to share another life lesson from The Oatmeal: . No related posts. No related posts.

continue reading...

Over the Thanksgiving holiday, I was ignoring the family and puttering around on the internet. There, I found a list of all the cool API calls you can do through VBA. An API call is essentially a...

continue reading...

Over the Thanksgiving holiday, I was ignoring the family and puttering around on the internet. There, I found a list of all the cool API calls you can do through VBA. An API call is essentially a...

continue reading...

Happy Thanksgiving to all you Excel Nerds out there. I hope you all enjoy your time with family and friends. . I'll return next week with more stuff. No related posts. No related posts.

continue reading...

Can we all admit that Takes Your Kids to Work Day is a joke? Who is getting any serious work done with little a-holes hanging around? . On my last "take your kids to work day", my kids asked if they...

continue reading...

Last week, Debra over at Contextures posted an article that showed us lots of nifty ways to navigate a workbook that has many worksheets. Today, I'd like to add my two cents by sharing a small macro...

continue reading...

Here's an easy tip from Excel MVP Bob Umlas “ author of the new book, Excel Outside the Box. . Let's say you want to fill in some rows with the 1st and the 15th of every month. So you enter something...

continue reading...

Last week, I was working with some data when I encountered the need to merge two staggered columns. That is to say, I needed to merge two columns where the data was blank in either one column or the...

continue reading...

In an Email last week, Christina asks: “Do you know of an easy way to show Access query results in thousands? Thanks DataPig.You are the like that black bird on Angry Birds “ the bomb.”...

continue reading...

It’s October 17th, which means it’s Spreadsheet Day! Today is the day we all celebrate Excel and take a moment to think about how Excel has made our lives better. . Spreadsheets are used...

continue reading...

One of my 12 fans (Lester) emailed to remind me that I have a blog. I almost forgot. So with a good kick in the pants, I'm back to blogging. . While I was away, Microsoft awarded me with the coveted...

continue reading...

I'm back from the Power Analyst Bootcamp in Washington DC - and of course, it was a success. 37 of the finest analysts attended the 2-day event, where we shared our passion for Excel, deli meats, and...

continue reading...