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.
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.
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...
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.
This is a how to hip hop and popping dance tutorial that takes waving beyond just the arm wave and body wave.
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.
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...
This IGN guide provides an overview of the different Strike Packages available in Call of Duty: Modern Warfare 3, including how the death streak and win streak packages work. You'll learn how to use the recon drone, Advanced UAV, and more.
If you're interested in creating your own GUI button in Minecraft, take a look at this tutorial to find out how to create and add one to the game using the ModLoader and MCP utilities. This is a bit of an advanced tutorial for Minecraft mod creators.
The HTC Desire Z continues the HTC hit parade of awesome smart phones. It offers some awesome standard features that used to be hard to make on older Android phones, like flip-to-speaker and flip-to-silence. This video will show you how to use these features and take full advantage of your phone.
Interested in playing Sir Elton John's "Candle in the Wind" on a piano or other keyboard instrument? Let this free video music lesson be your guide. While this tutorial is best suited for intermediate or advanced piano players, players of all skill levels can play along. Watch this tutorial to get started playing "Candle in the Wind"!
In this video tutorial, you'll learn how to play John Lennon's "Oh My Love" on piano or other keyboard instrument. While this tutorial is best suited for intermediate or advanced piano players, players of all skill levels can play along. Watch this tutorial to get started playing "Oh My Love"!
In this video tutorial, you'll learn how to play the Beatles' "Hey Bulldog" on the piano. While this tutorial is best suited for intermediate or advanced piano players, players of all skill levels can play along. Watch this tutorial to get started playing "Hey Bulldog"!
If you're just getting into balloon twisting but are looking for something a little more advanced then say, a flower, then check out this awesome video! In it you will get a step-by-step beginners guide on how to create a simple air plane that will impress anyone!
The basic forehand shot in tennis is predictable for your opponent and not likely to get your very far against advanced players. This video will teach you how to put topsin on your forehand shots like Rafael Nadal, allowing you to move the ball a lot more and confuse the opposition.
The forehand shot is the preferred shot for many tennis players. If you feel like you've reached the limits of your current forehand shot, you should practice up and add some new techniques to it, and this video will help you do just that.
If you've mastered the basic tennis serve, it's time to move on to the more advanced styles. If you want to put spin on your serves like Rafael Nadal instead of going for pure power, the slice serve is probably for you, and this video will teach you how to do it.
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.
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!
The key to a good standing backflip is looking confident and feeling loose. If you're rigid, it will look sloppy and force, but if you're loosened up and feeling comfortable, it will be the best backflip ever. Superstar gymnast Andrea Catozzi shows you how he performs an acrobatic backflip from standing. This is a high aerial backflip, so be careful.
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!
This freestyle soccer move is hard, we're not gonna lie. You have to already have mastered the Around the World and Crossover. If you've got all that down, you might be ready to learn a Touzani Around the World. It combines both of those tricks into one graceful flurry of legs and ball.
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.
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.
If you need to capitalize a word using Swype and aren't sure how, then this is the tutorial for you. This advanced quick tip will get you started so your texts can be both lightening fast AND grammatically correct.
In this video, learn how to light your Zippo by slamming the lighter into your hand in one fluid motion. This "hot hand" illusion is very flashy and works well for impressing a date that needs a light. This trick is a little advanced, so practice, practice, practice! Have fun!
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.
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.
This extensive and great tutorial is great for any crochet expert, or the advanced student. Step by step you'll walk through each technique in creating a pair of crochet baby cowboy booties. Perfect booties for your doll or even a new born baby.
Check out this informative video tutorial from Apple on how to organize your Mail in Mac OS X's Mail. See how to sort messages with rules, create smart mailboxes, and comlpletely organize your mail. Mac OS X. It's what makes a Mac a Mac.
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.
Check out this informative video tutorial from Apple on how to use Mac OS X Mail to its fullest. See how to filter out junk mail, use data detectors, and view RSS feeds in Mail. Mac OS X. It's what makes a Mac a Mac.
Learn how to do a slim-chance with Flysurfer teamrider Mathias Wichmann. This trick is extremely hard and looks awesome. It's technically advanced.
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.
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.
You can easily integrate images from your Aperture library into your Keynote '08 presentations using the Keynote media browser.
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.
In this tutorial, you'll learn to play Bob Marley's "Redemption Song" on the acoustic guitar. While this tutorial is best suited for intermediate and advanced players, any guitarist will be well served by the close-up shots it presents of the player's left and right hands.
In this tutorial, you'll learn to play Peggy Lee's "Why Don't You Do Right" on the guitar. While this tutorial is best suited for intermediate and advanced players, any guitarist will be well served by the close-up shots it presents of the player's left and right hands.
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.