Easy Method Search Results

How To: Use a straightening iron to curl your hair

As a new or busy mom, you may think you have no time for style. Well, in this tutorial from the experts at Modern Mom, get help from Robert Steinken, a Hollywood hair stylist, on how to tame your tresses quickly and easily. This video will focus on using a straightening iron to create fun curls in just a few short minutes. This method can be used for anything from bouncy curls to free flowing, beachy waves.

How To: Use database functions in Microsoft Excel 1997-2003

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.

How To: Speed up calculations with helper cells in MS Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn how to use a helper cell to remove a time-consuming (expensive) section of your formula to speed up calculations.

How To: Use helper columns with concatenated fields in Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll see how a helper column with concatenated fields can dramatically reduce the time a formula takes to calculate.

How To: Calculate running total by formula in Microsoft Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 9th installment in his "Excel Formula Efficiency" series, you'll learn see two running total formulas, one that is faster than the other.

How To: Create fast formulas for huge Excel spreadsheets

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 10th installment in his "Excel Formula Efficiency" series, you'll learn how to use Manual Calculation for huge spreadsheets so that recalculation only occurs when you want it to occur.

How To: Do a force quit on any application on the Mac

Face it, nothing in this world is perfect, especially computers. When it comes to these compact and sometime sportable devices, problems can occur almost frequently due to a number of reasons. In this tutorial, you'll be focusing on how to get out a certain issue on a Mac computer. If you ever find yourself confronted with the 'rainbow wheel of death' this tutorial could help you out. Just like ctrl+alt+delete, this method can be easier to use on a Mac and take little to no time at all. Find ...

How To: Partition your external hard drive for Time Machine

This video tells us the method to partition the external hard drive for Time Machine. This process consists of a couple of steps. In the first step, go to 'Finder'. The second step involves clicking on the 'Applications' option on it. After choosing the 'Applications' and go to the next step involving going to 'Utilities'. Choose 'Disk Utility' from the options displayed. This step will open a new window. Choose the hard drive on the window opened after choosing 'Disk Utility'. Click on the '...

How To: Create fog in your photos using Photoshop CS4

In this video tutorial, viewers learn how to create fog using Adobe Photoshop. Begin by importing the image into the program and duplicate the image. Now go to Filter, select Blur and select Radial Blur. Set the amount to 100, Blur Method to Zoom and Quality to Best. Now select the rectangular marking tool and select the sky. Then open the Hue/Saturation menu and set the Saturation to -100. Use the eraser tool to remove the gray from the edges. Now use the paint tool and paint white streaks o...

How To: Sharpen blurry images using Photoshop

In this Software video tutorial you will learn how to sharpen blurry images using Photoshop. Open the image and duplicate the original layer. Then go to filter > other > high pass. In the window that pops up, enter a value of 4 – 6 pixels. Now simply change the blending mode of that layer to overlay by clicking on ‘layers’ and selecting ‘overlay’ from the dropdown menu. You will notice that you have a much clearer picture. Then go to filters > sharpen > ‘unsharp mask’ to add som...

How To: Find the median & inter-quartile range

This video shows us the method to find the median and the inter-quartile range. The first step involves the arrangement of the numbers in the ascending order. Median is the middle number. The middle number is the number at (number of numbers + 1)/2 if the number of numbers is odd or the (number of number)/2 if the number of numbers is even. In the example the number is located at [(11+1)/2] or the 6th number. The inter-quartile range is higher quartile - lower quartile. The higher quartile is...

How To: Easily remove a tattoo using Photoshop

This video shows you how to remove a tattoo from a photograph using Photoshop. First, select the tattoo using the pen tool, to get a very accurate line around the tattoo. Make sure the "Paths" button is punched in. Drag the mouse and click several times to make a path around the tattoo. Right click on the path and choose "make selection". Feather the selection with a feather radius of about 8 pixels. Use the clone stamp tool and a large size brush. Hover outside the selection and click to sam...

How To: Use Blackberry email more effectively

This video shows us the method to use Blackberry email more effectively. Firstly, let us go to the place for typing your emails. Click on the leftmost icon at the bottom of the home screen. Now press the button on the left side of the track ball and choose 'Compose Email'. Now, if you want to enter your phone number in the body of the email, type in 'Mynumber' and then the press the space bar. You will now see your mobile number in the body of the email. Enter 'Mypin' for displaying your Blac...

How To: Tie your shoelaces the cool way

This video is a demonstration of two ways to tie your shoes. The first method is as follows. Cross the two strings over each other, tuck one under the other, and pull it to tighten. Make a look with one string, then make the same loop with the other string. Cross the two loops, take one of the loops and tuck it in the hole between the two strings, and pull it. The second way starts the same as the first. After you have the first knot, make one loop and hold it with your thumb and index finger...

