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

Blogs

  • 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:
  • How much faster is the double-VLOOKUP trick?

    Quick post. I was writing up the Double-VLOOKUP trick I learnt from Charles Williams for the book. Standard VLOOKUP on unsorted data: =VLOOKUP([@ID],Table2,2,FALSE) Double VLOOKUP trick on sorted data: =IF(VLOOKUP([@ID],Table2,1,TRUE)=[@ID],VLOOKUP([@ID],Table2,2,TRUE),NA()) The point of the double VLOOKUP trick is this: Standard VLOOKUPS on unsorted data are slow, because your VLOOKUP has to look at each item […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Apr 23 2015
    Filed under:
  • Evolving Data Loss Prevention in SharePoint Online/OneDrive for Business and Office applications

    Everywhere your data exists, moves or is shared, we want to protect it. Office 365 has provided Data Loss Prevention (DLP) capabilities for email since Exchange 2013. As collaboration extends beyond email to sites and documents, we are extending the DLP capabilities to these services. The post Evolving Data Loss Prevention in SharePoint Online/OneDrive for Business and Office applications appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Apr 21 2015
  • Take control of data with Excel’s business analytics tools

    Today, businesses are required to understand a growing amount of data to drive effective business decisions and remain competitive. Many specialized business intelligence and analytics solutions are entering the market to take advantage of this trend with most requiring installation of new data systems or new training of employees to learn new tools. Excel may already have the business analytics tools you need to drive the information analyses and data-driven… The post Take control of data...
    Posted to The Excel Team Blog by Office Blogs on Mon, Apr 20 2015
  • 6 updates for Power Query for Excel

    This month’s Power Query for Excel update is now available to you and is packed with lots of new features. The post 6 updates for Power Query for Excel appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Apr 14 2015
  • 5 easy and powerful Excel features you may not know about

    We all know that Excel is packed with tons of powerful features, libraries of formulas and galleries of interesting charts, making it one of the most useful tools for business analysts. I believe that, among the great secrets of Excel, there are several that are easy to use and quickly add value to your work. —Read more about power Excel features from Purna Duggirala of changoo.org The post 5 easy and powerful Excel features you may not know about appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Wed, Apr 8 2015
  • Excel 2013 VBA Unreasonably Slow

    I’m not the kind of guy to upgrade too soon. I spend a lot of time in VBA, so new features in Excel don’t generally inspire me. Recently a client of mine upgraded to 2013 with, let’s say, disasterous consequences. First, there’s the Single Document Interface (SDI). That’s where every document is in it’s own […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Apr 7 2015
    Filed under: ,
< 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.