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

Blogs

  • Datalabel height and width for 2007 or earlier.

    Over at Chart LeaderLines in Excel 2010 or earlier I posted some code that draws leader-lines on charts just like Excel 2013 does. Unfortunately that title was misleading in regards to the or earlier bit: Eric said that the code isn’t working at all in XL07, and Jon Acampora advised that the DataLabel.Height and DataLabel.Width […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Feb 24 2014
    Filed under:
  • Join us for Tuesday’s webinar: Understanding Power Pivot in Excel 2013

    Struggling with Power Pivot for Excel 2013? Want some tips on how to best work with a data model? During Tuesday’s webinar at 9:15 am Pacific time, Owen Duncan, Senior Content Developer for Power Pivot, will show you the ropes. He’ll walk you through some basics and also teach you some best practices. Read More...
    Posted to The Excel Team Blog by Office Blogs on Mon, Feb 24 2014
  • Data Validation doesn’t care about volatility.

    Huh. All these years I’ve been telling people to avoid volatile functions in models – especially in dropdowns because large chains of dependents usually hang off of these – and it turns out that I’m wrong in that specific case, as per Roberto’s comment in this thread. If you use a volatile function to feed […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sun, Feb 23 2014
    Filed under:
  • Opening the Addin Dialog like a Pro

    Back in the old days when Excel had menus and toolbars, a guy could use Alt+t+i to open the Addins dialog (Tools – Addins). But that would only work if there was an open workbook. No open workbook, no dialog. Now in the days of the Ribbon, the shortcut is Alt+f+t a a Alt+g (File […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Feb 21 2014
    Filed under: ,
  • Creating an Appointment in Outlook 2010 Installation

    Creating an Appointment in Outlook 2010 Creating an Appointment in Outlook 2010 Part II You can download MGoogleCal.zip Here are the steps to install the code. Download the zip file from the link above Unzip the four files and make a note of where they are Open Outlook 2010 Press Alt+F11 to open the VBE […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Feb 20 2014
    Filed under: ,
  • Creating an Appointment in Outlook 2010 Part II

    Yesterday I posted about replicating how you can enter an item on Google’s calendar in Outlook. Today, we’ll look behind the form to see what’s going on. I won’t cover every piece of code, but you can download the code to see all of it. Let’s start with the Initialize event. In the entry point […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Feb 19 2014
    Filed under: ,
  • Creating an Appointment in Outlook 2010

    I got a new job about a year ago and I went from using Google’s calendar to Outlook. I’ve added some code to Outlook to handle emails a little more like GMail does, but one thing I’ve missed is the ability to add something to the calendar easily. According to Google, you can enter multiple […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Feb 18 2014
    Filed under: ,
  • Join us for Tuesday’s webinar showing how Office works on an 82-inch touch screen

    Like working on your tablet or smartphone? Imagine one bigger than your TV. Perceptive Pixel by Microsoft delivers exceptional, multi-purpose touch devices for brainstorming, collaboration, and interactive presentations. In this week’s webinar, we'll show you how Excel, PowerPoint, and OneNote work on a 82-inch screen. We start our Office 15-Minute Webinar at 9:15 am Pacific Time, with a Q&A to follow. Click the... Read More...
    Posted to The Excel Team Blog by Office Blogs on Mon, Feb 17 2014
  • The Amsterdam Excel Summit

    A Unique Opportunity Dear Excel lovers, Is Excel the first and last application you use every day? Do you want to improve your Excel skills and get first-hand knowledge from the absolute best Excel experts in the world? Then this unique event is for you. The Amsterdam Excel Summit Worldclass Excel Experts An absolute unique […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Feb 17 2014
    Filed under:
  • Applying NumberFormat Version 4

    I’ve been using a macro to apply the comma style for about five years. I’ve even enhanced it. It’s such a simple bit of code that it really never broke – until now. I got a workbook that caused the code to fail because it didn’t have a style named ‘Comma’. I just assumed that […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Feb 17 2014
    Filed under: ,
  • Instant Pivot: Just Add Water

    Ahem. BEHOLD! Sub InstantPivot() '   InstantPivot: Just Add Water '   Assign this to Ctrl + Shift + P or something like that. '   Description:    * Turns selection into Excel ListObject '                   * Makes a Pivottable out of it at the edge of […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Feb 12 2014
    Filed under:
  • Thanks for nothing, ListObject

    Why is it that you can do this: Dim lo as ListObject Set lo = ActiveCell.ListObject If lo Is Nothing Then 'Do something …but you can’t do this: Dim pt as PivotTable Set pt = ActiveCell.PivotTable If pt Is Nothing Then 'Do something …and instead you have to do this: Dim pt as PivotTable On […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Feb 12 2014
    Filed under:
  • Find all your data connections with Office Discovery and Risk Assessment

    Do you need to find out where your data is being used? More specifically, how can you find Excel workbooks that have data connections to your databases? We went to SQL MVP Scott Stauffer to help answer that question. Scott is helping his client launch a data warehouse that will be the preferred source of data for many areas of the business. The client is also planning to switch to… Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Feb 11 2014
  • Sending Images via WinSCP

    Since my recent move to Digital Ocean for hosting, I’ve had to make a change to how I upload images for this blog. I used to create an FTP file and a batch file, but as far as I know that doesn’t support SFTP. I’m using WinSCP to transfer files manually and learned that it […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Feb 11 2014
  • Power BI for Office 365 now available to do more with business insights in Excel

    Today we’re happy to announce that we’re making Power BI for Office 365 generally available to a billion Office users. Since announcing and previewing Power BI for Office 365, we’ve been continually adding new features and with today’s general availability customers can now make more informed decisions by discovering, analyzing, and visualizing their data in Excel and sharing through Power BI for Office 365. Read More...
    Posted to The Excel Team Blog by Office Blogs on Mon, Feb 10 2014
< 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.