Category Archives: How To

How to Incorporate Slides in Skype

Skype is software that enables you to make free calls anywhere in the world. Skype uses P2P (peer-to-peer) technology to connect you with other users. It offers several features, including SkypeOut calling from Skype to regular and mobile phones worldwide, conference calling, and secure file transferring. Here is the instruction to tell you how to incorporate slides in Skype.

1
1. Download and install Skype from here:

http://www.filepuma.com/download/skype_7.1.0.105-8046/

2. Run Skype and select the person you want to show the slideshow to from your contacts list.

3. Click the “Call” button.

4. Get ready your slideshow. Click the “+” button at the bottom of the screen to start the slideshow.

5. Select “Share Screens” and click “Start” when asked whether you should start sharing your screen.

6. Now your contact could see every action on your screen. Start your slideshow.

7. Click “Stop Sharing” at the top right corner of the screen to end the screen-sharing.

How to Make All Words Capitalized in Excel

Microsoft Excel is a great program which can let you arrange data in a spreadsheet easily and quickly. However, it can be quite annoying to edit all the text to be capitalized. Is there any short cut for us to operate this? Here is the instruction to tell you how to convert the text automatically.

excel1
1. Open your spreadsheet with Excel.

2. Identify the area of the spreadsheet you want to capitalize. Write down the coordinates of the top left cell.

3. Scroll to the right blank and then select an empty cell.

4. Enter the following formula in the cell:

=PROPER(“the coordinates of the top left cell you just wrote down”)

Click “Enter” to confirm.

5. Select the cell and click the small square in the bottom right corner of the cell, drag down until all the spreadsheet you want to edit.

6. Click the small square again and drag to the right until all the spreadsheet you want to edit.

7. Hold “Ctrl+C” to copy the formatted text. Go back to the area that contains your original text, right click and select “Paste Special” and then click “Values” to paste the formatted text over the original one.

8. Delete the group of cells you used to generate the formatted text.

How to Add a Template to Scribus

Scribus is an Open Source program that brings professional page layout to Linux/UNIX, Mac OS X, OS/2 Warp 4/eComStation and Windows desktops with a combination of press-ready output and new approaches to page design. Templates helps provide uniformity to multi-page documents. Here is the instruction to tell you how to add a template to Scribus.

Scribus-1.3-Linux
1. Download and install Scribus from here:

http://www.filepuma.com/download/scribus_32bit_1.4.5-8073/

2. Select a layout from the “Document Layout” list, and then you could click “OK” when the “New Document” window loads, or click on the “Open Existing Project” tab to load one.

3. Click “Edit” and select the “Master Pages” option. The “Edit Master Pages” menu will appear, now you could click on the “Import master pages from another document” option.

4. Click on the “Change” button in the “Import Master Page” menu. Select Scribus template filand click on the “Import” button to load it.

5. Select the “Apply Master Page” option from “Page” menu.

6. Insert the template into the page you want.

7. Click “OK” to apply the operation.