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 662nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add or average while ignoring values in hidden rows. In addition you can ignore both Hidden Rows and Error Value.
These chocolate-raspberry cupcakes dessert may look intimidating, but don't let that stop you from making this yummy chocolate and raspberry treat. Plus, in addition to getting your daily fill of chocolate, you can also claim that eating one of these cupcakes counts as a serving of fruit (it does!), which means you're being health conscious as well. Sort of.
By now, the phrase "Taco Tuesdays" has acquired a sort of all-American, mass produced, and "lazy mother" sort of connotation, as many types of frozen tacos can be easily acquired at the grocery store and then simply heated for a meal.
In this clip, learn all about the brand new cameras on your iPhone 4. The latest iPhone from Apple has made major improvements on the cameras from the older models. Not only do you now have a flash, but you also have TWO fully functioning cameras with great picture resolution for a cell phone. In addition to that, the iPhone 4's new camera has face recognition software, a zoom lens AND an autofocus. There are so many fun things you can do with these cameras from photography to video to two-wa...
You either like pineapples or you don't. For some, pineapples are the epitome of a tropical treat, sweet and juicy and the perfect fruit salad addition. For others, they're saccharine and too damn difficult to prepare.
This tutorials covers how to create a more advanced type of facial rig, showing you how to use the "stretch to" constraint to give the face a more fluid way of animating. The "stretch to" is great for things like lips and eyelids (which is shown in this tutorial); in addition, you'll see how to make the eyelids "stick" to the eyeball surface, so there's no unwanted gap between the two while animating. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics appl...
No one expects you to have a gym full of dummbells and exercise machines at your fingertips, nor does anyone expect you to drop hundreds of dollars monthly to tone your fabulous body at the gym.
In mathematics, the order of operations define the priority in which complex equations are solved. The top priority is your parenthesis, then exponents, followed by multiplication and division, and finally addition and subtraction (PEMDAS). This video tutorial demonstrates the order of operation with various examples and explains the associated methodology. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autod...
Attention sushi enthusiasts! The natsu maki, also known as "the summer roll" is refreshing and easy to make for sushi beginners. This roll is a great addition to the menu for those who are trying to make the transition to raw. What's inside this delicious roll? Cucumber, avocado and crabstick... essentially a California roll. Half seared and half raw salmon tops this roll, as well as lemon juice and kewpie mayo to make for a perfectly delicious meal.
In this Home & Garden video tutorial you will learn how to conceal screw heads. This video is from www.ultimatehandyman.co.uk. It is very easy to do. You will need a kit called screw digger and plug cutter set for size 8 or size 10 wood screws. Using the drill bit from the set, drill the hole. This will drill a hole for fitting a plug in addition to the hole for the screw. Now take a piece of similar wood and cut out a plug with the plug cutter tool as shown in the video. Drive the screw in t...
This video demonstrates how to make a Strawberry Smoothie. For this recipe, you will need the following ingredients: fat free yogurt, a banana, ½ of a cup of milk, 2 T. flaxseed, strawberry whey powder, and fresh strawberries. You could add oatmeal or other fruit, if you would prefer.
Pergolas make a lovely addition to any home. They offer shade and interesting shape to where you live. In this two part tutorial, learn how to build your own pergola for your home. Follow this step by step video and soon you'll be on your way to relaxing in one of your very own!
This video offers Photoshop users a detailed procedure for adding simulated water droplets to photographs. A male voice-over describes each step in a conversational tone, and his instructions are easy to follow and apply. As he narrates, each step is carried out on screen, allowing you to find the different Photoshop tools and settings when you do it yourself. The procedure uses the gradient tool, drop shadow, and liquefy filter to create a water droplet to a clover leaf. In addition to showi...
In another great video from FashionFace TV, we get a full face look inspired by the iconic beauty of Raquel Welch.
In this video from Fashion Face, we are shown how to do a 1920's pink film noir makeup look that was actually requested by Courtney Love and originally created by a makeup artist for the brand Illamasqua. This is an extreme look, and there are a lot of tools and makeup involved, but it creates a really cool look, and provides some great tips.
If you or someone you know has light eyes, then you are no stranger to red eye sneaking into your photos. Red eye is an annoying addition to most photos taken with a flash camera. Luckily, if you have Photoshop, this is easy to fix. With this tutorial, learn how to use the Channel Mixer tool in Photoshop to edit your prints, and make it look like the red eye never existed. None will be the wiser when you display these altered photos. Using the channel mixer is an all time classic red eye remo...
This video is a highly informative tutorial on how to add and control text to a line in Photoshop. According to the author of the video, most people can add text to paths in Photoshop, but are often in the dark about how to manipulate. This, as demonstrated by the author, is quite easy and simple. The tools for path selection, text addition, and various other features which make this particular task very simple are clearly outlined by the author.
In this tutorial Mike Lively of Northern Kentucky University shows you how to get started with Wireshark. Wireshark is a network protocol analyzer for Unix and Windows. It is used for network troubleshooting, analysis, software and communications protocol development.
In this video tutorial, Chris Pels will show how to read, write, and delete cookies in an ASP.NET application. First, learn the basic operations for manipulating cookies. Then learn approaches to storing multiple values in a single cookie using name-value pairs called subkeys. Next, learn how to limit the scope of cookies to a particular application domain or folder. See how to modify values and expiration dates in existing cookies and how to delete an existing cookie. In addition, several co...
In this video tutorial, Chris Pels will show several aspects of defining and using master pages in an ASP.NET web site. First, see how to create master pages declaratively using the ASP.NET master page model and learn what information is best suited to a master page compared to an individual content page. Next, see how to programmatically assign master pages on-the-fly in an individual content page. Also learn how to create a base page class which assigns a master page programmatically for al...
In this tutorial, learn how to make an entirely unique salad with Betty. This loaded baked potato salad is warm and delicious and makes a perfect addition to any gathering or picnic. Enjoy!
Roofing is pretty dangerous work, maybe one of the most dangerous is residential construction. But if you're following all of the necessary safety guidelines, the chances of getting injured on the worksite are minimal. Working safe doesn't take long, and you don't have to sacrifice safety to do quality work and make a profit.
This video is dedicated to the residential construction workforce and focuses on how to safely install siding. It's intent is to help provide employees and employers with the tools to make the residential workplace productive and safe. It outlines a number of code requirements and will show how to work safely and how to meet all of the safety requirements during the siding phase of residential construction. The areas discussed in this safety video are job preparation, walk-around safety inspe...
One of the most important things in a person's life is sleep (some of us don't get enough of it, and some of us get too much). Why not make it one of the most comfortable things, too? Having the right sleeping attire is great for comfort, especially when you make them custom yourself. See how to make pajama tank top in this video from GiannyL.
Sleep is one of the most important things in a person's life. So why not make it one of the most comfortable things, too? Having the right sleeping attire is great for comfort, especially when you make them custom yourself. See how to make pajama pants in this video from GiannyL.
Chef Don from HouseCallChef demonstrates how to grill mushrooms, asparagus, zucchini and yellow squash. You can also grill other vegetables such as parsnip, rutabaga, potatoes, tomatoes or peppers, and even some fruits like pineapple, watermelon, apples and oranges. You can use any type of grill that you want.
John White, a Doña Ana County Extension Agent, highlights a new section on the show - a monthly checklist for the garden. This time, he talks about what to do in your garden in the month of February. The checklist includes planting dormant plants, pruning with a purpose and applying herbicides and pesticides. He shows us various types of dormant plants that can be purchased from nurseries in February for planting such as potted, bare-root or root-balled plants wrapped in burlap. As for prunin...
If you have never dealt with wire color-coding then Old64goat takes you through a very elementary tutorial that will give you the helpful aid needed to deal with common household wires. The first cord that is reviewed is the three pronged cord. The color wires contained within it is the green wire which is the ground prong, the white wire which is neutral, and the black wire which is the heat. Old64goat then demonstrates where the wires are connected to on the prong. He even gives out helpful...
John White discusses how to propagate houseplants. You will need a potting mix called a “soilless” mix, which contains only vermiculite, perlite and peat moss. In addition you will need a sharp knife, a pruner and a weeding hormone to help induce root growth on the cuttings.
Bob and Jeremy of the Washington Township Fire Department demonstrate P.A.S.S., which is an acronym to help people remember how to operate a fire extinguisher - Pull/Aim/Squeeze/Sweep. Pull the pin, Aim the nozzle at the base of the fire, Squeeze the handle down, Sweep from side to side at the base of the fire.
What does your backyard need? A garden. You already have one? Then how about a garden bench? Join Lowe's as they walk you through, step by step, the building of a wooden garden bench. One of the most marvelous things about woodworking is that with just a little planning and effort, you can turn a few boards of lumber into an beautiful and elegant project like this bench.
Learn to use Zotero to create bibliographies and citations with this tutorial. In addition, collect and organize information from all sources. So help correct the sources research paper. Before using the excitation features, make sure to select and prepare the style of your paper. If you are not sure ask your instructor. She has a preference style. You will select by clicking on the action button +preference then choose the style. It will include the number of most common style. You can downl...
Homemade granola is a welcome addition to any recipe collection. This recipe is perfect for vegetarians and suitable for all ages. Serve granola for breakfast or with yogurt for a midday snack. Because this recipe contains wheat germ, sunflower seeds, and honey, you will find that it is a delicious alternative to commercial granola. There are no artificial ingredients or additives. Learn how to make it.
Systm is the Do It Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. We will help you avoid pitfalls and get your project up and running fast. Search Systm on WonderHowTo for more DIY episodes from this Revision3 show.
Check out this overclocking tutorial from HotHardware.com! Intel's Core i7 processor offers a significant performance increase over previous generation Core 2 processors. In addition, like the legacy Core 2 architecture, the new Core i7 also has a bunch more headroom for wringing upside performance out of the chip, maximizing value, power and return on your investment with overclocking. In fact, Intel actually built-in a predefined overclocking feature called "Turbo Mode". We explain how not ...
Excerpts from a presentation by Dr. Simeon Hein at the International UFO Congress, 2005. Dr. Hein is the director of the Institute for Resonance in Boulder, Colorado. The Institute is devoted to the study of subtle-energy sciences including remote viewing, crop circles and related subjects. Dr. Hein has a Ph.D. in sociology and has previously taught research methodology and statistic courses. Dr. Hein first learned remote viewing in 1996 and subsequently became involved in crop circle researc...
It's very easy to get a slightly blurry photograph due to a moving subject, camera shake, or just an incorrect auto-focus, but you don’t have to let that ruin an otherwise terrific picture. All it takes is a little finesse in Photoshop or another photo editing software. This guide covers sharpening a blurry image using Photoshop specifically.
Pronunciation is key to learning any new language. Before diving into the vocabulary and basic phrases, a good approach is to listen and try and get your aural perception honed in. A new word or phrase, like "je m'appelle" in French, is awesome to learn, but it's important to learn it correctly: that starts and ends with pronunciation.
Bring some excitement to your vest. Accessorize and expand your wardrobe with this stylish multi-functional vest cover-up. This one piece can be re-configured and worn in totally different stylish ways! See how to make a multifunctional vest coverup in this video from GiannyL.
This explanation of positive and negative signs in addition is beneficial and easy to understand for young school aged children. The tutor of this video explains briefly about what to do with the different signs on both side of addition problem. The number line helps the viewer of this video to visually understand the concepts discussed. The tutor explains the direction of number line evaluation is dependent on the left side operand, which is also used to understand the concept of a number line.