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 320th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT & SUMIF functions together to look up multiple items and add them in one cell.
Trojans, viruses, and malware can be more than a simple nuisance to your computer--they can destroy data and ruin your system. This video tutorial shows how to get rid of malicious software on your computer. When combating a virus, it's best to use multiple applications to insure system extraction.
There are many different approaches to sharpening images in Photoshop. This tutorial demonstrates multiple options in order to optimize the final presentation of your photographs.
Want to retrieve a value in a given Excel column based on criteria from multiple other external columns? You can. And it's not so very hard provided you know what to do (hint: you'll use the LOOKUP function). Get in the know with this, the 541st installment of ExcelIsFun's series of Excel magic tricks.
What's better than Microsoft Excel's conditional formatting feature? Microsoft Excel's conditional formatting feature when used with multiple criteria, that's what! In this Excel tutorial from ExcelIsFun, the 544th installment in their series of Excel magic tricks, you'll learn how to build multi-variable conditional formatting formulas using the TRUE, FALSE and AND operators.
Jackie OFee from Signature Style shows how to add a bit of a punch to your wardrobe with scarves. She shows how to tie summer scarves and uses multiple scarves; skinny silk ones, large summer scarves, and scarves for evening and she even includes one for your hair. If you follow the instructions and learn from her suggestions in this video and you will know what do with a scarf for any occasion in the summer and other seasons as well.
This video by KnitWitch.com demonstrates how to bind off with patterns or in other words shows how to end off two different types of knitting stitches. You want to bind off by working the stitches the same way as if you were still working the pattern. Not only does this video show you how to bind off using multiple stitches, it also shows you how to finish off the last stitch in the row so that all of your finished work doesn't unravel.
Virtual DJ is a powerful disk jockeying tool, that allows you to digitally manipulate multiple tracks at once. Learn the basic features of the tool in this video. Download a free trial of Virtual DJ and start mixing.
Learn how to screen print/ silkscreen a tshirt without using an actual silkscreen. Have you ever wanted to paint your own shirt or silkscreen multiple prints? Now you can know how! Creating your own designs is a lot of fun.
Watch this pen spinning video tutorial to learn how to do some basic pen spinning tricks, like the Twisted Sonic, the Reverse Twisted Sonic, Thumb Around, Multiple Thumbspin, Infinity, Shadow, and Back Around.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using the HLOOKUP function to generate adaptable grades from marks. For more on using HLOOKUP across multiple documents, watch this Microsoft Office how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a letter to multiple recipients using one form letter and a table to populate it. For more on using mail merging in Microsoft Access, watch this how-to.
This video editing software tutorial looks at working with large images, and setting keyframes in Final Cut Pro. The FCP tutorial also goes into working with multiple layers a little bit. Working with large images can get slow and frustrating, so it's worth learning these tricks to make it easier in Final Cut Pro. Crank the volume, the audio on this tutorial is a bit low.
If you have a blocked sink, there are multiple solutions. This video tutorial will see to it that you find the right fix for your clog. For more information, as well as to get started unblocking your own sink, watch this helpful plumbing tutorial.
This image editing software tutorial shows you how to use the image processor tool in Photoshop CS3 to convert your corrected RAW files to a format more suited for printing or retouching; jpeg and Tiff. The image processor is can be used in the Bridge as well as in Photoshop and allows you to convert multiple files at once. See how in this Photoshop CS3 tutorial.
Because Microsoft has not yet released PowerToys for Windows Vista, you might be at a loss for how to batch resize your images. This video tutorial presents a handy workaround for resizing multiple images at once. For a clear, step-by-step look at the process, press play!
This stitch pattern was featured in the May 2008 issue of Simply Knitting. Here is a brief demonstration of how this stitch pattern is worked. You will be working in multiples of two stitches with one added stitch at the end of each row. Watch this knitting video to learn the secret to knitting a cool rolling pleat pattern.
Watch this two part instructional knitting video to knit an uneven rib stitch. You will want to cast on your stitches in multiples of four. The uneven ribbing pattern uses a row of purl two, knit two pattern with an added knit stitch at the end of each row. The Continental method is used here, meaning the yarn is held with the left hand.
Watch this two part instructional knitting video to knit a 3x3 rib stitch using an even number of stitches. You will want to cast on your stitches in multiples of six. Simply knit three and purl three to knit the 3x3 rib stitch. The Continental method is used here, meaning the yarn is held with the left hand.
Watch this two part instructional knitting video to knit a 2x2 rib stitch using an even number of stitches. You will want to cast on your stitches in multiples of four. Simply knit two and purl two to knit the 2x2 rib stitch. The Continental method is used here, meaning the yarn is held with the left hand.
Safari makes it easy to browse multiple web sites in the same browser window using tabs. In the latest version of Safari in Leopard, you'll find even greater flexibility in the way you deal with tabs. For a survey of the new features available to users of Apple Safarin in the Mac OS X Leopard operating system, watch this video tutorial.
If you travel a lot for work and give presentations, you know that, sometimes, you're forced to use another person's computer system. And sometimes your Keynote presentation just doesn't look right. In this video tutorial from Apple, you'll learn how to save a Keynote presentation so you can assure that the look and feel is consistent across platforms.
This 3D modeling software video covers multiple tools that will help you be more accurate and precise when building in SketchUp. SketchUp has many tools that make it easy to be creative when designing buildings or models, but it's just as important that they be accurate. Learn how to use numeric values and SketchUp tools to add accuracy and realism to your work.
In this tutorial, you'll learn how to manipulate multiple copies of a single track in Traktor, formerly known as Traktor DJ studio, to achieve interesting effects. More specifically, this tutorial looks at phasing, beat repeat, snare fill, drum solo and half-time fill techniques. To learn how to achieve any and all of the above effects, press play!
Who says you have to workout by yourself? Studies show that people who workout to socialize and have fun workout forty percent more. Grab a group of friends and start shedding the pounds. In this how to video SELF Magazine presents a simple fitness workout routine that can be used by multiple people. Slim down and tone up with your friends.
This how-to video provides step-by-step knot tying instruction from Curtis Owens of Performance Tackle. The dropper loop is used for fishing with multiple hooks. Watch this video knot-tying tutorial and learn how to tie a dropper loop variation knot for fishing.
Take a look at this instructional video and learn how to create quick and easy copies as well as repeated copies, or arrays. As arrays are so easy to create, don't worry if you make a mistake. Simply undo the array and recreate it. This tutorial covers how to make one copy, creating multiple copies or arrays, changing the number of copies, the difference between external and internal array, and how to Create circular arrays.
Take a look at this instructional video and learn how to use the eraser tool in Google SketchUp. Keep in mind that the eraser tool only works for edges in SketchUp, and you won't be able to erase surfaces with the eraser tool. This tutorial covers how to erase single or multiple edges easily and how to soften or hide edges with the eraser.
This software tutorial shows you how to use the video editing software Wax 2.0 to clone someone in a video. Learn to make multiple versions of yourself interact in one video in this Wax 2.0 cloning tutorial.
Been practicing a few pen spinning tricks? Check out this pen spinning magic trick to learn how to get at least two spins with a continuous backaround. This move looks nice in a combo move. Learn the multiple backaround movement and you can start performing 3-6 backarounds in a row like a pen spinning pro!
In Microsoft Office Excel 2007, you can quickly insert new rows, columns, cells, and worksheets and just as easily delete them — with a few clicks.
Ever had too many windows open in an application on the Mac? Take a look at this instructional video and learn how to close them all with a click of the button.
Some plugins load 1 instance that can control several patches. This tutorial shows you how to set up multiple out plugins in FL Studio to do just that.
This video origami tutorial shows how to make a sham. Modular origami differs from basic origami in that multiple pieces of paper are used instead of just one. Learn how to fold this modular origami sham ball by watching this instructional video.
Omnisio.com allows you to take videos from YouTube, Google Videos, etc and lets you cut them and splice them together to make a single video from multiple ones.
Tired of multiple lines of text not pasting correctly into a single line text field? Watch this video from Tekzilla and banish this irksome habit from FireFox for good.
This Lightroom tutorial is about a feature that a lot of people miss in the Develop module called Auto Sync. It comes in really handy when you’re trying to work on multiple photos at the same time.
Make an amazing paper toy that can take on multiple shapes and appears to turn inside out. This how-to video will show you just how to make this perfect paper puzzle that will amaze anyone.
This tutorial shows us how to split up your iTunes Library to make multiple libraries for your music collection.
Put an effect on multiple tracks in Logic and make your mix your own with an assortment of cool sounds and layers.
