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

Blogs

  • 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
  • Creating Tables the Right Way

    And by ‘right way’ I mean the way I want. JKP commented: I wish MSFT would put a tablename box right into the “Format as Table” dialog as it is the first thing I do after formatting a range as a table. O, and always put that checkbox on. My tables always have a header […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Feb 24 2015
    Filed under:
  • Excel Fun—Build 3D graphics from a spreadsheet

    From video games to movie special effects, 3D graphics drives today's entertainment. But how do 3D graphics work? How does the computer know where on the screen to put the little dots of color? Motivated by simple curiosity, I wanted to understand this. And for me, to understand means to make an Excel spreadsheet. The post Excel Fun—Build 3D graphics from a spreadsheet appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Wed, Feb 18 2015
  • Converting an Excel Range to HTML the Hard Way

    Every time I write a RangeToHTML function, it’s different. I don’t re-use my old functions because the HTML elements that I care about change from project to project. I could make a generic RangeToHTML function that attempts to capture every possible cell property, but I don’t. I don’t want a bunch of code in my […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Feb 13 2015
    Filed under:
  • Weeding the KwikOpen Garden

    A little less than a year ago, I said Why 1,000 files? I don’t know. We’ll see how the performance holds up. I’ve been using it for three days and my text file is only up to 58 files – the 50 Excel stores plus eight additional. I guess it will take a bit longer […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Feb 11 2015
  • What’s new: January 2015

    The Office 365 team got the new year off to a great start in January by delivering Office across more platforms and adding new features, service updates, and apps for your devices. The post What’s new: January 2015 appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Feb 10 2015
  • Power Map for Excel–February update for Office 365

    In our December update, we promised to have some big things to share about Power Map for Excel in the first quarter of 2015. This month, we are ready to start revealing a few of these great additions. With our brand new feature, data cards, and a few amazing improvements to how you use heat maps, we are looking forward to seeing the new stories you will tell with your… The post Power Map for Excel–February update for Office 365 appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Feb 10 2015
  • Go To Special Blanks no longer my Go To guy…

    So I’ve always used Excel’s Go To Special and VBA’s SpecialCells method to select things like formulas, constants, blanks etc from large ranges because I was under the impression that this was efficient. Is is, unless you’re using it to find blanks, in which case it’s a dog. Try this: Select column A:A, and use […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Feb 10 2015
    Filed under:
  • Switching Aggregates in Pivot Fields

    We’ve all been there. You create a pivot table, add your Values fields, and Excel thinks you want to Count them instead of Sum them just because you have a few blanks. To fix it, you can click the yellow Count of Labor (for example), choose Value Field Settings, and change the aggregate. Or you […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Feb 6 2015
    Filed under: ,
  • Handling Errors when Opening Outlook Attachments

    Back in 2013 when I returned to using Outlook as an email client (new job, prior job used Google Apps), I was sprucing up some old code. I have two problems with the code on that page; one I’m solving here and one I don’t know how to solve yet. The first problem is when […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Feb 4 2015
    Filed under:
  • KeyRocket

    Fellow keyboarder, Peter, said I should try KeyRocket. KeyRocket is an application that teaches shortcuts. Sounds right up my alley, so I download the evaluation version. It doesn’t say, or I couldn’t find, how long the evaluation lasts. I have a couple of thoughts about the install process. First, I like that when you click […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Jan 30 2015
    Filed under:
  • The Office you love is now on your Android tablet

    At Microsoft, we are working hard to reimagine the Office experience for a cloud-first, mobile-first world. On January 21st we previewed versions of Office for Windows 10 fully optimized for touch and mobile devices. Today, we are proud to announce the general availability of Word, Excel and PowerPoint for Android tablets. The post The Office you love is now on your Android tablet appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Jan 29 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.