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

Blogs

  • 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:
  • Exploring Manhattan with Excel Power Map

    New York is an iconic city with a rich history of innovation. I have a lot of family in New York and grew up visiting the city. Now that I’m living in Seattle, thousands of miles away, I thought it might be fun to see if I could explore New York from the comfort of my desk using Excel. Through a little Internet searching, I discovered New York City’s “PLUTO”… The post Exploring Manhattan with Excel Power Map appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Mar 24 2015
  • The great “Your Name Here” competition.

    I’m getting close to finishing off the first draft of my book, and I’m putting some goofy images at the start of every major section, to lighten it up. I want this to be a laugh-out-loud Excel book: my goal with these images is to make some *** reading an Excel book snort out loud […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Mar 23 2015
    Filed under:
  • Formula Arguments and Intellisense

    Even though you’ve seen Excel’s Formula Intellisense a million times, I bet there’s a few things that you don’t know about it that can make your life even easier. Let’s first look at an example for one of Excel’s in-built functions. Say we want to use an IFERROR function. As soon as we type the […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, Mar 21 2015
    Filed under:
  • Office 365 ProPlus—IT Control and Management update

    A key benefit of Office 365 ProPlus is the reduced burden around upgrades associated with traditional software deployment. The result is that Office upgrades are fast and it’s always up to date, just like you expect from a cloud service. Today, we’ll discuss the IT Control and Management capabilities specifically around deployment and upgrade management for enterprise environments. The post Office 365 ProPlus—IT Control and Management update appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Mar 19 2015
  • White House 2016 budget in 3D using Power Map for Excel

    An email from Vice President Joe Biden leads to 3D visualizations of the U.S. federal government’s budget using Power Map for Excel. The post White House 2016 budget in 3D using Power Map for Excel appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Mar 17 2015
  • Welcome to “Excel…not quite finished” week.

    A couple of days ago I floated the concept of a dedicated annual “Still Broken” week in which we can talk very honestly about the things in this otherwise great application that we think are still broken, plus review our list from the same time last year to see if any action has been taken […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sun, Mar 8 2015
    Filed under:
  • Why not let users trigger macros from a UDF?

    I like Colin Legg’s cool code over at Self Extending UDFs – Part 1 and Self Extending UDFs – Part 2. And I keenly await Self Extending UDFs – Part 3 (subtitled Return of the User-i or something similar) If you haven’t seen those articles, go check ‘em out…they show you how you can use […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Mar 5 2015
    Filed under:
  • The Office 2016 Mac Preview is here!

    Today is a big day for the Mac community–we're excited to announce that a preview of the new Office 2016 for Mac is now officially available! Office 2016 for Mac is powered by the cloud so you can access your documents anytime, anywhere and on any device. The post The Office 2016 Mac Preview is here! appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Mar 5 2015
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.