Category Archives: Tutorial

Archives of basic tutorials from microsoft office apps to photoshop cs, limitless ideas.

How to pull the first letter of a word in Excel

Posted on November 11, 2010 by taragis

   Given that you have hundreds of records of employee names, and you need to take down their initials or make a list of email accounts in a given format. Here, we will learn how to extract a letter from a given … Continue reading →

Posted in Tutorial | Tagged , | 5 Comments

Create Windows 7 Bootable USB Drive

Posted on August 17, 2010 by taragis

A bootable flash drive is a flash drive that boots up when you start your system. Having a bootable flash drive comes in very handy if you ever want to install an operating system on your flash drive. Continue reading →

Posted in Tutorial | Tagged , | 5 Comments

Conditional formatting in Microsoft Excel

Posted on August 5, 2010 by taragis

Here’s another excel tutorial that will help automate the desired cells in the worksheet. Using the “Conditional Formatting”. I use my existing grading sheet, and do the conditional formatting: All grades below 75 will be in red color. Continue reading →

Posted in Tutorial | Tagged , , , , | 17 Comments

Simple IF Statement in Microsoft Excel

Posted on July 15, 2010 by taragis

This is a basic function that you can use if you want to automate some cell results in your excel sheets. 

Posted in Tutorial | 17 Comments

How to edit picture with large file size

Posted on July 9, 2010 by taragis

There are times that we really need to resize images taken from digital cameras. And there are number of reasons why we need to do it, whatever is yours, here’s the easiest and fastest way to do it. Right click the picture image and click “Open with”, … Continue reading →

Posted in Tutorial | Tagged , , , , , , , , , , , , | 6 Comments

How to edit a PowerPoint Show (.pps) file

Posted on July 7, 2010 by taragis

 Ok, you received this file. You opened it and it runs in full screen mode. You found some details that are inappropriate and you want to make changes. But how? everytime you open, it goes on full screen slide show. .pps is the extension … Continue reading →

Posted in Tutorial | Tagged , , , , , | 1 Comment

Play with your phone

Posted on July 6, 2010 by taragis

While talking to someone over the phone,  push the following sequence in tune to the song ‘Happy Birthday’     Customer: I have a huge problem. A friend has placed a screen saver on my computer, but every time I … Continue reading →

Posted in Tutorial | Tagged , , , , , , | 3 Comments

How to combine two cells in Microsoft Excel

Posted on July 5, 2010 by taragis

Assuming that you have a very large records in your excel sheet and you need to combine two of its cells Continue reading →

Posted in Tutorial | Tagged , , , , , , , | 6 Comments