View RSS Feed

The ExcelGuru (Ken Puls) Blog

This is where I share opinions and rants, test material, share site updates and stuff like that. If you like Beta software, this is a good place for you. If you don't, well... you may not want to try much of what I post here.

  1. PowerPivot And DAX Just Got A Whole Lot Easier...

    As many readers of this blog will know, I am a huge fan of PowerPivot, and honestly believe that this is THE most important feature to hit Excel since VBA was introduced to the product. And anyone who has ever taken a course from me knows that VBA is the greatest thing to be added to Excel since the grid was mapped into rows and columns.

    For those who donít know, PowerPivot was a free add-in to Microsoft Excel 2010, and is now baked into the Excel 2013 release. It basically allows us ...
    PowerPivot , Excel
  2. Site Performance

    Over the past few months, I've been getting an ever increasing number of emails from my site with errors due to overloading. Fortunately my friend Simon is really good with websites, and is very helpful too, so I've been able to put in some changes that I hope will fix things.

    I think it's fair to say that I'm pretty accomplished with Excel, but man... websites are a different matter. Every day I touch this stuff I realize how little I know. Granted, I'm learning all the time, but ...
    Site Stuff