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

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 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 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 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 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 April 4, 2007	Making Excel Remember More Data Using excel to find linking values of data.
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 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 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 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 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 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 September 27, 2006	Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft Excel.
PC Magazine February 3, 2004 Neil J. Rubenking	Highlight Cells Containing Formulas In designing and auditing spreadsheets, I'd like to distinguish visually between cells containing formulas and those containing values.
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 February 17, 2004 Helen Bradley	Add Images to Excel Projects Put pictures and graphics in your charts to make visual data more compelling.
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 April 6, 2004 Helen Bradley	Better Lists in Excel Excel 2003 offers some useful new tools for working with lists.
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 September 7, 2004 Helen Bradley	Mapping Your Data If your Excel presentation contains geographical data, why not display it on a map?
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 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 April 18, 2007 Helen Bradley	Secrets of Readable Charts Measure for measure, a chart that can be easily read and understood will always win out over a chart that looks cool but says nothing or, worse, misleads. Here's are some tips to creating charts in Excel.
Macworld March 2001 James Bradbury	Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips...
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 September 14, 2005 Neil J. Rubenking	Excel's Calendar Control Object How to add Calendar Control 11.0 to your spreadsheet.
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 May 3, 2006	Down with Ugly Excel Charts Customize a default chart 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 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.
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 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 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 August 30, 2006	Problem Merging Zip Codes That Start with 0 Making Microsoft Office 2003 Small Business allow zip codes that begin with 0.
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 3, 2004	Counting Unique Names in Excel, Reloaded How to count unique names in excel using pivot tables.
PC Magazine September 26, 2007 Helen Bradley	Give Your Charts a Makeover Sift through the pages of The New York Times and you'll notice that the charts used to illustrate the stories don't look like typical Excel offerings.
PC Magazine May 31, 2006	Pick Lottery Numbers With Excel Using the LARGE() function in Excel.
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 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 Magazine June 8, 2004 Neil J. Rubenking	Double Drop-Down Validation in Excel Is there a way to make the drop-down list that appears for cell validation conditional on the value in another cell?
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 November 14, 2007 Sarah Pike	Excel Tip: Rearrange Data Data is much easier to manipulate when Excel can help with the sorting.
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 September 14, 2005 Ben Z. Gottesman	PivotTable Magic Exploring complex Excel data is easier with a PivotTable. Our tips show you how.
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 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 World February 2002 George Campbell	Word: The Write Stuff Fifteen essential tips for smarter, faster word processing -- no matter which version of Word or WordPerfect you use...