Daily posts of Excel tips…and other stuff
Archive for the ‘General’ Category.
Carim asked an interesting question:
Do you think a UDF could determine the string language … ?
In Switzerland, there are three national languages (German, French, Italian) and it would be very handy to have an UDF return in which language a given string is written
My first thought was to create a group of common words in [...]
Given the problem I have with images and blog posts, I’m trying something new. I uploaded the content of the post to my website and am using an iframe to post it here. Yes, the UI experience is somewhat different than scrolling the entire browser window but hopefully it is something most people [...]
We were trying to figure out the odds on keno the other day. There’s something about statistics that doesn’t create appropriately strong synapses in my brain. I got an A in stats in college, so I know I can retain the information long enough to be tested on it. But put me [...]
Mike Alexander tells me that I have to sell, so sell I shall.
First, the pretty:
Microsoft MVPs Jon Peltier (Peltier Technical Services) and Mike Alexander (DataPig Technologies) are joining together again to bring you our acclaimed Excel Dashboard and Visualization Bootcamp!
This 3-day boot camp is designed for Excel users who need to more effectively synthesize [...]
Part 1: http://www.dailydoseofexcel.com/archives/2010/02/26/powerpivot-part-1-of-4/
Part 2: http://www.dailydoseofexcel.com/archives/2010/02/27/powerpivot-part-2-of-4-prepping-the-census-data/
As mentioned in the Part 1, I had developed this technique to conditionally color shapes some time ago. Based on customer feedback and my own experience I made changes to simplify the various connections required to make it all work.
Also, documenting the technique was easier to do with a webpage [...]
Part 1: http://www.dailydoseofexcel.com/archives/2010/02/26/powerpivot-part-1-of-4/
Since Excel 2007 (and later) can handle a million rows of data, I figured it made sense to explore PowerPivot (PP) with a data set larger than that. In addition, I have had a long time curiosity about the US census data. So, this seemed an appropriate time to combine the [...]
After the MVP Summit I was motivated to further explore a Microsoft add-in for Excel 2010 called PowerPivot. I don’t know all its capabilities but at the very least it can analyze millions of rows of data. If you are using Excel 2010 you can download the add-in from http://www.microsoft.com/downloads/details.aspx?FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca&displaylang=en
Do keep one thing [...]
Brad sent me a link to this cool YouTube video
http://www.youtube.com/watch?v=4YG_WWZYqUs
Libro1? Is that Italian Excel?
Then there’s this:
http://www.youtube.com/watch?v=8oR1_PA3yTw
And you thought 3D charts were useless.
