Unconventional Pick Search Results

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: 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: Choose a lighting kit

There are so many different lighting kits out there, but what's the right one for you. Fortunately this video tutorial series demonstrates the different types of lights and picking which ones are the right for your production.

How To: Play "Wish You Were Here" (Pink Floyd) on guitar

In this acoustic guitar video lesson, brought to you by GuitarJamz, host Marty Schwarz, will teach you how to play "Wish You Were Here" by Pink Floyd. As you follow along with him, he teaches you the progression of the chords used in the song, breaking down each part of the song, teaching you the chords and explaining the strum pattern and picking of the guitar riffs. This tutorial focuses mostly on just the beginning of the song, and does not cover the entire song.

How To: Do a basic, continental, German, or left hand stitch

Officially, anyone who holds the yarn in their left hand is a Continental knitter. Some continental knitters wrap the yarn between the needles to knit it, and some simply scoop, or "pick", the yarn with the needle. The latter requires fewer hand movements, and has a reputation of being the fastest method of knitting there is. Watch this video knitting tutorial and learn how to do a basic, continental, German or left-handed knit stitch.

How To: Play a simple guitar boogie in G

Check out this music tutorial video that demonstrates how to play a simple guitar boogie in G. This instructional video provides fret diagrams and live action to show how to play a simple boogie in G. This video is aimed at budding fingerstyle guitar players, but can be adapted to a pick. Advanced beginners are also encouraged to watch and learn. Play a simple guitar boogie in G and improve your guitar playing skills!

How To: Deal with & stand up to a bully

It’s scary, but you can learn how to stand up to a bully – and come out on top. You will need courage, wit, and even a bit of self-control. Bullies tend to pick on those who don't stand up for themselves, so being a little assertive helps. Find out how to stand up to a bully by watching this video self help tutorial.

How To: Hand make inexpensive Christmas presents

Roxy and Sarah take a trip to the craft supply store, and pick up material to make inexpensive Christmas presents at home. Kids can learn how to make a decorated cocoa jar to give to teachers, coaches, or neighbors. All you need is a glass jar, hot chocolate mix, marshmallows, and whatever Christmas decorations you want. Watch this video crafting tutorial and learn how to do this fun kid-friendly activity of decorating cocoa jars as a Christmas gift.

How To: Make a Pisces fall in love with you

Pisces can be hard to figure out, but here are some clues. To figure out a Pisces you will need an interest in the entertainment field, a strong personality, and a reassuring nature. Learn how to use astrology advice in dating, by watching this how-to dating video. Pick up tips on making a relationship with a Pisces work.

How To: Make a Scorpio fall in love with you

Playing hard to get doesn't work with a Scorpio; they only respond to slavish devotion. So drop everything and dedicate your time solely to the Scorpio in your life. Learn how to use astrology advice in dating, by watching this how-to video. Pick up tips on making a relationship with a Scorpio work.

How To: Make a Leo fall in love with you

Once you know what makes a Leo tick, it will be easy to get under his or her skin. Learn how to use astrology advice in dating, by watching this how-to dating video. Pick up tips on making a relationship with a Leo work. Leo's have a healthy self image, so when you date a Leo make sure to admire them.

How To: Select orchids

Selecting orchid plants takes more than just admiring an orchid's flowers, but with the right information it can be quick and easy. To find the expert's secrets on orchid selection, Meghan Carter visited award winning orchidist Dick Wells of Hilltop Orchids and got to the bottom of how to pick out the best orchid flower.

How To: Run a set offense

Basic lessons covering the set offense. Great for spectators or new players to learn the basics of water polo. Includes setting the hole, driving, RB, strong-side drives, weak-side drives, rotations, and picks.

How To: Play Mah Jong

Board game enthusiast Scott Nicholson reviews a new game each week showing you the pieces and rules of play, as well and demonstrating the game with friends. This weeks game, Mah Jong, is an ancient Chinese game about collecting sets. Don't confuse this with the tile picking game on your computer of the same name!

How To: Do the one arm kettlebell swing

This video demonstrates how perform the one arm kettle bell swing to work out your glutes and hips. To do this, just place the kettle bell between your feet, crouch as you pick it up and use your glutes and hips to swing up the kettle bell.

How To: Make a strap lock for guitar

In this guitar tutorial, learn this great tip on how to make your own strap lock system for musical instruments. No modifications are required to the original buttons or button holes. They can be easily removed and replaced if necessary. They are sometimes called "lock-picks." Of course, these don't have to be made from a pick (although the nylon material is highly recommend), but guitarists don't go to the hardware store for parts. Make a strap lock for your guitar and play guitar with ease!

How To: Sew bias tape binding on a curved edge

Bias tape can add a professional, classy edge or finish to any project. Working with bias tape on a straight edge certainly isn't hard, but the curves can sometimes be a bit tricky. However, they're not impossible, and you can pick up the technique in just a few minutes! This video shows you how to work with single fold bias tape and sew it evenly and professionally around curved edges.