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

Blogs

  • 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
  • 3 updates to Excel Power Query

    The February update for Excel Power Query is now available to you! This update includes tremendous Performance improvements, a new Microsoft Dynamics CRM Online connector and a couple of new transformations supported in the UX. The post 3 updates to Excel Power Query appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Mar 5 2015
  • Custom Table Styles

    Whenever I look at the default Table Style that Excel spits out:       …I think: Nice structure. Pity about the finish. That formatting is a bit eyestrain-inducing , if not migraine-producing. I’m going to have to sand that sucker back to the wood, and repaint it. So I look through the default styles […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Feb 27 2015
    Filed under:
  • Catching a comet with Excel Power Map

    The recent news that the Rosetta spacecraft made the closest approach ever to the Comet 67P inspired the Power Map team to plot the trajectory of Earth, Mars, Comet 67P and Rosetta—by visualizing their paths through time. The post Catching a comet with Excel Power Map appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Feb 26 2015
< 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.