1. The following instruction describes how to generate sub totals in Microsoft Excel Sheet. 2. Take Region as a Primary column and Sales Rep as a Secondary Column. 3. First method to sort: Select a cell in Region and goto Data select A to Z. 4. Second method to sort: Select a cell in Region and Right click and select Sort A to Z 5. Then click a cell in Region and select Data->OutLine->SubTotal 6. In the SubTotal Window select 1.Each Change in: Region 2.Use function:Sum 3.Add subTotal to:Sales...
Need to make a PCB quick? Well, this video tutorial will show you how to create a PCB with the toner transfer method using photo laser paper.
Are you fed up using Zbrush? Are you just not cut out to be a 3D digital sculptor? Nah, all you need is a little practice. Check out this three-part Pixologic video tutorial on how to use the basics when sculpting a head. You'll see how to make the perfect 3D animated head, and you'll learn how to make an imperfect head. You'll learn how to form with a few tools, and be on your way to great 3D animated character modeling. NOTE: the tutorial starts by using a squirkle, NOT a square mesh - if y...
Alright, there are lots of videos out there dealing with Master combination locks, but this how-to video will show you how to open a Dudley combination lock. These locks are commonly used in schools, so you've likely seen one there. This method opens the lock permanently, meaning you won't be able to close it afterward. You'll need a flat head screwdriver and a little patience. The method involves prying off the style, allowing you to get to the insides of the lock. After that, you'll be push...
This video is aimed at beginner level viewers and shows one of the basic techniques involved while solving linear equations having one variable.
Whether you are pursuing drawing as a professional or as a hobby or you are just a common person, we're pretty sure that you have drawn a tree somewhere in your lifetime. This video merely shows how to do the same in a better way. Though there is no narration (just background music) in this video, it is easy to understand the additive method of drawing. The artist starts off with a broad tree trunk and then starts adding thinner branches to the trunk that spread outwards. Then, even more thin...
Want to create 3D shapes in flash easily, without doing any real 3D modeling work? Watch this video and learn a few basics. An Adobe Flash tutorial video that is essentially divided into three sections. The 1st section teaches how to create a rounded filled circle with spherical effect and depth. The second part teaches the same thing with rectangular objects while the third teaches how to create a cylindrical effect using a rectangle. The obvious uses of these methods is to create your own 3...
If you like homemade light shows, this is one hell of a way to do it. AP Digital light shows you how you can hack a small fan into a special mirror used to create a poor man's PIC-based laser show. It's an experimental method of balancing a fan-mounted acrylic mirror for spirograph project.
Several Tanzanian girls demonstrate how to tie a kanga (an African sarong). The first method is to wrap the kanga around the waist and tuck the end in at the waist to secure. The second method is to wrap the kanga into a cylinder to use it as a base for carrying a parcel on the head. Another way to wear the kanga is to wrap it around the neck like a shawl or wrapped under an armpit and tied over the shoulder for a fancier look. To wear the kanga as a scarf, fold it into quarters the long way,...
In order to make flower magnets and faux brads, you will need the following: card stock, a hole punch, a sponge applicator, and crystal effects.
This video illustrates the quick and easy method to Dual boot Windows XP & Vista . The process is comprised of the following steps:Step 1: Install Windows XP OS on your PC. Run it and see if it works fine.Step 2: By using the Windows Vista OS setup , start the installation process and choose "Custom Installation" as the installation method.Step 3: Make sure you install Windows Vista on a Local Disk different from the one where Windows XP or any other Windows OS is installed as this may result...
This particular video demonstrates a method to wax your snowboard. This method of waxing the snowboard does not involve use of iron. It is done using a large piece of wax and a piece of cork. Firstly we need to rub the piece of wax over the surface of the snowboard. Hard rub is required and one ball jay is the most efficient. After rubbing for some time we need to polish the waxed using a large round piece of cork. After polishing for some time you will discover a shiny looking snowboard read...
Learn how to add the decimals together in simple and easy steps. 1. First practice adding two normal digits using the traditional adding method and get your answer correctly. 2. Now to add the decimals together use the same example by including decimal points to them. 3. The adding will also be the same traditional method except that you have to place a decimal point in the exact location of your answer. 4. Now take another example (E.g.: 3. 33+4. 2) and add it in the same way by placing a ze...
Danby Taylor from the University of Maryland University College teaches how to write an abstract research paper for graduate school Analyze the things that you read so you can extract the essential information such as the goal or the purpose of the reading in your own sentence. Learn the methods or ways of how the author studied the subject and reached the results of the study. Pay attention to details and write in a block paragraph, without indentations. Write one or two sentences about each...
Like most of us, you probably recorded some of your favorite memories onto a VHS tape. Preserve the good times by transferring the tape to a DVD.
This video series shows one method to produce an artistic watercolor effect from a photo. Instruction also incudes tip for "actionizing" this method, in Photoshop. Remember, this is an artistic idea so make your own interpretations and additions!
In this video we learn how to draw a nose using simple methods. Use a grid to start sketching out your drawing. Note the dark and light areas by outlining them on your paper. Then, crosshatch the first layer using whichever method works the best for you. Then, use a tissue to blend the pencil marks in with each other and create a lighter shade. Grab your darker pencil and mark on the darker areas of the nose, then start to shade in darker then before. To finish, use your pencil to add in the ...
If your baby isn't quite coming on schedule, you're probably wondering to yourself how you're going to make it happen. This video will show you countless natural methods to getting your body to begin labor, be sure to keep a piece of paper and a pen, there's a lot to take down!
Pixie braids are a lot different than micro braids, and this video will show you a few methods to styling pixie braids in your hair. These two methods are the burn (seal) and pin curling the ends techniques. These examples are perfect for your hair if trying to achieve the bob style.
Is there a way to stretch your natural hair length without using heat? Yes! It's called the banding method, and this video will tell you all about it. Watch to see the detailed process of combing and banding your natural hair to stretch your hair.
Transitioning from riding a snowboard on the ground to launching it (and you) into the air off jumps is scary and dangerous. That doesn't stop people from doing it though, and this video offers a lot of good advice for how to take an air off a ramp with your snowboard. Specifically, it describes how to perform a Method grab while in the air and land it successfully.
Having problems with cubes. For some people, mathematics doesn't come easy, but there are tricks to solving certain problems, like squares and cubes. Check out this math video tutorial to learn how to get cubes in math with mysterious Vedic methods.
Having problems with subtraction. For some people, mathematics doesn't come easy, but there are tricks to solving certain problems, like subtraction. Check out this math video tutorial to learn how to perform mental subtraction for math class.
A great way to rack your brain is by trying to solve a puzzle, so grab your puzzle and get solving! If you need a little help, this video tutorial will show you how to solve the Rubik's Cube F2L with the Keyhole Method. The 3x3 Rubik's Cube is one of the most baffling puzzles on the market today, so make sure your up to speed on solving it. Watch and learn a few algorithms to get your puzzle solved! The Keyhole Method is an easy way to cut down on the layer-by-layer approach to the first two ...
Check out this video tutorial on how to use the "double string method" to simulate cylinder fins on dummy model engine cylinders. If you like building engines for remote-controlled vehicles (airplanes), then this will definitely help you out with your RC projects, just by learning the "double string method" for cylinder fins simulation.
The landing method used in this video, crosswind landing, is the method which can be most useful in FSX. There may be better ways to land in this scenario but for this basic tutorial this approach was best. So watch and learn how to crosswind land a plane in Flight Simulator (FXX).
Installing drywall means a lot of measuring and a lot of cutting. In this how to video, home improvement expert Danny Lipford looks at easy methods for the do it yourselfer to cut drywall.
Drying herbs like sage is a great way to store the bounty of your garden. In this how-to video, Rita Heikenfeld from AboutEating.com shows you a simple way to dry and store your herbs straight from the garden. Use the old fashion method of drying herbs to make sure they last through the year.
This how-to video stamping tutorial demonstrates two methods of heat embossing using a heat gun or heating tool, stamping powder, a rubber stamp, Versamark watermark ink and a pigment ink. Heat embossing is a great technique to multi-task rubber stamps and create some texture in card-making or scrapbooking projects. Learn how to do two different methods of heat embossing with an embossing tool by watching this how-to video.
This video is designed to give lots of clear and helpful information about the cable cast on method. It produces a nice, even cast on edge which is excellent for picking up stitches for decorative borders.
In this guide we show you the how to cast on knots using the two needle method. This helps create a loose edge in your knitting projects.
This video will help you learn how to remove the blade from your riding lawn mower deck. The method for taking blades off of a double or triple blade deck is similar to the method shown in this movie.
In this golf lesson golf instructor Steve Bishop discusses some popular takeaway methods, his whole club takeaway method, and examine some common faults among golfers. These tips will help you swing on plane from the very start.
Learn how to use method extraction in a simple scenario in Visual Studio with C#.
Learn about ancient iridized glass and a method for creating iridized glass surfaces. This video is part of the exhibition "Reflecting Antiquity" at The Corning Museum of Glass (February 15 - May 27, 2008). Note: the method portrayed uses stannous chloride fumes, which can be highly toxic. Do not attempt this without proper protective equipment.
In this video drum lesson, you will learn the two most popular bass drum techniques. This includes the heels-up and heels-down methods. Each have their own advantages and disadvantages, so it is highly recommended that you learn both methods.
Gum is fun to chew on, but no so fun when it pops out of your mouth and lands on the carpet. This video shows you one of the quickest and easiest methods for removing gum in your carpet.
With the rise of OLED displays, Android users have been begging Google for a true system-wide dark mode for years. While a system-wide solution is still somewhat unlikely, Google has given in by providing a dark mode for certain apps, including Contacts.
The iTunes App Store makes it easy to buy an app or game on someone else's behalf, and it's a great way to send an iPhone user a thoughtful gift. The Google Play Store doesn't have such functionality, but there are still a few workarounds to accomplish the same goal: gifting an app to an Android user.
For the majority of phones, Android's volume rocker is wrong. A large vocal part of the Android community wishes the volume buttons' default control was the media volume, not the ringer. Although the Galaxy Note 9 is in the "wrong" camp, Samsung has included multiple ways to change it.
