Entrance Row Search Results

How To: Knit one-row button holes

Knitting button holes doesn't need to be a pain. With the tips in this how-to video, it can be quick and easy. If the button you're using is 4 stitches wide, make a 3-stitch buttonhole (as demonstrated). For a 5-stitch-wide button, make a 4-stitch buttonhole, etc.

How To: Show Your Guests Around in Style with Redstone Guide Lights

Builds in Minecraft aren't usually for your own personal enjoyment; most people want to show them off to others. So to some extent, builds need to be user-friendly. That is, they should automatically guide people to areas of interest or importance. One particularly stylish way to do that is by using guide lights. I have two different designs included here, which you can either use or adapt to your own purposes.

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: Increment column numbers for an Excel lookup table

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 335th installment in their series of digital spreadsheet magic tricks, you'll learn how to increment column numbers for a VLOOKUP lookup table when you are copying the formula down across the rows (down a column).

How To: Invert a range of values in Microsoft 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 307th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, ROWS, COLUMNS, LARGE, SMALL functions to create 4 different formulas that will invert a range of values.

How To: Extract records from a table to a column in MS 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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from standard table and put a record in a column using the VLOOKUP, IF and ROWS functions.

How To: Do the Vertical Fly Stitch

The fly stitch can be worked both horizontally and vertically. In this video tutorial from Needle 'n Thread, you'll see the fly stitch worked vertically.Besides working fly stitches in horizontal rows or vertical columns, the stitch can also be isolated, to create "filled" (loosely filled) background areas, or to create small accent-like stitches across a "canvas." Experiment with it! It's a fun and quick stitch!

How To: Add, Remove & Reorder the Share Sheet Options on Your iPhone

On iPhones, the share sheet is a powerful yet largely underestimated tool. For the uninitiated, the share sheet is the menu that opens whenever you tap the share button (the box with the up-arrow). This menu features sharing options to first and third-party apps, as well as extra functions like saving, copying, duplicating, and more. Best of all? It's surprisingly customizable.

How To: Make a lace wig

In an upcoming play in which you have to make your own costumes? Going as Betty White for Halloween this year? Whatever the reason, you're looking for how to make a wig and you're looking in the right place. In this video, learn how a "wig master" makes a professional lace wig with the help a tool called a hackle - a giant comb with rows of steel teeth.

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: Sum every nth value in Excel with SUMPRODUCT

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 466th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM every nth value using SUMPRODUCT, MOD and ROW functions.

How To: Do a reverse two-way lookup in Microsoft 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 149th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a value in a table and then return the row or column value when there are no duplicate values.

How To: Increment numbers in an Microsoft Excel formula

New to 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 Excel tutorial from ExcelIsFun, the 336th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROWS, COLUMNS, MOD, ROUND, and WEEKDAY functions to increment numbers in Excel formulas.

How To: Do a ladder stitch for beaded jewelry making

In this beading video tutorial you'll see how quick and easy it is to create this basic stitch - a must know stitch for weaving many other stitches! The ladder stitch creates a row of beads as long as you want to make it. Learn how to do a ladder stitch with beads by watching this video jewelry-making tutorial.

How To: Crochet a slip stitch to end the round

Are you having trouble ending the round when you are crocheting? Shred Betties shows us how to crochet a slip to end the round. You will need the following: crochet hook, yarn. Procedure: Use a slip stitch to end a row. Insert the hook in the middle of the third stitch of the chain that started the row yarn over and finish round 2 by pulling the yarn through the loops on the hook. Follow these steps and you will no longer have trouble ending the round the next time you crochet.

How To: Do a triple T-Spin in Tetris

The T-Spin is a vital move if you're going to play really good Tetris, but doing it three times in a row can be tough for even a seasoned player. This video will show you in slow-mo how to do a triple T-Spin, which you hopefully won't need but it'll be there when you do.

How To: Create forms in iPad Numbers

You can create forms on your iPad by using Numbers. You can use the forms to fill in the rows of a spreadsheet instead of entering data into the spreadsheet grid. This can come in handy if you are looking for a quick way to get your job done.

How To: Count dates with an array formula in Microsoft 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 142nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a complex array formula that counts weekends between two dates with the SUM, IF WEEKDAY, ROW and INDIRECT functions.