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

Blogs

  • 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: ,
  • Teaching Excel and data analysis—one professor’s efforts to prepare students for today’s careers

    Should a university teach a course on Excel? I have heard this question a lot. But while doing research for my Ph.D. thesis at Delft University of Technology, I noticed the whole world is run by Excel.—Read more from Felienne Hermans, an assistant professor at Delft University of Technology in the Netherlands on teaching Excel to university students. The post Teaching Excel and data analysis—one professor’s efforts to prepare students for today’s careers appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Mon, Apr 6 2015
  • Cricket World Cup fever–analyzing the data with Power Query

    With the 2015 Cricket World Cup in full swing there’s all sorts of player and team data available to analyze. This is a job for Excel and its data analysis tools—Power Query and Power View. The post Cricket World Cup fever–analyzing the data with Power Query appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Fri, Apr 3 2015
  • AET Excel Utilities

    Hi there. For the last few months I’ve been working on my main add-in, AET Excel Utilities. I first started working on it in 2005, as a hobby, and a way to learn VBA. Over time it’s grown from having a handful of very simple tools, to what it is now – well over a […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Apr 3 2015
    Filed under: , , ,
  • BeyondCore’s new apps for Office helps find insights in your data automatically

    The U.S. faces a shortage of 140,000 to 190,000 people with deep analytical skills. BeyondCore delivers technology that further extends the powerful analytics features of Excel and familiar storytelling environments of Word and PowerPoint to help bridge this gap for business users. The post BeyondCore’s new apps for Office helps find insights in your data automatically appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Apr 2 2015
  • April Fools, Excel-style.

    Thought I’d share my two favorite pranks with you. Number one: Take a screenshot of an MVP from their own website, subtly change it somehow, then email it back to them saying “Did you really say this, or was your site hacked”. Here’s an example. Spot the original. Number two: Take a screenshot of someone’s […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Mar 31 2015
    Filed under:
  • Built-in mobile device management now generally available for Office 365 commercial plans

    Today, we are pleased to offer the general availability of MDM capabilities for Office 365. With MDM for Office 365, you can manage access to Office 365 data across a diverse range of phones and tablets, including iOS, Android and Windows Phone devices. The post Built-in mobile device management now generally available for Office 365 commercial plans appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Mon, Mar 30 2015
  • I want a global feed of them there comments

    I wish more Excel blogs had a global site-wide comments feed that you could subscribe to, like this one does. (Daily Dose of Excel: http://www.dailydoseofexcel.com/comments/feed/) Comments are where the party is. Sure, you can subscribe to comments on blogs post by post, but sometimes the article doesn’t seem that relevant to you at the time, […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Mar 30 2015
    Filed under:
  • Today() ain’t so bad…

    Finding alternatives for the TODAY and NOW functions is tricky, but here’s an example of some creative workarounds for the Evil Boss’s report generator.       That last one that uses a dropdown I pulled from a at the ExcelHero LinkedIn group . It’s pretty clever: what you do is create a small Table […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Mar 27 2015
    Filed under:
  • The Amsterdam Excel Summit Last-minute discount

    Hi everyone, Our event is coming real soon now and we’re very much looking forward to it. We have outstanding speakers and excellent content, so everything is lined up to make this a superb Excel event. To entice the undecisive Excel lovers to make up their minds and subscribe after all, we decided to make […] Read More...
< 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.