| 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 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
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
March 16, 2005
Helen Bradley |
Conditional Formatting in Excel Make the information in your spreadsheets more accessible with formatting based on certain conditions. |
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
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
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
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
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
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 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
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 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
September 21, 2004 |
A Subtle Bug in Excel Pivot Tables A reader discovers an unusual Excel 2003 flaw, and we have a demonstration. |
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 22, 2004
Neil J. Rubenking |
Get the Last Nonblank Cell in An Excel Range Creating an array formula for this task. |
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
December 30, 2003
Neil J. Rubenking |
Finding the First Thursday Excel's WEEKDAY and MOD functions help you determine which days fall on which dates each month. |
PC Magazine
September 4, 2007
Helen Bradley |
Making Choices in Excel Vlookups can easily return data from even very large tables. |
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
April 4, 2007 |
Making Excel Remember More Data Using excel to find linking values of data. |
PC Magazine
September 14, 2005
Ben Z. Gottesman |
PivotTable Magic Exploring complex Excel data is easier with a PivotTable. Our tips show you how. |
PC Magazine
May 18, 2004
Neil J. Rubenking |
Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in 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
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
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
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
July 12, 2006 |
Conditional Formatting for Plotted Points in Excel Faking conditional formatting for your plots. |
PC Magazine
December 9, 2003
Brickley & Cutting |
Automate Long Fills In Excel It's easy to create a macro that takes the hassle out of filling large ranges in Excel. |
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. |
CFO
April 15, 2012
Bill Jelen |
A Global Shift (of Decimals) How to move the decimal point in an array of Excel data. |
PC Magazine
August 1, 2007
Neil Rubenking |
Excel Formulas That Read Your Mind Understanding #REF! error markers in Excel formulas. |
PC Magazine
April 6, 2004
Helen Bradley |
Better Lists in Excel Excel 2003 offers some useful new tools for working with lists. |
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
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
August 3, 2004 |
Counting Unique Names in Excel, Reloaded How to count unique names in excel using pivot tables. |
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
November 30, 2005
Edward Mendelson |
Office Problems, Solved! Some of the most notorious problems and the most useful tricks with Microsoft office. |
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
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. |
PC Magazine
May 4, 2005
Helen Bradley |
Demystifying Excel Macros Writing macros can be a challenge; learn the basics with our example. |
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
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? |
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 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
September 4, 2007
Neil Rubenking |
Renaming Excel Rows and Columns Excel can optionally number the columns instead of lettering them. |
PC Magazine
April 18, 2007 |
Pre-1900 Dates in Excel Sorting dates prior to 1900 in Excel. |
PC Magazine
April 20, 2005
Helen Bradley |
Outlining Your Data Use Excel's Group and Outline feature to view only as much data as you need. |
PC Magazine
January 10, 2007 |
Copy Only Subtotals in Excel A way to copy just the results of a subtotal display to other cells in an Excel spreadsheet. |
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. |
