Players Pick Search Results

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: 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: 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: 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: Fix a wet iPod or iPhone

Have you ever dropped your iPhone or iPod in water? Learn how to fix it here. Water can be very damaging to electronics because of its conductivity. You can avoid short circuiting your device by following the directions in this tutorial. Discover why water can hurt your electronics and how to dry out a wet device from the inside out. Find out how to open the device and access the logic board. With materials as simple as a hair dryer and guitar pick, your device can be as good as new!

How To: Solder your own headphone amp

Systm is the Do It Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. We will help you avoid pitfalls and get your project up and running fast. Search Systm on WonderHowTo for more DIY episodes from this Revision3 show.