• Home
  • About
  • Appearances
  • Contact

hemmans.com

fresh insights on technology

Word: Change Whatever the Case May Be

Posted May 31st, 2010 in Word

There is a command in Microsoft Word that changes the case of text when it is invoked. It changes text to lowercase, uppercase, title case, or sentence case, based on the selection.

Read more | Leave a Comment


Apple’s iPad: First Impressions. Can You Put it in a Box?

Posted April 15th, 2010 in Apple

I have had an opportunity, thanks to a generous friend, to use an iPad for several hours over the past week. During that time, I showed it to roughly 2 dozen people and managed to collect some of their first impressions.

Read more | 1 Comment


Apple’s iPad: Will it Find a Place in Your World?

Posted February 3rd, 2010 in Apple

On January 27th, in the year twenty-ten, Steve Jobs announced to the world Apple’s latest creation, the iPad. People are still trying to figure out if it’s a laptop replacement or a Kindle killer. They also want to know whether they need one.

Read more | 3 Comments


Keys to Reduce Scrolling on the BlackBerry® Home Screen

Posted January 20th, 2010 in BlackBerry

BlackBerry® smartphones excel when it comes to working with large amounts of e-mail. They ship configured to allow easy dialing from the Home screen. Changing this setting unlocks an array of shortcut keys.

Read more | Leave a Comment


Get a Handle on AutoFill in Excel

Posted January 5th, 2010 in Excel

You can use the AutoFill handle to quickly drag a series into existence. You can drag days of the week, months of the year, or a numerical series — you can even create your own custom series.

Read more | Leave a Comment


Toggle the display of formulas on a sheet in Excel

Posted November 24th, 2008 in Excel

When working in Excel, you may wish to see the formulas in use on your worksheet to help you track down an error, or to see which cells are dependent upon other cells.

Read more | Leave a Comment


Set up reliable data validation in Excel

Posted September 12th, 2008 in Excel

You can use data validation to restrict the type of information allowed in a given cell (or cells). In addition, you can use data validation to limit data to a predefined list of acceptable items and display the items as an in-cell dropdown list.

Read more | 1 Comment


Use the Lookup feature to find values in lists with vLookup in Excel

Posted September 12th, 2008 in Excel

Use VLOOKUP to find corresponding information in a list of data.

Read more | Leave a Comment


Combining data from multiple cells with Concatenate in Excel

Posted September 12th, 2008 in Excel

Excel gives you the ability to combine text from multiple cells into a single destination cell.

Read more | Leave a Comment


Distributing data across columns with Text to Columns in Excel

Posted September 12th, 2008 in Excel

In Excel, you can take a cell and split its text across columns in a number of ways. The easiest of these is to use the Text to Columns command under the Data menu in Excel.

Read more | Leave a Comment


« Older Entries
   

hemmans.com is powered by WordPress
Entries (RSS) and Comments (RSS).