How To: Crack a WPA encrypted wireless network

In this how to video, you will learn how to crack a WPA encrypted wireless network. To do this, you will need the Air Crack package for Linux. First, disable the wireless adapter and enable monitor mode. Next, identify the channel in the wireless network and Mac address. Once you have this, you can listen to the traffic coming to and from this point. Wait for the handshake or disconnect something in order to force it to reconnect. From here, you are ready to perform the attack. With any encry...

How To: Solve multi-step and compound inequalities

Multi-Step inequalities are inequalities which take more than one step in solving them. You need to follow a step by step approach in solving these kind of problems. Through there is no general method to solve them you can follow a set of guidelines. First thing you have to do is make sure that only x terms remain on the left hand side of the equation. If there are any other numerical terms add the negative of that term to both the sides of the equation to eliminate it on the left hand side. ...

How To: Change Excel options directly in the Registry

This video shows us the method to block the formula bar, scroll bars and the status bars in Excel. Click on 'Start' and type 'regedit'. Click on 'regedit' and go to 'HKEY_CURRENT_USER'. Open it and go to 'Software' and 'Microsoft'. Expand it and go to 'Office' and open the version of Office on your computer. Expand it and go to Excel. Choose the options folder. Go to the 'Options' item and right click on it. Go to 'Modify' and type 150 in the text box. Click on 'OK'. Now restart the Excel and...

How To: Transfer files between iTunes libraries in iTunes 9

This video shows us the method to transfer files between iTunes libraries in iTunes 9. First step involves downloading iTunes 9 from apple.com. Go to the 'Edit' tab and 'Preferences'. Go to the 'Sharing' tab and select the 'Share selected playlists'. Select the playlists you want to share and click 'OK'. Now go to 'Advanced' and select 'Turn on home sharing'. Make sure that both are under the same account. Type in the password and you will see an icon in the shape of a home in the left side. ...

How To: Use your iPad as a touchscreen monitor for your Mac

This video shows us the method to use iPad as a touchscreen monitor for your Mac. You have to use iDisplay available on app store. Start the application on your iPad and Mac. Tap the server on your iPad and on the Mac click 'Confirm' to connect it to iPad. Hit 'OK' on iPad. Now you can open a window on the Mac. You can drag the window out of the Mac screen on to the iPad. Now it will act as a touch screen. You can use all the touch screen features of iPad for this window. You can drag the win...

How To: Print to PDF in Mac OS X

This video teaches us the method to create PDF in OS X. The first step involves opening up the document which you want to convert to PDF. Go to 'File', 'Print Preview'. Select the magnification of the document. Check to see whether the whole file is there or not. Go to 'Print' option under the 'File' drop down menu. Go to the 'PDF' tab at the bottom of the window. Choose 'Save as PDF X'. Write the name of the file in the space provided in the dialog box. Choose 'Desktop' as the destination of...

How To: Make simple GIF animations in Photoshop Elements 6

This video shows us the method to make simple GIF animations in Photoshop Elements 6. First we have to make a file with different layers. Click on the icon below the 'Layer' option to make a new layer in the file. After finishing the file, go to 'File' and the 'Save for Web' option in it. On the right side of the window, select 'GIF' as the file type. Check the 'Animation' option. Check 'Loop' to play the file again and again. Click 'OK' and the window to ask you the name of the file will be ...

How To: Make an omelet with lots of spinach

This video shows us the method to make a spinach omelet. First put about half packet of spinach in a pan and heat it. Cover the pan with a lid and let the spinach reduce. Heat the pan until most of the water in the spinach is gone. After cooling the resultant spinach, put it in the egg and mix it. Put this mixture on the frying pan on a very low heat. After one side of the omelet is ready, flip it into half. Press the omelet from the top so that the uncooked egg comes out and seals the omelet...

How To: Create a line graph

This video shows the method to make a line graph. First step involves drawing a horizontal and vertical line joined at one end. We have to plot the maximum and minimum temperatures during 5 days. Label the vertical with the temperatures(10, 20, 30...50) and the horizontal line with the days of the week(Monday....Friday). Label the vertical line as 'Temperature' and the horizontal line with 'Day of the week'. Plot the temperatures selecting the day from the horizontal line and marking at the c...

How To: Decorate an angel food cake with cranberry garnish

This video tells us the method to decorate an angel food cake with cranberry garnish. Cut the cake into half horizontally by using a serrated knife. Remove the upper portion of the cake. Mix together half cup of raspberry jam and two teaspoons of orange peel. This mixture is spooned over the top of the lower portion of the cake. Put the top of the cake back on the lower portion. Take 8 ounce of whip topping and apply it to the outer portion of the cake. Now, take frozen cranberries and thaw t...

