Similar Articles

Browse Main Topics:

Business
Computers & Electronics
Education & Reference
Entertainment & Leisure
Family & Home
Finance & Investment
Health
Internet
Pets & Animals
Science & Technology
Society, Politics & Culture
Sports & Recreation

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.
CFO April 15, 2012 Bill Jelen	A Global Shift (of Decimals) How to move the decimal point in an array of Excel data.
Macworld March 2001 James Bradbury	Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips...
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 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 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 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 November 16, 2005 Neil J. Rubenking	Import Over 256 Columns in Excel How to a list of more than 256 items into excel.
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 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 June 18, 2008 Neil J. Rubenking	Tech Tip: Cell Couture Tips for working with Excel.
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 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 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 April 4, 2007	Making Excel Remember More Data Using excel to find linking values of data.
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 July 12, 2006	Conditional Formatting for Plotted Points in Excel Faking conditional formatting for your plots.
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?
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 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 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 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 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 August 3, 2004	Counting Unique Names in Excel, Reloaded How to count unique names in excel using pivot tables.
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 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 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 October 10, 2007 Gary Berline	Excel Tip: Cell Navigation Jump easily from one cell to a non-neighboring cell.
PC Magazine May 31, 2006	Pick Lottery Numbers With Excel Using the LARGE() function in Excel.
PC Magazine October 14, 2003 M. David Stone	Tabs in Word Tables Here's a quick and easy way to line up decimals and format columns in your Word tables.
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 March 16, 2005 Helen Bradley	Conditional Formatting in Excel Make the information in your spreadsheets more accessible with formatting based on certain conditions.
PC Magazine August 19, 2003 Neil J. Rubenking	Combo Boxes in Excel I want to insert information from a combo box into an Excel spreadsheet.
PC Magazine April 6, 2004 Helen Bradley	Better Lists in Excel Excel 2003 offers some useful new tools for working with lists.
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 World September 2002 Lincoln Spector	Answer Line: What Apps Should I Use to Open Mystery Files? Programs for opening mystery files... customizing the Places Bar in IE 6's Save As dialog box... etc.
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.
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 2, 2006 John Brandon	Get to Know Excel Templates Making sense of data is both the purpose of Microsoft Excel and its challenge.
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 World September 25, 2006 Scott Dunn	Windows Tips: Vanquish Still More Windows Annoyances These eight tricks should improve your Windows experience.
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.
Search Engine Watch July 20, 2010 Jeremy Hull	Paid Search Keyword Building the Smart Way! This six-step process for building a keyword list will help you craft effective ad groups and landing pages for PPC success.
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 February 14, 2007 Sarah Pike	Explorer Columns Customize Windows Explorer to make managing your files easier.
PC Magazine December 22, 2004 M. David Stone	Exploring Document Properties Take advantage of a little-known Word feature to make dealing with files much easier.
PC World May 3, 2001	Top 5 Spreadsheet Add-Ins Avoid the pain and tedium of writing Excel formulas...
PC Magazine July 7, 2009 Julie Sartain	Use Excel as an Architectural Design Tool Here's how to you can use the spreadsheet app to design and build simple projects such as decks, porches, dog houses, and even furniture.