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.
A fire is the second most important thing you need to have in most survival situations, so having a good fire starting kit in your wilderness survival gear is crucial. This video will show you a variety of great fire starting tools you can include in your survival gear and how to use them best. These include tea light candles, waterproof matches, cotton balls, and ingenious combinations thereof.
Learn everything you could possibly want to know about the internet, multiplayer game Evony with tutorials from EvonyTutorials. Watch this video tutorial to learn how to play Evony - advanced prestige building. See exactly what the game Evony is!
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!
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.
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.
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.
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.
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.
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.
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.
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.
The Elite Advance Suit is the best suit in the game, and is a bit difficult to find. Ths video walkthrough (which is not spoiler free) shows you the best way to find this suit when playing Dead Space 2.
This tutorial is aimed at those who are already somewhat adept at using Flash and ActionScript 3. This demonstrates an advanced masking technique called a 'glint' - having a beam of light pass over the object in your dynamic flash image.
Strength training is the foundation of ripped abs, buxom biceps, and atheletes that don't throw in the towel just because a particular fight is too hard or strenuous. In order to make those big time events seem as easy as pie, you have to train hard on your own.
In this guitar lesson, learn how to play basic and advanced power chords on a guitar in standard tuning (EADGBE). With the guitar, as with any other instrument, if you want to improve, you'll need to practice. Fortunately, the Internet is awash with free, high-quality guitar lessons like this one. For more information, and to get started playing power chords on your own guitar, watch this video tutorial.
This video features softball coach Crissy Rapp explaining some of the advanced techniques of softball hitting. Working with a tee, the presenter and her discuss different contact points, and how to practice using the proper contact point to hit the ball where you want it to go. Never hit a weak grounder to third again! Well, there is no training technique that can promise that, but you should be hitting those a lot less after practicing these techniques.
