| Similar Articles |
|---|
 |
PC Magazine
June 22, 2004
Neil J. Rubenking |
Get the Last Nonblank Cell in An Excel Range Creating an array formula for this task.   |
PC Magazine
September 4, 2007
Neil Rubenking |
How to Sort by Birthday in Excel How to sort through dates while avoiding leap years. |
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
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
December 1, 2009
Neil J. Rubenking |
Conditional Formatting in Excel Excel's conditional formatting can make spreadsheets a lot easier to interpret - -changing the text color in a cell. |
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
February 3, 2004
Neil J. Rubenking |
Separate Address Elements In Excel I have an extensive Excel spreadsheet with company names and addresses. The city, state, and ZIP code information are combined into one cell. Is there a way this data can be split into three cells? |
CFO
September 1, 2012
Bill Jelen |
An Average Solution How to create a prediction of sales in Excel using a moving average and a trend line. |
PC Magazine
August 14, 2008
Neil J. Rubenking |
Can't Enter Dates in Excel Solutions to Excel date problems |
PC Magazine
June 22, 2005
Neil J. Rubenking |
Degrees, Minutes, and Seconds in Excel I needed to convert coordinates from decimal to DMS (degrees, minutes, seconds). I found a way to convert from decimal to DMS using LEFT and MID, but it seems to take several steps and leaves me with the individual parts, which I can't figure out how to assemble. |
PC Magazine
May 4, 2005
Neil J. Rubenking |
Control Rounding in Excel I have an Excel spreadsheet for my small business that I use to figure employee payroll. What formula can I use so that Excel will always round across the columns so they add correctly? |
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
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. |
PC Magazine
February 16, 2005
Neil J. Rubenking |
Problem with Excel Time Comparison How to build a formula in Microsoft Excel that produces a different answer based on time. |
PC Magazine
May 4, 2004
Neil J. Rubenking |
Sorting Text in Excel Reordering words is more complicated than numbers. Here's a procedure that works. |
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
April 18, 2007 |
Pre-1900 Dates in Excel Sorting dates prior to 1900 in Excel. |
PC Magazine
October 19, 2004
Neil J. Rubenking |
Excel Converts Fractions to Dates How to enter numeric fractions such as 3/16 or 5/9 in Excel, without having them converted to dates such as March 16 and May 9. |
PC Magazine
August 12, 2008
Neil J. Rubenking |
Checksum for a Spreadsheet Create a cell in Excel that does the equivalent of a "hash" or sum of the entire active workbook. |
PC Magazine
March 16, 2005
Helen Bradley |
Conditional Formatting in Excel Make the information in your spreadsheets more accessible with formatting based on certain conditions. |
PC Magazine
December 14, 2004
Neil J. Rubenking |
Advanced Ranking in Excel Q: I have columns of students, band instruments, and tryout scores... A: This seemingly knotty problem can be solved with a single formula... |
InternetNews
July 21, 2010 |
Earnings Preview: How Will Microsoft Fare? Microsoft is expected to have another great quarter, thanks to its well-received operating system. But it needs more than Windows sales. |
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
September 21, 2004 |
Shuffle Numbers in Excel This is an easy way to generate a non-repeating list of random numbers. |
InternetNews
August 25, 2005
Paul Shread |
HP Boosts Buyback HP announced plans to buy back an additional $4 billion in stock late Thursday... Oil prices stabilized... The broader markets edged higher... TiVo plunged 15% on reduced expectations... etc. |
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
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. |
The Motley Fool
May 2, 2006
Rich Smith |
Educate's Lesson in Patience Act in haste; repent in leisure. Now that the bleeding is done, let's do a quick analysis to figure out what so frightened Thursday's sellers and what enticed the brave souls, who reaped the gains, to stick around for their investment reward. |
The Motley Fool
May 7, 2010 |
The May 6 Meltdown. What Happened? Recapping a crazy day in the market. |
InternetNews
September 1, 2005
Paul Shread |
Ciena, JDS Post Losses Ciena and JDS Uniphase showed Thursday that it's still hard to make money in the telecom equipment market... The broader market was mixed Thursday... The Nasdaq slipped 4 to 2147 and the S&P added 1 to 1221... etc. |
InternetNews
October 22, 2009 |
Microsoft Set to Announce Flat Earnings? Analysts are looking at fairly flat first quarter but Windows 7 may cause an uptick by the New Year. |
InternetNews
September 3, 2004
Chris Nerney |
Intel Warning Sinks Nasdaq Chipmaker Intel's warning about third-quarter revenues sent the tech sector reeling in early trading Friday... President Clinton may have suffered a heart attack on Friday... |
The Motley Fool
June 10, 2006
Rick Aristotle Munarriz |
The Fool Looks Ahead Monday: The new trading week starts off with Lehman Brothers reporting... Tuesday: Sure, Best Buy is already a quarter removed from its telltale holiday quarter... Wednesday: This day marks the end of the fiscal year for Atari... etc. |
InternetNews
August 31, 2006
Paul Shread |
Ciena Can't Escape Telecom Woes Better than expected results from Ciena weren't good enough for investors Thursday... The broader market was little changed... Stamps.com lost... etc. |
InternetNews
October 28, 2010 |
Microsoft Poised for Another Record Quarter Propelled by swelling demand in the consumer sector for Windows 7, software giant Microsoft appears to be on the verge of breaking another record when it reports earnings on Thursday. |
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. |
