| Similar Articles |
|---|
 |
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
September 7, 2004
Neil J. Rubenking |
Asterisk Foils VLOOKUP Here's why Excel's first-column search function trips over a little star and what to do. |
PC Magazine
October 1, 2003 |
Excel's Array Formulas Array formulas are a powerful addition to your Excel toolbox. We show you how to start using them. |
PC Magazine
September 16, 2003
Helen Bradley |
15 Great Excel Tips Microsoft Excel is jam-packed with functions that perform a range of handy calculations and tests. We take a look at 15 Excel functions you may not know about and show you some clever ways to put them to work on your data. |
PC Magazine
August 31, 2005
Helen Bradley |
Performing Lookups In Excel If you need to pull information out of spreadsheets in Excel, use the VLOOKUP function. |
PC Magazine
April 26, 2005
Neil J. Rubenking |
Another Way to Get Last Nonblank Cell Tips for getting the most out of Microsoft Excel. |
PC Magazine
April 4, 2007 |
Making Excel Remember More Data Using excel to find linking values of data. |
PC Magazine
December 30, 2003
Neil J. Rubenking |
The Ultimate Sum Formula in Excel Here's how to set up a formula that will automatically adapt and sum all the cells above it, wherever it is placed. |
PC Magazine
May 18, 2004
Neil J. Rubenking |
Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel. |
PC Magazine
July 1, 2003
Neil J. Rubenking |
Filtering with Excel's PivotTable Is there a way to count the number of occurrences of each name in an Excel column? |
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? |
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
February 14, 2007 |
Numbers With Superscripts in Excel You can format each digit of a number with a different color within an Excel cell, but for the purpose of calculations, the formatting doesn't make any difference. |
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 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
May 16, 2007 |
How Excel Formulas Can Reference Comments How to carry non-cell data from one Excel worksheet to another. |
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. |
PC Magazine
September 27, 2006 |
Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft 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
August 1, 2007
Neil Rubenking |
Excel Formulas That Read Your Mind Understanding #REF! error markers in Excel formulas. |
Science News
April 17, 2004 |
Functions on Display Website offers information about and visualizations of more than 87,000 formulas. |
PC Magazine
May 31, 2006 |
Pick Lottery Numbers With Excel Using the LARGE() function in Excel. |
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. |
Macworld
March 2001
James Bradbury |
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... |
PC Magazine
October 14, 2003
Neil J. Rubenking |
Absolute and Relative References in Excel Avoid error messages in your formulas by using the $ character to indicate cell references that should never change. |
The Motley Fool
November 14, 2007
Mary Dalrymple |
Ship Your Presents Free! To help make the most of Cyber Monday, the online retailer's answer to Black Friday, look around for the best shipping deals to cut your holiday costs. |
PC Magazine
August 14, 2008
Neil J. Rubenking |
Can't Enter Dates in Excel Solutions to Excel date problems |
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. |
Food Processing
January 2012
Diane Toops |
Gallup Poll Reveals Americans Reporting Increased Ideal Weight A poll of 1,012 American adults reveals self-reports of weight and average ideal weight have increased over the past 20 years. |
The Motley Fool
December 10, 2004
W.D. Crotty |
Excel Maritime's Cut-Rate Move The shipping company sells its shares at a steep discount to the market price. |
PC World
May 3, 2001 |
Top 5 Spreadsheet Add-Ins Avoid the pain and tedium of writing Excel formulas... |
The Motley Fool
November 25, 2006
Elizabeth Brokamp |
Holiday Deals for Online Shoppers Love shopping online but hate paying the shipping fees? You may be in luck. Many of the big online stores are offering discounted or free shipping deals this season in order to secure your business. But not without strings attached, of course. |
The Motley Fool
September 17, 2004
W.D. Crotty |
Say Ahoy to Big Profits Bulk shipping company Excel Maritime increases profits by 338% and rockets ahead on the AMEX. |
PC World
December 17, 2001
John Fontana |
Exposing Excel's Dirty Little Secret Spreadsheet could potentially reveal confidential data, but Microsoft says the problem is only one of perception... |
