Similar Articles |
|
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 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 April 4, 2008 Sarah Pike |
Copying Multiple Paragraphs into One Cell There's an easy way to avoid having paragraph breaks split text among cells in Excel. |
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 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? |
CFO June 15, 2012 Bill Jelen |
Blank Check How to get rid of pivot table blanks without affecting calculations. |
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. |
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 November 2, 2005 Neil J. Rubenking |
Word Document with Linked Excel Data Linking excel data to word documents while maintaining word formatting. |
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 February 15, 2006 |
Formatted Excel Date Within Text Calculate a date from some cells and then combine it with literal text in another cell. |
PC Magazine January 1, 2008 Neil J. Rubenking |
The Incredible Shrinking Excel Text Excel fonts getting a bit tiny? Here's how to keep them readable. |
HHMI Bulletin February 2011 Sarah C.P. Williams |
Releasing the Brakes on Cell Fate Converting one cell type directly into another is a kind of modern-day alchemy, an ultimate goal in biological research. But unlike turning base metals into gold, changing a cell's identity is feasible, new research shows. |
PC Magazine June 18, 2008 Neil J. Rubenking |
Tech Tip: Cell Couture Tips for working with Excel. |
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 May 18, 2005 Neil J. Rubenking |
Convert Blank Cells to Zeros in Excel In Excel, is there any way to select a range of cells and tell Excel to fill the blank cells with the value zero? |
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. |
PC Magazine June 1, 2005 M. David Stone |
Listening to Office You may know you can speak text and commands to Office. But did you know Office can talk back? |
CRM December 5, 2011 Judith Aquino |
Leads360 Introduces New Automated Text Message Capabilities Leads360 added automated text messaging to its offerings, allowing sales associates to automate the process of composing and sending text messages via the SPAM-compliant Short Message Service protocol. |
PC Magazine August 3, 2004 |
Counting Unique Names in Excel, Reloaded How to count unique names in excel using pivot tables. |
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. |
Wall Street & Technology March 19, 2007 Ivy Schmerken |
Capital Markets Firms Can Run Spreadsheets on a Server With Microsoft's New Excel Services Responding to Wall Street firms' compliance concerns over spreadsheets in Excel 2007, Microsoft is now offering firms the ability to run Excel Services on a server. |
PC Magazine January 20, 2004 M. David Stone |
Create Columns Using Text Boxes In Word With text boxes, your graphics will stay where you put them in Microsoft Word. |
InternetNews September 17, 2010 |
Study: Mobile Phone Users Largely Ignore Apps Pew Research Center study finds majority of cell phone owners don't bother using any of the apps embedded on them. |
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 September 4, 2007 Neil Rubenking |
Renaming Excel Rows and Columns Excel can optionally number the columns instead of lettering them. |
CFO December 1, 2010 Marie Leone |
Total Trouble The older generation of Excel users remembers how potentially dangerous this Microsoft snag can be. |
PC Magazine September 14, 2005 Jamie M. Bsales |
OCR and More Turn paper documents into editable digital files with ScanSoft's OmniPage Professional 15. |
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. |
AskMen.com |
The Texting Age About two-thirds of all teens use text messaging, mostly due to its simplicity as well as the privacy of being able to communicate without being overheard. |
BusinessWeek August 5, 2010 |
The Call of the Wild Retrevo's Gadgetology Report on American cell phone use. |
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. |
AFP eWire January 31, 2005 |
Next Big Fundraising Trend: Giving Through Your Cell Phone Donors will soon be able to make charitable gifts by using their cell phones to send text messages. |
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. |
InternetNews September 8, 2010 |
Users Love, Loathe Their Cell Phones: Survey New survey says interruptions, spam and security holes are the unfortunate but acceptable side effects of relying more and more on mobile devices for work and leisure. |
PC Magazine January 18, 2005 Neil J. Rubenking |
Print a Watermark on Excel Worksheet I often create information in Microsoft Excel 2002 that needs to be used before it is complete. I would like to overlay a message such as "INCOMPLETE" in large text across an entire page. |
PC World August 23, 2006 Dennis O'Reilly |
Web Spreadsheets Nearly Ready for Prime Time Internet services offer simpler, easier-to-use worksheets. |
IEEE Spectrum June 2012 Dave Levitan |
The Solar Efficiency Gap Companies continue to push solar-cell efficiency records toward theoretical limits. Are actual production-line solar panels keeping up? |
PC Magazine April 6, 2004 Helen Bradley |
Better Lists in Excel Excel 2003 offers some useful new tools for working with lists. |
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. |
Chemistry World October 31, 2012 Ian Le Guillou |
A cell for a cell If you ever need to isolate a single bacterial cell, why not build it a prison cell? This is the approach that colleagues from Sandia National Laboratories, US, have taken. Using multi-photon lithography, they can construct four walls and a roof around a single cell in just over a minute. |
PC Magazine April 18, 2007 |
Pre-1900 Dates in Excel Sorting dates prior to 1900 in Excel. |
PC Magazine September 7, 2004 Neil J. Rubenking |
Inverted Printing in Word Print left-to-right and right-to-left on the same page. |
Chemistry World July 21, 2011 Elinor Richards |
Cell Control to Change Cell Function US scientists can now control the reactions occurring inside cells. |
CFO May 15, 2012 Bill Jelen |
Keep It Secret How to make sure hidden rows in spreadsheets stay hidden. |
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 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 World May 3, 2001 |
Top 5 Spreadsheet Add-Ins Avoid the pain and tedium of writing Excel formulas... |
Macworld April 18, 2005 Ross Tibbits |
PDF2Office 2.1 Professional If you have to open simple PDF files in Microsoft Word on a regular basis, Recosoft's PDF2Office 2.1 Professional is a very useful tool. Unfortunately, it isn't always accurate. |
Chemistry World December 12, 2013 Jeanne Therese Andres |
Kiss-and-run drug delivery Carriers that release hydrophobic substances at cell membranes but do not enter the cells themselves could be the foundation for a new way to deliver drugs into cells, according to a team of scientists in Germany. |