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 174th installment in their series of digital spreadsheet magic tricks, you'll learn how to lookup up the last value in an unsorted list.
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 172nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create running total with a formula or a pivot 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 170th installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting to hide or show items in a list using a TRUE/FALSE formula.
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 151st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the days, months or years between two dates using Excel's undocumented DATEDIF function.
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 153rd installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to the MAX value in a set of three incentive pay plans.
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.
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 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data validation list drop-down and the hyperlink function to create a list of links.
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 Excel tutorial from ExcelIsFun, the 572nd installment in their series of digital spreadsheet magic tricks, you'll learn about how to use conditional operators in your formulas.
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 Excel tutorial from ExcelIsFun, the 568th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a SUMIFS function to tabulate a monthly running total from transaction data.
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. With this video tutorial from ExcelIsFun, the 393rd installment in their series of digital spreadsheet video tutorials, you'll learn how to remove the last two words from column of data with the LEN, SUBSTITUTE, FIND, REPT, RIGHT and TRIM functions.
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 246th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a waterfall profit chart from a stacked column chart.
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 101st installment in their series of digital spreadsheet magic tricks, you'll learn how to use IS functions (ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF &ISTEXT).
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 9th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Excel's EXACT function to check to see whether two text strings are equivalent and whether or not they have the same case.
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 94th installment in their series of digital spreadsheet magic tricks, you'll learn how to use and link a currency web query to a data validation cell drop-down list for money conversion.
This how to video installment explains a basic autoharp melody playing technique called "pinching". Playing melody on the autoharp is not as difficult as it may first appear. There are an awful lot of strings, but finding a melody note and playing it clearly isn't as hard as it seems. Pay attention to these harp playing tips.
Ian Beckman of Azerothian Super Villains fame introduces the third installment of How 2 Machinima. This series of tutorials is aimed to introduce both the fundamentals and advanced techniques of WoW machinima-making. Use Adobe Premiere to model machinima and create proper machinima or video game films. Change the lighting to diffused, specular or ambient lighting.
In this installment from the Unorthodox Hacking series of computer security videos, you will explore a few of the areas in Windows that most Sysadmins don’t even know exist. See how to become Local System through the Task Scheduler and abuse long filenames. Take a look at some of the features within Windows—registry—that many system administrators don't know exist with this hacking how-to.
The quality of the time you have when playing the drums is proportional to the quality of the time you keep. Ndugu Chancler is known not only as a world-class drummer and percussionist, but also a producer, composer, clinician and teacher. In this installment from his video lesson series covering many of the most frequently asked questions from his clinic tours across the world, Ndugu will teach how you to best develop your sense of time on the drums.
Ndugu Chancler is known not only as a world-class drummer and percussionist, but also a producer, composer, clinician and teacher. In this installment from his video lesson series covering many of the most frequently asked questions from his clinic tours across the world, Ndugu will demonstrate how to play the Ndugu cross stick, a rimshot played on drum with a unique, versatile sound.
Cankers, if left untreated, can grow and prove lethal for your trees. In this installment of the Fruitwise Heritage Apple guide to apple pruning, Stephen Hayes demonstrates how to amputate a diseased tree branch with a saw. Watch and learn why, as Stephen puts it, "a seen canker is a gone canker."
Each year an apple tree should produce three things: new growth, fruit buds on last year's and older growth, and fruit on those fruit buds formed in previous years. In order to keep an apple tree in balance and fruiting, one must prune. However, pruning is often done poorly. In this, the first installment of his series on practical apple tree pruning, Stephen Hayes of Fruitwise Heritage Apples looks at the general structure of the apple tree.
Plangere Culture Lab demonstrates how to use the opacity feature in Final Cut Pro. The opacity feature is a beneficial tool to use when working with layers. Opacity is an attribute which relates to how much you can see through a clip. To layer clips, create a new video track on the timeline. Make sure that the source tab is in the right position. The track on the top of the stack is the dominant track and will be shown. Select the volume and opacity overlay button. Click on the line over the ...
Ever needed to fix a clip where an unwanted or unexpected object appears in the scene? A car is suddenly passing across or a stage hand got in the shot by accident? And re-shooting is expensive or impossible? You would be facing hours of tedious frame-by-frame rotoscoping to get rid of the pesky element in your video...
Did you know you could play external music files in Final Fantasy VII with a simple mod? If that interests you, watch and learn how to install the FF7 Music Patch for Final Fantasy 7 PC. If you want an improvement in music, this is the patch you need.
Any hardcore Final Fantasy VII fan will appreciate this mod. Watch and learn how to install the APZ Cloud Battle Model mod for Final Fantasy 7 PC. This mod is a huge improvement on the original Cloud Battle Model, so make sure and try it out.
Big fan of hugely popular video game Final Fantasy? You're definitely not alone. In this drawing tutorial, learn how to draw main character Tidus from Final Fantasy with help from Drawing Now. Search WonderHowTo for more videos from Drawing Now to learn how to draw a variety of characters and cartoons!
Indy Mogul's Backyard FX series has another great video for making high quality props and special effects. In this installment, you'll learn how to make a destructible wall, perfect for the big action sequence in your next low budget film project.
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 19th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate return on equity, assets, and profitablility — return on investment (RoI).
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 15th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to generate a common-sized financial statement within 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 725th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate quartiles with the MATCH and QUARTILE function.
Need to know how to express gallons in quarts, pints and cups? From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to convert between gallons, quarts, pints and cups.
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 720th installment in their series of digital spreadsheet magic tricks, you'll learn how to use filtering, the AND, TODAY and EDATE functions, and conditional formatting to show values between two dates.
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 705th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Ctrl + ] to find dependent or
In this installment of the online prank video institution Do Unto Others, you will learn a wide variety of great ways to mess with people in a variety of situations. Some of these situations include at a job interview, at the gym, when meeting a new roommate, and when using a public restroom. All are sure to add a little spark and concern to your fellows' day.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve word problems that require you to find price per unit.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve problems that require you to estimate differences by rounding.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve word problems requiring use of the identity property of 1.
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 568th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the five largest values for each a data set using the new AGGREGATE function.
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 669th installment in their series of digital spreadsheet magic tricks, you'll learn how toe AGGREGATE function cannot handle 3-D cell references.
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 647th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic line chart that will show any updates to the cash account.