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

Blogs

  • We’ve updated Excel Online: What’s new in April 2014

    A year ago we announced that Excel Online and each of the applications that make up Office Online were destined to become a comprehensive productivity experience on more browsers and devices—not just companions to the desktop applications. Since then we’ve released several major updates and many minor updates, and today I’m sharing another significant step forward! (Note that these changes will roll-out worldwide over the course of the next few… Read More...
    Posted to The Excel Team Blog by Office Blogs on Mon, Apr 14 2014
  • Join us for Tuesday’s webinar: All about watermarks

    In this week’s webinar you’ll learn how to make or remove watermarks in your documents. You’ll learn how to place images behind text in Word and make sure Confidential or Draft are clearly noted. Plus we’ll cove how to customize a watermark in Word and PowerPoint. We start our Office 15-Minute Webinar at 9:15 am Pacific Time, with a Q&A to follow. Click the link below or go to http://aka.ms/offweb for more information… Read More...
    Posted to The Excel Team Blog by Office Blogs on Mon, Apr 14 2014
  • Paste and Transpose icon in QAT crash Excel 2013

    Hi all I add a new page on my site with a workaround for this problem. I hope that there are no more of this problem icons for the QAT. Not easy find the problem with bugs like this, you not think that an Excel icon in the QAT can crash Excel. Paste and Transpose […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, Apr 12 2014
    Filed under:
  • The Garage Series for Office 365: Prague road trip and apps for Office challenge

    This week the Garage Series Road Trip continues in Prague. Jeremy catches up with organizations using Office 365 in Europe. Then custom apps for Office are put to the test to help Jeremy navigate the historic city and its landmarks in record time. After Hong Kong – where we saw the impact of multiple device usage and mobility in one of the most crowded cities on earth, hearing first hand… Read More...
    Posted to The Excel Team Blog by Office Blogs on Wed, Apr 9 2014
  • Join us for Tuesday’s webinar: Office for iPad

    Last week, we announced that Office is available for the iPad. In this webinar, we’ll show you how to get up and running with these new apps. Read More...
    Posted to The Excel Team Blog by Office Blogs on Mon, Mar 31 2014
  • Creating burndown charts for Project using Power Pivot and Power Query

    When you are managing a project and tracking the work done versus the work planned or the remaining time left, it is common to use a burndown chart In this article, we show you how to create a report of all tasks for the last 90 days, using Excel 2013 and oData streams. This example will also introduce you to some key Power Query and Power Pivot functions. Read More...
    Posted to The Excel Team Blog by Office Blogs on Mon, Mar 24 2014
  • Calling all Excel pros

    We invite you to join analysts from around the world to connect, share experiences, and learn more about the power of data to transform business. Learn more about PASS Business Analytics conference. Read More...
    Posted to The Excel Team Blog by Office Blogs on Mon, Mar 24 2014
  • Daylight Saving Time Error

    It’s DST here in the US and I couldn’t be happier. I don’t care if my drive to work is pitch black, but the drive home? That’s another story. One thing I learned since the clocks sprung forward is that the GetTimeZoneInformation API doesn’t work the way I thought. The TIME_ZONE_INFORMATION return type has a […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Mar 19 2014
    Filed under:
  • Keyboard Shortcut Metrics

    You all know that I love keyboard shortcuts. There is a limit, though. Some of my custom shortcuts clear the Undo stack, which can be a real pain, so I have to balance the productivity gains of the shortcut against the side effects. Back in January, I wanted to see which shortcuts I’d been using, […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Mar 17 2014
    Filed under:
  • Synchronising Slicers

    Hi Everyone, I’ve just added a new page to my site on how to synchronise slicers which point to different pivotcaches: Synchronising Slicers Enjoy the read! Jan Karel Pieterse www.jkp-ads.com Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Mar 13 2014
  • Announcing Office 365 Personal: A new way to access Office 365!

    At last week’s SharePoint Conference, we discussed Office 365 for business investments and got some outstanding feedback from customers. Now it’s time for a few updates for our consumer customers using Office 365 – 3.5 million subscribers and counting. Today I want to announce Office 365 Personal. Coming this Spring, Office 365 Personal is a new, great option for people interested in using Office 365. It’s designed for an individual, allows… Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Mar 13 2014
  • What’s Up at DDoE

    Something is spiking memory on my server and MySQL is shutting down as a result. It doesn’t seem to matter how much memory I throw at it, it just maxes out and shuts down. This morning I implemented a plan of shutting down plugins until it happens again. I started with a database reset plugin […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sun, Mar 9 2014
    Filed under:
  • How do you know if a ListObject is filtered?

    If you try to filter a ListObject, and someone has turned the filter off, then you’ll get an error. But how the heck can you easily test if the filter is on or not? If you fire up the macro recorder, and click the Filter icon a few times to toggle it on and off, […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sun, Mar 2 2014
  • DataPoint Top and Left for 2007 or earlier.

    Over at Datalabel height and width for 2007 or earlier Andy Pope says: Another couple of properties that are not available prior to 2010 are the Left and Top values of the data point. If you want to know the position of the data point you need to get creative. Having determined the width and […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Feb 26 2014
    Filed under:
  • Office 2013 Service Pack 1 now available

    Today we’ve released Service Pack 1 (SP1) for the 2013 set of Office products including Office 2013, SharePoint 2013 and Exchange Server 2013. SP1 delivers greater stability, expanded functionality, security enhancements and improved compatibility with Windows 8.1 and Windows Server 2012 R2. Office 2013 customers will begin to get notifications of SP1 availability through Windows Update within the next 30 days. Exchange Server 2013 and SharePoint 2013 customers can download SP1 at… Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Feb 25 2014
« First ... < Previous 4 5 6 7 8 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.