| 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.   |
PC Magazine
February 1, 2006 |
Halves, Quarters, Eighths, Sixteenths in Excel Translating units without error in 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
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
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... |
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 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
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, 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
June 22, 2004
Neil J. Rubenking |
Get the Last Nonblank Cell in An Excel Range Creating an array formula for this task. |
PC Magazine
December 21, 2005
Ben Z. Gottesman |
Dragging a Field Trouble replicating the item "Drag That Field Again and Again" using PivotTables in Excel 2003. |
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
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 26, 2005
Neil J. Rubenking |
Another Way to Get Last Nonblank Cell Tips for getting the most out of Microsoft Excel. |
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 3, 2009
Kathy Yakal |
Should You Be Doing Your Payroll Online? More accurate than a ledger sheet and more usable than a spreadsheet, online payroll services can save you an enormous amount of time and pain. |
Macworld
December 2001
Joseph Schorr |
Mesa 3 Mesa 3, a full-blown spreadsheet program for OS X, lets you build a budget, map out complex statistical data, and produce presentation-quality reports. But how does Mesa measure up to Microsoft Excel when it comes to slicing and dicing your numeric data? Not very well, unfortunately... |
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
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. |
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
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 12, 2006 |
Conditional Formatting for Plotted Points in Excel Faking conditional formatting for your plots. |
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
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
August 1, 2007
Neil Rubenking |
Excel Formulas That Read Your Mind Understanding #REF! error markers in Excel formulas. |
PC World
December 17, 2001
John Fontana |
Exposing Excel's Dirty Little Secret Spreadsheet could potentially reveal confidential data, but Microsoft says the problem is only one of perception... |
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
August 14, 2008
Neil J. Rubenking |
Can't Enter Dates in Excel Solutions to Excel date problems |
PC Magazine
November 2, 2005
Neil J. Rubenking |
Word Document with Linked Excel Data Linking excel data to word documents while maintaining word formatting. |
PC Magazine
July 19, 2010
Edward Mendelson |
10 Excellent Tips for Microsoft Excel 2010 Excel is, without a doubt, one of the most powerful, complex, and tricky desktop apps ever designed. Mastering Office 2010's spreadsheet app can take years; fortunately, we've got 10 very cool shortcuts to Excel mastery. |
Entrepreneur
January 2004
Mark Henricks |
The Payoff If handling payroll by yourself has become a hassle, maybe it's time to go with an outside service. |
PC World
January 2004
Richard Morochove |
Ease Your Payroll Burdens Online service PayCycle Plus automates tasks. |
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 1, 2010
M. David Stone |
Repeat Rows and Columns in Multipage Excel Documents If your Excel table is longer than one page, it's often helpful to repeat the header row at the top of every page. |
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
August 17, 2004 |
Use a Formula as a Named Range in Excel Regarding the article "The Ultimate Sum Formula in Excel"... |
PC Magazine
April 18, 2007 |
Pre-1900 Dates in Excel Sorting dates prior to 1900 in Excel. |
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
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
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? |
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
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. |
Macworld
March 2001
James Bradbury |
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... |
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
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
September 27, 2006 |
Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft Excel. |
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 World
August 23, 2006
Dennis O'Reilly |
Web Spreadsheets Nearly Ready for Prime Time Internet services offer simpler, easier-to-use worksheets. |
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. |
CFO
December 1, 2010
Marie Leone |
Total Trouble The older generation of Excel users remembers how potentially dangerous this Microsoft snag can be. |
