Year Old Saudi Search Results

How To: Use AGGREGATE instead of SUBTOTAL in MS Excel 2010

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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...

How To: Make a halter dress out of old t-shirts

Of two old t shirts, one is taken and marked from the collar to under the armpit on all four sides of the t shirt. The marked lines are cut along. The shirt is tried on and pinched and pinned under armpit until the right fit and marked with chalk. Both sides of the shirt is cut off and along the chalk line is pinned. A straight edge and chalk is used to make a line from the pin to the bottom edge of the shirt on both sides.Both side of chalk lines are pinned down. The bottom is made even with...

How To: Make an origami wallet from an old book page

The video starts out saying that we will learn how to make an origami wallet made from a page from an old library book. You trim the page to the size of 8 1/2 x 11. You then fold the page in half and then fold each piece back up, on the front and on the back. Then unfold so the page is just folded in half. Fold the ends about half an inch on each side, back and front. Then you fold each corner into little triangles, so that they meet the line that you had previously folder, about half way up ...

How To: Prune hybrid-T roses

John White and Rosemary Maddox Master Gardner will teach us how to prune our hybrid t-roses. To begin, you’ll need a set of bypass pruners, long handles loppers for branches or canes, which are bigger than your thumb. You may also need a pruning saw, 10% bleach solution which is 10 parts water + 1 part bleach., an old dog bowl for the bleach, gloves, and a low stool. Begin with the bypass pruners clipping all branches that may be crossing or too close to the main branches that you will keep. ...

How To: Repair and replace the DVD drive in your XBox 360

In this how-to video, you will learn how to repair and replace an optical drive in an Xbox 360. This will be helpful if your current optical drive does not work anymore. Remove the drive from the actual Xbox. Also remove the chrome tray from the old drive. Take the screwdriver and remove the screws of the cover. Push the black tab, allowing the board to be removed fro the drive. Do the same with all the other cables. Now, do the same with the new drive. Replace the old board and reconnect the...

How To: Flush your auto transmission fluid in less than 10 min

Instead of paying to have someone else do it, learn how to flush your auto transmission fluid in less than 10 minutes by following this tutorial. Unknown to most people, is the fact that draining your transmission from the bottom, only removes about half of the fluid, while the rest remains. This tutorial shows how to do a complete flush. First, find out how much transmission fluid your vehicle needs by reading the owner's manual. You will also find out what type of product you need to use. R...

How To: Create a New Year's harlequin mask makeup look

Traditional makeup is too boring for special occasions, so why not try something a little more fun to ring in the new year? This how-to video goes through the intensive process of applying a vibrantly colorful and ornate harlequin mask, using just makeup. The cosmetic products used to create this look are N.Y.C Yellow Concealer, Clinique Super Powder Double Face Make Up # 10 Matte Medium, N.Y.C Black Pencil Eye Liner, Graftobian Crème Foundation Yellow, Graftobian Crème Foundation #89092 Augu...

How To: Make a DIY Light Bulb Aquarium

Add new life to your old light bulbs by transforming them into a DIY light bulb aquarium. Using needle-nose pliers, a screwdriver, and a small hammer, you can remove the copper connector and other inner components from the light bulb to create a clear opening from the stem to within the bulb.

How To: Repaint Old Wooden Furniture

Bored of your living room furniture? As a weekend DIY project, one easy way to give new life to old wooden furniture is to add a new coat of paint. All you need are a drop cloth to cover the floor, sandpaper and sanding sponges, primer, latex paint, a foam roller, synthetic bristle brushes, and a well-ventilated room to paint the furniture in.

How To: Organize Your Chaotic Cable Clutter

If you are like most people, you probably have a discordant mess of cable and computer cords in your workspace or living room snaking all over the floor or against your desk. Though you can buy various cable organizers at the computer store, you can also organize them the DIY way with bread twist ties, binder clips, cardboard tubes, old credit cards, Velcro tape, or even your old hair clip.

How To: 11 Cool Ways to Reuse Old Jeans

Do you have a bunch of old jeans that no longer fit you or are too outdated to wear in public? If you are handy with a sewing machine, the possibilities for upcycling your jeans into something crafty are endless. You can update your old denims into a jean tote bag, yoga mat bag, quilt, or a super-handy utility belt (or mini-apron).

News: Sleeveface

Favorited by our man Crow. Submitted by user God. How could I not be tempted by this tutorial?    A perfect combination of old school retro, arts & crafts, and hipster cool.    Just take an old vinyl record sleeve, cover a part of your body, and snap a photo.     Proof once again that the how-to imagination of the internet has no bounds.

How To: Install a sliding glass door to your home

If you have an old glass sliding door that is difficult to open and looks ugly, maybe it's time to install a new one. That's exactly what this video focuses on. In it, you'll find out how to remove the old sliding door and install the new one. It is a project that can take up to a day or two, depending on your experience. So good luck and enjoy! Install a sliding glass door to your home.

How To: Apply a ceramic tile over an old countertop

Sometimes, it can be a pain to remove an countertops made of material such as wood and laminate. So an easy to do option would just let it be. If you're looking to add ceramic tile, you can easily do that over your existing countertops. This video will show you how for a quick to do and easy kitchen project. Enjoy! Apply a ceramic tile over an old countertop.

How To: Install or move a shower valve

This two part video show you how to remove an old shower valve, preparation and installation of a new shower valve. Also, you'll see how to clean, cut and connect copper plumbing pipes. Don't forget to watch part two and always make sure to shut off the water main first!

How To: Make the best padlock shim out of an aluminum can

The padlocks that secure most of America's high-school lockers are one of the easiest types of locks to open in the world for thieves and other miscreants. The easiest, cheapest way to do so is using a shim. These can be bought online, but why both when you can make one yourself out of an old soda or beer can? This video features a professional lockpicker at a conference explaining exactly how to make your own can shim and use it to open any padlock. You little devil you.

How To: Prank your friends into thinking their computer has had a major DOS error

DOS may be a distant memory for most computer users at this point, but for many it will always be the first thing that pops into their head when they ponder PC computing. Nowadays, the only time most people see anything that even looks like DOS is if they're playing old PC games in a shell or something has gone very, very wrong with their computer. With this prank, you can make your friend believe that the latter has happened to them! All you do is open the DOS command program (Windows XP or ...

How To: Remove old web page content from Google's index

Google is the biggest and best search engine on Earth, and if you are a webmaster and want your website to be a big success it would really behoove you to know as much about how it works as possible. The Google Webmasters series of videos and website were created to teach webmasters, SEO professionals, and others how Google works by answering their questions and giving them insights into how they can best integrate and utilize Google's functionality to improve their business. This video will ...