So this past Friday, I had the opportunity to go and shoot a couple of Excel webcasts that I'm doing for the Certified General Accountants. This was a pretty interesting experience, as I'm very used to doing live presentations, but
I recently migrated to the 64bit edition of Microsoft Office 2010. My main reason for doing this was that I wanted to make use of the RAM in my machine with PowerPivot, but it certainly didn't come without a bit
The other day I was working on a financial model. During a break I saw on Twitter that @JesseH77 posted the following: My budget files have 180,850 and 160,191 formulas and 11 lines of code to count the formulas. This
Since I know I have a few charting guys that follow this, I figured that I'd ask this question here. Hopefully the response will help someone! I'm creating a food & beverage function evaluation form, and threw a chart on
I came across this a while ago in a weather app on my iPhone, and thought it was interesting. Then there was a conversation on Twitter in which I brought it up as well. I'm not a huge fan of
Clark asks: I am trying to copy two different operations into a "This workbook". One is the "disable cut copy paste" function that I found and the other is the "force user to enable macros" so that the disable cut
Last week I was working through creating some more DAX measures. And while I was successful, I still don't feel that I've really truly wrapped my head around how they work. (I notice that Dick Moffat feels similarly, too.) The
Over the last couple of days I've been trying to build some stuff with PowerPivot and I've come up with some other things that I would find pretty helpful. Here's one of them. One of the big challenges I found
After all my evangelizing (or complaining if you like), I think it's important to acknowledge when someone does/announces something that addresses my concerns. Post titles are the first things that come up in search engines. So if someone is searching
Yesterday Rob Collie made a post on his blog about sizing considerations for PowerPivot implementations on Sharepoint. The main thrust of the post was directed at end users and making sure that their server farms have adequate resources to efficiently
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
