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.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 480th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a percentage of total from a database data set when the variable of interest is text (word). This is accomplished with recourse to the COUNTIF, SUM & COUNTA functions.
This video will show you how to use the ‘find’ and ‘replace’ text buttons in Microsoft Word 2007. Microsoft Word 7 is slightly different from the Microsoft you might be used to but with these instruction you’ll have no problem finding the buttons.
In this ESL how to video we look at your character and the English words that describe it. The way you act or the way you behave among other people is very important... at least it is to you! Learn how you can use positive and negative descriptive words to talk about yourself with this English tutorial.
This screencast tutorial from Chris Grover, author of Word 2007: The Missing Manual, guides you through working with tables in a Microsoft Word 2007 document.
In this video, we learn how to speak English: An introduction to phrasal verbs. Phrasal verbs are also called two-part and three-part verbs. This is a verb and one or two other short words. Together as a phrase these have a special meaning. The other words are called particles, which come together with the verb to make a different definition. Particles can change the word "figure" to "figure out" and the word "look" to "look through". These particles at the end of the verb change how the word...
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve problems requiring you to add whole numbers.
In this tutorial, we learn pronunciation tips to Speak English. To help someone learn this, use an analogy, imagery, and vivid explanation so they understand what you are talking about in full detail. Use your hands to make the motions, then relate words to your base words. You will need to repeat yourself a lot, and also draw pictures so it can help them visually understand. Don't use difficult words, just start by doing simple words that are easy to understand. Once the easy letters are und...
In order to insert Word Art, into your document, using Microsoft Word 2007, you will need to begin by opening your document. Next, find "Insert", at the top of your screen. Click on it. This will take you to the Insert Tool Bar. Find Word Art. Choose the style that you would like to use, from any of the styles in the style gallery. When the window opens, you can choose your font style at the top, if you want to change from the default setting. You can also change the font size. Write the word...
Sometimes there is more than one option for a particular finger Swype. When this happens, Swype will give you a list to choose from so that you can pick whichever word you were hoping to use. Swype is the fastest way to send texts and e-mails available and with a bit of practice you will have it mastered. Just think of Swype as the T9 of 2010 and you will catch on fast.
In this clip, learn how to use the Swype Key while texting with Swype on your cell phone. The Swype key is where all of your options are like dictionaries, tips and tricks, help menus and everything else you may need.
In this video tutorial, viewers learn how to save in .doc file format in Microsoft Word 2007. When saving a file, click on File and select Save As. In Format, change it to Word 97-2004 Document(.doc) and check Append file extension. To set .doc as the default format, go to Word and select Preferences. Under Output and Sharing, click on Save and change the format to .doc in Save word file as. This video will benefit those viewers who want to learn how to save files in .doc format so that it ca...
Watch ad Wordtoons demonstrates how to turn to word "dog" into a Cartoon character. Start by writing the word "dog" all lowercase and neat. It won't work if the writing is messy or is in cursive or caps. Then draw a small circle above the "o" and "g" and then draw a line from that circle to the end of the ""d"s stem. Add a loop around the other side of the "d". Then color in the circle that makes up the "g" to make a nose. The "o" and then circle above the "g" will make eyes. Watch the rest o...
Eva Holtz shows us how to approach different types of questions on the SAT, in this episode from Brightstorm. The different types of questions in the SAT Passages section include "Vocabulary in Context", "Line reference", "Whole passage", and "I, II, III, except, least, not" questions. Eva explains that the best way to approach Vocabulary in Context questions is to treat them like Sentence Completion questions. First, read two lines before and after the word in question. Then, it's best to ca...
Rebecca Robeson shows you how to remember which side of the plate to put the fork, knife and spoon. To set a table the correct way, follow these steps: The word 'fork' has four letters, as does the word 'left'. So, the fork goes on the left. The word 'knife' has five letters, as does the word 'right'. So, the knife goes on the right. The word 'spoon' also has fiver letters, so it goes alongside the knife. Remember that the safe side of the knife, the dull side, faces out to anyone sitting nex...
Want to run Apple's popular word-processing application, Pages, on an iPad? It's easy. That didn't stop Apple from producing this clean video overview, however. Get started creating, editing and sharing your own newsletters, reports, flyers & other documents with this how-to.
This video will teach you basic and useful words in Polish. The video sets out the word used for 'drink' in the Polish language. The word in Polish is 'napoj'. To learn the word listen to it and repeat it a number of times. This will help you to memorize it. Spell it out as na-poj. Visit the website to learn more Polish words.
In words like bottle and mitten, the "t" really isn't a "t" sound; it is more of a "d" sound or a very fast "t" sound. Practice the "t" sound with the words button, carton, brighten, tighten, fatten, eaten, rotten, matter, butter, flutter, water, bottle, settle, and metal. In American English, the "t" sound is very difficult to hear in some words. An example of this is the word butter, where the "t" sounds more like a "d." Remember, the way people speak English in the United States is differe...
Have you ever wondered how to make a brochure in Microsoft Word? Is your job requiring you to learn how to create a brochure in Microsoft Word? This tutorial will teach you step by step how to find templates online, transfer them into Word, and how to open the blank template in Word. This will enable you to create a successful brochure with a highly professional look to give to your clients. This step-by-step tutorial is guaranteed to tell you everything you need to know about creating brochu...
This how to video describes how to properly use the word "like." Since "like" is one of the most misused words in the English language this is great for anyone who is not an English professor. The author begins by describing what types of words you can use the word "like" with and then he presents numerous examples for its correct usage. The video itself will only take about two and a half minuets of your time and will greatly improve your speaking skills.
BoboWabatabe teaches how to say some basic words in Klingon. You can learn to say a few basic words like yes, no, and success in the Klingon language. Hear the words and look at the pronunciation and soon you'll have a few words in your Klingon vocabulary. The video doesn't bombard you with to many phrases, their simple and easy to repeat. Bobo likens the language to something like German in order for you to understand how the form should be.
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 use the keyboard on the Apple iPhone 3G. The iPhone redefines what a mobile phone can do.
Putting together a table of contents is as easy as 1, 2, 3, especially when you use built-in heading levels as you begin writing your first draft. Then let Microsoft Office Word create the TOC with your headings. Watch the demo to see how to insert a table of contents and make revisions that Word will update automatically.
Finnish is an unusual language, which can make it tricky for foreigners to learn. Instead of relying on a book, the Learn Finnish video language-learning tutorial series shows a photograph of a vocabulary term while pronouncing the word in Finnish. This technique allows the student to associate the object itself, rather than the term in their native tongue, will the Finnish word, thus allowing for maximum comprehension and absorption. In this video segment, the vowels, "vokaalit" in Finnish, ...
German phonemes pronounced, each with example words. I tried to cover all letters and letter combinations which learners of the German language need to pay attention to.
Here is a beginner's guide to getting going on this highly addictive online word game, WordSteal. Watch the first video for registering and logging in, the second for creating a game, and the third for joining a game.
Plastic masks are usually the cheapest that you can get, but their tiny eye and mouth holes impede your use of your organs and can cut you as well. Watch this video to learn how to use a woodburning pen to widen the holes in such as way that they wont' come out sharp and jagged, and will make you Guy Fawkes or other mask much more wearable.
In this video, we learn how to pierce your own lip and avoid infection. First, mark the spot on your lip where you want to pierce it and then check it in the mirror. After this, grab your needle and clean it off with antiseptic or mouth wash that has alcohol in it. Push the needle all the way through the spot on your lip and then place the jewelry into your lip. Once finished, you will need to rinse your mouth out with mouth wash that has alcohol in it. Make sure to clean this regularly so yo...
In this tutorial, we learn how to detect and avoid bad breath. If your mouth is very dry, it's going to smell worse and worse. The more oxygen and moisture that you have in your mouth, the less bacteria will be inside it. For people with halitosis, they have a big problem with bad breath. Bacteria lives in your tongue, so you can't scrape them away. You can take a test to see how bad your breath is with a machine. After you do this test, you can learn how to keep more hydrated. Once you have ...
We are painting the ninja turtle-Michelangelo. Use orange metallic to cover over face. Put orange metallic around the eyes and ears. Use green metallic on forehead and across the nose, chin, mouth and cheeks. Use white close to the mouth for smile and teeth. Take black paint and give a bandit face. Outline the eyes, forehead. Place wrinkles around the eyes and make knots on the side of the face to make it look like a tie. Make the ninja turtle mouth smile.
In this video, we learn how to play the dizi, a Chinese bamboo flute. First, fine the mouth hole where you place your mouth. After this, look to see the different finger holes that are on the side of the flute. At the end, you will see air vents that are not to be confused with the finger holes. To prepare the flute, you can twist it so the pitch is changed when you play it. Now, place your fingers along the finger holes and start to blow into the mouth opening. After you do this, you will be...
If you love the ocean and love swimming, it's time you step up to the next level… snorkeling. Snorkeling is one of the best ways to explore the underwater life, without fancy equipment or expensive training. And all you need is a snorkel. If you want a better look at what’s underwater, all you have to do is snorkel.
In this how to video, you will learn how to draw a Cookie Monster cupcake. First, draw two circles for the eyes. Follow this with a furry texture oval shape for the face. Add a mouth with a cookie in it and draw the bottom as a cupcake wrapper. Draw the pupils of the eyes. Next, color the face a blue color. You can draw the cookie inside of the mouth a brown color. Use a black color to outline the areas around the mouth. Fill in the chocolate chips of the cookie with a darker brown color, and...
In this video, we learn how to tie a surgical knot in someone's mouth. First, you will push through the gum into the tooth root, you will do this with surgical string and two surgical pliers made for this. Then, you will push the needle and thread through on the other side of the tear until you can tie a knot. Tie this knot several different times until both sides of the tear are closed. Once you have both sides closed, you have successfully tied a surgical knot. This is easily done when the ...
How to loudly whistle with one hand
Ray provides information that hopefully will help you swallow pills easier and quicker. First go to the mirror, open your mouth and say ahhh. Look how big the hole is that allows you to swallow the pill! Put the pill on the back of your tongue as far as you possibly can. Practice with the tongue at this point putting the pill not half way, but all the way to the back. Next, close your mouth. When you close your mouth, your tongue goes back down anyway and the pill goes down your throat. The f...
This video shows you how to quit smoking by keeping your mouth busy. By chewing on something you can avoid smoking. Edarem uses sunflower seeds to keep his mouth chewing. He placed them in his pocket in place of his cigarettes. Anytime he needed a cigarette he would chew sunflower seeds. After 2 weeks he stopped smoking by doing this. You can also take 3 deep breaths anytime you feel the need for a cigarette. You should consider the price of cigarettes when quitting.
In this episode of Dogmantics, dog trainer Emily Larlham goes over how to stop a puppy from mouthing and biting and how to interrupt unwanted behavior from your unruly puppy.
In this how to video, Kathie Hill, children's choir director for over 30 years, gives helpful tips to choir directors in how to get children to open their mouth and sing. This tutorial teaches singing techniques to help one single child or a whole choir of children. Watch this tutorial and you will be able to teach kids to sing in no time.
Bill Myers shows you how to create the popular motor mouth effect in Sony Vegas Pro using event Pan & Crop, and the mask effect.