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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use Advanced Filter to extract records from a table with 1 criteria, then use a Macro to automate the process.
You’ve got the basic head structure down and now it’s time to learn how to draw a detailed face of woman. It can be a little tricky to draw an angled view of a face but you can use sketching and shading tools to give depth, angle and form to create a realistic woman.
Street artist wackojacko54321 teaches you how to draw "wild style" graffiti. There is no definite technique or way of drawing wild style. Wackojacko54321's interpretation involves starting with a simple piece with connecting letters (of which he provides an example) and possibly arrows. Add more basic arrows and connections to unify the piece more. Connection points of the arrows are important. Attach them to the ends/corners of letters or other letters/connections. Spice it up with more adva...
Popularized by artists like Son House and Skip James, Delta blues is not only one of the oldest forms of blues music, it is among the most stylistically distinct and technically rewarding to play. In this video guitar lesson from YouTube user deltabluestips, you'll learn how to adapt Delta blues technique for playing James Brown-style funk. While this lesson is geared more toward intermediate and advanced guitarists, this means beginning players merely have all the more to learn. Trace the ev...
If you are looking to improve your piano technique then this how to video is the place to start. You will learn how to improve finger strength and articulation with these easy piano exercises. You must learn to strengthen them so you can play piano better. This is a great exercise for beginner to advanced students. With this tutorial you will be able to gain finger strength and articulation with these piano exercises.
After water skiers get the basics down, it's time to move onto trick water skiing. Practice advanced trick water skiing with tips from a trick water skier in this free video series on water skiing.
In these Salsa dance lessons on video, learn some steps in the Miami style of Salsa dancing. Learning these advanced salsa dance steps—the mojito, las manos complicadas, the yuka, and the noventa—will help you get around on the dance floor a little more, as well as add a little flair to your salsa dancing routines.
If you are looking to improve your classical piano technique then this three part how to video is the place to start. You will learn how to practice and study Chopin's nocturne number 20 in C# minor. This detailed lesson goes over where to place the accents, analyzes the dynamics and legato playing technique. This piano tutorial teaches you the best way to practice it so you can Chopin's nocturne no.20 quickly and easily. This piece is not for beginner students, this lesson is directed to adv...
When the shuttle feels cramped as you pass the weft through your weaving, it's clearly time to advance the warp. This video shows the steps involved in advancing the warp on an inkle loom: loosen the tension, move the warp around the pegs, reposition the heddles. At the end, check the position of the warp threads on the pegs and re-tighten the warp.
See the demo to learn how to take advantage of some of the advanced features of Office Communicator 2007, including rich-text formatting, transferring files, and escalating to a Live Meeting. If you use Office Communicator at your office for video conference calls or chatting, then this tutorial will explain some very useful advanced features.
Hackers are claiming money for a security flaw in Apple's new update. Quick Summary:
In this how to video, you will learn how to perform an advanced jig rhythm Bodhran. The way it is performed is going down down up. The down and up accent create an alternating back and forth feeling. If the accent is the same sound every beat, such as on the down, it has only a forward drive to it. First, do a down stroke but do not follow through. Drop the stick to hit a few inches below. From here, go up and hit the drum. The instant way to get this is to do the opposite. Basically, go up, ...
Know how to do the pindrop? Well, how about the advanced pindrop? Team ExClu$!v3, an advanced team of jerk dancers, take us through a couple advanced pindrop (sometimes known as the "baydrip") moves including the "Hell Drop" and "The Stickpin" ...meaning you stick your leg and hold it at all times, coming up spinning? Confused? Watch the video. Team Exclu$sive makes is all look so easy.
Check out this instructional English language video that demonstrates how to improve your English vocabulary skills, your listening skills, and your grammar skills. This is a lesson for the advanced English language learner. The theme is the 2008 Olympic Games that focus on VOCABULARY, LISTENING, and GRAMMAR skills. This is PART THREE, in which we examine and practice several (but not all) verb tenses. Be sure to watch the first two videos. Improve your English vocabulary with this instructio...
Check out this instructional English language video that demonstrates how to improve your English vocabulary skills, your listening skills, and your grammar skills. This is a lesson for the advanced English language learner. The theme is the 2008 Olympic Games that focus on VOCABULARY, LISTENING, and GRAMMAR skills. This is PART ONE, so you will study vocabulary. Be sure to watch the second half. Improve your English vocabulary with this instructional video!
This may just be one of the coolest origami folding projects we've ever come across at Wonder How To. Yeah, it looks almost impossible to fold and super complex, but if you're an advanced origami folder then this project will be fun to attempt.
Battery drain is one of the biggest issues with Android phones, but with proper power management it is possible to do something about it. Advanced Task Killer is a free app with customizable settings that shuts down apps that are no longer being utilized. This informative video takes you step by step through the different configuration settings.
This pose is only for people who are advanced practitioners of yoga, and should not be done by anyone who has a chronic neck injury. If you feel confident in your yoga skills, watch this video and learn how to do the headstand pose.
If you're like us, you always begged your parents to let you get a parrot (What? They make you look like a pirate when perched on your shoulder), but they never consented because of the noise factor.
This tutorial goes into a few more advanced uses of the sections tool in Google SketchUp. You can use this tool to control the display of section cuts, change the width and color of section planes and even create section animations.
Are you so good at freestyle soccer that mere crossovers are boring you? Why not try this more advanced combo trick, dubbed the CO-360-CO, or crossover-360-crossover. This video will show you how to do it properly, with the key being mastering the crossover first.
Character rigging is important. Advanced Rigging makes it easier to animate your character. View joints and nerves so that you may easily select parts of the character.
This software tutorial is an advanced color correction tutorial showing you how to color correct with the Colorista plug-in for After Effects. It assumes you already know how to use Colorista for basic color correction and will cover power masking. Learn how to use power masking and motion tracking for secondary color correction in the Colorista plugin for After Effects.
Learn about some of the advanced features in Adobe Photoshop CS4 Extended for animating 3D objects in this software tutorial. In this project we will create a solar eclipse simulation from 2D, and video images of the earth and moon. This is an advanced users tutorial so you should be familiar with Photoshop first. Follow along as Russel Brown shows you how to work with the new 3D features of Photoshop CS4.
A tutorial from Khris Khaos on doing advanced Krumping and Krump moves.
An advanced tutorial on Krumping and Krump dancing. You'll learn: Chest Hits
If you are looking to improve your piano technique then this how to video is the place to start. You will learn how to strengthen your fourth (ring) and fifth (pinky) fingers, as well as the wrist and arm, with this easy piano exercise. The fourth and fifth fingers are often the weakest fingers when playing piano. You must learn to strengthen then so you can play piano better. This is a great exercise for beginner to advanced students. With this tutorial you will be able to gain strength in y...
Check out this instructional magic trick video that briefly teaches you how to do 3 coin vanishes and 1 coin production. These are tricks that a magician should always know. These tricks are good to use in bigger tricks and combine them to make it look real nice. These tricks are mostly techniques that will help you build onto other tricks to perform more advanced magic tricks. Practice your skills and perform vanishing coin tricks like a pro!
Polyrhythm is the simultaneous sounding of two or more independent rhythms. A common example of a polyrhythm is 3 notes against 2, with the 3 beat pattern being faster than the 2 beat pattern, so that they both take the same amount of time. This how to video teaches the polyrhythmic structures of 2 against 3 and 3 against 4. This is a technique for the advanced musician and pianist. Watch this how to video and you will finally figure out the mystery behind playing polyrhythms.
In this video tutorial, we learn how to use advanced search parameters like "define" and "site" to access hidden functions of the Yahoo! search engine. For more information, including a complete demonstration and detailed, step-by-step instructions, watch this how-to from the folks at CNET TV.
This video covers the Expo plugin in Ubuntu Linux, which is similar to the Exposé feature in Mac OS X. The Expo feature can be found in the Advanced Desktop Effects Manager. Once you enable it and tweak the options, you'll be able to view multiple workspace areas at once and manipulate your running programs between them. Check out all of the other desktop effects.
If you're a beginner piano student looking to improve in both music theory and practical piano playing skills, then this tutorial on how to play tetrachords is perfect for advancing your skills beyond playing single finger melodies.
Addicted to keyboard shortcuts? Interested in adding a few more to your arsenal? This home computing how-to from the folks at CNET TV demonstrates a number of intermediate- and advanced-level shortcuts sure to speed up your Microsoft Windows Vista workflow. For the specifics, and to get started using these useful Windows key commands yourself, watch this handy how-to.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 19th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about using Advanced Filter to extract data from an Excel List/Table/Database. See these 7 Advanced Filter examples:
Upper body strength is important and who doesn't want nice, toned arms? This tutorial will show you a new advanced exercise for working out your upper body. This workout is called the Dumbbell Renegade Rows and the video will show you two different versions - beginner and advanced.
Pushups are a great workout. But if you think you're ready to take it to the next level, you should consider incorporating backback pushups into your workout. The added weight will give your muscles added strength and give an exciting new take on a simple exercise.
During Easter, everybody stocks up on the eggs because dying eggs is a great Easter activity. But there's something else you can try… dying and marbling. Watch this video recipe to learn how to dye and marble Easter eggs. A new twist to Easter eggs.
Advanced crip walking takes lots of control and practice. This shows you moves like 'The V', 'quick step' and 'shuffle spin'. He breaks down this form of hip hop that is popular on the street. It involves a lot of feet shuffling and is often accompanied by rap or hiphop music.
This software tutorial shows you how to use some of the more advanced tools of the Colorista plug-in for Final Cut Pro. Colorista is a color correction plugin. You will learn how to fix a bad clip using Colorista in Final Cut Pro.
Learn to play an advanced version of "Love Story" on the piano.
