Software Tips & Reviews

• Microsoft Excel: Create Random Numbers

Learn how to use Excel's RAND function to generate random numbers.
By  July 6, 2011

• Microsoft Excel: Create Random Letters

Problem: Instead of random numbers, you need to create random letters.
By  July 6, 2011

• Microsoft Excel: Create a CSE Formula to Build a Super Formula

Problem: Your dataset has a column with quantity sold and another column with unit prices, as shown in Fig. 587. You want one formula to figure out the total of quantity times unit price.
By  July 6, 2011

• Microsoft Excel: Count, Average, Etc. Without Using A Formula

You don't need to construct a formula to determine certain measures, like an average, in Excel. Read on to learn a quicker way.
By  July 6, 2011

• Microsoft Excel: Count Records That Match A Criteria

Learn how to use the COUNTIF function to find out how many items in an Excel list satisfy a certain condition.
By  July 6, 2011

• Microsoft Excel: Copy Without Changing Borders

Need to copy items into an Excel table without changing the borders? Here's how.
By  July 6, 2011

• Microsoft Excel: Convert Times From H:MM To M:SS

You entered the results of a running challenge for the students in your class. The results are from 2 min. 35 sec. to 3 min. and 15 sec. Totaling the times, something is wrong. If you have 11 students at around 3 minutes each, you would expect an answer...
By  July 6, 2011

• Microsoft Excel: Convert Text To Hours, Minutes, And Seconds

Someone in another department set up a spreadsheet with 100’s of time values. Instead of using Excel time formats, they entered each cell as text with hours, minutes, seconds, and AM or PM (Fig. 510). How can you make the text entries to...
By  July 6, 2011

• Microsoft Excel: Convert Text To Minutes And Seconds

Problem: Someone in another department set up a spreadsheet with hundreds of time values. However, instead of using Excel time formats, they entered each cell as text, as shown in Fig. 506. How can you convert the text entries to real Excel times?
By  July 6, 2011

• Microsoft Excel: Convert Numbers To Text

Problem: You have a field that may contain numbers or text. You need the numeric entries to sort with the text entries. Instead, Excel always sorts the numeric entries to the top of the list, followed by the text entries, as shown in Fig. 319.
By  July 6, 2011
showing 61-70 of 198    < Previous  |  page: 5 6 7 8 9 ...  |  Next >