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 226th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply names to formulas and replace existing cell ranges as well as how to name ranges from selections.
This is video is a tutorial on how to sharpen a pocket knife. It is filmed as a man sits at a dining room table discussing points and demonstrating how to properly sharpen the knife. He makes several points about different ways on how to sharpen knives. He is careful to explain why you sharpen the knife during each step in the process. This video would be great for people who have never sharpened a knife before because he discusses a lot of information. However, if you're just looking for a n...
This Adobe Illustrator tutorial demonstrates the basic shape modes in path finder (add, subtract, intersect, and exclude), and shows how to use the direct selection tool and expand features of Illustrator. Finally, a bubble box is created (for the Yahoo Map project) with the add shape mode and a drop shadow effect added.
This is a tutorial in Adobe Photoshop CS2 demonstrating primarily the use of the quickmask tool to make precise selections of organic shapes. Other topics covered include adjustment layers and layer masks. So watch and learn how to enhance photos using quickmasks, layer masks and adjustment layers in Photoshop CS2.
This is a great little project for beginners and shows how to make a simple knotted bead bookmark. They also make thoughtful handmade gifts! You will need some waxed cord, a selection of beads, some scissors, and glue. Learn how to make this bookmark by watching this video beading tutorial.
Selecting orchid plants takes more than just admiring an orchid's flowers, but with the right information it can be quick and easy. To find the expert's secrets on orchid selection, Meghan Carter visited award winning orchidist Dick Wells of Hilltop Orchids and got to the bottom of how to pick out the best orchid flower.
A pinch harmonic is an overtone. This video is a demonstration of how to play a pinch harmonic on the electric guitar with a right hand technique. Distortion, attack, vibrato, pick selection and more are discussed in relation to this topic.
If you have a lot of jewelry and hair accessories then your collection probably looks more like a land fill than an exquisite, well-curated and organized selection of adornments.
This video is an extensive and in depth analysis of how you can best play a four-person team on a multiplayer match in Call of Duty: Black Ops, especially on the Kino Der Toten maps. Always know where to look out for campers!
By enabling the dev console in Fallout 3, you can give yourself exactly the same kind of superuser game access that the developers have when they are working on the game. Here's an extensive list of console commands you can use to get all sorts of great stuff.
Sometimes, you want to focus the attention of your viewer on a particular aspect of your image, or get rid of extraneous or distracting details. This retouching tutorial shows you how to use Adobe Photoshop to reduce detail and simplify your selection without losing much meaningful content overall.
In this tutorial, you'll learn about the cables required for setting up a small home or office network. Fortunately, cable selection is an easy process and this video presents a complete guide. For more information, including a full demonstration and detailed, step-by-step instructions, watch this helpful home-computing how-to.
You used to need scissors and glue to be able to create a collage. Now all you need is a selection of digital images and a copy of Adobe Photoshop Elements! This tutorial shows you a few techniques to turn your favorite photos into a collage.
In this clip, you'll learn how to use the Slice and Slice Selection tools to create and adjust slices when doing design work in Adobe Illustrator CS4 or CS5. Whether you're new to Adobe's popular vector graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video ...
Are your electricity and water bills comparable with that of Raging Waters? Then it's probably the right time to consider how to save on your energy and water bill by taking small steps like assessing where you're at in your home, having an energy audit, and eliminate leaky faucets.
It's time to get down and dirty in this next tutorial. If you own a lathe, you may already know that there is a great selection of different styles that can be carved using the right carving tools.
Expand your dinner table selection, with help from ths wonderful and easy recipe for stuffed cabbage. Include this as a side dish to a main meat dish, and nobody will leave your dining table unsatisified. For this recipe you will need: cabbage, white wine, chicken broth, carrots, tomato sauce, onions, tomato, cooked rice, celery, garlic, and ground beef.
Using ASP.NET Secure Services and Applications Services
Dave Campbell shares some tips to speed-train for marathon running. All runners should develop their speed-skills to enhance recovery and as well enhance efficiency. As a warm up, start an easy run, do some active stretches and drills like low-skip, high-knees, butt-kickers to emphasize different parts of the running form. You can also do short fast sprints to emphasize perfect form and technique. After an extensive warm up, you would run 800 at a prescribed pace and then jog a 400. Being abl...
Excel dilettantes and seasoned Microsoft Office professionals alike may be surprised to learn that in Excel one can make a drop down list based upon a second drop down list (or, similarly, data validation list that is based on a second validation list).
This video is a tutorial on how to fade and tear your denim jeans. She uses a lot of tools such as knives, potato peelers, chalk, and bleach to name a few. When she is demonstrating how to use the knife to tear the jeans, she is cutting towards her body which is very dangerous considering she could stab herself. She does tend to ramble on throughout the video which is why it is almost 10 minutes long. When she's applying the bleach, once again her techniques are not safe for viewers to attemp...
Originated by James Higgins (AKA "The Original Skeeter Rabbit") in the 70s, the skeeter rabbit is a shuffle step you can use in your hip hop dancing. This move employs your skills on locking to contrast with the fast moves you're doing on the dance floor. The skeeter rabbit calls for extensive use of your legs, hopping swinging and freezing for a frantic move that's sure to impress on the dance floor. This video tutorial will teach how to do the skeeter rabbit dance move.
This video shows you everything you need to know to repair your mountain bikes rear derailer. From dismantling, to putting it back together, position the chain, cutting the chain, releasing the cable, and giving your bike the love it needs. This is an extensive, yet easy to follow tutorial to keep your bikes maintenance up to date for an enjoyable and easy ride. You can use these instructions for any kind of bike really, but in the video we see the mountain bike. So gear up for a fun ride.
In this video, learn about the different functions of the Canon EOS 7D, which features an 8 frame per second shooting speed. This video goes over menu options & configuring the buttons, AF point selection, AF focus, & the flash functions.
Bucky from The New Boston serves up this Python video tutorial on how to do cool things with strings in Python. This is the program you use to write all of your Python code down. Do cool things with strings and format them!
Bucky from The New Boston serves up this Python video tutorial on how to use cool string methods in Python. This is the program you use to write all of your Python code down. Cool string methods!
Bucky from The New Boston serves up this Python video tutorial on how to use dictionaries in Python. This is the program you use to write all of your Python code down. Dictionary!
Bucky from The New Boston serves up this Python video tutorial on how to program "if" statements in Python. This is the program you use to write all of your Python code down. The famous if statement!
Bucky from The New Boston serves up this Python video tutorial on how to program else and elif statements in Python. This is the program you use to write all of your Python code down. Else and elif (elseif)!
Bucky from The New Boston serves up this Python video tutorial on how to program nesting statements in Python. This is the program you use to write all of your Python code down. Nest a simple "if" statement!
Bucky from The New Boston serves up this Python video tutorial on how to program full and while loops in Python. This is the program you use to write all of your Python code down. Learn how to use the for and while loop in Python programming!
Bucky from The New Boston serves up this Python video tutorial on how to program infinite loops and breaks in Python. This is the program you use to write all of your Python code down. Learn how to make an infinite loop and also how to use the break statement!
Bucky from The New Boston serves up this Python video tutorial on how to build and program your own functions in Python. This is the program you use to write all of your Python code down. Learn how to create your own function!
Bucky from The New Boston serves up this Python video tutorial on how to use default parameters in Python. This is the program you use to write all of your Python code down. Fun with default parameters!
Bucky from The New Boston serves up this Python video tutorial on how to program parameters in Python. This is the program you use to write all of your Python code down. Different parameter types in the same function!
Bucky from The New Boston serves up this Python video tutorial on how to use tuples as parameters in Python. This is the program you use to write all of your Python code down. Fun with tuples!
Bucky from The New Boston serves up this Python video tutorial on how to program object oriented programs in Python. This is the program you use to write all of your Python code down. OOP or the famous object oriented program. Hold on guys, the waters getting rough!
Bucky from The New Boston serves up this Python video tutorial on how to program classes and self in Python. This is the program you use to write all of your Python code down. Fun with classes and self!
Bucky from The New Boston serves up this Python video tutorial on how to program subclasses and superclasses in Python. This is the program you use to write all of your Python code down. Learn what parent and subclasses are!
Bucky from The New Boston serves up this Python video tutorial on how to overwrite variables on a subclass in Python. This is the program you use to write all of your Python code down. Fun with subclasses!