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

Blogs

  • Power Query November 2014 update—Connect to Analysis Services, Salesforce and more! 

    We are happy to announce the availability of the November 2014 update for Power Query—packed with lots of new features that we hope you will enjoy and thank us for them (since we are in the Thanksgiving week). The post Power Query November 2014 update—Connect to Analysis Services, Salesforce and more! appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Nov 25 2014
  • Evaluate(Evaluate)

    Since Excel 2013, Microsoft has given us a FORMULATEXT function, which if you point at a cell will do just that. Here’s a naughty snapshot of FORMULATEXT playing with itself in the corner:       I thought I’d have a go at writing a FormulaArray function to complement it, because when I’m building up […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Nov 24 2014
    Filed under:
  • Introducing a new feature in Access 2013 web apps—Download in Excel

    We’re proud to announce that a new feature called, “Download in Excel” is available to all of our Access 2013 Office 365 customers, which makes this process much simpler. This update is available for customers using Office 365 with Access Services so look for this feature soon within your web apps and try it out. The post Introducing a new feature in Access 2013 web apps—Download in Excel appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Fri, Nov 21 2014
  • Out, damn’d gridlines! Out, I say!

    So after doing some incredibly complicated formula challenges and ninja-grade VBA, I thought I’d turn my hand to something simple: finally changing the default template that loads when Excel starts or when I create a new workbook or worksheet so that gridlines are turned off. Because if there’s one thing I hate about Excel, it’s […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Nov 20 2014
    Filed under:
  • Help shape the Microsoft Ignite event

    When we announced Microsoft Ignite last month, we told you it will bring together the best of our past events for Exchange, SharePoint, Lync and Project—and then take it to the next level, based on what our customers and partners have asked for. The post Help shape the Microsoft Ignite event appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Nov 20 2014
  • Dynamically extracting the nth numerical element without delimiters

    ExcelXOR has a great post on using formulas to extract all numbers from a string where: The string in question consists of a mixture of numbers, letters and special characters The numbers may appear anywhere within that string Decimals within the string are to be returned as such The desired result is to have all […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Nov 20 2014
    Filed under:
  • 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:
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.