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.
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.
In this how-to video tutorial fitness trainer Derrick Young takes you through the advanced technique of a push up. This will strengthen your, chest, shoulders, back, stomach, and arms. Watch this video workout to learn the proper technique for advance pushups. These are great workout tips from Ebony Magazine.
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.
Learn a full body Energywork technique including how to do Energywork using pendulums, minerals, and crystals.
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!
Using Maya you'll learn to produce an alpha to use in Zbrush. Very easy method to make a controlled alpha without using Zdepth tools in Zbrush. In part two, Using Zbrush tools to make a tileable texture. Texture sculpting techniques and the 2.5d tools within Zbrush. Part three covers setting up the Maya render for the texture and attaching maps to the node.
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.
Fast-pitch softball is fast becoming one of the most popular youth sports in America. This video features softball coach Cirssy Rapp demonstrating some advanced techniques for developing athletes fast pitch softball skills. These include learning how to throw hard before working on accuracy, and once the accuracy is there down the middle, giving corner assignments regularly to improve the athlete's accuracy further.
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.
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.
Check out this puzzle video tutorial on how to solve a 4x4 Rubik's Cube by advanced edge pairing. This video goes over how to match up multiple edges at a time, allowing you to eventually become faster with practice. This will also allow you to understand the technique necessary for multiple edge pairing in bigger cubes as well, where it really becomes necessary in solving quickly.
Watch this ceramics tutorial video to learn how to use some more advanced glazing techniques to make the inside different than the outside. The detailed instructions in this helpful how-to video are best for intermediate to advanced potters who want to glaze both the inside and the outside of their pottery.
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
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.
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 yo-yo tutorial demonstrates the advanced slack.
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.
This Photoshop software tutorial demonstrates how to combine the refined edges of the Pen Tool and the soft transparent qualities of the Extract Tool to create monster masking effects. The results are well worth the effort. Learn how to use advanced masking techniques to make cool smoke effects coming from a monster in Photoshop.
Learn to play an advanced version of "Love Story" on the piano.
What lurks in the shadows? Is it something scary and frightening? Nothing so nefarious in this insightful episode of PixelPerfect in which Bert casts light upon the mysteries behind creating advanced shadow effects within Photoshop.
In this video tutorial, you'll learn how to solve the Rubik's Cube's F2L (first two layers) with advanced techniques, such as the use of empty slots and stuck pieces, along with some general tips and tricks.
Unclaimed money, or money that has gotten lost in the financial system but is owed to you, is all over America. If you think there might be money that belongs to you in the state of New York, check out this video made by State Comptroller Mike DiNapoli outlining how to check whether you are owed unclaimed money and how to claim it.
