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

Blogs

  • 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...
  • What help forum would you recommend, and why?

    One of the key premises of my book is that Excel has many passionate online user communities. And on that subject, I say: If you don’t utilize them, you are missing out. If you tap into them, your work isn’t just based on what you know, but on what the collective we know. Which is […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Mar 27 2015
    Filed under:
  • Quick tour of Office 2016 for Mac Preview

    On today’s show, we’ll take a look at the new Office 2016 for Mac Preview, which brings together all the most recent updates for Office on the Mac. Kaberi Chowdhury demonstrates highlights of what’s new with PowerPoint, Excel, Word, Outlook and even the newest member of the Office for Mac family, OneNote. The post Quick tour of Office 2016 for Mac Preview appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Wed, Mar 25 2015
  • VLOOKUP: V is for Volatile.

    Well THAT sure got your attention. I was doing a bit of research for the book (the only bit, mind), and I came across this great old thread on VLOOKUP vs INDEX/MATCH. There’s a few false starts in terms of test methodology until Jon von der Hayden puts things back on the right track about […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Mar 25 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.