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 633rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create conditional formatting that will highlight the dates within a given year using the Year Function and Mixed Cell References in a logical TRUE-FALSE formula.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and work with pivot tables (PivotTables) in Microsoft Office Excel. Specifically, this video covers the following topics and examples:
This video shows you how easy it is to use system restore on Windows XP and Vista to bring your computer back to life. System restore takes your computer back in time to a point before it had errors or problems. Go to the start menu, all programs, accessories folder, system tools, and system restore.
Let's face it, people: Many of us power through the holidays with the aid of an extra glass of wine or beer here and there. Whether it's your perverted uncle or your overbearing grandmother that you have to put up with, a little buzz makes everything more jolly.
When we think of holiday songs, usually "White Christmas," Bing Crosby, and lots of fake snow falling on Bing Crosby while he sings "White Christmas" come to mind. Thanksgiving songs are often neglected or get lost in the shuffle during the very Christmas-centered holiday season.
As little girls, we always read stories about beautiful princesses with neverending long hair, some with hair so long they could turn it into a rope to aid their prince to rescue them.
It's like magic. Creating a .LOG file has never been easier. And all you need is Notepad on your Windows PC. After creating this LOG file, Notepad automatically inserts the current date and time after the last line. Check it out. If you've ever wondered about LOG file types, this Notepad trick is must.
In this clip, you'll learn how to ask someone you like on a date when flirting with him or her. As a general rule, when flirting with someone, it's important that you be confident and natural. But, if you're feeling nervy, there's little shame in doing a little prep work with silly videos like this one. For more information, and to get started using this tip for yourself, take a look.
This video shows viewers how to make a paper airplane. You should begin with an 8.5 x 11 piece of paper and fold one corner to the opposite side, making a triangle. This should be repeated on the other side, so that a cross is formed on your paper. Folding down opposite sides of the creases, you should have a triangular flap on your paper. Fold both sides of the flap upwards and then flip the paper over. You should then take the tip of the paper and fold backwards. Fold the paper in half so t...
In order to prepare a survival tin for camping, you will need the following: water purification, condoms, brass wire, a candle, a magnifying glass, waterproof matches, cotton balls, fishing hooks, small compass, whistles, fishing line, and empty tobacco tin, and artificial worms.
To take care of your relaxed hair, you will need to choose your relaxer carefully. Lean towards relaxers that aid tensile strength rather than deplete it. The hair has to be conditioned properly and regularly. Relaxed hair has been processed, and it requires a lot of moisture. Try using a hair mask. The Moroccan masks are a good choice for your hair. Make sure that you deep condition the hair at least once a week. Try to avoid blow drying your hair. Blow drying dries out the hair. It pulls th...
In this video, we learn how to prepare a pack for 2 days and 1 night of hiking. Each person has different needs, so change according to your preferences. Something important is to pack something to sleep on, which would be a hammock and blanket. Also, pack a Bible if you are religious. Hand sanitizer is a must-have for any hiker to kill germs that can cause illness. Make sure you have water bottles packed as well as a GPS and compass. Two different compasses are a good idea just in case one h...
In this how to video, you will learn how to clean your plastic headlights. This is important if you cannot afford to replace the headlights of your classic or semi-classic car. Toothpaste works great as a rubbing compound to fix this. First, take a rag and rub the toothpaste into the headlights. Next, take the paste off with another rag. Use some water to aid you in this. Now, your once clouded lens will be fairly clear. You can then move on to the other side to finish the whole car. This vid...
In this tutorial, learn how to make delicious homemade sauerkraut. Sauerkraut is a tasty tradition, and no summer picnic is complete without this classic topping.
In this how-to video, you will learn how to remove tattoos using Photoshop. First, open the image in Photoshop. The patch tool is the easiest for removing these type of tattoos. If the tattoo is very ornate and complicated, it will take longer to remove. First, select the patch tool, which looks like a band-aid. Hold it down and select patch tool. Zoom in on the tattoo and draw a selection around it. Once it is selected, click the left mouse and hold it down. Drag the selection to an area sim...
Here the New Boston shows you some tips about using the Spry Validation Text Field. To begin you will go to the Spry Validation Text Field, on Dreamweaver CS4. Looking at the bottom of the page notice the various options that are available for Properties. You find drop-down boxes for Type, Pattern, Minimum or Maximum values, Required, Enforce pattern, Format, Validate on, Blur or Change and Preview States. You can see the types of text available for validating by left mouse clicking the Type ...
In this video the Miami dating coach answers the viewers questions and tells you everything you need to do to attract that guy, and make him interested in a long term relationship. You'll learn what to look for what moves to make to have that boy in love with you for a long time.
Jevon's third video teaches how to make agua de piña a traditional Mexican drink which is much healthier than Kool-Aid or soda. To make the base, he starts with sugar, water, and pineapple. The pineapple is chopped into 1 inch pieces and put in a large bowl with sugar and water. Then he uses an immersion blender to chop up the pineapple further. Blending the mixture takes quite a bit of time as the pineapple should be shredded quite small. When the blending is complete, the mixture is straine...
Use this simple recipe to catch great catfish, and make it all from the comforts of your own home! First what you need is an old butter dish to mix in, as well as an old spoon. Cornmeal, flour, old cheese, kool-aid for flavor, garlic powder, tuna, and water are the simple ingredients you need for this wonderful recipe. Mix all of these ingredients together until the mixture is nice and thick. Next place the mix into the microwave and cook it for about one minute. After it is heated up, place ...
First you need to get some palm aid hair gel and rub it through your hair. Using a flat iron you use it where ever you want to start with your hair. While using the flat iron get a comb and brush your hair while you follow your flat iron. Using your flat iron move it upwards to get the style you like it. To get you hair to stand strait up you have to angle the flat iron away from your head to get that look. The hairspray helps to any parts in you hair that are not standing up. Then you just p...
This video shows some fun, inexpensive projects you can try for kids. There are several different crafts presented, beginning with Flubber, or Silly Putty. Mixing some glue, water and Borax in a bowl makes the same stuff you can buy in the store. The next craft is Crazy Crayons, where you gather old crayons together and heat them in an oven to make new, colorful creations. Then comes Spiffy-Sniffy Watercolor Paints, where we find out you can just mix water and Kool-Aid powder to make bright w...
Mind you now, that using a normal rectangular piece will not give you the desired results. You must use a square piece of any size. Start by making two diagonal folds for each corner to corner cross section. Now do two hot dog folds, like wise, then take each corner and fold it into the middle so it resembles triangular tabs. Now take these tabs and once again fold them in half but up to the outside of the paper, resembling another triangle. Fold Over, and do as shown in the video for the bes...
The drum support rollers are usually in the same spot on every dryer, no matter the brand. They will be below the drum. In order to remove the rollers, you need to open the dryer's cabinet and remove the drum. Perhaps you will notice that the left roller is more worn out than the right one. This is a common occurrence, but you need to replace both at the same time. Be sure to remove the nut before you remove the roller. Don't use more than one drop of oil on the hub as too much oil will aid t...
This video demonstrates how you can tell if someone is lying using visual accessing cues. This is a sample video of Kelley Moore teaching for a breakthrough collaborative application. She uses basic psychology terms to aid in understanding when someone lies. A sample visual cue for lying is to notice the eyes. If someone is lying, their eyes would twitch or unconsciously shift to the left side. If you follow the steps in this video, you'll be able to notice when someone is lying to you.
The video shows the user how to make their hands resemble those of a vampire. This is done by applying a thin layer of white makeup to the backs of the hand with a cylindrical sponge. The reason for only applying the makeup to the backs of the hands is to avoid coating surfaces you touch with the white makeup. It's suggested that you leave a gap between the makeup and the sleeves of your jacket as it does not spoil the effect and helps eliminate the likelihood that you'll get makeup over your...
This how-to video shows a way to create a pretty fairy look to use as part of a Halloween costume. The demonstrator used these cosmetics: Mac Studio Fix Fluid Foundation, Makeup Forever HD Powder, Mac Emote Blush, Airbrush Stencils, 88 Shimmer Palette, Flat Head Stippling Brush, Ben Nye Final Seal, Benefit Lemon-aid, 88 Shimmer Palette, Mac Uppity Fluidline, Mac Blacktrack Fluidline, Urban Decay 24/7 Eyeliner in "Zero," Ardell Enchanting Lashes, Duo Lash Adhesive, NYX Lipliner in "Rose," and ...
Groin strains are painful and can take a long time to heal. However a few massage techniques can help aid in the recovery of groin strains. Get expert tips and advice on massage and other treatments in this how-to video.
Ascenders are one of the types of equipment used in aid climbing. Ascenders allow the climber to maintain his progress when taking a break. Learn how to use ascenders in this climbing video tutorial. Take action: consult your local store, attach with carabineer, and use teeth to create gripping friction. Josh, the instructor in this how-to video from Live Strong, is an avid climber that resides off the coast in central California. He has managed for a mountaineering sports company for several...
Packing for a hiking trip is easy with these tips. Get advice on backpacking, hiking, and the great outdoors in this video tutorial. Take Action: pack heavy items at the bottom, bring extra water, and include a first-aid kit in your pack. John Flaherty, the instructor in this how-to video, has a great love for the outdoors. In 2003, John and his wife started Central Coast Outdoors in northern California. His company provides hiking, kayaking, and biking services for those wanting to be closer...
Check out this instructional science video that demonstrates how to make high production spirals. Since for many people it is much easier to buy 1/12 of an inch 316 L Stainless Steel welding wire or a 1/8 of an inch wire (instead of plates or tubes), then for those of you who do not have the practical skills this video might just be a little hint and a aid on how to proceed. There are so many details needed involved in order to make it simple and replicable. Learn how to build production spir...
If you suffer heel bruising you might want to consider using heel pads. Using heel cups and pads for rehab and treatment may aid recovery. Learn how to treat sports injuries in this how-to video on health and rehab.
Runner's nipple is caused by shirt fabric rubbing against the tips of the nipples. Learn how to prevent getting runner's nipple and stay fit in this sports medicine how to video. All you need to prevent runner's nipple is band-aids or petroleum jelly. Watch and see how simple it is to take care of.
In this video tutorial, Chris Pels will show you how to implement tracing in an ASP.NET web site to monitor or measure the performance and to diagnose errors. Learn how to add tracing to an entire web site as well as individual pages. See how to add custom trace messages in pages and business objects to aid in assessing site performance and in diagnosing errors. Learn the differences between tracing in an ASP.NET page and in using System.Diagnostics.Trace for tracing information in business o...
If you are having a difficult time getting someone's phone number this is the how to video for you. Watch and learn ten easy tips to getting a phone number and maybe even a date.
Professional Matchmaker, Samantha Daniels gives advice about how to date someone long distance. Long distance relationships are the most difficult relationships to have because you don’t have the easy and spontaneity of a regular relationship. However, if the person is worth it, you can make a long distance relationship work. Watch and let Samantha give you some simple tips for navigating and succeeding in your long distance relationship!
Let's face it: Powerpoint presentations are boring. For the most part, you use them as a lecture aid for science class or to give a presentation at work about market trends. Okay, we're making ourselves tired already. Point is, there's really not much going on with Powerpoint presentations, so make your next one as painless as possible by adding some cute animated clips.
In this video series, expert Marilyn Anderson teaches you the ins and outs of online dating. You will learn all about things to think about beforehand, sites to look for, and ways to search. Marilyn also teaches you how to write a profile, going for being positive and humor. You will learn how to choose pics for your profile, and why certain pics are no good!
Vanae goes over some tips on how to successfully ask a girl out in this video tutorial. The first tip offered in this tutorial is building a connection between yourself and the girl. This means talking and getting to know the girl before asking her out. The next tip is figuring out what she likes as far as restaurants and movies. The third step is to decide where you want to take her. For example, if there is a new restaurant that just opened up, Vanae suggests asking the girl if she wants to...
Watch this video to learn how to make a Middle Easter favorite, a date and walnut cake. It goes great with rose tea or coffee.
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 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:
