Today I’m working on building a new reporting system at my day job. Basically we’re looking at creating tools to budget and forecast results to be reviewed weekly, with a goal of being more on top of results so we
A while ago I started transitioning from VBA to VB.NET again, attempting to build a tool to manipulate the new Power Pivot components in Excel 2013. While I was able to get part way to a working solution using Visual
This is a personal post, but it was a HUGE weekend for me where some very cool things happened. If you’re a fan of Excelguru on Facebook, follow me on Twitter, or are connected to me on LinkedIn, you’ve already
No really, that is it’s name! I was trying to figure out why pressing F4 wasn’t toggling from relative to absolute referencing in my Excel formulas, and was starting to think I found a bug in Excel 2013. But then
The only thing that can't be automated in Excel is the input of raw data... and even that can sometimes be done. If you are looking to avoid repetitive tasks in your Excel spreadsheet (clearing out data to start a
ExcelGuru.ca is run by Ken Puls, FCPA, FCMA. I'm a Certified Management Accountant, who never remembers life without spreadsheets and computers. Since mid 1999, my career has been spent in the hospitality and tourism industry, in the finance and IT
Back in the days of classic Excel (versions 97 through 2003), I displayed about 10 toolbars, working out to hundreds of commands represented by tiny icons. We recognized them, and were able to have all of our most used commands
Today we began the process of migrating away from VMWare to Microsoft Hyper-V for our server farms. Something I'm sure that Microsoft would be pretty happy to hear. And yet I got burned by an issue in the process that
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
Tonight we picked up an iPod Touch from our local Save-On Foods with some reward points that we'd been accumulating. This is pretty cool for a variety of reasons, including the fact that now my kid will try and scoop
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
