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

Blogs

  • Recent Update of Office causes problems with ActiveX controls

    Hi, Yesterday, I installed a host of updates, including some of Office. As it happens, I tried to add an ActiveX control to a worksheet and received an error. After some research I discovered the cause of the error to be two-fold: 1. The controls were updated by the update 2. Excel did not clean […] Read More...
  • What happens when 9 Excel power users come to Microsoft campus?

    Excel is a tool that means different things to many different people. And with the app available for the PC, Mac, web and even your phones and tablets, the ways in which Excel is being used is expanding like crazy. So it is important for our team to continuously learn from our diverse customers. In November, we decided to try a new way of engaging with some of our most… The post What happens when 9 Excel power users come to Microsoft campus? appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Wed, Dec 10 2014
  • Excel Power Map–December update for Office 365

    Last month we shipped a great time saving feature—playing a tour directly from any scene. This month we’ve improved Geocoding performance, made the Auto Fit feature for custom maps more accurate, and added another popularly requested feature as well—a quick way to select all items when filtering. The post Excel Power Map–December update for Office 365 appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Dec 9 2014
  • New Document Inspector features for Excel, PowerPoint and Word

    Beginning with the November and December 2014 updates for Microsoft Office 2013 and 2010, several enhancements are being added to the Document Inspector, also known as the “Check for Issues” tool in Excel, PowerPoint and Word. The post New Document Inspector features for Excel, PowerPoint and Word appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Dec 9 2014
  • Who will be crowned Financial Modeling World Champion in New York?

    It’s a big deal. This year, ModelOff, the Financial Modeling World Championships, caught the attention of over 3,700 Microsoft Excel users and financial modelers from the U.S., Australia, Russia, India, China and other countries across the globe. The post Who will be crowned Financial Modeling World Champion in New York? appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Dec 4 2014
  • Evaluate Mid

    In my last post, I created an array from formula text by using VBA’s Evaluate method, in order to roll my own FormulaArray function that displays the array returned by a formula, for documentation purposes. In the course of this, I’ve discovered something a bit weird about how this method evaluates the arrays returned by […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Dec 3 2014
    Filed under:
  • 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:
« First ... < Previous 4 5 6 7 8 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.