Carefree Shifting Search Results

How To: Discipline your toddler without spanking

At one time or another, every parent has thought about taking off the belt, but that's frowned upon in our current society, perhaps even illegal. Even using you hand could be too harsh for the child's sake, but there are ways to get your unruly tot under control. Toddlers are often headed for trouble, but you can steer them in the right direction without spanking.

How To: Find & extract duplicate records from a data set

This video is about finding duplicate entries in excel sheet. The example excel sheet contains different names. There are around 1000 different names in the sample excel sheet. CountIf(range,criteria) formula has been used to do the comparison and return of results in True or False mode. Type =CountIf( now move your left arrow key, this will generate the formula like =CountIf(A2. Now press Ctrl+Shift+Down arrow, this will select all the available values in the column. Now press F4 to lock it ...

How To: Retouch or add digital makeup using Photoshop

If you want to retouch or add digital make up using Photoshop you should first erase and cover up any blemishes you see on the surface of the skin. This can be bruises, blemishes, or even acne marks and bumps. Do this anywhere you feel necessary such as the face or on the body. Using the lighten tool, you can also lighten the eye color as well as the whites of the eyes. Next, you can also adjust the texture and color of the lips. You can also shift the color saturation of the picture to add r...

How To: Change car rims and increase the size in Photoshop

In this how to video, you will learn how make car rims bigger using Photoshop. First, open the image in the program. Choose the elliptical marquee tool and select the rim. Next, right click the selection and click layer via copy. Now you should have the cut out rim in a new layer. Drag layer 1 bigger by holding shift. Replace it and then click on the accept button. Erase the part of the rim that is on the body of the car with the eraser tool. Have layer 1 selected and merge it down. Do the sa...

How To: Make a photo black and white with colored parts

This video teaches us to make a photo black and white with coloured parts in Photoshop. This procedure consists of many steps. In the first step, we choose the magnetic lasso tool from the application. This is followed by the second step. In the second step, we draw the contours of the places we want to stay colored in the photo. Press the 'Shift' key to keep the contours selected while drawing contours across multiple places in the image. After drawing the contours, go to step three. Right c...

How To: Create collapsible and expandable cell ranges in Excel

This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...

How To: Make a real 3d text in Photoshop

This video shows how to make a real 3d text in Photoshop. First open up Photoshop. Create a new document File > new. Then select width then OK. Fill the background with black. Then go to the text tool and write whatever we want. Choose a font with fat letters. Right click on the text layer and go to "Blending options". Then edit the text in our way. We can create a Gradient Overlay, Contour, Stroke and Outer Glow. We can add any effect we want. Again right click on the text layer and click "R...

How To: Make a party balloon Christmas tree

First of all you have to take a plane wooden board which is about one foot and square shape, and place it on the floor. There should be a holder in the middle for inserting the rod. Now take a rod which is about four feet in length, and then insert it in the holder. Now use a tape and stick the rod firmly to the holder. Take two red color balloons and two blue color balloons which are joined at their ends. Now pass over these balloons two or three times at the ends so that the red and blue ba...

How To: Make a brushed metal effect in Photoshop

In order to make a brushed metal effects in Photoshop you should first go to your gradient tool and select a dark grey or a black and click okay. Shift and drag your mouse to create the gradient. Next, go to filter, Noise, and then add noise and change the percent to 40% and click okay. Now, go to blur and ocean blur and change the angle to 0 and distance to 100 pixels. Now, for the sides to look like brushed metal, crop those sides out. Now you have a metal effect. To make a screw, click on ...

How To: Make a lightsaber image using final cut express

In this how-to video, you will learn how to make a light saber or similar image in the Final Cut Express program. First, go to the effects tab and go to video generators and select color solid. Drag this to the viewer. Go to the control tab and select the blue color. Now drag it to the time line. Double effect the color solid and go to mask shape. Select filters and change the effects settings to 2.5 horizontal scale. For the vertical scale, select 75 to 85. Go to the effects, video effects, ...

How To: Simplify exponential expressions in basic algebra

The video shows how to solved mixed property problems using the exponent rules. See if there are any rules you can apply to the problem until you get to a point where you can't simplify anymore. The instructor shows in the example problem that the two bases are the same, but there is extras happening the numerator. The power to power multiply rule is applied removing the extra issues from the numerator. Next the quotient rules is applied as there is the exact same base to the power so we keep...

How To: Properly focus your video camera

This video shows you how to properly focus your video camera. Usually cameras have two focusing modes, manual and automatic. Despite the sophistication of modern cameras and their auto focusing modes, manual focusing still gives the person operating the camera the most control. To focus in manual focusing mode you must first focus your eyepiece. To focus your eyepiece fully zoom in on your subject, then rotate your lens' focus ring until the subject becomes sharp and clear. Finally rotate you...

How To: Do text effects in GIMP

Click in File and New to create a new document, press OK and select the text tool and click once on your file and write something, then close the window. Click in move the active layer to make easier to move the text. Go again to the text tool and click on the Color to change the text color. Press Crtl+O, select the background layer and change the color to the one you want, now select the bucket tool and click on the background to paint it with the color you have selected. Go back to the text...

How To: Arrange paths in Illustrator

Objects used in the tutorial are available free at the website preceding this description. The project here involves two groups of paths. You will be shown three ways to change the order of these groups. Go to one of the groups and right click on the mouse, in the menu that comes up choose Arrange, and within the next box choose bring forward. This works with either group. Go to the other group, right click, choose Arrange, then choose bring forward and now this group will appear ahead other ...

How To: Vacuum your car

Just like your living room rug, your car’s carpeting needs a thorough vacuuming now and then. Watch this how to video to learn how to vacuum your car. Don't pay those car wash prices!

How To: Transfer Your Spotify Playlists to Apple Music from an iPhone or Android Phone

Music streaming services make it difficult to transfer your favorite songs and artists from one service to another and for a valid reason: they don't want you to leave. But when it comes to switching, playlists are a big concern, because who wants to do it all over again? Luckily, if you're moving from Spotify to Apple Music, you can use a third-party app to take playlists with you.

How To: Downgrade an iPhone to iOS 7.1.2 from iOS 8

There are a lot of great new features in iOS 8, but not everyone is enjoying them. Some of you may just genuinely prefer iOS 7 over iOS 8, and some of you may be experiencing lag on older devices like the iPhone 4S, however minimal it may be. Whatever the reason, if you don't want iOS 8 on your iPad, iPhone, or iPod touch, there's still time to downgrade back to iOS 7.1.2.