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 laugh…you've done this too.
If you're not certain if you're in Macro Record mode or not, you can simply look at the bottom left corner of your screen.
» Read more: Handy Macro and Career Tip
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 for another Xcelsius training event this year, we decided to put on another one.
The second is my acclaimed Excel Power Analyst Boot Camp. Do you know someone who is struggling and needs to get up to speed quickly with advanced Excel analysis and reporting? Well, this is definately the course for them.
I hope you can all make it to one of these events.
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 few weeks ago Dick Kusleika posted a small but brilliant piece of code that auto formats the active pivot data field to a number format without having to muddle through the formatting dialog boxes. I loved it and used it for a while. Then I thought:
» Read more: Auto Format PivotTables to Match Source Data
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 his series, he would interview Excel gurus, asking them Excel related questions. In my version, I ask questions that have nothing to do with Excel.
Today's Excel Bastard is Mike Alexander!
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 series, he would interview Excel gurus, asking them Excel related questions. In my version, I ask questions that have nothing to do with Excel.
Today's Excel Bastard is Bill Jelen!
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 Ross Mclean!
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 Chandoo!
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 a series called Road of the Excel Masters started a long time ago by Excel MVP, Colo. In his series, he would interview Excel gurus, asking them Excel related questions.
In my version, I'm asking questions that have nothing to do with Excel. Let's get to know our Excel gurus through the prism of 10 stupid questions.
Today's Excel Bastard is Debra Dalgleish!
I've been away on business but I'm back this week.
This week, we will have in depth interviews with:
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. In this series, we are getting to know our favorite Excel gurus through the prism of 10 idiotic questions.
Today's Excel Bastard is Dick Kusleika!
