Over the past while we've been building a Dashboard report for our golf course. It's got some historical information in it, but we've also pulled in things like weather forecasts. The intention is that our managers will be able to
In a discussion about PowerPivot yesterday, one of my friends stated that it wasn’t really useful since you couldn’t perform write-back using PowerPivot. To him this is a very important piece in the Excel budgeting process. Now, I agree that
The following article is courtesy of Yoav Ezer, who volunteered to do a guest post for me while I am at the summit. Thanks Yoav! User Defined Functions versus Formulas in Excel Which are better, Excel functions or UDFs? Use
So I've been working on a massive model over the past year, and recently recorded a webcast on modeling practices. In the course I cover some of my philosophies for making sure that the model lends itself to attracting valid
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
