On this blog, Saturday is Bacon recipe day. So no Excel tips and tricks today. Today we learn about bacon.   Today's recipe (Bacon and cheese Quesadilla) is honor of Cinco de September. This was...

continue reading...

We interrupt today's blog post to bring you this announcement. Yesterday, John Walkenbach announced that this will be his last month as a Microsoft Excel MVP. If you don't know who John Walkenbach...

continue reading...

One of the more common questions I get revolves around running an Excel macro from Access. That is, how do you fire an existing Excel macro from Access. I'll share the code to do that in a moment. I...

continue reading...

On this blog, Saturday is Bacon recipe day. So no Excel tips and tricks today. Today we learn about bacon.   It's morning here in Dallas and I'm thinking about making some Bacon Oatmeal. This is sure...

continue reading...

Here's a tip for all you cool dudes who like to wear your security badges on your belt. Take your badge off your belt before you have a go at the toilet.  Everyone can see exactly who's releasing the...

continue reading...

I was reviewing someone's workbook the other day way I saw some code similar to this: Sheets("Sheet1").Unprotect Password:="MeatFace" PROCEDURE Sheets("Sheet1).Protect Password:=" MeatFace " This...

continue reading...

Sandra asks: "Any way to add a rank to a pivot table"? DataPig Answers: In Excel 2010, it's really easy. In Excel 2007/2003, it's a bit clunky.   Adding Rank in Excel 2003/2007 Step 1: Sort your...

continue reading...

On this blog, Saturday is Bacon recipe day. So no Excel tips and tricks today. No, today we learn about bacon.   Today's recipe is Bacon Wrapped Fried Macaroni and Cheese – a.k.a "the beautiful gut...

continue reading...

Every now and then, one of my 12 fans asks me about the Saturday Bacon Recipes I used to post here.  You may have noticed I've stopped posting them.  Why?  Mostly because of the book schedules I was...

continue reading...

Wendy writes to ask: "In Excel, I can use the PROPER function to change my text to proper case. Why is there is no PROPER function in Access? " Wendy has stumbled on one of the mysteries of life -...

continue reading...

When I started this blog over a year ago, I knew that 'Spam Comments' would be an issue. These are comments inserted into posts by web crawlers - typically containing links to sites trying to sell...

continue reading...

So I decided to record a macro, and for some reason, I forgot to hit Stop Recording. By the time I realized I was still recording, I had created a macro that represented a half a day's work. Don't...

continue reading...

I always put on a couple of Live training events after the long hot summer.  This year, we'll do a couple post-summer events.  First, Xcelsius – we had such an overwhelming turnout and requests...

continue reading...

So summer is for practically over and I'm back to blogging topics that can actually help people. For my first post back, I'll come out big with one of the best pieces of code I've ever written.   A...

continue reading...

This is the last interview of my summer series, the 'Road of the Excel Bastards'. This series was my take on a series called Road of the Excel Masters started a long time ago by Excel MVP, Colo. In...

continue reading...

This is the last week of my summer series, the 'Road of the Excel Bastards'. This series was my take on a series called Road of the Excel Masters started a long time ago by Excel MVP, Colo. In his...

continue reading...

It's summer time and blog readership will be down. So I'm saving my good Excel and Access tricks for later. Right now, I'm continuing my 'Road of the Excel Bastards' series. Today's Excel Bastard is...

continue reading...

It's summer time and blog readership will be down. So I'm saving my good Excel and Access tricks for later. Right now, I'm continuing my 'Road of the Excel Bastards' series. Today's Excel Bastard is...

continue reading...

It's summer time and blog readership will be down. So I'm saving my good Excel and Access tricks for later. Right now, I m continuing a series called 'Road of the Excel Bastards'. This is my take on...

continue reading...

I've been away on business but I'm back this week. This week, we will have in depth interviews with: Debra Dalgeish (Contextures) Chandoo (Pointy Haired Dilbert) Ross Mclean (Methods in Excel) Bill...

continue reading...