Category Search Results

How To: Make an Excel PivotTable year category from text dates

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 612th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Year Category for a PivotTable from dates entered as text using the RIGHT function and the ampersand (&) join symbol.

How To: Create a WordPress sidebar widget that displays links by category

In this clip, learn how to create a smart sidebar WordPress widget to display your links. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.

How To: Change themes on your Xbox 360

This video tutorial is in the Video Games category in which Tina Wood will show you how to find and change themes on your Xbox 360 (Xbox 101). Head over to game marketplace, select explore game content, and then choose "themes and gamer pictures". Here you find "halo 3 ODST" and download it. Once it is downloaded, you can choose "change theme" right then and there to redecorate your dash board. You will find one image on my Xbox, one on the game library, one for the video, music and picture l...

How To: Understand polyatomic chemical formulas

This is a video tutorial in the Education category where you are going to learn how to understand polyatomic chemical formulas. When writing the formula using polyatomics, the same cross-over rule applies. 1st identify the metal and non-metal. Then you write the symbols, write the charges, cross-over the charges from top to bottom, remove the charge and simplify the numbers and remove the 1s. for example, iron (II) phospahate. The "ate" ending implies that phosphate is polyatomic. The symbol ...

How To: Send an update to the fans of your Facebook page

In this how-to video, you will learn how to send an update to the fans on your Facebook fan page. First, go to your fan page. Go to the top and press edit page. Now, click send an update to fans. Now, click edit to change who will receive this update. This includes sending it according to gender or location. Enter the subject and message of the fan page. Click send to complete the process. This update will be shown in the sub category in the messages page called updates. Click it to read the ...

How To: Use a protractor to measure an angle

This video in the Education category will show you how to use a protractor to measure an angle. This video is from Brightstorm. In Geometry it is important to know how to measure an angle. This is a very simple and easy process. In order to measure an angle, you will need a protractor. Every protractor has a base and a center point marked on the base. You will put the center point on the vertex of the angle. Then align the base line of the protractor perfectly on one side of the angle. Now ch...

How To: Do barbell hack squats

This video in the Fitness category will show you how to do barbell hack squats. The video is from Livestrong. Michelle Trapp, a Certified Personal Trainer at Gold’s Gym will demonstrate this routine. Keep the bar low enough so that you can safely un-rack it. Stand next to the bar facing away from the bar. Lift the bar and step away from the rack. Keep the bar close to your legs and let it slide along your legs as you come up and down. Your chest should be up and your head should be straight u...

How To: Shop the App Store on the Apple iPhone 3G

Right out of the box, iPhone is incredibly easy to use. If you want to get the most out of every feature, you’ve come to the right place. This video tutorial straight from Apple will teach you how to shop the App Store on the Apple iPhone 3G. The iPhone redefines what a mobile phone can do.

How To: Open XML on Mac OS X

Working with both Macs and PCs covers all bases, but it also adds new problems. If you fall into this category, you probably work with file formats that are not incompatible with the other computers. One of these file types in XML files. This tutorial will show you how to open XML on your Mac.

How To: Play chess like Napoleon Bonaparte

Check out this chess video tutorial from Grandmaster Alexandra Kosteniuk on how to play chess like Napoleon Bonaparte. This chess game is from Napoleon vs General Bertrand in St. Helena (1818). White plays and wins, but how? Well, see for yourself. Let's just say that Napoleon wins the chess game with his queen.

How To: Kill boredom with weird and random websites

This is a video tutorial in the Computers & Programming category where you are going to learn how to kill boredom with weird and random websites. This video lists 11 such websites and explains what each one does. The 1st one is Zigzagphilosophy. This site allows you to make a lot of zig zag lines on the screen by moving your mouse. #2 omglasergunspewpewpew. On this site you use the mouse to control a squirrel on the screen and use the left click to shoot a laser. The #3 site is allemande and ...

How To: Make a miniature vortex cannon

This is a video tutorial in the Education category where you are going to learn how to make a miniature vortex cannon. For this you will need normal plastic drinking cup, punching bag type balloon, black electrical tape, lighter, candle, scissors and a drill. Drill a hole in the bottom of the cup and cut off a big circle at the bottom. Cut the punching bag balloon in half and stretch it over the mouth of the cup and tape it up nicely. The cannon is ready. Now light the candle, hold the cup aw...

How To: Fold a five-point paper barn star

This is a video tutorial in the Arts & Crafts category where you are going to learn how to fold a five-point paper barn star. You will need a square sheet of paper. Fold it in half to make a rectangle. Take the right folded corner and fold it up to the left edge of the rectangle. Place the corner about 1/3 from the top edge and fold the sheet. Next take the left corner and fold it over the edge you just folded. Finally take the flap on the right and fold it over to the opposite side. Now cut ...

How To: Create a macabre and beautiful dark fairy Halloween makeup look

Fairy costumes are as common as witch costumes or vampire costumes (especially now with the "Twilight" fever) for Halloween. But dark fairies are a whole other category altogether. Rather than the cute pink frills, golden hair, and pixie dust you imagine your typical Disney fairy to have, the dark fairy in this makeup tutorial is scary, though still beautiful.

How To: Use the English proposition "at"

This video is in the Language category where you will understand how the proposition "at" is used in English language. "At" is used to indicate either location or time. A few examples of using "at" for indicating location are; "I am at school", "You are at home", "She is at the store" and "They are at the park". To indicate exact time, the preposition "at" is used. A few examples are; "The movie starts at 6:15", "You have to be there at 1:30" and "Let's meet at noon". You can watch the video ...

