Specialists Learn Search Results

How To: Perform a general shoulder exam on a patient

In this video lesson for doctors, you will learn how to do a shoulder examination. First, you'll get a review of the procedures for evaluating any joint, and then jump into the basics of inspection of the shoulder, then learn palpation, and range of motion. This is a very general shoulder examination, meant to serve as a refresher course for those medical doctors or medical students who already know the exam procedure.

How To: Access Android tethering on the HTC EVO 4G

One of the coolest features of the new Android phone, HTC EVO 4G is its ability to tether the Internet. In this clip, learn how to access and set up tethering, as well as which apps work best. You will also learn how to use Sprint's 29.99 Hot Spot plan, or bypass the charges by setting up free options. So, follow along and get your phone up and running with the new lightning fast 4G network.

How To: Remove a radiator in your home

In this clip, learn how to remove a radiator in your home. If you have a broken or faulty radiator that needs to be replaced or are getting rid of the thing altogether, check out this clip from the Ultimate Handyman. In this clip you will learn the essential steps you need to take to remove a radiator from a central heating system and cap off the thermostatic valve, this is important as it is often missed by some people.

How To: Dominate the challenge rooms in Batman: Arkham Asylum

In this clip from IGN, learn how to dominate the challenge room in Batman: Arkham Asylum. This video will give you some essential do's and don'ts to survive Story Mode in this game. You won't be able to complete the game 100% until you've completed all 16 maps and in this clip you will learn the easiest and fastest ways to do that while staying alive.

How To: Style a boho summer updo for the beach

In this video, learn how to make a cute summer updo whether you are heading to work or the beach. This look is stylish, boho and great for keeping your hair away from your face in the summer sun. So, follow along and learn how to create a braided headband/braided bun intricate updo in just a few minutes! Have a great summer!

How To: Repurpose an old skirt into an oversized tote bag

In this video, learn how to take things you find in thrift stores and repurpose them as cool, new items. In this clip, you will learn how to cut up a frumpy old skirt and turn it into an adorable, stylish oversized tote. This is a fun project that costs just a couple of bucks and will become a unique bag you will love for years to come!

How To: Graph trigonometric functions

Learn how to graph the amplitude and periods of sine and cosine functions in basic trigonometry. Learn how to use trigonometric functions to calculate the sides of a right triangle. Need to know how to solve a matrix-form linear equation in algebra? From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your h...

How To: Dynamically load external images and SWFs in Flash

Interested in loading external images and SWF files in Flash? Learn how with help from this video. Learn how to load images and SWF files that are not actually in your Flash document dynamically using Actionscript 3.0. This can be especially useful if you are creating a website or gallery with a lot of content as it gives your website user control over what actually gets loaded. Learn everything you need to know about how to accomplish this in this free Flash tutorial.

How To: Calibrate your jointer

You will to learn set up and calibrate your jointer for optimal woodworking and creating a clean and straight edge on a rough board to later use as a reference. You will also learn a system on how to set up your knives to achieve the perfect cut using a jig and how to select the best jig to work with.

How To: Dance advanced style salsa moves

In this episode of Addicted to Salsa, you will learn some advanced club style salsa moves. These moves are similar to the most popular ones found in New York City's salsa nightclubs. So, if you are ready to add some Latin flair to your dancing, have a look at this tutorial.

How To: Retrieve multiple values from a horizontal Excel table

hether 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 21st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the HLOOKUP and ROWS function to retrieve multiple values from a horizontal table.

How To: Filter data in eight different ways in Microsoft Excel

hether 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 17th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to filter spreadsheet data using eight different methods.

How To: Reference worksheets and workbooks in Excel formulas

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 6th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create worksheet and workbook references in formulas.

How To: Multiply & sum arrays with Excel's SUMPRODUCT

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 37th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with MS Excel's SUMPRODUCT function.

How To: Create projections for sales numbers in MS 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 10th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a percentage increase formula.

How To: Create a basic array formula in Microsoft Excel

Looking for a primer on how to create and work with arrays in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the very first installment in his series of Excel array formula series, you'll learn how to create a basic array formula. Learn about the syntax, the Ctrl + Shift + Enter method of formula entry and the curly brackets that get entered automatically by Excel.

How To: Use Microsoft Excel's Goal Seek tool to modify inputs

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 103rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use Goal Seek to change a formula input number so that the formula is a desired result. Also learn how to use the PMT function.

How To: Create an average with multiple criteria in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 91st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an average with multiple criteria using pivot tables (PivotTable). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Create an Excel inventory template with running totals

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Evaluate vendors with array formulas in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 63rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an array formula to find the vendor with the maximum rating and the lowest cost Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Count unique records exceeding a hurdle in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 54th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count records exceeding a given hurdle using Excel's advanced filter tool. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Prevent duplicate entries in an Excel spreadsheet

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 41st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a true/false formula with the COUNTIF function to prevent duplicate entries in a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Calculate plate cost for a print shop in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 47th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to calculate total plate cost for a print shop using the VLOOKUP function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Make a long stem rose out of duct tape

Learn how to put that roll of duct tape to use with help from this tutorial! In this video, learn how to make a long stemmed rose out of duct tape... Perfect to surprise a girlfriend or boyfriend with to show them how much you care. Make unique duct tape gifts and hone your duct tape skills with guidance from this instructional!

How To: Do a Pop Tornado freerun trick

In this video tutorial, viewers learn how to do a pop tornado free-run trick. The pop tornado is the same as a tornado kick except he pop tornado does not have that extra step. Because there is no step, this move is more difficult to perform. Users should learn how to do the tornado kick before attempting this move. Start with a wide leg stance and turn the body. Then do a hook kick and set the feet down. Now quickly jump as you pull your arms in and spin the body. Lift the knee up. This vide...

How To: Make a bicycle wheel windmill

In this video, you'll learn how to make your very own bicycle wheel windmill. This completely recyclable creation which can easily be made from that old bike that's just been rusty away. Put it to good use and make this great eco-friendly windmill. Step by step you'll learn exactly what to do to make this windmill spin.

How To: Ollie on a skateboard, for beginners

It takes most everyone a long time to do an ollie but once you have it done it happens all the time. When first starting out it is a good idea to learn the technique in the grass or on some carpet so the board doesn’t roll around. It’s also a good idea to fully learn the ollie in place before you start doing it in motion. Next is foot placement, have your front foot right behind the front bolts on your skateboard and you back foot on the tail. When you press the back foot into the ground lift...