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 595th installment in their series of digital spreadsheet magic tricks, you'll learn how to resolve a problem that the DGET function and advanced filter have with criteria and duplicates. See how to switch to either the VLOOKUP function or not criteria for advanced filter.
Attention advanced balloon artists! Learn how to make a one balloon horse that involves a difficult balloon shape and a tricky air bubble situation. Learn how to make this impressive balloon animal with help from one ballooning expert. Your Balloon Man, Mr. Fudge, is full of balloon tricks! Be sure to find other balloon videos on WonderHowTo from Mr. Fudge teaching everything from animals to planes! In a few twists and a few ties, you'll be an expert balloon artist in no time!
Get started using Adobe After Effects with the help of The New Boston! This beginner's tutorial is bound to answer the many questions you have about the popular digital motion graphics and compositing software. The main purpose of After Effects is for film and video post-production.
Practice advanced technical drills for training in the fastest field game in the world: hurling.
This tutorial series shows you how to put up an Adobe Air Flex 3 Encryption System. One of the weak points of Adobe AIR and Flex is there is no encryption system built in, making your data and applications vulnerable. But that's ok, because this tutorial will show you how to remedy the problem by adding an AES encryption system.
In Scooby's opinion, pushups are the #1 best exercise you can do! They are simple to do and are a great upper body workout for the complete beginner or the advanced bodybuilder. You can get a complete upper body workout by combining these pushups with crunches and pullups, all of which can be done easily at home.
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.
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.
This tutorial shows the best way to model a human hand with perfect edge flow. Made in Maya but should work great in any package. This is an advanced tutorial so you should be familiar with the software and interface.
This video will teach you how to C Walk. It covers basic and advanced C Walk dance moves including: The V V Step Back V Variation
In this episode you will learn how to turn direct speech to indirect speech in the English language. This video is great for advanced, intermediate, and beginner learning to speak the English as a second language (ESL).
In this episode you will learn how to use relative clauses in the English language. This video is great for advanced, intermediate, and beginner learning to speak the English as a second language (ESL).
