Add (append or prepend) text along with excel functions/formula in a single cell

Hi friends,

Today I have come across a situation where i want to have the cell to descriptive and to have summation of some cells. I have got information on how to do it. Please find below

Input Data:

3

4

2

I want a cell to be on top those with description and summation value

Expected output data:

Sum = 9

3

4

2

To get the output, I have written the following function

Syntax:
="Text"& function

Example:
="Sum = "& SUM(A2:A4)

We can append and prepend the text to excel function to combine text and numbers as well.

Please send your comments and feedback to psrdotcom@gmail.com

Combine Different Network Connections to get Faster Internet Connection Speed Simultaneously

Hi friends,

Have you ever thought of combining your ethernet connection internet speed and your mobile internet speed and wi-fi internet speed and etc.?

Getting one active Internet connection speed doesn't suite for high speed downloads.

But Connectify Dispatch made this possible to combine different Internet connections and made a single, faster Internet connection to download with summation of all available networks.

Use multiple connections simultaneously to get a faster connection speed.

Please find more details at

http://www.kickstarter.com/projects/523076551/dispatch-the-internet-faster

References:

Connectify

Converting Power Point Presentation (PPT) to Images and Conversion of Images to PPT

Hi all,
Today I was searching for converting the slideshow to images and doing some batch processing to the images like crop, resize, filename change and again making ppt with the modified images.

I followed the below procedure to convert my slides in ppt to images, cropping the images and finally making slideshow with edited images.

• Converting slides to images
1. (MS Office 2007) Office Button (Top-Left) -> Save As ->  Other Formats
2. Choose the corresponding destination folder
3. Choose "Save as type" as "JPEG File Interchange Format (*.jpg)"
4. One pop-up comes with the following options
• Every Slide: This option saves every slide to an individual image
• Current Slide: This option saves only the current slide to an image
5. Choose relevant option to you
• Batch Processing the images
1. I have seen one video from youtube and I was impressed with the Irfan View working with batch processing of images
2. Please see the below video and do the batch processing of images
• http://www.youtube.com/watch?feature=player_detailpage&v=Z_eEKD8AJz0
• Uploading images to PPT
1. (MS Office 2007) Click on "Insert" tab and select "Photo Album" -> "New Photo Album"
2. Select the image(s), which you would like to add in the presentation.

This kind of approach makes our lives easy.


If you have any queries, please mail to psrdotcom@gmail.com