Tips Yang Search Results

How To: Fight as Amaterasu from Okami in Marvel vs. Capcom 3

Okami was one of the best games of the last decade, perhaps Capcom's finest, and it's heroine Amaterasu makes a much-deserved appearance in Marvel vs. Capcom 3. She isn't quite as powerful as you'd expect the God of Everything to be, but she kicks serious butt and this video will teach you the basics of fighting with her, including tips on all her normal attacks and special moves.

How To: Shoot at night when using a DSLR camera

One task to which DSLRs are particularly well suited is nighttime shooting. Fast, wide-aperture lenses make the most out of available light. In this video tutorial from renowned DSLR cinematographer Philip Bloom and the staff of Vimeo, we receive some tips on how to film at night using, for example, a Canon 7D, T2i (550D) or 5D Mark II.

How To: Make a Call of Duty Black Ops player card / emblem

Your Call of Duty Black Ops custom player card / emblem is the first thing that a potential opponent sees about you, and you should be proud of it. This video will give you some great tips that will help you make any emblem you choose to make look sharper, less flat, and overall just plain more badass. The example made in the video is a cool star, so if you wanted a star you're even luckier!

How To: Make children listen with their "listening ears"

In this video from CullensAbcs we learn a tip for how to children should listen with their "listening ears." This is taught by a girl and a gator puppet. She says to ask children to put on their listening ears so they can hear a story you are going to read to them or if you have something that you are going to say. Children like doing these types of things. It's a great tip to use to get your child to hear what you have to say. They can also make a sound when putting on their listening ears t...

How To: Prevent eyeliner from smudging with tips

Makeup always looks good when it's freshly applied. The problem, however, is that most of us apply that makeup in the morning and don't get back until 7 at night, meaning it's been on for about 12 hours. And if you happen to have a date or need to go out that night, your makeup is probably looking more Courtney Love than Camilla Belle.

How To: Troubleshoot and fix broken windshield wipers

If your windshield wipers don't come on when you turn the switch, then try out the solutions in this video! First, check to see if there's a blown fuse. If that's okay, next check the power going to the wiper motor. You have to take the wiper arms off to get to the motor. Watch Scotty Kilmer in this video for all the remaining troubleshooting tips for broken windshield wipers.

How To: Use four tricks to make your eyes look bigger

In this tutorial we learn four tricks to make your eyes look bigger. The first tip is to layer on a shimmery light shadow to the eyes and then add on a darker color to the crease of the eye. Curl the lashes and then apply mascara to the eyes after clamping and working up the eye. Next, take some false lashes and apply these to the outer edge of the eye. The lashes will give you a thick and luxurious look. Later when you go to take these off you just need to use simple eye makeup remover. Any ...

How To: Turn a Ctrl + Shift + Enter formula into an Enter array formula in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 52nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the INDEX function to turn a Ctrl + Shift + Enter array formula into just an Enter array formula. Avoid Ctrl + Shift + Enter by using the INDEX function and a blank as the row argument.

How To: Make a spooky smoking punch bowl for your Halloween party

Hosting your own party for Halloween this year and want to really set the tone for the party? Some people have one of those smoking punch bowls that are somewhat like a smoking cauldron. Looking to make the same effect? Well you will need to get some dry ice, but regardless of that, you should probably watch this video first to get the tips on making the proper smoking punch bowl with the right tips for safety and more.

How To: Calculate hours worked in a shift with a lunchbreak in Microsoft Excel 2010

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 727th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the hours worked in a night or day shift with a break for lunch given time number inputs using the MOD function.

How To: Light digital home videos like a professional

Shooting home video is fun, and is a great way to get started on the path to a film career. But one thing that can kill your video is poor lighting. Not everyone is rich enough to a professional light kit, so what do you do to compensate? In this video you will get some great low budget, and even some free, tips on how to create proper lighting both in-doors and outdoors and tips on what to avoid in your scenes.

How To: Shoot in a film noir setting

Film Noir, or black film, is a type of film that can easily be attributed to classics such as the Humphery Boggart films of old (Maltese Falcon, King of the Underworld, ect.). If you're looking on how to create the effect yourself without a big budget, check out this video! John Hess gives you some basic tips to creating the effect with lighting and more!

How To: Calculate weekly gross pay from time values in Microsoft Excel 2010

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 722nd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate gross pay for the week from time values using the SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.

How To: Avoid double-counting duplicates within a list in Microsoft Excel 2010

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 726th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SIGN, COUNTIF and SUMPRODUCT functions to count 1 for each item in a first list that's also contained in a second list.

How To: Build an effective first shelter in Minecraft

If you're just starting with Minecraft for the first time and seem to be failing at surviving through the first night, maybe it'd be a good idea to watch this video from Machinima! In this video you'll learn how to get started, harvest resources, create a work station, and other tips for survival.

How To: Identify the cause of a noise coming from your car

When cars start to get older, their many fragile moving parts start to make noises they never made before. Sometimes, when your car starts making a new noise, it can be very difficult to identify what is causing the noise and what you need to do to repair it. This video offers some great tips for finding the source of different kinds of car noises, from engine noises to suspension noises.

How To: Play power chords with a 5th string root note

Justin Sandercoe teaches us how to play power chords with a 5th string root note in this tutorial. Start out by placing your first finger on the root note and your third and fourth finger underneath. The tip of your fourth finger should be touching the sixth string. Push the tip of it up until you've trained it to always touch the sixth string, without this the song will sound terrible. Once you have the chord shape down, you will need to start to play some riffs. Move the fifth string root a...

How To: Change strings on the erhu

In this video, we learn how to change the strings on the erhu. First, loosen and remove the inner string. After this, take and unwind the new inner string. Then, take the end with the loop and put it through the Qianjing. Then, loop it in the screw at the bottom of the erhu. Then fold the tip of the other end of the string and put it through the hole in the first peg. Then, loop the string one and push the tip into the hole. Now turn the peg clockwise to tighten it. Repeat this for all the st...

How To: Compare a list of numbers where one group is entered as text in Excel 2010

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 719th installment in their series of digital spreadsheet magic tricks, you'll learn how to compare two list of numbers and see what happens when one list is numbers is aligned right and the other list is numbers as text.

How To: Create a data validation drop-down list from a table with duplicates in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 608th installment in their series of digital spreadsheet magic tricks, you'll learn how to to create an expanding data validation drop-down list from table with duplicates using a number of different tricks.

How To: Do more effective searches on Google

Google is the most powerful search tool in all the land, and there are all sorts of setting to tweak and tricks to use that can make your search results better and more relevant to you. This video features Google Webmaster Help video personality Matt Cutts outlining some tips and tricks for getting better answers to your Google queries, including changing the boolean of your search.