Reference Letter Search Results

How To: Fix common Excel spreadsheet problems & errors

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 25th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to interpret and resolve the nine most common Excel formula errors — namely, ####, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Reference, and #NULL!.

How To: Extract records using MS Excel's advanced filter tool

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 525th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records using advanced filter and wild-card criteria. See, for example, how to extract records that start with the letters W or J.

How To: Format a hard drive to boot a second operating system

In this Computers & Programming video tutorial you will learn how to format a hard drive to boot a second operating system. First, do a Google search for EASEUS partition master, download and install it. Launch the program. Right click on the unallocated space on your hard drive and then click ‘create’. Now create a new partition for the new OS. Name it Vista, select ‘primary’ in the ‘create as’ window, choose ‘NTFS’ in the ‘file system’ window, select drive letter as ‘V...

How To: Count instances of a character in a string in 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 223rd installment in their series of digital spreadsheet magic tricks, you'll learn how to count individual letters in a word. See how to count the occurrence of a given character in a text string.

How To: Do sand writing as a children's sensory activity

Shelley Lovett from Childcareland demonstrates sand writing as an early childhood learning activity. All you need for this activity is a baking sheet that is approx one inch deep and some sand. Colored sand makes it more fun for the kids. Shelley says the cheapest place she has found colored sand is at Wal-Mart, but it is also available at craft stores and perhaps even at Home Depot or Lowes. You spread a thin layer of the sand onto the baking sheet and try to make it pretty even. For very yo...

How To: Recycle an aluminum can into an indoor mini planter

This video shows how to make a eco friendly plant holder. The first thing you do is trace a fabric around the tin can this is to give it a better look. Then stamp the letters on the fabric of what you want to name your plant. After that poke about ten holes at the bottom of the can. Then glue the back of the fabric to place it on the can. Now wrap the fabric around the can on the sticky side. Lastly tie twine around the can for extra protection to hold up the fabric. Then put in the plants an...

How To: Teach your toddler the days of the week

In this video from modernmom, Nancy Stone, a parenting coach teaches how to teach your toddler the days of the week. There's a few simple and easy tips to do this. Music and songs are some favorites. Also rhyming things with the days of the week is a great idea. Or make a calendar and have them trace the letters. Another example is to speak to them and say things like on Saturday we don't go to school and Sundays we go to church. Another thing to say is when they wake up work in the day of th...

How To: Perform the Christ Ace card trick

kammagic shows you the Christ Ace card trick. You start off with a regular deck of cards and choose 4 cards, these should be signed, and split the deck into 4 piles. Place each card into a pile then put all the piles on top of each other. After the first two cards are revealed, you can ask the member of the audience what their card was and using letters as cards, spell that out. You will get to their card. For the final card simply turn the deck and reveal that there's only one card facing do...

How To: Uninstall a program in Windows 7 easily

Go to the Menu and click the Start button. Now select Control Panel. In the Control Panel, you can see the Option Programs. Now you can see Uninstall Programs in small letters below the Programs option. Click on Uninstall Programs. Here you can see the list of programs installed, when they were installed, what is the size of the program, and which version of program is installed. To uninstall a program, simply click on the program you wish to uninstall. Some options get displayed above the ta...

How To: Make an owl Halloween card using Cricut Storybook

Learn how to make an owl Halloween card using the Cricut Storybook cartridge: Mary explains how to make a 5 x 5 inch square Halloween card in a few simple steps. On page 34 of the Cricut Storybook manual you'll find the owl. Cut the owl at 3 inches out of the darker brown by hitting shift and the owl. Then cut the owl out in the shadow and layer it. Give the owl big google eyes. Cut a tag out of Tags, Bags, Boxes and More at 4 inches. Then run it through the crimper. Then cut the letters W-H-...

How To: Write the letter V in calligraphy copperplate

In this video, Hamid Reza Ebrahimi indulges the viewers in the world of copperplate writing through a short tutorial on how to accurately form the shapes of capital and lower case V. The video requires that the viewer has some previous experience with copperplate writing since it is not accompanied by instructions. Mr. Ebrahimi does a great job and the final result is honestly a true work of art. This video is an inspiration to anyone interested in learning how to write copperplate or just im...

How To: Write the letter W in calligraphy copperplate

Mr. Hamid Reza Ebrahimi has shown a demo on how to write the character W & w in a calligraphy copperplate. The single pen like brush was used by him to complete that fine art. He started drawing with a thick impression and then used the same brush with the thinner impression. We need to learn how to handle the brush before starting with the art work. His art work has accentuated our eyes. Viewer should learn to be calm while doing such art works. It will give you peace and calmness.

How To: Arch comic book text in Illustrator

This video shows you how to create text for comic books, using just a few easy steps. It's explained simply, so that a beginner that has never used Illustrator before, could do this. It shows how to stretch, and shadow your lettering, as well. Detailed illustrations will show you how to create a professional looking heading or title, in just a few minutes. It's perfect for banners, brochures, and pamphlets. The creations you can do are limitless, and you can learn how to do this today by just...

How To: Meditate to relax with Tara Stiles

Here are some meditation tips from Tara Stiles. Tara Stiles is a revered Ford Models yoga instructor. Meditation is a mental discipline by which one attempts to get beyond the conditioned, "thinking" mind into a deeper state of relaxation or awareness. Meditation often involves turning attention to a single point of reference. It is recognized as a component of almost all religions, and has been practiced for over 5,000 years.

How To: Stop on roller skates

