Similar Articles |
|
PC Magazine April 6, 2004 Helen Bradley |
Better Lists in Excel Excel 2003 offers some useful new tools for working with lists. |
PC Magazine November 16, 2005 Neil J. Rubenking |
Import Over 256 Columns in Excel How to a list of more than 256 items into excel. |
PC Magazine July 2, 2008 Neil J. Rubenking |
Eight Handy Tools in Excel You Probably Don't Know About These simple features in Excel will smarten up your spreadsheets in no time. |
PC Magazine March 6, 2007 |
Analyze Multiple Worksheets in Excel Combine long lists of items from about a dozen different workbooks into one Excel worksheet, without duplicating entries. |
PC Magazine July 12, 2006 |
Conditional Formatting for Plotted Points in Excel Faking conditional formatting for your plots. |
PC Magazine April 20, 2004 Neil J. Rubenking |
Another Way to Separate Address Elements Here's another approach to breaking addresses apart, but one that requires no formulas for use with Excel. |
ONLINE Sep/Oct 2012 Marcy Phelps |
Visualization Tools for Turning Information Into Insights Rather than delivering a compilation of articles or pages of text, research professionals add value by turning the information into insights and helping clients understand what it means to them. |
PC Magazine May 31, 2006 |
Pick Lottery Numbers With Excel Using the LARGE() function in Excel. |
PC Magazine April 20, 2005 Neil J. Rubenking |
Insert Alternate Blank Rows in Excel I have an Excel report that fills about 1,000 rows. I want to insert a blank row between each of these rows. Obviously, I know how to insert a row one at a time, but is there a quicker way to do this? |
PC Magazine September 14, 2005 Ben Z. Gottesman |
PivotTable Magic Exploring complex Excel data is easier with a PivotTable. Our tips show you how. |
InternetNews May 2, 2006 Andy Patrizio |
Turn Your Laptop Into a GPS MapPoint 2006 provides GPS and regional data analysis. |
Macworld March 2001 James Bradbury |
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... |
PC Magazine November 14, 2007 Neil J. Rubenking |
Find Unique Rows in Excel Stop searching for new or special entries in Excel by telling the software to how to do the hunting and highlighting for you. |
PC Magazine April 20, 2005 Helen Bradley |
Outlining Your Data Use Excel's Group and Outline feature to view only as much data as you need. |
PC Magazine September 27, 2006 |
Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft Excel. |
PC Magazine June 18, 2008 Neil J. Rubenking |
Tech Tip: Cell Couture Tips for working with Excel. |
PC Magazine August 3, 2004 |
Counting Unique Names in Excel, Reloaded How to count unique names in excel using pivot tables. |
PC Magazine August 3, 2004 |
Convert a Tabular Word Document to Excel Is it possible to convert a Word document to an Excel spreadsheet when the Word document has columns of numbers? |
PC Magazine November 14, 2007 Sarah Pike |
Excel Tip: Rearrange Data Data is much easier to manipulate when Excel can help with the sorting. |
PC Magazine September 26, 2007 Helen Bradley |
Give Your Charts a Makeover Sift through the pages of The New York Times and you'll notice that the charts used to illustrate the stories don't look like typical Excel offerings. |
PC Magazine January 31, 2007 Helen Bradley |
Introducing Excel 2007 Along with its new interface, Microsoft Excel 2007 offers several subtle improvements to those spreadsheet tools you use every day. |
PC Magazine April 6, 2004 Neil J. Rubenking |
Fix Excel 2003's RAND Function In December, PC Magazine reader and Excel maven Earl Takasaki brought a curious Excel bug to our attention: The RAND function in Excel 2003 may return negative numbers. |
PC Magazine February 8, 2008 David Cardinal |
Create Appointments Automatically Do you work on projects whose due dates or events are kept in a spreadsheet? Here are some tips to importing them into your digital planner. |
PC Magazine November 11, 2003 Neil J. Rubenking |
Fixing an Excel Formula I have created several Excel 2000 worksheets that use the VLOOKUP formula to get information from one central worksheet. Now I need to add columns to the root worksheet. |
PC Magazine March 16, 2004 Neil J. Rubenking |
Count Unique Names in Excel I have a list of some 900,000 names in an Excel worksheet. Most of the names have duplicates. How can I count the number of names without counting duplicate entries? |
PC Magazine September 4, 2007 Neil Rubenking |
Sort on More Than Three Columns The how and why to sort data with more than three columns in Excel. |
PC Magazine November 14, 2007 Helen Bradley |
Fast Data Entry in Excel Anytime you can enter data without having to type it yourself, you improve accuracy and save yourself effort. There are plenty of opportunities in Excel to enter data in a faster and smarter way than via the keyboard. |
PC World October 11, 2002 John Walkenbach |
Who Knew Excel Could Do That? Ten Top Tips Make your spreadsheets work harder and give them a polished look with these nifty tricks. |
PC Magazine December 22, 2004 M. David Stone |
Exploring Document Properties Take advantage of a little-known Word feature to make dealing with files much easier. |
PC Magazine May 17, 2006 |
Excel Filter Problem Resolved Making the count of matching items in Excel using it's Auto-Filter feature appear in the status bar at bottom left. |
Macworld August 16, 2007 Rob Griffiths |
Numbers '08 Numbers '08 is a strong entry for Apple in the spreadsheet arena, especially for those who find Excel's feature set overwhelming. |
PC Magazine June 1, 2008 Neil J. Rubenking |
Easy Date and Time Entry in Excel Cut down data entry time in a flash with handy Excel tricks. |
PC Magazine November 30, 2005 Edward Mendelson |
Office Problems, Solved! Some of the most notorious problems and the most useful tricks with Microsoft office. |
PC Magazine June 1, 2005 M. David Stone |
Listening to Office You may know you can speak text and commands to Office. But did you know Office can talk back? |
PC Magazine August 30, 2006 |
Problem Merging Zip Codes That Start with 0 Making Microsoft Office 2003 Small Business allow zip codes that begin with 0. |
PC Magazine November 2, 2005 Neil J. Rubenking |
Word Document with Linked Excel Data Linking excel data to word documents while maintaining word formatting. |
PC World August 20, 2007 Steve Bass |
The Web's Best Mapping Sites At the top map services, driving directions are just the beginning. |
PC Magazine June 20, 2007 |
Save Time With Heading Functions in Excel Making custom applications for Excel is easier than you think. Read on to learn how. |
PC Magazine January 1, 2008 Neil J. Rubenking |
The Incredible Shrinking Excel Text Excel fonts getting a bit tiny? Here's how to keep them readable. |
Search Engine Watch November 3, 2005 Chris Sherman |
Yahoo Enhances Maps, Integrates Local Search In a major overhaul, Yahoo has significantly upgraded its Maps offering with cleaner maps and integrated local search results. |
PC Magazine March 16, 2005 Neil J. Rubenking |
Row-Based Page Breaks in Excel I have extracted information from a database that now forms extremely long lists in Excel. |
Searcher June 2002 Irene E. McDermott |
Where was I? Maps on the Web There is a tremendous amount of spatial data on the World Wide Web: multitudes of maps; armfuls of atlases; cartloads of cartography. Enough to keep a map nerd like myself clicking and dreaming for years. Maps on the Web are designed for many uses, and many of them are free... |
PC Magazine September 8, 2005 Craig Ellison |
Dual XNAV3500P Portable GPS Navigation System The relatively small size, built-in battery, and pedestrian profile makes it possible to use while walking, but there are several better, less expensive GPS receivers available in this class. |
PC Magazine January 18, 2005 Neil J. Rubenking |
Print a Watermark on Excel Worksheet I often create information in Microsoft Excel 2002 that needs to be used before it is complete. I would like to overlay a message such as "INCOMPLETE" in large text across an entire page. |
PC Magazine February 8, 2006 Davis D. Janowski |
Yahoo! Local Maps (beta) This service forgoes a lot of the glitzy features in favor of a clean straightforward interface and good routing features. It provides a quick means of locating local places and things from within an intuitive interface -- and it's still only a beta. |
PC Magazine May 16, 2007 |
How Excel Formulas Can Reference Comments How to carry non-cell data from one Excel worksheet to another. |
PC Magazine February 8, 2008 Neil J. Rubenking |
Turn Excel Data and Charts into JPEGs Create figures or a movie from Excel charts. |
PC Magazine February 15, 2006 Davis D. Janowski |
Mapping Goes Local New local search services combine the search functionality of yellow-page sites, the cartographic abilities of the best mapping services, and a healthy dose of business and restaurant reviews provided by the locals themselves. |
PC Magazine February 1, 2010 M. David Stone |
Repeat Rows and Columns in Multipage Excel Documents If your Excel table is longer than one page, it's often helpful to repeat the header row at the top of every page. |
National Gardening |
New Hardiness Zone Maps The standard hardiness zone map for the U.S. has been the USDA Plant Hardiness Zone Map, most recently revised in 1990. This map is now being updated by the American Horticultural Society through a grant from the USDA. The revised edition is scheduled for release this fall. |