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 100th installment in their series of digital spreadsheet magic tricks, you'll learn how to replace a long IF formula with a simple MIN/MAX formula (or an even simpler MEDIAN function). See 3 amazing examples. When you have a hurdle such a Commission Hurdle or a Payroll Taxable Earning Hurdle, and you are using an IF function fo...
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 518th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, SMALL, IF, COLUMN, COLUMNS, COUNTIF and MIN functions to extract and display vendor names when multiple vendors are ties for a low bid.
In this video tutorial, viewers learn how to use a green screen in iMovie. Begin by opening iMovie and click on Preferences. In the General tab, make sure the Show Advanced Tools is checked. Now film your video with your green screen. Then import the video(s) onto your computer from your camera. In iMovie, click on File, go to Import and select Movies. Place the video(s) in your project. Drag the green screen clip onto the project clip. When the menu pops up, select Green Screen. This video w...
Learn how to enable JavaScript and cookies in the Opera web browser. 1. Open Opera. 2. Click on tools. 3. Click on "preferences" to open the preferences pane. 4. Select the "advanced" tab. 5. Click on "content" and then check the "enable JavaScript" checkbox. 6. Click "cookies" and then click "accept cookies". 7. Click "ok" to close the preference pane and save the settings. Now you should be able to fully enjoy the web on your favorite browser !
Customizing Window Vista's glass borders is relatively simple. In order to expand the borders, right click and choose properties, then choose appearance. Scroll down and click on 'open classic appearance properties'. Under Windows Aero, choose advanced settings, and click on desktop and choose border padding. You can then increase the size to your choosing and click 'ok' and 'apply'. After a few short seconds, you will notice that your borders are fatter than they were before! You can also us...
This video shows how to make this spicy chicken dish. The chicken breasts are marinated in advance for 24 hours. They are grilled with the skin down first, which helps preserve the moisture and flavor of the chicken.
Dr. Cook discusses the best ways to pack your food for a camping trip. When it comes to packing food for your camping trip, the best way is simply to pack everything into Tupperware. Everything will be held neatly in one place, and certain items can even be organized in Ziploc bags, and then put into the Tupperware. These bags are also great for keeping the food dry, and can also be used to pack individual meals. Removing the food from its original packaging and placing it in a Ziploc bag als...
This is a tutorial to get XBox live without paying $100 for the router. You need an Ethernet cable and a laptop or computer with a wireless internet connection. To begin, go to the start menu and click on control panel. Change the control panel view to classic view. Then click on network connections and go to your wireless connection under the heading 'LAN or High Speed Internet'. Right click on the wireless connection icon and select properties. In the properties window, go on to the advance...
Be warned before hand that by making changes your router settings that you know nothing about can damage your router. Start off by opening your internet browser and then in the address bar either type 192. 168. 1. 1 or www.routerlogin.com. A prompt will come up in which you have to fill in "admin" in the first box and "password" in the second one. Look for the "Advanced" option and under it will be "WAN", click it. Now change your "NAT filtering" to "open". Make sure that "Disable SPI Firewal...
Learn how to fix or recover a corrupt windows registry following the steps outlined in this video tutorial. To begin, take the hard drive out of the computer with the corrupted registry and connect to another computer. To find the files you need to replace go to Start and My Computer. Look for the hard drive that you just added and double click on it. Go to Tools and Folder Options. On the View tab under Advanced Settings click Show Hidden Files and Folders, and unclick Hide Protected Operati...
You’ve got the basic head structure down and now it’s time to learn how to draw a detailed face of woman. It can be a little tricky to draw an angled view of a face but you can use sketching and shading tools to give depth, angle and form to create a realistic woman.
An two part introduction or overview of English articles: a, an, the, and the zero article. This is for the advanced or intermediate student. Part one presents basic rules or guidelines for using English articles. Part two summarizes the basic rules for using English articles and offers practice.
Windows Movie Maker can be used to make HD movies. This step by step clip shows you how. The first step is to import your picture or video and make sure they're in your timeline. When you've finished editing, go to tools and options and choose the advanced tab. In video properties there's video format and aspect ratio. Select NTSC and 16:9. If you're using a cell phone or video camera, you'll be using 4:3 which is pretty small for YouTube and similar sites in order to get full screen. Save th...
The video first opens up with a muscular man standing in a well lit weight room. He begins with a quick description explaining how he will be performing the stretches and then begins to do so. He swings his leg back behind him and bends it and pulls it up to his behind, he continues to do so for some time. Next he brings the same leg forward and stretches it over his other knee. After that, he bends over and exhales and touches his toes. He then gets a foam pillow and stretches his legs out c...
This is another video in the helpvids series of technology videos. The video describes how to set power options in Microsoft Windows XP. These options control when the monitor is turned off, when the computer goes to sleep, and when the computer will go into a hibernation state. Laptops will have more options than desktop computers since there are battery options on a laptop. Click on the Start Menu and then Control Panel, then Power Options. The first screen offers the option to turn off you...
This video shows the viewers how to create a simple but well done Halloween text in GIMP. Starting from a simple white background you will end up creating a creepy text perfect to use every year on the 31st of October . The video is actually a easy to learn walk through , showing your each and every step you need to make . Advance users but also beginners can benefit from this short clip . At the end of the video you will surely create the type of text you usually see only in horror movies su...
This is a tutorial on how to clear your Skype call history and chat history. The option for clearing call and chat history is difficult to find in Skype. To begin, click on Tools and select Options from the Menu. In the pop up box, click on the Privacy button. By showing Advanced Options, you will be able to access the button which enables you to clear your call and chat history. Please note that when you click the Clear History button, you will not only delete your call and chat history, but...
This video discusses the number zero in division. When dividing numbers, there are ways to check your math, like multiplying the two numbers. When you multiply zero with any other number, it still is zero. The video goes on to discuss indeterminate answers. If you were to divide a zero by a zero, your calculator would come up with an error message. But there are real results to these odd equations and they are indeterminate. The indeterminate doesn’t really show up in everyday living, but in ...
This is another HelpVids video on technology. In this segment we will learn how to set appearances and themes in the Microsoft Windows XP operating system. The videos starts by right-clicking on a blank area of the desktop, then selecting ‘Properties’. The presenter then clicks on the ‘Appearance’ tab. Clicking on ‘Advance’ will open some very detailed options such as changing the font in a title bar window. You can also change the size of the fonts in this window. The options are truly endle...
A video from Helpvids.com that shows how to Insert and edit text in Microsoft Word 2007. There are many ways to do document editing tasks in any of today's advanced word processing programs and MS Word 2007 is no exception to it. There are many ways to do the same task in word (For Ex. from the menu, using mouse gestures, using shortcuts etc).
Diane Morgan shows us how to make a delicious marinade for salmon and grill the salmon on a wooden plank.
Darin Stein from Fat Loss Lifestyle demonstrates how to build your pectoral muscles with exercise tips. Put two medicine balls into the butt of your palms, not your fingertips, for pushups. Lower your body for two seconds, keeping your elbows apart. Get a real nice stretch in the chest and push your body up. Do fourteen pushups. For an advanced workout, elevate your feet when doing the pushups. Walk a 65 millimeter resistance ball to your toes and continue doing the pushups. In addition to to...
Learn how to use Windows Vista remote desktop on your computer in simple steps. First go to Control panel, select 'User accounts' and create a password for your account. Now right-click on My Computer, select 'Properties' and click on 'Remote settings'. Now select the user you created by searching and return back to the properties area. Go to 'Advanced system settings', click the Computer name tab and find your computer name. Now open the Remote desktop connection, enter your name and enter y...
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.
Graffiti is a nuissance but it can also be an awesome form of true art. In this tutorial, learn how to draw 3D graffiti as demonstrated in Photoshop CS2. 3D graffiti gives your tag a very cool effect, making it appear to be popping out of the wall it is sprayed on and standing out from any other artwork nearby. Even though it looks advanced, creating 3D graffiti is actually quite easy to do. Try this style out and impress your fellow artists and passerbys alike.
In this video the tutor shows how to sign on to the Playstation network using Playstation 3. To connect to a Playstation network you will need a PS3 Controller and the PS3 itself. First signing on to the system, go to the System Settings. Then go to the network settings and you will need to configure your internet settings as shown in this video. It shows the different ways connecting to an internet like in custom mode or advanced mode, also the wired or wireless option. Finally after connect...
Street artist wackojacko54321 teaches you how to draw "wild style" graffiti. There is no definite technique or way of drawing wild style. Wackojacko54321's interpretation involves starting with a simple piece with connecting letters (of which he provides an example) and possibly arrows. Add more basic arrows and connections to unify the piece more. Connection points of the arrows are important. Attach them to the ends/corners of letters or other letters/connections. Spice it up with more adva...
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.
BeforeAndAfterTV teaches you how to get bigger buttocks through simple exercises. You can do these exercises pretty much anywhere. All you will need is a yoga mat. Here is how to get started: lie with your back against the mat, put your hands against your sides, head back and lift your hips, the feet being on the ground. You will have to lift your hips as high as you can and hold it up for about 3 seconds. For an advanced exercise you can have one leg up in the air and lift the hip. For the s...
This video is an extremely quick yet advanced tutorial of how to create Japanimation eyes in the Adobe Flash program. Otherwise known as "Manga", this style was created in the late 19th century Japan and is still commonly used in comics, books, media and cartoons. This is not a basic tutorial since you must have a general knowledge of how to use the tools in Adobe products like Photoshop, Flash and Imageready. Using the transform, vector and paint brush tools to create the shapes that make up...
This how-to video shows you how to rip a DVD to a hard disk drive. You need VLC media player installed to rip the media. Start by turning on VLC media player and going into the view tab and clicking Advanced Controls, you can then close VLC player and play the DVD on your computer in VLC media player. As the video is playing you can click the record option under the video to begin recording. Once done recording the video will be saved on your hard drive.
This video begins with teaching of percentage lesson. He is also teaching conversion of percentage to decimal and vise verse. This teaching is using advanced technology note pad when he goes on writing on pad that will display on screen. He is telling that percent 35% in decimal it is .35 and if decimal 2 it is 20% in percent. And he was teaching how to convert fraction to percent by taking one example 7/8 , to convert this first we have to divide 7 by 8 then we get answer .875 then to conver...
For more advanced math, you will need to use the difference of squares in order to factor certain polynomials. This video offers the basic technique for this factoring method as well as a few examples to get you started. In order for this factoring technique to work, you will need two numbers which are squares and are being subtracted from each other. The two factors will be the original numbers added to each other as well as subtracted from one another. This fast and simple factoring method ...
This video shows you how to perform a BOSU ball squat thrust. A beginner and a more advanced version of this exercise are both shown. First you put the BOSU on the ground flat side up and you reach down and grab the sides of the BOSU. You then kick your legs out into a push-up position, do a push-up and then stand back up. You finish the exercise by lifting the BOSU ball over your head. You should do 3 sets of 10 reps of this exercise.
This video shows you how to disable the automated spell checker in Mozilla Firefox. The spell checker is supposed to be a great feature in Firefox, but lot of people find it annoying. The spell checker helps you correct your writing mistakes by underlining the misspelled word with red. You can easily disable it by opening the Tools tab in Firefox and selecting Options. Then, go to the Advanced tab in the popped-up window and uncheck "Check my spelling as I type". That's it! Good Luck!
This video tells you how to set your default browser to Firefox3.5. In a few simple steps, you can set Firefox as your default browser and also make sure the browser is Firefox whenever you browse. Open Firefox browse- click on Files-Select Tools-Select options-select advanced-you will find System default at the end, just click the option button against". Always check to see if Firefox is the default browser on startup. This option changes your browser to Firefox and also makes sure that alwa...
We all learn a simple description of photosynthesis in grade school but there are a lot more complicated process going on. Plants can utilize carbon at night and this description will explain a very advanced understanding of how CAM works.
Corey Millligan takes you through the instruction needed for knife sharpening. He explains that all knives, regardless of cost, needs to be sharpened. He shows you the diamond steel sharpener. He explains the positions you can hold the sharpener and which one is best for beginners. You learn how to get and control the angel needed and how paying attention to pressure is important. Corey also teaches you how to sharpen serrated knives and different techniques for advanced sharpeners. Watching ...
A video from free math tutoring that teaches you a method of factorization of a complex polynomial. The tutor shown in the video demonstrates how to factorize common functions of a variable by the factor method. This video isn't for advanced learners of mathematics. It is for beginner to intermediate level viewers.
This video is one of the amazing videos in which we can see the use of the vertices in real application. The video gives a clear explanation on how to use vertices into optimization function. This is a not only basic example in mathematics but also an important foundation for the advanced problems in mathematics. Viewers can gain a clear idea about the vertices and how they are used in an optimization function. This is a very essential part of mathematics which every student should learn abou...
