| Similar Articles |
|---|
 |
PC Magazine
October 1, 2003
Neil J. Rubenking |
More PivotTable Power A July 2003 article "Filtering with Excel's PivotTable" states that a pivot table can't tell you who places the high bid, but this is not correct.   |
PC Magazine
August 3, 2004 |
Counting Unique Names in Excel, Reloaded How to count unique names in excel using pivot tables. |
PC Magazine
May 16, 2007
Helen Bradley |
Analyze Data in a Cinch Excel 2007 boasts a host of new feature. Among those is PivotTable a neat and useful new way to look at your data. |
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
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
September 14, 2005
Ben Z. Gottesman |
PivotTable Magic Exploring complex Excel data is easier with a PivotTable. Our tips show you how. |
PC Magazine
April 6, 2004
Helen Bradley |
Better Lists in Excel Excel 2003 offers some useful new tools for working with lists. |
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
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
May 31, 2006 |
Pick Lottery Numbers With Excel Using the LARGE() function in Excel. |
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
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
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
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
April 4, 2007 |
Making Excel Remember More Data Using excel to find linking values of data. |
CFO
August 1, 2012
Bill Jelen |
A Refreshing Change How to hold on to your updates when you correct a pivot table. |
PC Magazine
November 16, 2005
Neil J. Rubenking |
Import Over 256 Columns in Excel How to a list of more than 256 items into excel. |
CFO
June 15, 2012
Bill Jelen |
Blank Check How to get rid of pivot table blanks without affecting calculations. |
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
September 27, 2006 |
Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft Excel. |
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 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
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
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
June 18, 2008
Neil J. Rubenking |
Tech Tip: Cell Couture Tips for working with Excel. |
Macworld
March 2001
James Bradbury |
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... |
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
August 31, 2005
Helen Bradley |
Performing Lookups In Excel If you need to pull information out of spreadsheets in Excel, use the VLOOKUP function. |
The Motley Fool
June 16, 2010
Nathan Alderman |
Beat Back the Budget Beast! This handy spreadsheet can help you keep your money in line. |
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
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. |
PC Magazine
May 17, 2006 |
Excel Filter Problem Resolved Making the count of matching items in Excel using it's Auto-Filter feature appear in the status bar at bottom left. |
PC Magazine
November 14, 2007
Helen Bradley |
Fast Data Entry in Excel Anytime you can enter data without having to type it yourself, you improve accuracy and save yourself effort. There are plenty of opportunities in Excel to enter data in a faster and smarter way than via the keyboard. |
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. |
The Motley Fool
June 8, 2010
Nathan Alderman |
Make Your Checkbook Work for You Hate math? This easy, automated checkbook crunches numbers for you. |
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
May 16, 2007 |
How Excel Formulas Can Reference Comments How to carry non-cell data from one Excel worksheet to another. |
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
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 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 |
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
August 1, 2007
Neil Rubenking |
Excel Formulas That Read Your Mind Understanding #REF! error markers in Excel formulas. |
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 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
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
February 14, 2007
Sarah Pike |
Explorer Columns Customize Windows Explorer to make managing your files easier. |
PC Magazine
September 4, 2007
Helen Bradley |
Making Choices in Excel Vlookups can easily return data from even very large tables. |
PC Magazine
February 8, 2008
David Cardinal |
Create Appointments Automatically Do you work on projects whose due dates or events are kept in a spreadsheet? Here are some tips to importing them into your digital planner. |
PC Magazine
September 4, 2007
Neil Rubenking |
How to Sort by Birthday in Excel How to sort through dates while avoiding leap years. |
