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

Blogs

  • Joining Two Dimensional Arrays

    The Join function takes an array and smushes it together into a String. I love the Join function. The only thing I don’t like about it is when I forget that it doesn’t work on 2d arrays. Join only works with 1-dimensional arrays. The last time my memory failed me, I decided to write my […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Jan 28 2015
    Filed under:
  • First look at the new Power BI Preview

    This week Michael Tejedor joins Jeremy Chapman on Office Mechanics to give a first look at the updates to Power BI. The preview announced yesterday adds a number of new Power BI capabilities, including dashboards, new visualizations, support for popular software-as-a-service applications, a native iPad app and live “hybrid” connectivity to on-premises SQL Server Analysis Services tabular models. Michael demonstrates all this and more on the show and explains how… The post First look at the...
    Posted to The Excel Team Blog by Office Blogs on Wed, Jan 28 2015
  • Super Bowl Analysis

    Every so often my worlds collide like when a football game is so popular that non-football fans are aware of it. This week a bunch of nerds will use Excel to analyze the game and I don’t want to be left out. I’ve isolated what I believe to be the most important factor and data-analyzed […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Jan 26 2015
    Filed under:
  • Quick Access Toolbar Usage Update

    Ever since the great QAT Usage Survey of last year, I’ve had five controls on my QAT. Up from zero. Here’s how they’ve fared. Borders: Used zero times. I have my two most common border situations (single underline and grand total) available elsewhere. I guess I don’t muck around with borders as much as I […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Jan 23 2015
    Filed under:
  • The next chapter of Office on Windows

    Yesterday’s unveil of Windows 10 showcased a new generation of experiences that will empower people and organizations to achieve more. In partnership with Windows 10, the Office team is bringing a fantastic new set of Office experiences to this platform, furthering our mission to bring the unparalleled productivity of Office to everyone, on every device. The post The next chapter of Office on Windows appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Jan 22 2015
  • The Amsterdam Excel Summit 2015

    Hi Excel lovers! Last year we had a terrific Excel event in Amsterdam in May. This year we’re in for a repeat! I have just opened registration for what is going to be the place to be for anyone Excel-minded. We have two days full of excellent subjects. An impression: Three in-depth Power Query sessions […] Read More...
  • Inserting a Range into an Outlook Appointment

    Jesse asks: In VBA, how do I add a range of cells to the body of an appointment? Unlike email, the AppointmentItem does not have an HTMLBody property. If it did, then I would convert the range to HTML and use that property. Formatted text in the body of an AppointmentItem is Rich Text Format […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Jan 21 2015
    Filed under:
  • Power Query January update—new connectors and usability improvements

    Power Query for Excel enhances the Business Intelligence (BI) experience by simplifying data discovery, access and collaboration. The Power Query team continually works to improve the Power Query experience and their January update includes a new connector—or many new connectors, in this case—and a host of usability improvements. The post Power Query January update—new connectors and usability improvements appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Jan 20 2015
  • Xbox and Power Map team up to analyze game data

    In the spring of 2014, the Xbox team asked the Power Map team to help them better analyze data collected from the instrumentation of various games to help them improve performance and the gamers experience. The post Xbox and Power Map team up to analyze game data appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Jan 20 2015
  • Finding the Earliest Time by Day

    A reader needs to find the difference between the time listed and the earliest time listed for that same day. Here’s the data: Date Time Difference 6/9/2014 14:49:05 0:00:00 6/9/2014 14:49:47 0:00:42 6/9/2014 14:50:33 0:01:28 6/9/2014 14:51:17 0:02:12 6/9/2014 14:51:31 0:02:26 6/9/2014 14:51:56 0:02:51 7/9/2014 6:19:55 0:00:00 7/9/2014 6:21:09 0:01:14 7/9/2014 6:21:31 0:01:36 7/9/2014 6:22:25 […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Jan 19 2015
  • How Not to Learn Spanish

    I’ve been trying to learn Spanish for almost 20 years. Of the seven words I know, four are swear words. So when I tell you how not to learn Spanish, you can take it to the bank. I signed up for Carlos Muñiz’s RSS feed. It’s in Spanish. Every so often I open the next […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Jan 16 2015
    Filed under:
  • First bug of the year

    And it’s a funny one. Save all your work, then make up a simple datasource that has a formula in the header:       Now, turn the Macro Recorder on, and while it’s recording, turn that datasource into an Excel Table. (I use the Ctrl T shortcut for that)       Excel will […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Jan 14 2015
    Filed under:
  • What Is the Most Awesome Microsoft Product

    As if you didn’t know. As the people talked, we started to get a sense for why they thought Excel is cool – Excel enables people to be rockstars at their jobs and get recognition from their peers. Excel makes people feel powerful. Excel is a work tool that people *love* to use. You can […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Jan 13 2015
    Filed under:
  • Finding the Next Row in a ListObject in VBA

    ListObjects (Tables in Excel’s UI) are structured ranges. I use them constantly. I love the built-in named ranges and referring to them in VBA without a lot of hullabaloo. It’s as close to a database as you’re going to get in Excel. Recently I decided to automate a process of adding some payroll records to […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Jan 9 2015
    Filed under:
  • Tidying Up the Project Explorer

    You know that pressing Ctrl+R in the VBE takes you to the Project Explorer. Of course you do. I’m not going to sit here and insult your intelligence by pretending that you don’t. But that means you are probably also just as confused as I am about which projects the VBE “chooses” to expand and […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Jan 8 2015
< 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.