| 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
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 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
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
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
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
May 21, 2009
Ben Z. Gottesman |
Beyond Numbers: Manipulating Text in Excel Excel is great for crunching numbers, but it's also a simple database solution for many. Luckily, with a few handy formulas, Excel can learn to crunch your alpha-bits too. |
PC Magazine
September 27, 2006 |
Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft Excel. |
PC Magazine
April 18, 2007 |
Pre-1900 Dates in Excel Sorting dates prior to 1900 in Excel. |
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
May 18, 2004
Neil J. Rubenking |
Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel. |
PC Magazine
August 1, 2007
Neil Rubenking |
Excel Formulas That Read Your Mind Understanding #REF! error markers in Excel formulas. |
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
April 4, 2007 |
Making Excel Remember More Data Using excel to find linking values of data. |
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. |
Macworld
March 2001
James Bradbury |
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... |
PC Magazine
August 17, 2004 |
Use a Formula as a Named Range in Excel Regarding the article "The Ultimate Sum Formula in Excel"... |
PC Magazine
January 12, 2005
Neil J. Rubenking |
Mysterious Four-Year Error in Excel I have an Excel 2002 workbook with records from the past ten years. |
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
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
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 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? |
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 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
August 3, 2004 |
Counting Unique Names in Excel, Reloaded How to count unique names in excel using pivot tables. |
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. |
PC Magazine
September 4, 2007
Neil Rubenking |
Renaming Excel Rows and Columns Excel can optionally number the columns instead of lettering them. |
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? |
PC Magazine
September 21, 2004 |
Shuffle Numbers in Excel This is an easy way to generate a non-repeating list of random numbers. |
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 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? |
PC Magazine
September 14, 2005
Neil J. Rubenking |
Excel's Calendar Control Object How to add Calendar Control 11.0 to your spreadsheet. |
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 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
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
November 14, 2007
Sarah Pike |
Word Tip: Rearrange Data Convert text to a table and sort through your data more efficiently. |
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
June 18, 2008
Neil J. Rubenking |
Tech Tip: Cell Couture Tips for working with Excel. |
PC Magazine
August 14, 2008
Neil J. Rubenking |
Can't Enter Dates in Excel Solutions to Excel date problems |
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 14, 2007
Sarah Pike |
Excel Tip: Rearrange Data Data is much easier to manipulate when Excel can help with the sorting. |
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
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
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
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
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
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
February 8, 2008
Neil J. Rubenking |
Turn Excel Data and Charts into JPEGs Create figures or a movie from Excel charts. |
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... |
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. |
