Advance Service Search Results

How To: Extract records using MS Excel's advanced filter tool

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 525th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records using advanced filter and wild-card criteria. See, for example, how to extract records that start with the letters W or J.

How To: Use an advanced filter to extract table data in 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 244th installment in their series of digital spreadsheet magic tricks, you'll learn how to use advanced filtering to extract records from a database (table or list) based on 1 criterion (criteria) and place reesults on a new sheet worksheet.

How To: Achieve a picture-in-picture effect in Apple iMovie

This video will show you how to take advantage of one of Apple's iMovie advanced editing feature, picture-in-picture effect. This feature allows you to embed either another video, or images into a base video. To enable this valuable tool in iMovie, go into the iMovie preferences by clicking on "iMovie" in the top left hand corner of your screen. Under the General tab make sure "Show advanced tools" is selected. Import a video from your event library by dragging it into iMovie and selecting pi...

How To: Use Pyro FX fire and smoke tools in Houdini 10

Want to know how to use the Pyro FX tools in Houdini 10? This masterclass will tell you everything you need to know about using Pyro FX fire and smoke tools in Houdini 10. The discussion covers the addition of exciting new fire and smoke tools. Topics covered include a powerful new fluid up-resing technique, advanced noise and turbulence control, and a highly tweakable custom fire and smoke shader.

How To: Use the Sicilian Dragon opening in a chess game

Learn how to play chess with 2005 Missouri Scholastic Chess Champion Joseph Garnier. If you know nothing of the board game, then you might want to check out this video tutorial. Actually, you need to know a little bit about the game. You really need to know how to play chess, because this is an advanced lesson. You'll learn about an advanced opening called the Sicilian Dragon. You could learn the tricks to using this opening for tournament play, and learn how to win.

How To: Practice Korean vocabulary with pictures

Check out this Korean language tutorial video to practice your vocabulary skills. This instructional video is a part of the picture/vocabulary series to help learners practice their Korean skills. This video is a great lesson for advanced learners who want to listen to native speakers, but it is also helpful for advanced beginners to build up their vocabulary skills. Watch as this instructional language video provides pictures supplemented by voice over with thorough explanations of each Kore...

How To: Hit a forehand volley in tennis

The forehand volley is one of the most important shots in tennis, allowing you to get to the net and move the ball, far away from your opponent. Watch this video to learn the basic technique of forehand volleying and some more advanced pointers.

How To: Perform an advanced butterfly twist (B-twist) acrobatic flip

If you're into urban tricking, parkour and freerunning, you probably know all about the B-twist. It's also a move highly used in gymnastics and acrobatics, and it's full name is the butterfly twist, which is an awesome aerial twist flip. This video tutorial, from superstar Andrea Catozzi, will show you the steps to performing a simple butterfly twist from the standing position. Good luck!

How To: Glide as part of your hip-hop dance

Gliding is one of the most important parts of hip-hop dance. It basically means sliding around the dance floor in a rhythmic, stylish way, and this video will show you how to do it like a pro. You don't have to be advanced already, it breaks it down real slow so you can make sure you learn the move properly and then dance you butt off!

How To: Pull off a freestyle soccer t-shirt trick MCNS

Now this is a sick freestyle soccer move. If you've already got the basics of this awesome new sport down, this video will teach you a great advanced trick to do dubbed a t-shit trick MCNS. This trick consists of catching the ball under the front of the shirt, then rolling it around the side and out of the back of the shirt into a back stall. Legendary.

How To: Create an image gallery (slideshow) in Flash CS4

Slideshow is such a dirty word. Most people immediately think of boring family reunions or 1980's corporate meetings when they hear it. That's probably why web designers prefer using the term image gallery to refer to their slideshow-like works. This video will teach you how to make an automatic image gallery using Flash CS4, which is a slideshow where the images advance automatically on a timer.

How To: Create and animate advanced buttons in Flash CS3

Need to create Flash buttons? You've come to the right place. In this video, learn how to make professional looking, but easy to make, buttons with no scripting. The buttons featured in this tutorial are featured all over the web and on almost every flash site. Create the buttons you need for your web project with help from this step-by-step tutorial.

How To: Tween with ActionScript 3.0 in Flash CS4

In this advanced level tutorial, learn how to tween with Actionscript 3.0 in Flash CS4. This video starts out slow with a simple fade-in animation and later gets more complex. Subjects covered in this tutorial include: Tween class, creating tweens, timers, timer events, tween events, using event listeners, functions, and more.

How To: Use the basics of Mac OS X Mail

Check out this informative video tutorial from Apple on how to use the basics of Mac OS X Mail. See how to set up mail with your email accounts, compose messages, add attachments, view attachments with Quick Look, and search through Mail. Mac OS X. It's what makes a Mac a Mac.

How To: Expose monsters with knockout in Photoshop CS3

In this Photoshop CS3 tutorial you will learn how to use the knockout feature. This advanced masking technique allows you to move a targeted layer around, revealing the layer underneath. This video will show you how to reveal a creepy skeleton under a monster werewolf right in Photoshop. This classic technique lives again! Learn the subtle qualities of the Deep, and Shallow, Knockout feature in Photoshop.

How To: Adjust JPEG and TIFF images with Adobe Camera RAW

Uncover the mysteries of working with JPEG, and TIFF images in Adobe Camera RAW. Warning! This is an advanced demo. Be sure to update to the current version of Photoshop and Bridge before attempting this process on your own. Watch this image editing software tutorial and improve your Camera RAW skills at adjusting jpeg and tiff images.

How To: Cheat to produce realistic music in FL Studio

Learn how to cheat like hell to produce realistic sounding piano flourishes, amazing rolls, and perfectly harmonious music in FL Studio. This tutorial uses examples from other FL tutorials on this site so you may have to watch more than just one. Check out this advanced music theory tutorial and get some great cheating tricks to help your music production in FL Studo.

How To: Do the Woven Picot Stitch

There are many dimensional embroidery stitches , but one of the most fun is the woven picot. You can do a lot with it! It's an easy embroidery stitch - it looks more advanced than it actually is! It's a great stitch for adding texture to your embroidery project, and it doesn't necessarily have to be free standing. See how it's done in this video from Needle 'n Thread.