MagPortal.com   Clustify - document clustering
 Home  |  Newsletter  |  My Articles  |  My Account  |  Help 
Similar Articles
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. mark for My Articles similar articles
PC Magazine
February 3, 2004
Neil J. Rubenking
Mail Merge Formatting Problem I prepare bills using Office XP. An Excel spreadsheet serves as my database, and I use Word's Mail Merge feature to print the bills. mark for My Articles similar articles
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? mark for My Articles similar articles
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. mark for My Articles similar articles
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. mark for My Articles similar articles
PC Magazine
September 4, 2007
Neil Rubenking
How to Sort by Birthday in Excel How to sort through dates while avoiding leap years. mark for My Articles similar articles
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. mark for My Articles similar articles
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. mark for My Articles similar articles
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. mark for My Articles similar articles
CFO
June 15, 2012
Bill Jelen
Blank Check How to get rid of pivot table blanks without affecting calculations. mark for My Articles 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. mark for My Articles similar articles
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. mark for My Articles similar articles
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. mark for My Articles 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. mark for My Articles similar articles
PC Magazine
September 27, 2006
Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft Excel. mark for My Articles similar articles
AskMen.com
Bernie Alexander
The Significance Of Zip Codes How zip codes have evolved and what the digits mean. mark for My Articles similar articles
PC Magazine
July 19, 2005
Neil J. Rubenking
Inserting an Address Bar Code in Word In Microsoft Word 2003, is there a way to get the address bar code on a letter for use with a windowed envelope? mark for My Articles similar articles
PC Magazine
September 21, 2004
Shuffle Numbers in Excel This is an easy way to generate a non-repeating list of random numbers. mark for My Articles similar articles
PC Magazine
February 1, 2006
Halves, Quarters, Eighths, Sixteenths in Excel Translating units without error in Excel. mark for My Articles similar articles
PC Magazine
July 12, 2006
Conditional Formatting for Plotted Points in Excel Faking conditional formatting for your plots. mark for My Articles similar articles
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. mark for My Articles similar articles
PC Magazine
August 1, 2007
Neil Rubenking
Excel Formulas That Read Your Mind Understanding #REF! error markers in Excel formulas. mark for My Articles similar articles
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. mark for My Articles similar articles
PC Magazine
April 4, 2007
Making Excel Remember More Data Using excel to find linking values of data. mark for My Articles similar articles
PC Magazine
November 28, 2007
Kyle Monson
Adding Thousands Separators in Word In Microsoft Excel we can format numbers so they display using the thousands separator for accounting or currency. mark for My Articles similar articles
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. mark for My Articles similar articles
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. mark for My Articles similar articles
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? mark for My Articles similar articles
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. mark for My Articles similar articles
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. mark for My Articles similar articles
PC Magazine
January 18, 2005
Neil J. Rubenking
Easier Excel Fractions Regarding the PC Magazine tip about fractions in Microsoft Excel, there's another way to enter fractions directly that will both preserve the actual value of the number and autoformat the cell with a fraction format. mark for My Articles similar articles
PC Magazine
May 18, 2005
Neil J. Rubenking
Convert Blank Cells to Zeros in Excel In Excel, is there any way to select a range of cells and tell Excel to fill the blank cells with the value zero? mark for My Articles similar articles
PC Magazine
November 14, 2007
Sarah Pike
Excel Tip: Rearrange Data Data is much easier to manipulate when Excel can help with the sorting. mark for My Articles similar articles
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. mark for My Articles similar articles
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. mark for My Articles similar articles
PC Magazine
December 14, 2004
Neil J. Rubenking
Excel's Custom Formats Q: The user wanted to format a cell in Excel so that if its value is positive, it is formatted with the Accounting format and looks like this: "$ 456 "... A: To create your custom format, first format one cell with the Accounting format... mark for My Articles similar articles
PC Magazine
May 18, 2004
Neil J. Rubenking
Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel. mark for My Articles similar articles
Macworld
March 2001
James Bradbury
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... mark for My Articles similar articles
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. mark for My Articles similar articles
The Motley Fool
June 8, 2010
Nathan Alderman
Make Your Checkbook Work for You Hate math? This easy, automated checkbook crunches numbers for you. mark for My Articles similar articles
PC Magazine
November 30, 2005
Edward Mendelson
Office Problems, Solved! Some of the most notorious problems and the most useful tricks with Microsoft office. mark for My Articles similar articles
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. mark for My Articles similar articles
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? mark for My Articles similar articles
PC Magazine
May 18, 2004
Neil J. Rubenking
Find, Format, Replace Expert advice on Microsoft Word's Find and Replace for format, not text. mark for My Articles similar articles
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? mark for My Articles similar articles
PC Magazine
August 14, 2008
Neil J. Rubenking
Can't Enter Dates in Excel Solutions to Excel date problems mark for My Articles similar articles
PC Magazine
April 6, 2004
Helen Bradley
Better Lists in Excel Excel 2003 offers some useful new tools for working with lists. mark for My Articles similar articles
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. mark for My Articles similar articles
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. mark for My Articles similar articles
PC Magazine
September 7, 2004
Helen Bradley
Mapping Your Data If your Excel presentation contains geographical data, why not display it on a map? mark for My Articles similar articles