| Similar Articles |
|---|
 |
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
November 25, 2003 |
Joining Columns that Include Dates Our Excel merge tip works with any two columns of data, but the formula changes a bit when you're working with dates. |
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 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
September 4, 2007
Neil Rubenking |
Renaming Excel Rows and Columns Excel can optionally number the columns instead of lettering 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
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
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
October 28, 2003
Neil J. Rubenking |
Averages Without Extremes In Excel "I have a column in Excel that contains account balances. I would like to find the average balance after throwing out the one or two highest and one or two lowest values." A solution. |
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
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 4, 2008
Sarah Pike |
Copying Multiple Paragraphs into One Cell There's an easy way to avoid having paragraph breaks split text among cells in Excel. |
PC Magazine
May 18, 2004
Neil J. Rubenking |
Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel. |
PC Magazine
October 19, 2004
Neil J. Rubenking |
Excel Fails to Store Credit Card Numbers When entering numeric data over 15 digits long, prefix the data with a single quote ('). This forces Excel to treat the data as text. |
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
March 2, 2004
Neil J. Rubenking |
Transform Forced Text to Numbers in Excel One of my clients sends me Microsoft Excel files in which all the columns are in text format, even when they contain only numbers. What is the easiest way to correct the number formatting? |
JavaWorld
October 2002
Jeff Friesen |
Java's character and assorted string classes support text-processing Text-processing is one of the more frequent activities in which computer programs engage. Java supports that activity via the Character, String, StringBuffer, and StringTokenizer classes. This article explores each class and introduces you to an assortment of those classes' methods. |
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
September 2, 2003
Neil J. Rubenking |
Sort Thousands of Rows Individually You can run a sort operation on each row of an Excel worksheet using a handy function. |
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
August 1, 2007
Neil Rubenking |
Excel Formulas That Read Your Mind Understanding #REF! error markers in Excel formulas. |
Macworld
March 2001
James Bradbury |
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... |
PC World
August 23, 2006
Dennis O'Reilly |
Web Spreadsheets Nearly Ready for Prime Time Internet services offer simpler, easier-to-use worksheets. |
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
October 11, 2006 |
Flashing Text in Excel Make flash animation in Excel. |
PC Magazine
August 2, 2006 |
Dates To Quarters In Excel How to return the quarter of the year based on a date in Excel. |
JavaWorld
January 2001
Brian Goetz |
Design for performance, Part 1: Interfaces matter Many common Java performance problems stem from class-design decisions made early in the design process, long before most developers even start thinking about performance... |
PC Magazine
April 4, 2007 |
Making Excel Remember More Data Using excel to find linking values of data. |
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
September 14, 2005
Neil J. Rubenking |
Excel's Calendar Control Object How to add Calendar Control 11.0 to your spreadsheet. |
PC Magazine
January 20, 2004
M. David Stone |
Create Columns Using Text Boxes In Word With text boxes, your graphics will stay where you put them in Microsoft Word. |
PC Magazine
August 23, 2005
Ben Z. Gottesman |
Finding Hidden Columns in Excel I somehow lost several of the leftmost columns in a Microsoft Excel spreadsheet and have been unable to make them visible again. How can I get these lost columns back? |
Fast Company
Rose Pastore |
Snapchat And Twitter Can Also Transmit The iPhone Text Crash Bug Earlier this week, a string of characters in Chinese, Marathi, and Arabic, sent via text message, began crashing iPhones around the world. |
PC Magazine
September 27, 2006 |
Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft Excel. |
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
May 18, 2004
Neil J. Rubenking |
Find, Format, Replace Expert advice on Microsoft Word's Find and Replace for format, not text. |
PC Magazine
November 16, 2004
Neil J. Rubenking |
Copy Only Values in Excel A simple technique lets you grab just the data from a spreadsheet. |
The Motley Fool
September 4, 2007
Tom Taulli |
Hummingbird Sings for Wall Street Open Text's major software acquisition takes flight. Investors looking for a software opportunity may find Open Text attractive. |
