Expected Record Search Results

How To: Use the INDEX & MATCH functions in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 45th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the INDEX & MATCH functions.

How To: Walk on crampons in ice mountaineering

In this how-to video, you will learn the basics of walking in crampons in the North Cascades. Put on your crampons if you expect ice. If the snow is soft, you can kick-step in. Make sure you have two points of contact. Use your ice axe in the snow and then step and kick. Lift and place the ice axe in front of you and step and kick in. Keep on doing this. Another technique you can do is step side ways along with the axe. It is the same process except stepping sideways instead. Make sure all th...

How To: Make a keylogger

This video tutorial instructs you on what a key logger is and how to make a key logger which records your computers key strokes for later review. There are software or hardware based key loggers that intercept the connection between the keyboard and computer. Hardware key loggers consists of a micro controller for data logging. Software key logger is a script that runs in the background then processes and saves the key strokes to a text file. To make a key logger you'll need to know a program...

Walkthrough Assassin's Creed 2: Glyph Puzzle 17

Figure out the 17th puzzle, entitled "The Bunker", in Assassin's Creed 2. Code wheel puzzle: Here’s a tricky one; your clues are “<” and “2,” and the only advice you’ll get from your handlers is that maybe there’s “something we can count” on the strange symbols. In this case that “something” is the number of times each symbol bends sharply. Don’t expect consistency across the wheel on this one; just take a look at what symbols flank the blank spaces and pick a shape with the number of bends t...

Walkthrough Assassin's Creed 2: Mission 61

Caged Fighter: Make your way across town and you'll find an injured soldier on the rooftops that gives you some new information on finding Bartolomeo, who should in turn help you with Silvio. You get a large green area added to your map, but note that it's overlapped by a restricted area. Expect trouble.

Walkthrough Assassin's Creed 2: Mission 56

And They're Off: Time's crucial in this missions, so be careful. You've got a limited amount of time to complete this fairly challenging obstacle course. A series of waypoint show up one after the other, and you've got to run through all sixteen of them, quickly. The first four are on ground level, so you don't waste time climbing any buildings. The fifth waypoint will start you on an ascent up the side of a building, and from then on you can expect next bunch to require some careful platform...

How To: Deal with a flirtatious boss or sexual harassment

He's not exactly demanding sexual favors, but his flirting is getting really gross. What's a girl who likes her job to do? You will need diplomacy and documentation. Assess his behavior. Now, don’t be offended, but we have to ask: Is he really coming on to you, or is he just a sociable, flirtatious kind of guy? If it’s the latter, just ignore it. Do your part to keep the relationship professional. Don't chat about how your last two boyfriends cheated on you and then expect him to know that di...

How To: Use old tennis balls

Tennis balls aren't just for playing tennis, so when you are getting ready to trash those tennis balls… DON'T. There are many different uses you can find for them, from donating them to fluffing up laundry. Recycle them using these 7 helpful tips.

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: Hide thick legs

Let's face it, not everybody's perfect. But that doesn't mean that everybody is special or beautiful. But for those of you without the thin, lengthy legs, there's hope for beating your insecureness. Lengthen the look of your legs with your attire and show off your bashful thick legs.

How To: Use the Cardio Trainer app on an Android cell phone

Staying in tune with the digital age doesn't mean you have to sacrifice personal health. In fact, new technology only makes it easier to workout and keep track of your progress. On any Android mobile phone, there's an application called Cardio Trainer that could help you out significantly. But how? Best Buy has answers. The Best Buy Mobile team explains how simple it is to use the Cardio Trainer app your Android enabled cell phone.

How To: Fold durable paper ninja stars

This tutorial demonstrates how to make Ninja stars out of 2 pieces of lined notebook paper. Lined paper make your star look cooler and help you keep track of your folds. Fold you paper into five equal sections with a small section left over at the top. This is about five and a half lines per section. Next fold over one corner of the edge that is farthest away from you and then fold over the corner of the opposite edge. Set this paper aside. Repeat the process with your second sheet of paper e...

How To: Make a LEGO stop-motion movie

In this how to video, you will learn how to make a LEGO stop motion movie. First, you must create your set. The base plate must be taped down to the table or a hard surface. To create the animation, move the LEGO man's leg and take a picture. Move it again and take another picture. Keep on doing this until he reaches the destination you want. The more pictures you take the smoother the video will be. To edit the animation, import it to your computer and open up your movie editing program of c...

How To: Crumb coat a cake

Leif Hanson for the Betty Crocker Kitchens shows how to crumb coat a cake. This is when you put a thin layer of frosting on the cake to hold the crumbs in. She starts with a square cake with exposed edges. First, you take a big scoop of frosting and put it on top of the cake. Next, you spread it around with a spatula. As you spread it evenly you want it to go over each edge and corner, but don't let the corners sag. Next, she loads the spatula, fills it from the top edge to the bottom edge, w...

