Sunday, Feb 7th in a Local B&N: That Silver/Grey Spined Book is Ours! OK, for real, B&N has them now! (I have seen them myself, as pictured above, and every B&N I’ve called has them). Remember, they accepted our challenge…
The Second Time I’ve Used This “Egg on My Face” Picture
OK, on Tuesday I published a technique that I’ve been using for years now – a way to get a list of all measure formulas as text. And it took about five minutes for people to respond and tell me about all the better ways to do it.
I’d like to say that none of those ways were better than mine. But ALL of them were better
***UPDATE: Window Extended!
I think I can leave the “get your name in the book” offer open until the weekend. See this post.
You may have noticed a certain absence over the past couple weeks. David Churchward has been on quite a run of guest posts, and that is no accident. He’s been keeping things afloat here for me, as a HUGE favor, while I finish the book.
It was time
Yes, the book. One that captures the essential lessons that I’ve informally recorded and scattered on the blog over the years in random order. One that sequences all of those lessons properly, explains them more fully than the blog, and forces me to not cut corners. One that captures the way I teach when I train people onsite. Ideally, one that helps the Excel Pro in particular make the transition from Excel Pro to All-Out Data Monster.
I’ve been thinking about this forever. Hey, it’s always sounded like a great idea. But it’s one thing to think about it and another to actually do it. I actually started over New Year’s this past January, but then shelved it as things got hectic at work. Well… August rolled around, things were STILL hectic at work, and then I noticed THIS on Amazon… “rut roh Shaggy.”
WAIT! If you want to pre-order, do it Wednesday, and I’ll put your name in the book
(See below for details)
At the beginning of August, the release date was listed as September 1st. It was quite the wakeup call .
Plus, this is being published by Bill Jelen’s Holy Macro Press. It’s a Mr. Excel title! Bill has been fantastically helpful to me in this whole process, dating back to last calendar year. Thou shalt not let down Mr. Excel! So again, yeah, it was time.
I’ve been heads-down ever since, and the process is now happily in its final phases. The book will be released Nov 10.
150 Pages? Bah.
Yeah it’s listed at 150. That was the estimate that I submitted nearly a year ago. Then I dug in and quickly started realizing that I needed to exceed it.
I was recently sent a link to the best-selling books on Amazon, in the “Microsoft Spreadsheet” category. Check it out: The Top Two Best-Selling Excel Books Are Both PowerPivot Books!(Click to Visit the Page on Amazon) This Surprises Even Me…
VLOOKUP Week – Brought to You by Mr. Excel(Click Image for the Official Site of VLOOKUP Week) What is the “Scariest” Feature in Excel? A couple of years ago at lunch, Bill remarked to me that VLOOKUP was the…
Well the wait is over. It is now released, for real. No longer a beta or RC. The real deal. Download it here. Other important links: My first glimpse at new features here. Important warnings about compatibility with V1.
“IT’S ALIVE!!!!” (Just your average Excel Pro after converting his first PowerPivot Workbook into a Web App) I’ve got another article about to go live on CIMA Insight, but I’m gonna jump the gun a bit and post basically the…
OK, let’s say you already installed v2, whether inadvertently or… advertently. And now you need to downgrade to v1, so that your workbooks function on your server, or can be opened by other people running v1 on their desktops. So……
My former colleagues at Microsoft have responded to the issue I raised last week and have updated the PowerPivot.com download page to include links to both the “beta” of v2 as well as the latest, trusted version of v1. Still…
“Danger, Will Robinson!” I’m seeing this pop up a lot now, both in our hosting business and on forums. If you have gone to PowerPivot.com lately and downloaded PowerPivot, you downloaded a beta (a release candidate) of PowerPivot v2,…