There is more than one way to stop on roller skates. Proper technique is important for your safety and the safety of others. Learn how to stop on roller skates in this video lesson. Take action: each skate should have toe-stop, t-stop drags one foot behind other, keeping feet in shape of letter T, and plow stop points toes towards each other. Catherine Werst, a.k.a Stray Cat from Central Coast Roller Derby and the instructor in this how-to video from Live Strong, is the coach of Derby 101 and...

How To: Bleach t-shirt designs

Watch this step by step fashion design tutorial on how to bleach shirt designs. Print out a design onto durable paper and cut out the individual pieces. Iron the shapes in place atop the t-shirt. Place a protective lining on the inside of the shirt. Fill an empty spray bottle with bleach and spray your design lightly from about two feet away. The areas where you placed paper shapes and letters will not soak up the bleach.

How To: Pronounce and write the hard and soft signs in Russian

Check out this instructional language video to learn how to pronounce and write the hard and soft signs in Russian. Learn how to read and write Cyrillic with Viktor Dmitriyevich Huliganov in this 9th lesson. This is the penultimate Cyrillic alphabet lesson in the series, and covers the last two letters; the hard and soft signs, which have no sound of their own. Watch this tutorial video that is great for language nerds and beginning Russian speakers.

How To: The Secret to Typing in All Caps on Apple Watch

There's no default keyboard on the Apple Watch, but watchOS has another way to let you type text out for emails, messages, music searches, and more on the small display, and that's Scribble. With it, you simply draw letters and other characters on the screen with your finger, then your watch converts that into plain text. However, it's not perfect, and getting the nuances of regular typing can be tough.

How To: Deal with rejection from your father

In this video, we learn how to deal with rejection from your father. Don't let your father change who you are and change how you think about yourself. Know that people in your family are going to have problems, it can't be perfect. The mental warfare isn't worth it, grab the bull by the horns. Try to write him a letter from the heart and really let him know what you are thinking. If that doesn't work, make a video where you are talking right to him and tell him how you are feeling. After this...

How To: Draw a skull

In this tutorial, we learn how to draw a skull. First, draw the letter c with flames inside of it. After this, draw a lightning shape next to that and then draw teeth on the bottom of it. From here, you will draw in the rest of the head to the left of the side. Add in details and lines to show the bones curving and the jaw bone. After this, draw in the teeth on the bottom of the mouth on the jaw line. To finish this up, you will use your pencil side to shade in the side of the skull and add i...

How To: Tag friends and fan pages in Facebook

In this tutorial, we learn how to tag friends and fan pages on Facebook. First, open up your Facebook account and go to your main profile page. After this, you can start to type in your status update that you want all of your friends to see. When you are ready to tag in your friend or fan page, type in "@" and then type in the first letter of the name. From here, their name will show up and you can click on their name to tag them. Now, your update will show up on their page as well as yours, ...

How To: Draw a graffiti spraycan

In this video, we learn how to draw a graffiti spray can. Start out by drawing the top of the can with the nozzle on the very top. Use a half circle with a thick line under it to make the top. Next, draw the rest of the can creating a face on the side of the can with a mouth, nose, ears, and eyes. Then, draw in the bottom of the can using a circle shape and filling it on black so it looks sealed. Add in some lines to show the can spraying, then write in graffiti letters underneath to finish!

How To: Say "I love you" in Russian

In this video, we learn how to say "I love you" in Russian. If you want to learn how to say this correctly, you will need to make sure that you have the accent down correctly. Listen to the audio in the video so you can get an idea of how your voice is supposed to hand. If you cannot read the word written in Russian, just try to say it. Once you understand the basic way of how to say the different letters, you can put the individual words together. From here, you will be finished with saying ...

How To: Create and edit items in the Dragon Age: Origins toolset

If your Dragon Age story calls for an "Excalibur" or some other type of legendary weapon, armor (armoire of invincibility, kekeke, 5 points to whoever gets the reference!), or any other type of armor but aren't sure how to make them in the toolset you're covered! In this video you will learn how to create, edit and customize your own items! So go on, make that over-powered weapon and go have some fun slaying the Darkspawn!

How To: Understand the Tricktionary for pro jump roping

In this video, we learn how to understand the Tricktionary for pro jump roping. This is a great system where you label your moves by letter instead of making up names for them so you can avoid confusion. You can show your skills in a manner that everyone will understand when you use this method. You will need to use the "jump a bet" with the Tricktionary so you understand what moves you are doing and how to do them as well. This is a way to help you invent new skills, showing how tricks jump ...

How To: Make a Joy S-fold Christmas card using Cricut George

In this video, we learn how to make a Joy S-fold Christmas card using Cricut George. First, fold the card and mark it so it's in the S shape, then stamp the background of the card with colored snowflakes in different sizes and shapes. After this, use a black outline along the sides of the papers, then add in a black piece of paper to the middle of the top fold. Apply a monkey with a Santa hat to the front and wrap him around a J shaped candy cane. Add in the letters "o" and "y", then add in a...

How To: Use 'affect' and 'effect' correctly

'Affect' and 'effect' are two commonly misused words in the English language. This quick grammar tutorial provides a great reference to explaining the difference between the two words and how context is important to picking the right one. Improve your writing after memorizing this easy explanation!

How To: Make a gift Christmas jar with Stampin' Up!

In this video, we learn how to make a gift Christmas jar with Stampin' Up! First, take any type of jar you want to collect money in. After this, rinse out the inside and remove the labels off of the bottle and measure them. Now, take a piece of card stock and cut it out to make the length of the label from the bottle. Now, decorate the bottle with different Christmas decorations and then tape it onto the jar or bottle. Next, add on different types of felt cut outs to the jar as well. To finis...