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

Blogs

  • The Great Hungarian Debate

    I’ve discussed this in 2005. Then again in 2009. I guess it’s time to revisit the issue, mostly because Jordan says it’s time to say goodbye to hungarian notation. I’ve probably said everything I need to on the subject, so no long diatribes here. However, I decided that I was going to experiment with coding […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Apr 23 2014
    Filed under:
  • The Error Class Revisited

    In the comments to Error Handling Via an Error Class, Peter found that the problem with this method is the absence of the Stop and Resume in the error handler than let you debug at the line that caused the error. Yeah, that stinks. Then Jase got me thinking that I just wouldn’t create the […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Apr 21 2014
    Filed under: ,
  • Back to Blogging

    I just submitted the last chapter of a super-awesome new book project I’m doing with Mike Alexander. Submitting the last chapter is always a great feeling. I have no idea when it will be available, but I’ll be pimping it right here when I know. It’s a formulas book, and did I mention that it’s […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, Apr 19 2014
    Filed under:
  • A VBA performance class

    Hi everyone! If you write a lot of VBA code you probably sometimes run into performance issues. A customer rings you and complains that the Excel file you built for them does not perform well. I’ve written a small article on my site, inspired by a post here: Error Handling via an Error Class. I […] Read More...
  • 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
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.