Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Blogs

  • An INDEX of insights from ExcelXOR

    Everybody knows that you can’t do some things with the result of an INDEX function unless you return it to the worksheet first. For instance, I can return the 2nd and 3rd members of the array {10,20,30} to the worksheet with an array-entered INDEX function like this:       …but if I wrap a […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Nov 20 2014
    Filed under:
  • VLOOKUP & INDEX/MATCH Are Both Badly Designed Lookups: Here Are Some Better Ones

    It’s fun to argue about whether VLOOKUP or INDEX/MATCH is better, but to me that’s missing the point: they are both bad. So I decided to design and build some better ones. VLOOKUP INDEX/MATCH problems Here are some of the more-frequently mentioned VLOOKYP INDEX/MATCH problems Slow exact match (linear search) Approximate sorted match is the […] Read More...
  • Cult of the Flying Spaghetti VLOOKUP

    Sumit Bansal’s post VLOOKUP Vs. INDEX/MATCH – The Debate Ends Here! sparked some great discussion on the merits of VLOOKUP vs INDEX/MATCH, including at Oz du Soleil’s lighthearted rebuttal at The Anti-VLOOKUP Crowd Is Out In The Streets Again! I especially love Peter B’s comment at Sumit’ post: My opinion is that VLOOKUP and HLOOKUP […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Nov 17 2014
    Filed under:
  • Quick Access Toolbar Usage Survey

    Chris Macro at TheSpreadsheetGuru surveyed some Excel users to see what’s on their QAT. Here’s my contribution: I Don’t Use That Thing! To my surprise there were a handful of Excel bloggers I reached out to who don’t use the Quick Access Toolbar at all! This includes the likes of Petros Chatzipantazis (Spreadsheet1.com & RibbonCommander.com), […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Nov 14 2014
    Filed under:
  • String concatenation is like the weather…

    …everyone complains about it, but nobody does anything about it. Well, certainly not Microsoft, anyhows. But Nigel Heffernan at Excellerando.Blogspot.com has. A whiles back in 2012 he put up some nifty code for joining and splitting two dimensional arrays that I just stumbled across. I thought I’d have a go at turning the join one […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Nov 14 2014
    Filed under:
  • Excel Power Map—November update for Office 365  

    Last month we focused on quality improvements for Excel Power Map, shipping more fixes than in any previous monthly release. This month we’re continuing to make fixes but we’ve also added a nice convenience feature. The post Excel Power Map—November update for Office 365 appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Nov 13 2014
  • Garage Series: Power BI and Excel takes on El Clásico

    This week the Garage Series comes from Barcelona, Spain on the heels of TechEd Europe. In this demo-packed show Jeremy puts the advanced analytics and visuals in Excel and Power BI to the test to expose data patterns within past matches between Real Madrid and FC Barcelona. By combining historical El Clásico and player data, outside forces like temperature, humidity and moon phases, Jeremy tries to predict the outcomes and puts these predictions to the test among fans in Barcelona.… The post...
    Posted to The Excel Team Blog by Office Blogs on Wed, Nov 12 2014
  • Why Xojo Is Not Competitive For Windows & Linux

    I always find it interesting when I realize I took the wrong route to pickup a new development tool. Not that I laugh and smile for the money I have spent on it but more like why it didn’t turn out to be a good decision in the end. For some years ago I decided […] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Mon, Nov 10 2014
  • No you CANNOT have more of the same

    I like Doug Glancy’s UndoSelections code via his Selectracker utility. Nifty. I thought I’d try a simpler approach…simply not let the user select a cell that’s already selected. So I came up with this: Private Sub Workbook_Open() Set App = Application End Sub   Private Sub App_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)   […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Nov 10 2014
    Filed under:
  • The Future of VBA Development

    Remember nine years ago when I posted about the future of vba? Neither did I, but I just re-read it. I think if we keep talking about how VBA is dead, it might actually die someday. Nah, probably not. John at Global Electronic Trading has the latest VBA eulogy. He asked several VBA community members […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, Nov 8 2014
    Filed under:
  • Until Next Year

    International Keyboard Shortcut Day was a huge success. I expected that I would be the only one participating and I have pretty good evidence that a few other did. Therefore, we blew right through expectations and set the bar high in Year 1. I put my mouse away at 2:30 and worked pretty much nonstop […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Nov 6 2014
    Filed under:
  • Opening, Closing, and Saving Workbooks

    Happy International Keyboard Shortcut Day. Today, three quick ones for dealing with workbooks. Ctrl+O: Shows the Open dailog box to open a file from disk. The menu is File – Open (Alt + F + O) Ctrl+S: Saves the active workbook. If the active workbook is previously unsaved, shows the Save As dialog to choose […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Nov 5 2014
    Filed under:
  • Navigating and Selecting Cells via the Keyboard

    In honor of International Keyboard Shortcut Day, here are some tips for navigating around and selecting ranges via the keyboard. Arrows The arrow keys are how you navigate cell-to-cell with your keyboard. Earth shattering revelation, isn’t it? Ctrl = End Holding down the Ctrl key while using the arrow keys is the same as the […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Nov 4 2014
    Filed under:
  • Office and Dropbox to work together on phones, tablets and web

    Today we announced a partnership with Dropbox to help you work and collaborate more effectively. You can do more with your Office documents when they are stored online. You can easily share your documents with others, and you can access those files from anywhere, on all your devices. If you use OneDrive and Office together, you already know how easy it is to work online with Office. The post Office and Dropbox to work together on phones, tablets and web appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Nov 4 2014
  • Three Easy Formatting Hotkeys

    In honor of International Keyboard Shortcut Day, here’s three easy to remember shortcuts for formatting text. Ctrl+B: Makes the selected text bold. Get it? ‘B’ is the first letter of ‘bold’. Ctrl+I: Makes the selected text italics. Get it? ‘I’ is the first letter of ‘italics’. Ctrl+U: Makes the selected text underlined. Get it? Of […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Nov 3 2014
    Filed under:
< Previous 1 2 3 4 5 Next > ... Last »
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.