Placing Aims Search Results

How To: Perform a Cool Magician Magic Card Snatch Trick

Ever wonder how magicians can seemingly identify any card? Well, wonder no more! In this tutorial, learn how to identify a spectator's card when they randomly place it mid-pile. This sounds impossible and looks astonishing but, really, it is quite easy. So, follow along with this clip and you will learn all of the inside secrets to perform this trick on your very own.

How To: Use the TRANSPOSE & FREQUENCY array functions in 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 38th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the TRANSPOSE & FREQUENCY functions.

How To: Calculate subtotals 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 18th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to calculate (and sum) subtotals in Excel. See how to do subtotaling with the SUM function.

How To: Work with date functions (TODAY, NOW, DAY) 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've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 12th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the TODAY, NOW, DATE, YEAR, MONTH, DAY and EDATE functions.

How To: Record absolute and relative macros in MS Excel 2007

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 nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how (and when) to record absolute and relative macros in MS Excel 2007.

How To: Find and use VBA code 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 54th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to find, download and use VBA code in your MS Excel projects.

How To: Force a function to becom an array 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 39th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how if an array or range is put into a function argument that is expecting a single value, the function becomes an array and delivers an array of values instead o...

How To: Work with Microsoft Excel's order of precedence

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 24th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn see exactly how Excel calculates/evaluates formulas including things like intersections, unions, negation, text operators and comparative operators. Knowing the o...

How To: Get out of the map/demo barrier in the Skate 3 demo

In this tutorial brought to you by the guys at Achievement Hunter, you'll be finding out a secret in the Skate 3 demo. This video shows you how to get out of the map, or in this case demo barrier, into another skating area. This is the main place where you can find the infamous shark that is so difficult to jump. Enjoy!

How To: Value assets & analyze cash flows 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 50th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to value an asset as well as perform discounted cash flow analysis with the Excel functions PV, NPV & XNPV.

How To: Run advanced VLOOKUP queries 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 40th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to perform eleven VLOOKUP tricks including how to use VLOOKUP with the TRIM function to remove spaces from first column of lookup value.

How To: Set data up for sorting & filtering 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 14th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to set up data in Excel so sorting, filtering, subtotals and PivotTables (Pivot Tables) can be done easily.

How To: Fix common Excel spreadsheet problems & errors

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 25th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to interpret and resolve the nine most common Excel formula errors — namely, ####, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Reference, and #NULL!.

How To: Import different types of data 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 23rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to import data into Excel from text files, web sites, Excel files and Microsoft Office Access files. Also see how to import currency rates and major indicies from ...

How To: Work with mathematical word problems in MS Excel

Looking for a primer on how to create and work with array formulas 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 13th installment in his series of Excel array formula series, you'll learn how to set up, solve and write conclusions for math word problems in Excel.

How To: Transpose columns to rows & rows to columns in 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 2nd installment in his series of Excel array formula series, you'll learn how to use the array TRANSPOSE function to transpose a table, switching rows and columns to columns and rows.

How To: Calculate expected return with an Excel array formula

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 3rd installment in his series of Excel array formula series, you'll learn how to create an array formula that will calculate the expected return for a given stock.

How To: Use the FREQUENCY function in Microsoft Excel

Looking for a primer on how to create and work with array formulas 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 8th installment in his series of Excel array formula series, you'll learn how to use the array FREQUNCY function correctly.

How To: Create permanent consecutive integers in MS Excel

Looking for a primer on how to create and work with array formulas 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 12th installment in his series of Excel array formula series, you'll learn how to create array formulas with the ROW & COLUMN functions that will in turn permit you to create a set of permanently consecutive integers.

How To: Copy & paste a list of all names in an Excel workbook

Looking for a primer on how to create and work with names 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 12.66th installment in his series of Excel name tricks, you'll learn how to paste a list of all names in the workbook, both the name and the formula that defines the name.

How To: Use Excel names with pivot tables & data validation

Looking for a primer on how to create and work with names 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 5th installment in his series of Excel name tricks, you'll learn to use names with pivot tables, data validation & the VLOOKUP & COUNTIF functions and formulas.

How To: Sprout grains in a jar or easy sprout

This wonderful video takes you step by step on growing your very own grain sprouts. You can also use this tutorial to grow all types of grains like, barley, kamut, oats, rye, spelt, triticale or our grain mix. Grain sprouts are so fast and easy that they've included directions for sprouting in both a , mason jar and an easy sprout sprouter in this one video. After this video you'll be sprouting all over the place.

How To: Master reset and factory reset your Blackberry

This video will show you how to do a master reset, and a factory reset on your Blackberry. If you ever need to do this, this video tutorial is a great place to start. Just follow along with this tutorial. This is a good idea if you're looking to resell your Blackberry or pass it on to a relative or friend for whatever reason. This tutorial works for any Blackberry device.

How To: Emboss text on a glass surface in Photoshop

In this Photoshop video tutorial, hosted by photoshopuniverse, from Free Photoshop Video Tutorials, you will learn how to create an effect that makes it appear as though text you input into your image has been embossed on a glass surface. As you follow along with the host in this video, you will learn how to insert text, and align it to a plane, so that it will appear to be aligned to the surface you want to place the text on, as well as how to achieve the embossed look when you're finished.

How To: Make oven "smoked" bbq pulled pork shoulder

Mmm...barbecue pork shoulder. This oven "smoked" barbecue pulled pork will melt in your mouth. Watch this video to learn how to make a succulent, tender dish, that's great for dinners and parties. All you need to do is put the ingredients in a Dutch oven, and place in the oven for a few hours. You'll be rewarded with the delicious smell and taste of flavorful, tender pulled pork.

How To: Perform a frontflip

Want to learn how to frontflip? Well, you've come to the right place. This video tutorial will show you how to accurately perform a frontflip for any of your needs: gymnastics, parkour, freerunning, or just plain old fashioned fun. It's easy to front flip, it just takes practice... and guts.

How To: Do the Leg Catch freestyle soccer trick

Leg or heel catches are a great place for those new to the exciting world of freestyle soccer to start, as it isn't TOO challenging. All you have to do is flick the ball up and behind you and catch it against your heel in the crook of your bent leg. The video will show you everything you need to know and offers great tips on proper execution.

How To: Play the didgeridoo for beginners

Interested in learning how to play the didgeridoo? If so, this video lesson may prove a good place to begin. This tutorial will walk you through the rudiments of didgeridoo playing, including tonal techniques for varying the pitch, volume and timbre of your didge. For more information, and to get started playing didgeridoo yourself, watch this helpful video tutorial.

How To: Bring home a date when you have a roommate

Having a date over to your place for the first time is nerve-racking enough without having to worry about your embarrassing roommate. With these easy steps, an uncomfortable situation can be smoothed over. Watch this dating advice video and learn how to bring home a date when you have a roommate.

How To: Tether iPhone 3G to use as a wireless modem

This is a video demonstration on how to tether your iPhone 3G to a Mac laptop to use the 3G network for surfing the web on the laptop. This is against AT&T's policy so try at your own risk. This is in place of the NetShare app that keeps getting removed by Apple or ATT. This let's you connect your computer to the 3G wireless network by using a proxy on your jailbroken iPhone.