Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 95th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the OR, AND, NOT, & COUNTIF functions and Excel's advanced filter tool to extract records from a table of data. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 77th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to do a complicated payroll formula when tax data must be retrieved from multiple tables. See how to use the INDEX, INDIRECT AND MATCH functions in one big formula to retrieve tax data from multiple tables on multiple sheets. Learn to love digital spreadshe...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 70th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to clean up a bad data set with the TRIM function before building a pivot table (PivotTable) to calculate an average. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 46th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the DOLLAR, VLOOKUP, INDEX and MATCH functions and a previous bracket commission formula trick to calculate total commissions when you have variable commissions paid out. Learn to love digital spreadsheets more perfectly with the tricks outlined in t...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 44th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use 4 different tricks to convert a text formula or function to a number. Also see how to convert text to numbers. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 40th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the filter and advanced filter tools to extract the top 5 values from a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 34th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to hide columns, select visible cells only, and then copy and paste just those visible cells (all with and without the use of formulas). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 33rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to sort by color in Excel 2007 as well as how to use the copy and paste tools to extract records. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
In basic algebraic equations all the variables are on left side of the equation. But as the complexity of the problems increases you will find that the equations will contain variables on both sides of the equation. To solve these kinds of problems first simplify the equations on each side of the equation. You can use the distributive law to do this. Next try to cancel the variable on the right side of equation by adding the negative value of that variable to both the sides of the equation. N...
In this video from ScienceOnTheBrain we learn how to isolate the sugar in a can of soda. To find out how much sugar is in soda, pour a can into a pot and boil it until all the water is gone. You will be left with the sugar, and then you can weigh it. First weigh your pot before pouring the soda in. Now boil the soda on the stovetop. When the water evaporates, you'll be left with a syrupy sugar. A can of soda has 39 grams of sugar in it. That equates to about 7 1/2 teaspoons. Fruit juice conta...
One of the most important beauty tips to follow is removing your makeup properly at the end of the day. By using the right ingredients to take your cosmetics off, you will be able to avoid panda eyes and premature wrinkles caused by rubbing underneath your bottom lashes.
In this video tutorial, you will learn how to use sparklers, or fireworks underwater. You'll need some sparklers, tape, glass container, a lighter, and, of course—water.
The guy first gives the definition of differential equations. He explains that a differential equation is an equation that contains the derivatives of an unknown function. He then gives some examples of differential equation and explains what the equation's order means. After that he gives an example on how to solve a simple equation. He calculates it and gives examples of graphs. Then he explains what a general solution is and how to narrow down the number of solutions using data from the pr...
A straight line can be represented in the form of a liner equation containing two variables x and y. When the equation is graphed on a pair of coordinate axes, the line passes cut through the axes in two points. The point where the line cuts the x-axes is called as its x coordinate and the point where the line cuts the y-axes is called as its y coordinate. In this way a line has x-intercept and y-intercept. The x-intercept of a line lies on x axes and is in the form (a,0). Similarly the y-int...
The metal clay must be completely dry before you begin the torch fire procedure. Set up your work space in a well-ventilated area with your metal clay on a fire brick. Start your flame and move around the piece in a circular motion, not staying on one point for long. You might see little flashes of flame. Don't panic. That is to be expected. Time yourself for about a minute. Your metal clay should take on a peach color. It is important not to use a butane torch and metal clays that contain or...
This video will show viewers various tips on how to shape your eyebrows depending on the type of eyebrows which you would like. Using a kit called "Million Dollar Eyebrows", which contains an instructional CD which will show you how to perform this technique, the host of this video shows how she uses the kit in order to shape her perfect eyebrows. Using a tool provided in the kit, she shows how to determine the length, height, and width of your eyebrows so that you will have the perfectly sha...
This video shows the viewer how to take a ‘Trivela’ free kick. This is where the player kicks the ball with the outside of their foot. This makes the ball curve towards the foot that the player kicked the ball with – a right footed shot will curve to the right and vice versus. The main point the video makes seems to be to make good contact with the ball. This is very crucial. The video also contains other tips and tricks as well as some footage of successful ‘Trivela’ free kicks taken by the ...
This video shows the viewer how to make their own organic lip balm. This is a good idea as many commercial lip balms contain preservatives designed to preserve the balm – these preservatives can have detrimental effects. The ingredients used are 2oz of bee’s wax and 1oz of coconut oil. Grate the bee’s wax into a Pyrex boil, add the coconut oil and lower the Pyrex bowl into a saucepan of water. The water should be at a low heat. Gently stir the mixture until it has melted. Allow the mixture to...
When conducting covert mobile surveillance with video it is vital to have a good bag that will contain and allow you to get footage in an inconspicuous manner. Always take into consideration the lighting and distance you’ll be at.
In this video the instructor shows how to use the Auto play feature in Windows 7. Auto play is an old feature which was also available in Windows XP and Windows Vista. When you insert any removable media into your computer like a CD, DVD or a USB thumb drive, Windows automatically pops up a Auto Play window where it gives you various options that can be performed on the recently inserted media. This feature is very helpful and helps you open your media very conveniently. The Auto play window ...
In this video tutorial, viewers learn how to make "Filipino Bicol Express". The video provides all the ingredients that are required to make it. The ingredients required include: 6 cups of coconut milk, 2 lbs of pork cut into strips, 1 cup of shrimp paste, 1 tbsp minced garlic, 6 pieces of Thai chili peppers, 1 cup of grated ginger, 1 large cubed onion, 2 long chili peppers, 2 tsp of cooking oil, salt and pepper. The video contains slow pace and step-by-step instructions that allows viewers t...
David Rivers is back to give us some more tricks on using MS Outlook 2010. In this video he tells us how you can avoid sending email to the wrong person by setting up some email preferences in MailTips. MailTips actually has the ability to alert you when you are about to send an email under certain conditions. Don't worry about sending an email to your boss that was meant for your co-worker. Your MailTips folder contains many options that you can use to restrict some of your outgoing mail and...
If you are a user of FileMaker Pro then this video teaches you how to use calculation and summary fields in it while making new files. In Filemaker you can create a various kind of fields that you want your file to contain. In Filemaker a calculation is a data that gets computed depending up on the formula that is set in the Filemaker database settings. Calculations are very critical in file management. Open the Manage Database and there you can find some of the calculation fields. There in t...
Sarah Dussault gives us instructions on how to appropriately cut her favorite fruit, the mango. -There is a huge seed where the pit is, so first you want to cut off the sides. -Take one side and cut into a grid pattern. -Now you can simply pop the cubes of mango off and eat them. -Be careful, the skin of mangoes contain similar oils to those found in poison ivy. -Take the other side of the mango and cut into slices and then peel the skin off. This is another technique for cutting mangoes. Jus...
Use these steps and you will be able to open up a pomegranate, mess-free! *Select pomegranates by weight not color!* Remember the heavier they are the more juice they contain! Here is how to open a pomegranate: mess free! Cut the crown of the pomegranate off - (the top of it). Take your knife and cut through the membrane of the pomegranate (the middle). Get a bowl of water and separate the seeds from the membrane inside the bowl. The seeds will sink to the bottom, and scoop out the membrane w...
In this video tutorial the instructor shows how to perform basic lighting corrections in Adobe Photoshop. The levels tool is the Photoshop's most used command which has many features to it. Its most basic function is as a lighting correction tool. In this video open an image and work on its adjustment layer so that you do not damage the original picture. Now choose the levels option by right clicking and it shows a pop up window which contains a histogram which shows the population of the col...
This video shows you how to easily reduce fractions. A fraction contains a numerator and a denominator. The numerator is the number on the top and the denominator is the number at the bottom of the fraction. The first thing you have to do to reduce fractions is look for the greatest common factor between the numerator and the denominator and divide both top and bottom of the fraction by that common factor. (e.g.. 18/24 - the greatest common factor is 6 => (18/6)/(24/6)= 3/4. Continue reducing...
This video is about the Equation of Axis of Symmetry, The video is about the equation which is x = 3/4. In order to score correct marks for this equation, the gentleman in the video describes how and where to write x = 3/4, he says it has to be written on the graph, and the video contains the example graph. It is quite an interesting educational video, especially for those doing mathematics and want to learn more online, this video is very useful for students. There is more about the equation...
David from "The One Pot Chef Show" demonstrates how to make vegetable soup. It's a great dish for a cold winter day. This hearty soup contains potato, onion, carrot, parsnip, celery, diced tomatoes and turnip. To make it, you will need these ingredients as well as broth (David uses chicken) and soup mix. Chopping up the vegetables, preparing the soup mix and bringing it all to a boil on the stove is really all it takes. This video gives a great step by step demonstration and looks delicious!
Come on, who doesn't love sugary sweet Rice Krispy treats! Super easy to make, even small kids can help. This recipe puts a spin on traditional treats and makes a healthier even better version. You can add peanut butter as a source of protein and energy. You use organic or non brown Rice Krispys because it contains a lot less sugar than the regular stuff. Perfect as an afternoon surprise for when your kids get home from school. Plus, you will not feel bad about serving them.
In this Adobe Acrobat series of video the instructor shows how to combine comments in a PDF. When we receive comments as a part of a review of a document there is no need to view the comments is a separate document but you can view the comments in the same document. To do this go to the comments menu and select the option of import comments. Now from there you can select one or more PDF documents that contain the comments and integrate it to the current document. This video shows how to combi...
This video tutorial will show you how to use water vines to get water in the wild, if you fancy yourself the next Bear Grylls. There are different kinds of vines and not all vines are made equally. If you open them up they all contain water. Some vines produce bitter water and some are sweet.
The organizer pouch, a flat, rectangular, often multi-compartmented, nylon bag with zipper closure(s) is a great item that is becoming hard to find. They sometimes include see-through mesh panels, and are available in a variety of colors. These are terrific for avoiding what could otherwise be a cluttered mess in your bag. Give a little thought to organizing your belongings into categories and storing them in the pouches. This will help you keep track of those small items that have a way of g...
In this video, learn about los verbos relexivos. Some examples of daily use actions: Yo me cepillo los dientes. This means I brush my teeth. For most beginning students of Spanish, one of the hardest things to understand is verbs. That’s because verbs in Spanish act differently than verbs in English. There are many Spanish verbs (like ser and estar) that convey distinctions in meanings that don’t exist in English. You’ll discover tenses (like the subjunctive) that you never knew existed. Stra...
One of the most challenging, arduous parts of gardening is weeding vegetables that are close to the ground. Cabbage, for instance, leafs out near the earth and can be fiendishly tricky to weed. In this Growing Wisdom gardening tutorial, you'll learn about some of the tools that can help you weed those hard-to-reach spots without breaking your back in the process.
Whenever you see a website that has some weird fonts or characters displayed on the web page, like a website containing Arabic fonts, but which are not displayed properly, then InshaAllaah, check this tutorial and you'll have the problems rectified.
A pork chop is just a pork chop, right? Well, actually not. In fact, there are three different cuts of chops; the rib chop, the loin chop, and the sirloin chop. Each of the three cuts comes from the pork loin, which is the tender strip of meat that runs from the shoulder butt back to its leg (hip).
This video tutorial will show you how to start animating using the basics in Adobe Flash CS4. This is basically just an introduction to Adobe Flash CS4. You will learn about the Welcome Screen, Defaults, Properties, Layouts, and Tools.
Styling gel is the Swiss army knife of hair styling—an all-purpose tool that can help you achieve any goal or look. You may even want to take some on your next camping trip.
Check out this music tutorial video that shows you how to play "Nobody Knows You When You're Down and Out" by Bessie Smith on acoustic guitar. This is a brief and simple demonstration of the chords used to play the Bessie Smith classic. It uses live clips, fretboard diagrams and stop-motion frames. It emphasizes the use of barred chords, but contains a final section using mainly simple root chords. Learn how to play "Nobody Knows You When You're Down And Out" by watching this instructional vi...