How To: Use the image editor Portable GIMP

This video tutorial is in the Software category which will show you how to use Portable GIMP. It is an image editor packaged as a portable application, so you can carry your images and edit them on the go. You will need a pen drive for this. Do a Google search for "portable gimp' and download the free software from the first link and save it on the pen drive. Then you open it and install it on the pen drive and call it GIMP portable. You can now open the app, customize and use it. You can wat...

How To: Tag questions with indefinite pronouns in English

This is a video tutorial in the Language category where you are going to learn how to tag questions with indefinite pronouns in English. A tag question begins as a statement and ends as a question. Here's an example with a definite pronoun: He's a student, isn't he? Indefinite pronouns are exceptions to the rule. For example, everyone's here, can be made in to a tag question. But, the pronoun, everyone, is indefinite. Hence, when you make it in to a tag question, you can't use "it". The corre...

How To: Understand the sequence of tenses for English

This video tutorial in the Language category will show you how to understand the sequence of tenses for English. This is useful when you want to change direct speech to indirect speech and also for understanding conditional sentences. When the sentence is originally in the present tense, it can be changed to past tense. For example Paul said, "I am hungry". You can change this to indirect speech either in the present tense or in the past tense. So, the sentence can be said as Paul says he is ...

How To: Read the poem "Hope is the thing with feathers"

This video tutorial belongs to the Language category which is going to show you how to read the poem "Hope is the thing with feathers". This video is a reading of the poem is by Emily Dickinson. Here is the poem. Hope is the thing with feathers, that perches in the soul and sings the tune without the words and never stops at all and sweetest in the gale is heard. And sore must be the storm, that could abash the little bird that kept so many warm. I've heard it in the chilliest land, and on th...

How To: Make a Cricut get well card

This video tutorial is in the Arts & Crafts category where you will learn how to make a Cricut get well card. Cut out the shape of a dog out of white at 4". Then cut out the ears and nose out of brown also at 4". Cut the dog again in brown at 4" for the background. Now assemble the dog as shown in the video and glue on two Google eyes. For the card base take a 10" x 7" card and fold it in half. Take out a brown sheet at 4 3/4" x 6 3/4" and a striped mat. Now apply glue on the card and assembl...

How To: Make picture frames for vinyl record covers

This video tutorial is in the Home & Garden category where you will learn how to make picture frames for vinyl record covers. These frames do not use nails or clips to hold the covers. The covers slide in and out of the frames so that they can be changed easily. For this you will need 4 pieces of wood 3/4" thick, ¼" wide and 14" long. First you sand all the pieces. Then you set up your router and the rabbeting bit to cut out the four wooden pieces. Now you need to make indentations on the to...

How To: Use caret browsing

This video tutorial is in the Computers & Programming category where you will learn how to use caret browsing. Caret browsing is a method of selecting text on any web page. You can activate caret browsing by pressing the f7 button on your computer. It is available in Internet Explorer and Firefox browsers. Normally, for selecting text on a web page, you highlight the text by clicking and dragging the cursor and then you can copy and paste it in to a text editor. While doing this, if there are...

How To: Use the zoom feature in Mac OS X Leopard

In this tutorial, we learn how to use the zoom feature in Mac OS X Leopard. First, go to system preferences, then universal access. Find the zoom category, then turn it on of off. You will also see the keys that you can press which will make it appear. If you go to the options menu, you will be able to maximize or minimize the zoom. Test this out by zooming in on a page and holding the control key along with the tracking ball on your mouse. When you do this, everything will become far more zo...

How To: Replace a power lock on a Ford Excursion

This video tutorial belongs to the Autos, Motorcycles & Planes category which is going to show you how to replace a power lock on a Ford Excursion. This activity is neither easy nor cheap. But, you will save a lot of money if you do it yourself. Before starting you got to remove the side paneling, speakers, outside door handle and insulation. Then you remove the door lock system. Remove the cable connectors and replace the solenoid unit. Now you can check that the power lock is working and th...

How To: Create a frequency polygon line chart in MS Excel

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 655th installment in their series of digital spreadsheet magic tricks, you'll learn see how to create a statistical frequency polygon using a line chart. Also see how Excel mistakenly interprets number category label data as Number Series data.

How To: Describe problems in English

This video tutorial is in the Language category which will show you how to describe problems in English. When describing problems in English, many people use the word trouble. When you frame a question, you can frame it in the present or the present continuous tense. For example; what do you have trouble with or what are you having trouble with? Similarly, when you answer the question you can use the present or the present continuous tense. Examples of this are; I have trouble with my car or ...

How To: Map multi-sub objects in 3D Studio Max

This video tutorial is in the Software category which will show you how to map multi-sub objects in 3D Studio Max. What this means is you can apply two textures to a single 3D object. First you select the 3D object, say a box and go to editor > standard > multi sub-object > OK. Now change the number of materials from 10 to 2 and follow through the next steps to select the two textures. Then go to modify panel > edit mash. Select polygons, and apply the texture to the front of the box, move ar...

How To: Use WeFollow to get more Twitter Followers

In this how-to video, you will learn how to use the website Wefollow for twitter. This will allow you find more people to follow you on twitter. You can list yourself under a category so people can find and add you. If you are an antique dealer, you can label yourself as one. This allows you to be searched for and added. You will get higher on the search list as you get more influence and more people following you. If you are looking for people to follow in your niche, you can type in the nic...

Prev Page