Pick Ups Search Results

How To: Create edges and borders in Adobe Photoshop

Want to add a border to your digital image? With Photoshop, it's an easy process. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from the folks at Britec Computer Systems. This video offers a step-by-step guide on how to add borders and edges to digital images.

How To: Remove photo paper texture from old photos

Want to digitally preserve an old photograph without also preserving the imperfections of the physical photo paper? With Adobe Photoshpo, it's easy. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from the folks at Britec Computer Systems. This video offers a step-by-step guide on how to remove unwanted physical textures from your digital images.

How To: Create a digital photo montage in Adobe Photoshop

Create digital photo montages in Adobe Photoshop. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from the folks at Britec Computer Systems. This video offers a step-by-step guide on how to generate simple montages with digital photographs.

How To: Make studio portrait backgrounds in Photoshop

Want to add a studio portrait background to a photo after the fact? With Adobe Photoshop, it's easy. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from the folks at Britec Computer Systems. This video offers a step-by-step guide on how to digitally add portrait backgrounds to your images.

How To: Colorize a black and white image in Adobe Photoshop

Can't get enough of the colorized version of It's a Wonderful Life? Bring the same technology to bear on your own digital images. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from the folks at Britec Computer Systems. This video offers a step-by-step guide on how to add color to B&W photos.

How To: Adjust levels and curves in Adobe Photoshop CS4 or CS5

Maximize dynamic range with Photoshop's levels and curves tool. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from the folks at Britec Computer Systems. This video offers a step-by-step guide on how to adjust levels and curve of a digital image.

How To: Collect 100% Pure Adrenaline achievement in Skate 3

Jack and Geoff from Achievement Hunter show you how to pick up the high-flying 100% Pure Adrenaline achievement in Skate 3. In order how to collect this achievemen you need to get 10 seconds of freefall, to get freefall just hit down on your right thumbstick. You will see a good example of where to go and how to get there so that you can easily collect another achievement in Skate 3.

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: 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: Exercise to get in shape for mountaineering

Ali Alami with Fit Climb demonstrates how to get in shape for mountaineering. You can do these exercises in a park or at home. Your core and lower body are important in mountaineering. First, find a wet, wood bench that is four to six inches off of the ground. Do step ups to work your quadriceps and glutes. Balance briefly on one leg and then bring the other leg up. You can also do side steps. Step downs help you get you used to gravity. Calf raises are also helpful. To strengthen your core u...

How To: Do Hindu pushups

This video shows you how to do Hindu push-ups which have been used by wrestlers and martial artists for many centuries. It works all major muscle groups at the same time. You begin with the mountain pose, also known to yoga fans as the downward dog, with your hands and feet spread out. You go down by bending your elbows, until your body is on the ground. Then go into cobra pose, and as you push up into this pose you should inhale. Then push exhale as you push back to the starting position. Ke...

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: Make a dramatic film

This tutorial covers some of the basics of dramatic filmmaking. A drama is a film that is character-driven, using the characters' emotional responses to situations to move the story along. Epic and historical dramas put their characters in historical events. Crime dramas are set within the rules and boundaries of reality, but do not have to be linked with any historical event. These films utilize suspense and action to push the characters through the story. Biopics are motion picture biograph...

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: Enhance traditional art methods with digital media

Have you ever heard of tradigital art? Tradigital art incorporates traditional materials with digital media. This is a combination of such techniques as illustration with Decocolor Markers, Prismacolor Markers, pencils, and Photoshop. Watch this tutorial to learn how to enhance traditional art methods with digital media. It illustrates the tradigital process step-by-step. Make sure to pause the video after each step and look at the screen every few seconds while you are drawing.

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.