The 2012 Financial Modeling World Championships

http://www.modeloff.com/ I “pre registered” even though there’s not a lot of information on the site. For example, I could not find any information about the organizers, nor could I find any motivational details other than “The prize pool…will include cash, interviews with leading global Financial Institutions, product giveaways and more.” Neither is there any information …

Continue reading ‘The 2012 Financial Modeling World Championships’ »

Survey on Excel use

An INFORMS SPRIG email contained a request for a survey on Excel use from Abigail Rose Rebello, a graduate student at Cardiff, who needs the responses for her dissertation. It took me under 10 minutes, interrupted by 2 phone calls, to complete the survey. From the email I received: — quote — Understanding Spreadsheet Usage …

Continue reading ‘Survey on Excel use’ »

A winner of the Microsoft BI PowerView contest

Microsoft’s BI group is running a contest on using PowerView to answer business questions about one of its demo datasets. More than anything it’s knowing how to use the PowerView GUI to build the appropriate query because the winner is the first person to reply with the correct answer. In any case, I won today’s …

Continue reading ‘A winner of the Microsoft BI PowerView contest’ »

No more Google Adsense ads on my website – at least for now

For several years now, Google has shown ads on my website and when someone clicked on one of the ads, it shared with me some of the revenue it earned. For some time now I have had the impression that the Adsense revenues have been in decline – mine, not Google’s. {grin} So, earlier this …

Continue reading ‘No more Google Adsense ads on my website – at least for now’ »

Highlight matches to the current cell

I came across a very reasonable request from someone who wanted to see which entries in a list matched those in the current cell (http://answers.microsoft.com/en-us/office/forum/office_2010-excel/event/49aa9987-3cf5-4007-9f08-df076ff0beba). While the original request dealt with names, I abstracted the problem into a set of numbers. Column A in Figure 1 is one list of numbers. Column C represents a …

Continue reading ‘Highlight matches to the current cell’ »

Password Userform Module

This was inspired by Dick Kusleika’s post Masking Passwords (http://www.dailydoseofexcel.com/archives/2011/07/12/masking-passwords/). It’s an enhanced version of DK’s approach in the sense that the same userform module supports both entering a new password as well as entering a password for confirmation. There are other enhancements. The user can choose to either mask or unmask the password. The …

Continue reading ‘Password Userform Module’ »