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 - It sure would be nice if...

    I've been doing a lot of work with PowerPivot where I connect to databases. My normal development cycle is as follows:

    • Connect to a view or table, pulling in ALL columns
    • Work through my data scenario until I've worked out my logic and solve the issue I'm trying to solve
    • Cut the table/view query down to just the required columns
    • Add WHERE clauses to cut the data down to just the bare minimum I need
    • Deploy to my users


    By doing all this, I really focus on trying ...
    Tags: powerpivot
    Categories
    PowerPivot , Excel
  2. Retrieving Selection From A PivotTable Slicer

    After discussions with a friend the other day, I thought it might be worth pulling together an entry to show how to get the selected item from a PivotTable Slicer into a formula. This approach allows you to drive dynamic chart titles, or based other logic off a slicer as well.

    You can find the full aticle at: http://www.excelguru.ca/content.php?...otTable-Slicer
    Categories
    Excel , PivotTables
  3. Excelguru e-Learning catalog online!

    Hey everyone,

    For those following on Twitter and Facebook, you are no doubt already aware that last week I released some e-Learning courses online. For those of you who don't follow me there, surprise!

    I've pulled together a package that consists of a 1 hour video (1024*768 resolution so you can actually SEE the content) as well as all the example files and a full e-Book that shows how to replicate the video content. The first course is called "The Magic of PivotTables", ...
    Categories
    Site Stuff
  4. Site Changes

    I am currently in the process of making changes to my site, and updating my blog is one of them.

    I haven't blogged at all over the past few months, and a major reason for that is that my blog software broke during one of the forum upgrades. I've been trying to figure out if I should fix it or migrate the content to the blogging software that is built in to the vBulletin package that I use to manage the rest of the site. I've finally come to the conclusion that migration is exactly ...
    Categories
    Site Stuff
Page 3 of 3 FirstFirst 1 2 3