Daily tips for using Microsoft Excel.

Sunday, October 30, 2005

Excel Wiki

I am adding an Excel Wiki to the site. Every Excel user is welcome to add content to the Excel Wiki. You can add your favorite tips, hints on using commands, hints on functions, etc.

A "wiki" is a quick way to create a web page. Anyone is welcome to edit or add to the Excel Wiki. Today's Tip110 contains the 2-minute Wiki 101 information that you need to get started.

The Excel Wiki is located at http://www.mrexcel.com/wiki/index.php?n=ExcelWiki.ExcelWiki

Friday, October 28, 2005

Solve Sudoku Puzzles with Excel

Sudoku is the new puzzle craze appearing in many newspaper comics pages. If you've become addicted to Sudoku, check out this Excel-based Sudoku solver from Mike Oldroyd. Rad the details at http://www.mrexcel.com/tip109.shtml

Monday, October 24, 2005

Convert PDF to Excel Using Able2Extract

I've written a review of a cool software package called Able2Extract. The software allows you to take any PDF file and quickly convert it to Excel, Word, HTML, or Text.

I tried it out the other day, and this is far superior to using copy & paste from Acrobat. If you ever find yourself needing to do calculations on data trapped in a PDF, check out this review of Able2Extract.

Sunday, October 23, 2005

Use a FeedReader Application

You are probably starting to see the little orange "XML" or "RSS" icons on websites everywhere. I've even added a few to MrExcel.com. These icons are for people using a new class of software called a FeedReader. If you haven't discovered the joys of using a FeedReader, you will quickly come to love it. They are cheap or free to get, take just a few minutes to set up, and will allow you to monitor your favorite websites in a couple of minutes per week. Check out the complete article for details on how to use a FeedReader.

Saturday, October 22, 2005

MrExcel Video Podcast

Podcasting is the hot new trend that allows anyone to produce their own radio show. I really could not figure out how to teach Excel over the radio. But, as soon as I saw video podcasting, I knew that this would be very cool.

Every weekday, I will make a new 2-minute video tip available. The tip will demonstrate one chapter from the book - Learn Excel from MrExcel. The video tips are free. You can download to your iPod Video unit, or simply watch them on your PC.

I've written a complete guide to show you how to subscribe to this (and many other) podcasts using your PC and the free iTunes.

Wednesday, October 12, 2005

Download Web Data Directly Into Excel

Do you regularly copy and paste web data into Excel? Or, do you find yourself clicking the "Download as CSV" link in Yahoo Finance? There is a better way. In today's episode of Call for Help, you can learn about setting up a web query to automatically pull data down into Excel.

Learn how to change the properties to pull fresh data from the web every time that you open the workbook or even update the data every minute.

The complete show notes are here.

Wednesday, October 05, 2005

Mapping Excel Data with MapPoint

On today's episode of Call for Help, I will show you how to put your data in a map. In the first example, I add a customer list to a map in Excel. Zoom in to the neighborhood around your retail store to find where the customers live.

In the remaining examples, I import data to MapPoint in order to produce a heat map by province and driving directions.

All of these tips require a need for Microsoft MapPoint along with Microsoft Excel.

Complete details here: http://www.mrexcel.com/tip100.shtml