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

Blogs

  • 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
  • Subtracting Cells in the Status Bar

    Sometimes I just want to quickly see the difference between two cells or groups of cells. Excel puts some great aggregates in the status bar. and you can even customize them. Right click on the those aggregates. But I wanted the difference. So I wrote some code to find it. I already had a class […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Feb 10 2014
  • Caution: Pointless Message

    I was walking through the Wellington CBD the other day on one of those rare fine days that occasionally falls between earthquakes that warrant a 7.2 on the sphincter scale and hurricane-force Southerlies, when I came across this sign: I’m not really sure of the sign’s intention. What kind of caution should one exercise here? […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Feb 10 2014
    Filed under:
  • Indecent Add-in Exposure

    Every so often, for reasons I can’t explain, an add-in shows up in my Excel UI. Today it was BlogHelpers.xla, but other times it’s different. It’s always in a non-maximized window view. That is, the workbook name is in the window’s title bar and not the application’s title bar. You can see that the IsAddin […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Feb 5 2014
    Filed under:
  • Filtering charts in Excel

    Have you ever had a dataset but only needed to chart certain parts of it? Here are 4 methods for filtering your chart so you don’t have to edit or remove your data to get the perfect chart: hide data on the grid, table filtering, filtering using table slicers, and filtering directly from the chart. Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, Feb 4 2014
  • Chart LeaderLines in Excel 2010 or earlier.

    I love the Leader Lines that Excel 2013 puts in for you if you’re using Excel 2013 and you drag a datalabel somewhere. If you want to use Leader Lines in earlier versions, then they are only available if you use a pie chart. And we all know what Peltier would say about that, don’t […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Feb 3 2014
    Filed under:
« 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.