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

Blogs

  • Announcing new Excel 2013 BI stability and usability improvements

    Recently we announced a new public update to Excel 2013 that includes major stability and usability improvements in Self Service BI scenarios—especially when Power Query, Power Pivot and Power View are involved. The post Announcing new Excel 2013 BI stability and usability improvements appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Dec 16 2014
  • Powering your business with Big Data and business analytics webinar

    Big Data is big news, but what does it mean for you? Did you know that Excel now allows you to connect to more than 25 data sources—including Hadoop through Power Query? With Excel, anyone can use Big Data to inspire innovation, accelerate decision making and share insights—no supercomputers or PhDs required. All while using Excel, the tool you know and love. The post Powering your business with Big Data and business analytics webinar appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Fri, Dec 12 2014
  • Power View interactive visualizations and PivotTables can now be embedded in blogs and websites

    Telling a story with data has become so much more than basic tables and charts and some of you have been using Power View to create dynamic and interactive visualizations or shared PivotTable analysis based on your data models. But you have not yet had a way to share these publicly. Excel now offers all Office 365 Enterprise E3 or SharePoint Online Plan 2 subscribers with an option to embed… The post Power View interactive visualizations and PivotTables can now be embedded in blogs and websites...
    Posted to The Excel Team Blog by Office Blogs on Thu, Dec 11 2014
  • 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:
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.