As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 8th installment in his "Excel Business Math" series of free video lessons, you'll learn how to work with whole and decimal numbers. See how to write words to represent numbers (for checks). See how formatting can hide decimals.
Want to play the Eagles' "Hotel California" on your ukulele? Learn how with this free video ukulele lesson. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing "Hotel California" on your own uke, wa...
In this tutorial, learn how to make a very cool wet writing effect that you can use for graphics and logos. You will be creating this effect in Photoshop CS4. In this video, you will learn how to take tons of different layer styles and transform a basic text layer into a majestic piece of artwork. You will be shown the process step by step from the very beginning. This tutorial also shows the use of gradients and color corrections tools to optimize the full piece of work.
When you begin to graph equations you will need to know how to do so in different ways. In this tutorial, learn exactly how to graph linear equations by plotting points.
In this video, we learn how to connect an Apple wireless keyboard to the iPad. This is great if you need to write something that requires a lot of typing. First, go to "system preferences" then click on "Bluetooth". Once you're in this, make sure the "discoverable" check box is not checked, then highlight your keyboard. In the bottom left hand corner click the minus sign, then click "remove". Now, on your iPad click "settings" then "general" then tap "Bluetooth". Almost right away you should ...
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 367th installment in their series of digital spreadsheet magic tricks, you'll see that the IF function sees -1, 1, 10 and -1.23 as TRUE and 0 as FALSE and learn how to use this fact to your advantage when writing formulas.
This how to video shows you how to sort data in Excel in a custom order. First, open a spread sheet in Excel. Select a column of cells with words that you want sorted. Click the office button and select Excel options. Go to edit custom list. You will see different custom lists. Click import to import your selection as a custom list. Next, you can go back to a sheet with those words that you want sorted and click the sort command. Select custom list on the order tab and select your new custom ...
This video teaches us the method to create PDF in OS X. The first step involves opening up the document which you want to convert to PDF. Go to 'File', 'Print Preview'. Select the magnification of the document. Check to see whether the whole file is there or not. Go to 'Print' option under the 'File' drop down menu. Go to the 'PDF' tab at the bottom of the window. Choose 'Save as PDF X'. Write the name of the file in the space provided in the dialog box. Choose 'Desktop' as the destination of...
Khanacademy tackles problems involving multiplicative inverse (i.e. taking the number one and dividing it by that number) and dividing rational numbers in its simplest form (lowest common form).
Robert demonstrates how to quickly insert formulas into Excel. To create a sum, highlight your selected cells and press the sum key. Expand the formula by clicking on the fill handle. Double click on the fill handle to expand the formula. To sum vertical columns, highlight all the cells and click the sum button. Press and hold down the control key for another shortcut to work in accordance with the auto sum button. You can also select the average for the area. You can also select the area and...
Want to play the Beatles' "Penny Lane" on your ukulele? Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing "Penny Lane" by Paul McCa...
Java is a wonderful programming language which is widely used all over the world. To do programming in Java you will need a Java Development Kit which is also called as JDK in short. This can be downloaded from the Java Website for free. To improve and assist in your developmental activities you will also need an IDE, which is an Integrated Development Environment where you can develop, compile and test you code at once place. Though Java code can be written in a normal text pad and compiled ...
Rooting a cell phone can give you so many different perks and advantages that you wouldn't normally have. But at the same time it can also cause damage to the phone itself that it may even cease to function properly causing any money that you spent, to go down the drain. This tutorial shows you how to root your T-Mobile G1. Be careful and good luck!
When you tag someone in your Facebook status, you can show everyone activities you are doing together! This is incredibly simply, simply type the @ symbol when writing your status. Your Facebook account will immediately prompt you; showing you different people on your friend's list. It will also ask if you want to tag groups or events in your status. As you keep typing the name, simply select the friend, group or event you wish to tag. Now, your status update has a link to this person, group ...
First of all in the given question you have to write down the values of the total length of the line segment, PS=15. The length of the line segment, QR =3. Now you have to find the value of line segment RS. Because you know that the Q is the midpoint of the line segments PQ and QS must be equal. Therefore you can find out the length of the half of the segment using the midpoint. Subtract the value of QR from QS. Given that segment PS=15 and Q is the midpoint, you can conclude segment PQ=7.5 a...
The moonwalk has been written in history and will go down as one of the most well-known dance crazes next to the Macarena and the jitterbug. In order to moonwalk like Michael Jackson, it's important to focus on the pivot and push of the feet and legs while sliding. Make your moonwalk smooth with the tips and tricks given in this free dance lesson.
In this video tutorial, viewers learn how to copy or backup a DVD disc on a PC with Nero Express. Begin by opening the program and select Backup from the menu. Make sure that the disc is set to DVD and select Copy DVD. Now select the Source Drive, Destination Drive, Writing speed, Number of copies and the Image file. Click on Copy and wait for it to finish copying to the DVD. Now insert the disc into the disc drive and wait for it to finish burning. This video will benefit those viewers who n...
In this video you will learn how to download a torrent PC game, mount and the burn it. For this you will need a torrent program (to download torrents), daemon tools (to mount the images) and powerISO (to burn it). To get a torrent go on site mentioned in the video or on other torrent sites. After you downloaded the file, right click on daemon tools icon select virtual drive and mount your image. Enter in image from my computer, take the CD key from crack and write it on a CD case. To burn it ...
Shelley Lovett from childcareland demonstrates a fun activity involving finger paint that parents can do with their children. She uses finger paints and a pan to make a virtual canvas that is self contained and easy to clean up. She first recommends that only one color be used. She indicates that by using multiple colors, it may result in a brown ugly color and therefore should be avoided. She then spreads the paint onto a flat pan. After the paint is on the pan, parents and children are able...
The way to convert 0.300 Moles of water into Grams is to start by writing what you have. Then put grams on top and moles on the bottom, then put one by the mole, the omler mass goes by grams. Now you figure out the moler mass of water which has 2 H and 1 O, its 2 times 1 which is the atomic mass for hydrogen plus 16.0 for oxygen which gives a total of 18.0 g/mol. So then you insert the 18 up by the grams, now you can cancel out the moles and multiply 0.300 times 18.0g and it gives you 5.40 g,...
The video demonstrates how to sketch the cartoon character of Luigi on a snow board. First the character is drawn with a soft pencil using faint lines. The action of the character on the snow board are detailed ,even the minute details like the hand ,legs, eyes and its expression are slowly etched out. Once the faint sketch is complete the features are highlighted with a dark pencil or sketch pen. A depth to the sketch is given by shading the parts and giving it third dimensional feeling. A d...
In this tutorial, we learn how to set rhinestones using a Bejeweler. To do this, you will first need to prepare your Bejeweler and the fabric you are using. Lay out the pattern on your fabric and use tape as a guide for any letters you write. The rhinestones may move during this, just push them back in with tweezers. Once the Bejeweler is plugged in, rest it in a stand since it will become hot. Once it's ready, place it over an individual rhinestone for around 15 seconds. When time is up, lif...
It is very important to learn how to create a good book proposal. This video helps shed more light on things to think about when creating your book proposal. Essentially, a book proposal is your opportunity to sell yourself as a marketable asset to a publisher. Most publishers websites have down-loadable book proposal forms. They will request a lot of information such as what is your market, how do you intend to promote yourself, along with a few sample chapters. Publishers receive hundreds o...
This is a clear video showing how to easily draw a 3D letter 'B'. First of all you start by just writing the letter 'B' normally; and then you double outline all of the lines you have drawn, both inside and outside of the letter. Color it in with a block color for a 2-dimensional letter. Then its time to make it 3D! In the middle you just add lines parallel to the 2D letter, and also around the top and left sides of the shape; color this in with a darker color, and voila! You should now have ...
Have you ever wanted to hook back up with your ex-boyfriend or girlfriend, but aren't sure of how to do it? Vanae has some words of wisdom to share with you, as well as some great tips on how to get back with your ex. In her video, she explains the importance of self acceptance and being happy with yourself initially. Then, she adds that it is a good idea for you to write down a list of the problems you and your ex had during the relationship. This list is important because it can give you an...
In this video tutorial, viewers learn how to burn ISO-format disc images to a DVD from Windows. Users will need to download the program, DVD Decrypter. Download it from this link: DVD Exact Copy/] and double-click the file to install it. Users will also need a blank DVD disc. Open the program, go to ISO and select Write. Now click on the folder icon to locate your ISO file. Now click on the disc image and wait for the decryption to finish. This video will benefit those viewers who have downlo...
In this video tutorial, viewers learn how to reduce the noise of sent messages on Twitter. Begin by logging into your Twitter account. Then go to the website, Tweet Later. On the right side with all the listed options, select DM Opt-Out and follow the instructions provided on the page. Follow the Twitter user "OptMeOut" and wait for him to him to send you a direct message telling you that he has followed you. Then write a direct message back to him and unfollow him. This video will benefit th...
This video shows the method to simplify rational expressions. The example used in the video is multiple of 4 and x square plus multiple of 4 and x plus 1 or (4x^2 + 4x + 1)/(2x^3 + 11x^2 + 5x). As the first and last term is a perfect square we get the simplified numerator as (2x + 1)(2x + 1). Next, the denominator is simplified. Taking the common factor out we get x(2x^2 + 11x + 5). Now we factorize 2x^2 + 11x + 5. We get (2x + 1)(x + 5 ). Now, writing the terms in numerator and denominator w...
In this video, Mr. G demonstrates how to draw a wintery snowflake. You will need a plain pencil, or a blue and black colored pencil for this drawing. Start by writing your name and the date on a white sheet of paper. Then, begin lightly drawing the base of your snowflake. After you have drawn your base, Mr. G will show you how to make the lines darker to form the shape of your snowflake. Then, you will learn how to detail your snowflake by drawing small triangles inside the basic shape that y...
make delicious naan bread in the comfort of your own home with help from this three-part cooking tutorial. For written instructions on how to make these wonderful treat, go here. Ingredients you will need:
This video shows how to find the equation of the line perpendicular and parallel to a given line. The video starts off with an example, given the lines and the slopes (m). When 2 lines are parallel to each other, they have the same slope. When 2 lines are perpendicular to each other, the slopes multiplied together will give -1. Knowing these rules, the tutorial maker provides an example with numbers. He then leads each step of the process. Each step is written out in either black, red, blue o...
Marilyn Bohn, of Get it Together Organizing, offers a travel tip of how to measure carry on luggage. She warns you that every carrier has a different requirement for carry on luggage, so check before you leave what your carrier requires. In order to measure your carry on luggage you use three different figures and add them together for the final result. Measure length, measure width, and measure depth. Write your numbers down and then add them together. After this, you will come up with a sin...
Chau-Minh, a private tutor, discusses cramming and how to do it effectively. This video does not intend to endorse cramming, but if you are probably screwed then you might as well see it. When you cram, don't expect to get a high grade because you lack time. To pull out a high grade, we need to do deletion. Deletion is just like chopping a branch to make the tree smaller. The tree would signify the lectures of your professor. Crossing out the topics that are discussed rarely by the professor ...
Keri shows you how to tag people in your Facebook status update box. If you want to create a link to your friends and fan pages in your status update, follow these steps: Write you status update. Type the '@' sign, followed by the persons name or group. (Start typing the first few letters of the person or group's name, and you will be able to select them from a drop down box. )Notice that it has now turned into a link in your status update box. Hit the 'Share' button. Now your update will be ...
In this video we are about to see how to plant a garlic in your garden. First of all we should decide on the type of garlic to be planted where and write it down or else we will lose track of it. Garlic always like an area of full sun and a composite mixture of soil. She has double dig the ground and added organic mixtures to get the soil nice and lose and also for it to be fertile. Remove the garlic cloves one by one using your fingers or knives (a better way). Then always garlic is planted ...
In this video the instructor shows how to find out an equation of a perpendicular line. If you need to find the equation of a line passing through the given point and is perpendicular to another line, the first thing you need to do is compute the slope of the given line. Obtain the slope of the equation by writing it in the form of y = mx + b. Now the product of slopes of two perpendicular lines is a negative one. So the slope of our required line will be the negative inverse of the slope of ...
Learn how to cheat on a calculator test with a calculator in simple steps. You will need: a scientific calculator, a ruler and a small paper. 1. First remove the cover of your calculator and measure its length and width using the ruler. 2. Now cut a piece of paper with the exact measurements taken from the cover. 3. Write all you need on the paper and fix it in the cover carefully. 4. Make sure the paper does not fall out and then put the cover to the back of your calculator. 5. Finally test ...
In this video tutorial, viewers learn how to simplify expressions involving numeric radicals. This can be very frustrating to work with if you have not memorized the tables of square, cubes and fourths. If you are taking the square root of a number that is not a perfect square and you wish to simplify it, the key is to write it as the product of a perfect square or another number. This video is very descriptive and clearly explains the functions of the formula. This video will benefit those v...
In this algebra video the instructor shows how to work with complex numbers. When you have a positive number under the square root, you can easily find its value by writing it in the form of product of numbers, and then solving. That is, to find the square root of a positive number, you can find another number which multiplied by itself gives the original number. This new number becomes the square root of the original number. But when you are asked to find out the square root of a negative nu...
If interested in writing a story this two part tutorial will introduce you to Tikatok. You will learn the basic navigation and setup of the web site. Tikatok allows you to create and publish your own storybooks online. This program is ideal for allowing anyone to be creative and come up with their own ideas for stories.
