Results for:
Power Tips

• Pulling RSS data into Excel (or: Using Excel to Search Craigslist) - Part 1

  12 Oct 2010

  This blog post is brought to you by Dan Battagin a Lead Program Manager on the Excel team. OK, so I'm going to talk a bit about a relatively unknown feature in Excel: XML data import. It was introduced in Excel 2003, but we've done a pretty good job hiding it since Excel 2007 by putting it on the Developer...
• Auto Format PivotTables to Match Source Data (Power Tips Series)

  21 Sep 2010

    Today’s author is Mike Alexander, a Microsoft Excel MVP who shows us how to run a Stored Procedure to get data from a SQL server. For more information, visit www.datapigtechnologies.com .   So summer is for practically over and I'm back to blogging topics that can actually help people. For...
• You Asked: What the heck is Scroll Lock

  24 Aug 2010

  This week’s post is written by Amy Miller. Amy is a writer for Office.com. She’s written and edited content for Excel, Access, OneNote, and InfoPath. Imagine you’re working in a spreadsheet and you innocently press the arrow keys on your keyboard to move to another cell, but instead...
• Use SUMPRODUCT to find the last item in an Excel list

  4 Aug 2010

  Today’s author is Charley Kyd, an Excel MVP, who describes how to use the SUMPRODUCT function to find the last sequential item in an Excel list. Charley has worked with spreadsheets in business since 1979, and has written books on spreadsheet use for McGraw-Hill and Microsoft Press. You can find...
• Importing Text Files in an Excel Sheet

  10 Jun 2010

  Today’s author is Jan Karel Pieterse, an Excel MVP, who describes the process of importing text in great detail. You can find more useful tips from Jan Karel on his website: http://www.jkp-ads.com/ . In this article, I'll explain how to ease importing of .txt, .prn and/or .csv files into an existing...
• Solutions to Three Common Problems when Using VLOOKUP()

  10 Jun 2010

  Today’s author is Greg Truby, an Excel MVP, who addresses some common issues you may encounter when you use the VLOOKUP function. This article assumes a basic familiarity with the VLOOKUP() function, one of the easiest ways to lookup up a key value in one worksheet or block of data and return a...
• Running a SQL Stored Procedure from Excel (No VBA)

  7 Jun 2010

  Today’s author is Mike Alexander, an Excel MVP who shows us how to run a Stored Procedure to get data from a SQL server. For more useful articles and videos, visit www.datapigtechnologies.com . We all know we can use MS Query to get data from a SQL server. Typically though, we pull from a Table...
• Creating a TOC with Hyperlinks Programmatically

  30 Apr 2010

  Today's author is Dennis Wallentin, XL-Dennis, of http://xldennis.wordpress.com/ A few weeks ago we posted a code example for creating a table of contents for your workbook. Dennis offers another approach with this code sample for creating a TOC with hyperlinks. Dennis’ code uses the PageSetup.Pages...
• Creating Address Labels from a Spreadsheet Programmatically

  14 Apr 2010

  Today's author is MVP Bill Jelen of MrExcel.com . The following code example takes a list of addresses arranged as one address per row, and copies them onto another sheet, arranging them to fit on printable address labels. The workbook must contain two sheets, one named "Addresses" and one named "Labels...
• Add a Table of Contents to your Workbook Programmatically

  7 Apr 2010

  Today's author is MVP Bill Jelen of MrExcel.com . The following code example verifies that a sheet named "TOC" already exists. If it exists, the example updates the table of contents. Otherwise, the example creates a new TOC sheet at the beginning of the workbook. The name of each worksheet, along with...
• Where to Find the Form Controls

  12 Feb 2010

  Today’s author is Jan Karel Pieterse, an Excel MVP. In this article, he shows the different locations of the form controls in Excel. You can find additional details on how to use these controls on his web site: http://www.jkp-ads.com/articles/controls.asp . Excel 2007 and 2010 In Excel 2007 and...
• Report statistics about a Set of Workbooks

  7 Jan 2010

  Today’s contributor is Sarah Hothersall, Liaison Director at Lyquidity. She’s providing information about the Workbook Statistics add-in, a free tool for Excel users that was created by Sandy Marshall, a Product Manager at Lyquidity, who is in charge of development of ComplyXL for enterprise spreadsheet...
• Preventing auto_open and Workbook_Open events from running

  15 Dec 2009

  Today’s author is Jan Karel Pieterse, an Excel MVP. You can find more useful tips from Jan Karel on his website: http://www.jkp-ads.com/ . This post provides detailed instructions to prevent auto-open and Workbook-Open events from running. As a fulltime developer I oftentimes open files containing VBA...
• Daniel’s Extreme Lookup Collection

  10 Dec 2009

  Today’s author is Daniel Wiesenfeld, an Excel and Access Power User who is sharing his Extreme Lookup Collection with us so we can use the Excel User Defined Functions (UDFs) he created to enhance the lookup functionality. His web site danalytics.biz is currently under construction and should be available...
• Create conditional drop-down lists

  24 Nov 2009

  Today’s author is Reinout Dorreboom from the Netherlands, a Technical Consultant at Getronics, where he has worked with Office applications for many years, and where his Microsoft Certified Training skills enabled him to help other people get up to speed with Excel. In Excel 2007 (and earlier)...
• Easily manage defined names in Microsoft Excel

  17 Nov 2009

  Today’s author is Jan Karel Pieterse, an Excel MVP. You can find more useful tips from Jan Karel on his website: http://www.jkp-ads.com/ . This post informs you about Name Manager, a free utility that helps you manage defined names in your workbooks. If you need a free utility to manage defined names...
• Find Combinations

  12 Nov 2009

  Today’s author is Bill Seddon from Lyquidity Solutions, who informs us about a free tool for Excel users that allows you to find combinations of numbers that total to a selected value. For more information and a video, see http://www.lyquidity.com/findcombinations . Imagine you are an auditor or cash...
• Using form controls on a worksheet

  23 Sep 2009

  Today’s author is Rob van Gelder, previously quite active in the online Excel scene (Newsgroups, Excel forums, his own but currently inactive website) and who just upgraded to Excel 2007 because he still likes to dabble. The following power tip shows that he’s still having fun with form controls. My...
• Adding Every Other Cell in a Column

  23 Sep 2009

  Today’s author is Bill Jelen, author of 24 books on Microsoft Office Excel. He is a regular guest on TechTV with Leo Laporte and the host of MrExcel.com , which includes more than 300,000 questions and answers about Excel. Jenny asks "Is there a quick way of adding every other cell ?, I have a column...
• Calculate the ISO Start of Year date

  17 Sep 2009

  Today’s author is Shane Devenshire, who has been an Excel MVP for many years and who regularly contributes to Excel Newsgroups. He has published over 300 articles in different computer magazines, and co-authored numerous books. Excel might be better today because of the many bugs he posted when he was...