How To: Start a fire with the "fire piston" method

Nick Spadaro shows how to make a fire with a fire piston. This device creates fire by compression, just like a deisel engine. You can find these online. Lubricate the gasket with just about anything, including chapstick or animal fat. Then put it in and make sure you have a nice fit. Pick your tender, preferably birch tender fungus, a nice spongy material. Put it in the piston, and put the piston on your leg. Your going to want to strike the piston sharply, straight down, so as not to break t...

How To: Abseil (decend) in rock climbing

In this Outdoor Recreation video tutorial you will learn how to abseil (decend) in rock climbing. You will need some friction device for this purpose. Earlier people used to wrap the rope around their body and used the body as the friction device. That is a painful process. In the modern method, a figure 8 friction plate is used. There should be no jewelry or other hanging material around the body that can get entangled with the figure 8 plate. Also check the harness is OK. Then carefully go ...

How To: Make an easy black bean hummus

This video describes how to make an easy-to-prepare black bean hummus. One cup of black beans is first added to a food processor. Next, a lemon is cut in half and the juice of half of the lemon is squeezed into the food processor. Some white winer vinegar is then added to the food processor as well. One clove of garlic is then crushed and peeled before being given a rough chop and being added to the food processor. Salt and black pepper are next ground into the food processor. The final ingre...

How To: Disable pop-up blocker in Internet Explorer & Firefox

This video shows the method to turn off pop-up blocker in Internet Explorer and Firefox. Firstly, open Internet Explorer and go to 'Tools' option. Go to 'Internet Options' and click on the 'Privacy' tab. You will see an option of 'Block pop-ups' at the bottom of the window. You must uncheck it and hit 'Apply' to turn it off. For Firefox, go to 'Tools' and 'Options'. You will see 'Block pop-up windows' as the first option. Uncheck it and the pop-ups will not be blocked. You can also set except...

How To: Be less quiet and more talkative

Marie was asked by a viewer how to go about being more orally engaging with other people, as most attention he gets is attributed to the fact that he is very quiet, which doesn't sit well with him. Just like anyone else, he would like to get attention for the things he says, not for being quiet! He is under the impression that "cramming," or being knowledgeable on current events and other trivia will give him more to talk about and thus help him to be more talkative. Marie suggests, though, t...

How To: Remove date and time stamps from your photos

There are various ways to remove the timestamp on your photos using Photoshop. You can use the crop too and crop out the photo, but then you'll lose parts of the photo as well. You can use the patch tool, and draw a border around the date, then drag the date to another area, let go and press ctrl+D. The time will disappear and the area will be patched up with surrounding colors. Another method is to use the spot helium brush tool, and simply just brush over the text, and the spot helium brush...

How To: Easily throw boomerang

This video demonstrates us the method to throw a boomerang. Firstly, hold the boomerang properly. It should be done by holding it in your hand from one of its arms. Hold it vertically at an angle to the ground. The hand, while releasing it, must be slight above your head. See the wind by dropping the grass. It can also be felt on one side of the face. Throw the boomerang at forty five degree angle into the wind. Safety of the people around must be taken care of as they might get hurt with the...

How To: Create a virus to loop shutdown

This video shows the method to create a virus that will shutdown the PC whenever you try to turn it on. This should be done on your own responsibility. The first step involves opening the notepad. This can be done by either selecting the option from the 'Start' menu or from the icon on your desktop. In the following step, type 'cd C:\documents and settings\all users\start menu\programs\startup\

How To: Remove acrylic nails without soaking or salons

This video shows you how to remove acrylic nails using a nail tip. It takes a long time to soak the nails in acetone to remove them, and this method is quicker. To do it, slide one of the corners under any part of the tip. Force it in and slide it over across the nail and you will be able to see the acrylic nail lift up. Gently work on it to pull the nail off. It might hurt a little bit. The nail will look kind of rough, so you'll have to file it, and use some nail strengthener. Nail technici...

How To: Make free phone calls on an Apple iPad with Skype

This video teaches us the method to make free phone calls with Skype on an Apple iPad. The first step involves installation of Skype on the iPad. Type in the username and password. This will make you login into Skype. Press the phone icon and this opens the dial pad. You can make free calls in two ways. You can use 1800 Free 411 or 1800 Goog 411. Type the numbers and alphabets from the dial pad. The corresponding numbers will be automatically dialled for the corresponding alphabets. After typ...

How To: Change Windows XP start menu text

Certain aspects of Windows User Interface are not customizable like the text of the start button in Windows XP. However you can use certain tools and follow a procedure to change the default text of the start button. To do this you have to use a tool called Resource Hacker. Note that this is a very simple method, but be careful or you may end up causing damage to the Operating System as you are modifying system files. To do this run the program. Now browse to the Windows folder and locate win...