Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » All Tags » General (RSS)

Browse by Tags

  • Language Detection

    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 [...] Read More...
    Filed under:

  • Using the MATCH Function for a Linear Search and a Binary Search

    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 [...] Read More...
    Filed under: ,

  • Keno Odds

    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 [...] Read More...
    Filed under:

  • Plain and Pretty

    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 [...] Read More...
    Filed under:

  • PowerPivot - Part 3 of 4: Conditional Shape Colors

    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 [...] Read...
    Filed under:

  • PowerPivot - Part 2 of 4: Prepping the census data

    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 [...] Read More...
    Filed under:

  • PowerPivot - Part 1 of 4

    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 [...] Read More...
    Filed under:

  • Drawing in Excel

    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. Read More...
    Filed under:

  • New RDBMail Mail add-in for Excel/Outlook 2007-2010

    Hi all FYI I upload a new add-in named RDBMail for Excel/Outlook 2007-2010 this week http://www.rondebruin.nl/mail/add-in.htm The add-in create a new tab on the Ribbon named RDBMail with a lot of mail options and a option to insert a worksheet template to your workbook so you can send more then one mail with one click because the info for each mail [...] Read More...
    Filed under:

  • Consolidating Timesheets

    PHD did a post recently about consolidating data. I do this every other week with timesheets, so I thought I’d share my story. I get timesheets as Excel workbooks via email and I save them to a special folder. I open them one-by-one and record the data on a summary sheet. Here’s the main [...] Read More...
    Filed under:

  • Google Chrome

    This week I made the switch from Firefox to Google Chrome. The latest stable release of Chrome supports “extensions” so all those pesky annoyances that kept me away from Chrome in the past can be fixed. My only complaint with Firefox is that I have to restart it a couple of times a [...] Read More...
    Filed under:

  • Perfect Training

    Have you even attended a really good training session? What about it made it good? I’d like to develop some training sessions. I get a lot out of preparing and presenting (and I hope the attendees get something too). Rather than developing training that looks like every other session I’ve attended, I thought it [...] Read More...
    Filed under:

  • MZ Tools Non-Modal Dialogs

    I’ve recently rebuilt my computer, which means I get to figure out all those little settings that I’m accustomed to. Since re-installing MZ Tools, the accelerator keys don’t work on any of the dialog boxes. Take the Add Procedure dialog, for instance With this open, I click Alt+A and instead of actuating the Add [...] Read More...
    Filed under:

  • Capitalizing Web Addresses

    In written correspondence, which is best: dailydoseofexcel.com DailyDoseofExcel.com DailyDoseOfExcel.com www.dailydoseofexcel.com www.DailyDoseofExcel.com www.DailyDoseOfExcel.com http://dailydoseofexcel.com http://DailyDoseofExcel.com http://DailyDoseOfExcel.com http://www.dailydoseofexcel.com http://www.DailyDoseofExcel.com http://www.DailyDoseOfExcel.com I personally prefer #1, all lowercase and no unnecessary prefix. But I think I’m in the minority. One of the capitalized ones is probably...
    Filed under:

  • 2009 in Review

    Top 10 Page Views in 2009 Post Page Views Creating CSV Files 33,947 Sumif Between Two Dates 19,336 Number Stored as Text 15,003 Writing to a Range Using VBA 12,165 Automating Internet Explorer 11,248 Progress Bar 11,212 Testing for Empty Cells 10,581 Pattern Matching 9,665 Calculated Fields in Pivot Tables 9,321 Maxif Minif Functions 8,162 Most Viewed 2009 Posts Post Page Views Vlookup on Two Columns 6773 Vlookup 2695 Get the Path to My Documents in VBA 2258 Excel Sample Data 2230 Reading Xml Files...
    Filed under:
1 2 3 4 5 Next > ... Last »
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.