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

Blogs

  • Amazing business productivity through Office 365—Dynamics CRM integration

    Save time with seamless integration of Microsoft Dynamics CRM Online and Office 365—email integration and folder tracking within Dynamics CRM, note sharing using OneNote, immersive Excel experiences and self-service analytics with Power BI. The post Amazing business productivity through Office 365—Dynamics CRM integration appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, May 21 2015
  • Time to move on

    First of all, thank You everyone who have made this blog by posting through the years. Nothing last for ever, except for Microsoft (!!), so this is the last post here on this blog. It will be available as long as WordPress allow it. I guess it’s due to inactive it will, sooner or later, […] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Thu, May 21 2015
    Filed under:
  • Early look at Office 2016 Public Preview for Windows—on the desktop and phone

    On today’s show, we’ll take a look at the new Office 2016 Public Preview on Windows 10—both on the desktop and on a phone. The post Early look at Office 2016 Public Preview for Windows—on the desktop and phone appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Wed, May 20 2015
  • CF meets Paste Names, CF freaks out.

    Here’s a funny little bug I came across today. So I’m adding a CF condition, and I push F3 to bring up Paste Names rather than type out a reference or name:       And clicking on that named range duly inserts it into my CF formula:       …but the only problem […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, May 20 2015
    Filed under:
  • Office for Android phone Preview now available

    Over the last 12 months, we've transformed Office from a suite of desktop applications to a complete, cross-platform, cross-device solution for getting work done. In January, we delivered the Office apps for Android tablets—and we’re really proud of our 4+ rating in the Google Play store! Today I’m pleased to announce the preview for Word, Excel and PowerPoint for Android phones. The post Office for Android phone Preview now available appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, May 19 2015
  • Power Map for Excel–May update for Office 365

    In the May 2015 update of Office 365 we are proud to introduce a new core feature to Power Map: Custom Regions. The Custom Regions feature allows data to be mapped to the regions that matter most to you, even if they are not the traditional zip code, county, state or country regions. Custom regions are useful for plotting data on sales districts, school districts, congressional districts, land lot development,… The post Power Map for Excel–May update for Office 365 appeared first on Office...
    Posted to The Excel Team Blog by Office Blogs on Mon, May 18 2015
  • 11 updates to Power Query

    This month’s Power Query updates includes 11 new or improved features. The post 11 updates to Power Query appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Fri, May 8 2015
  • Office 2016 Preview

    From the Office blog: Office 2016 Public Preview Now Available Intuitive data connecting and shaping capabilities. With integrated Power Query, use Excel as your personal analysis workspace by connecting to and viewing all the data around you. Take advantage of a broad range of data sources, including tables from websites, corporate data like SAP Business […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, May 4 2015
    Filed under:
  • Office 2016 Public Preview now available

    Today we’re expanding the Office 2016 Preview, making it available to Office users everywhere in preparation for general availability in Fall 2015. Office 2016 previewers will get an early look at the next release of Office on Windows desktop, but more importantly they’ll help to shape and improve the future of Office. Visit the Office 2016 Preview site to learn more about the Preview program and if it’s right for… The post Office 2016 Public Preview now available appeared first on Office Blogs...
    Posted to The Excel Team Blog by Office Blogs on Mon, May 4 2015
  • Building an Excel Add-in

    Hi there! Only recently I read this quote somewhere: “If you want something done, ask a busy person”. I found two entirely different people as the originator of this quote: Benjamin Franklin and Lucille Ball. I wonder which it is… Well, turns out I’ve been quite busy as of late. So I decided it was […] Read More...
  • CellAbove trick no longer needed?

    I was writing up the CellAbove trick for the book. You know, the trick outlined at Ken Puls’ place. First I was going to show how SUM doesn’t handle row insertions immediately above the SUM function itself. So I duly made up a crappy example (if you’ll pardon the crappy pun):       …and […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, May 4 2015
    Filed under:
  • Today at Build—new possibilities with the Office platform

    Office is the world’s most popular set of productivity tools for getting things done and is used by over 1.2 billion people around the world today. Developers play a critical role in the world of Office by building new experiences for users and customers that we could never have imagined. The post Today at Build—new possibilities with the Office platform appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Wed, Apr 29 2015
  • What’s in store for Office developers at //build and Ignite 2015?

    We’re thrilled for the //build and Ignite 2015 conferences to kick off. We’ve spent the months since TechEd Europe in Barcelona last October preparing and pulling together tons of great new capabilities, content and experiences, which we will share with Office developers at these two conferences. The post What’s in store for Office developers at //build and Ignite 2015? appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Mon, Apr 27 2015
  • Timing Formulas

    In my last post, I looked at how much faster the Double VLOOKUP trick was on sorted data compared with the usual linear VLOOKUP on unsorted data. Below is the code for the timing routine I use. I stole the guts of it from joeu2004 who made some incredibly insightful comments at this great thread […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, Apr 25 2015
    Filed under:
  • Emailing Access Report in Email Body

    I’ve been doing a fair bit of work in Access lately, which is why I’m so irritable. I like Access for it’s rapid development characteristics, but I have specific user interface requirements that don’t happen in Access out of the box. By the time I implement those quirks, I feel like I should have just […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Apr 24 2015
    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.