How To: Make videos that mix live action with video

In this how to video, you will learn how to make videos that mix live action with video. First, set up the camera in the back of the room. Zoom the camera in where the white area is. Once the camera is running, go in front of the screen and perform actions. Next, play the video so that it projects on to the screen. You can hide and interact with the surroundings so it looks like the person on screen is doing the actions in real life. You can also interact with your shadow by careful editing. ...

How To: Resize an image in Adobe Photoshop to submit to Alamy

In this how to video, you will learn how to re-size any image in Photoshop to submit to Alamy. You will need the file to be 48 megabytes and uncompressed. First, open the image in Photoshop. At the bottom, you will see the current image's file size. Now go to image and image size. Increase the size by two or by five percent. Make sure re-sample image and constrain proportions are selected. Make sure bicubic smother is selected at the bottom of the window. At the top of this window, you will s...

How To: Properly set up a turntable

Paul demonstrates to viewers how to properly set up a turntable. Each turntable has the same basic parts, so this tutorial should work for most users. There are several components: the platter is the part that spins and it has a slip mat on top. The tone arm is to the right and it has a head shell and stylus cartridge (needle) mounted on the end. The queueing lever is at the base of the tone arm and it raises and lowers the tone arm base. There is also a VTA (Vertical Tracking Angle) adjustme...

How To: Graph x & y intercepts on a TI-84 Plus calculator

In this video the teacher shows us how to use a TI-84 plus graphing calculator to graph a function, adjust the view window, and determine the values of several types of critical points on the graph such as x-intercept, y-intercept, local maximums, and local minimums. After entering the function in the Y= editor she presses the ZOOM button and selects Z-Standard this adjusts the view window to a range of -10 to 10 on both axis. To find each of the critical points requested the teacher uses the...

How To: Burn SVCDs and DVDs in Magix Movie Edit Pro 15

This video tutorial from Magix presents how to burn (S)VCDs and DVDs using Magix Movie Edit Pro 15 application.First you need to group videos you want to burn.If you want to play movies using remote control you have to place chapter markers. You can set markers manually or choose automatic? marker setting which places markers before each new scene.Once all chapter markers are placed, click Burn button.Here you can choose Start Menu Templates. To change movie titles and chapter headings double...

How To: Make a microphone wind screen for a Zoom H2

For anyone who has ever used a microphone, trying to record something during a windy day can be a bit of a pain. Of course we can eliminate most of the interference with a simple wind screen that can be purchased at the store, but many times they can be a bit pricey. Well, in this tutorial find out how to make your own wind screener for a Zoom H2 mic. Enjoy!

How To: Make a mini cupcake polymer cake mold

Use the tread on wire-nut, to create a mold for mini clay cupcakes. Usually used for joining together electrical wires, the repeated lines of the wire-nut will here be used to form the ridges expected on a cupcake bottom. Press the wire-nut into a small piece of clay to form a depression just as big as you want your finished cupcake to be. Bake in the oven to solidify into a mold. Dab the dried mold with a bit of cornstarch or baby powder; this will prevent fresh clay from sticking to it too ...

How To: Edit footage from a Canon 7D at 1080 24p using Avid

The video shows us how to edit footage from Canon 7D at 1080/24p using Avid Media Composer. Canon 7D is first of the video DSLR which is actually an easily editable of an Avid media composer. If you are shooting a project at 1080 24P, then Canon 7D records the footage at 23.98 which is perfectly compatible and tested with Avid. Firstly create a new 1080/24P project. Now import footage from a CF card in DNxHD codec. Then edit the time line in real-time apply the real-time effects but here the ...

How To: Use MIDI in Logic Pro 9

This Lynda tutorial teaches how to use the Logic pro, a songwriting application. Midi sequencing and quantizing is the main focus of this video. Midi is a short name for Musical instrumental digital interface. Midi is not sound. It is a low resolution computer protocol, developed in early 80’s to enable computer to communicate each other. Midi is fast, simple and reliable. It has a intensity stream. In this project, Scot Hirsch explained how a midi file is manipulated in Logic pro. Midi file ...

How To: Get an FHA loan

Looking to get an FHA loan? The Federal Housing Administration, FHA for short, provides mortgage insurance on loans made by FHA-approved lenders throughout the U.S. Here's how to get your FHA-insured loan. Learn how to get one with help from this video.

How To: Get a Canadian work permit

To obtain a work permit, you must first have a job offer from a Canadian employer. To get a job offer, you can apply directly and send your resume to a perspective employer, use an employment agency, or post your resume on employment websites. Next, you must have a labor market opinion. To get an LMO, you have to fill out some forms and submit some supporting documents. This process can take from a few weeks to 6 months to complete. After the LMO is approved, you must then apply for a work pe...