The instructor of this video shows you how to completely hide the ribbon, or the menu, in Excel. If you only want to partially hide the ribbon, you can use the shortcut control + F1. To completely hide the ribbon, though, go to the Visual Basic screen, hit Alt + F11. Then, go to insert, then module, and type in the macro "sub (Your name for macro)" then hit enter, then type in the code "application.executeExcel4macro''show.toolbar(""Ribbon"", false)''". To set up the code to show the ribbon a...
This video shows you how to generate random numbers with decimals in Microsoft Excel.When generating random numbers you must have a lower and upper limit, so that your number will be generated between the two limits. For a number without decimals, you only have to use the "=randbetween" function. If you want to use decimals, you will have to use a different but similar function. Start by typing "=rand()". Next, you multiply this by the difference between the limits and add the lower limit. Fo...
Watch Southwest Lawn and Garden's John white and Dr. Bernd Leinauer Discuss the importance of Bermuda grass lawn fertilization and the correct techniques involved. You'll learn how to interpret the meaning behind the fertilizer label, and why a complete fertilizer, including nitrogen, phosphorus and Potassium. Along with how to calculate much fertilizer to use per square foot, You'll learn how each important nutrient helps your lawn, and why having the correct balance is so important. Most im...
In this video tutorial, viewers learn how to change the lock pattern on an Android phone. The lock pattern allows minimum security on the phone to prevent other people from tampering with your mobile files. Begin by going into the Settings and click on Location & security. Under Screen unlock pattern, select Change unlock pattern. In order to change the unlock pattern, users will have to type in the current unlock pattern. Now type in the new unlock pattern and press Continue. Then retype the...
This video tutorial from butterscotch presents how to change file associations on your computer.File association is a link between a certain type of file (.doc, .gif, .txt) with a particular program.For example text files are by default associated with Notepad application.So if you double-click text file it will be automatically opened in this program.In case you want to open this file in a different type of program, you need to change the file association.To do that, right click the file, th...
In this how-to video, you will learn how to choose the right sage plant for your garden or landscape. The Texas Ranger is one type of plant to choose. They do well in hot, dry climates and heavy soils. They do not need a lot of maintenance. Selective pruning is useful for this particular plant. Green Cloud has dark green foliage and is a lot thicker. Scarlet Sage attract Hummingbirds. These have little insect problems if you do not give them too much water. Mexican Sage dries very well. It ca...
In this video you will learn how to tie a knot known as the "Hunter's Bend". A "bend" is a type of knot used to join two ends of a rope together. Generally, it should be possible to untie this type of knot, once it's usefulness has passed. This knot was originally created by a man named Phil D. Smith during WWII, at which time he dubbed it the "Rigger's Bend". An English physicist, by the name of Edward Hunter, rediscovered the knot in 1978, and popularized it's use, leading to it's current n...
For those interested in crochet, this video tutorial outlines the steps to doing a double treble stitch. This type of stitch is a much taller stitch than most others. To begin, you will start with a five chain series that will act as the first stitch. Wrap the yarn around the hook three times and insert it into the next stitch. You will then pull the yarn through working off two loops at a time. Working off essentially means dropping the loops off the crochet hook. Then, you just repeat these...
In this video from FusionGuy09 we learn how to use different lampshades to create different looks in your home. This video is from the store Naomi's Lampshades and Lamps. When buying a shade you want to bring your lamp to the store. Bea Searles shows us a bunch of different lampshades on different lamps and how they look and the different type of looks they will give to a room. Also in many cases you can just change the shape of the harp in the lamp to fit other kinds of lampshades. She shows...
As you type in Microsoft Word, take care to notice when the computer puts a red squiggly line underneath a word you typed. If you see a red squiggly line, the word is spelled incorrectly. If you right-click on the word, MS Word will show you a list of correctly spelled words that it guesses you were trying to spell. If you wish to check the entire document, you can click the Tools tab at the top of the page and then spell check. This will go through the document and point out every misspelled...
In this video, JD, from Tying It All Together, demonstrates how to tie a knot known as a "Ringbolt Hitch". This is also known as "coxcombing". This type of knot was once a common tie used by sailors to dress-up items and parts of their ships. When tying a wheel, a "Turk's Head" knot was used to cover the part of the wheel where the two ends of the ring bolt met, which would firm up the hitch, and help to keep the tied ends from unraveling. It is a nautical tradition to use this type of knot t...
This is a video about "How to Hack: Demolition City 2" by Travis. This is a flash game. To begin hacking, go to the game and enter the first level. At this point, you do not have any cash. Specify that you are using Mozilla in the cheat engine. After you have completed the first level, write "double" variable in value type and then type the value for the first level, and you can easily notice the game appearance seems to be changed, because the second level of the game consists of first level...
In this video the author describes how to design a centerpiece for your table with a holiday or winter type theme. The author uses different types of foliage including cedar, pine, sugar pine cones, roses, and twigs to accomplish this masterpiece. This is a step-by-step video and is easy to follow along with. The author starts with floral foam and explains the process from start to finish with enthusiasm and detail. The finished product would decorate a large table for a party or gathering an...
This video is from HelpVids and describes how to change the axis titles on charts in Microsoft Word 2007. To access the chart tools, select the chart and the tools will appear above the ribbon. There are many different design options that you can preview on the screen to make your final selection. To change the chart title, click on the Chart Title button which is located on the Layout ribbon. You can then select where you would like the title to appear. Once you select the location you can t...
This video tells you how to save files in Microsoft Word using different file types. If you are trying to save a file as the old Microsoft Word 97-03, the process is easy. This video takes you through a visual tutorial on how to save files under different documents. If you click the circle in the upper left corner and scroll down to save as, it will give you several different options to save under. Then, you can choose which document you want to save it under, and save the file under a new na...
In this video tutorial, viewers will learn about decorating bag basics. A decorating bag is used to pipe semi-solid foods by pressing them through a narrow opening at one end for many purposes, including cake decoration. Viewers will learn about the types of decorating bags, how to add a coupler to a decorating bag and the proper way to fill a decorating bag with icing. This video introduces three different types of decorating bags. The bags are the feather white bag, the disposable bag and t...
Georgia Koons demonstrates how to give a relaxing and holistic facial massage. A facial massage has many benefits. It can be anti-aging because it causes the blood to better circulate in your face. It can be relaxing by massaging in soft circular motions. Any type of massage is sure to relieve tension and a facial massage specializes in ridding the body of tension cause by squinting and straining the facial muscles. This type of massage is great for headaches or to help you fall asleep faster.
This video teaches "How to Download and Install JAVA plug in for your web browser". Open your web browser.
When defining fields in FileMaker Pro 10, one has to choose what type of field to decide for a database. There are two fields that accommodate special handling of data. They are time and time stamp fields. When one decides a field under manage>database,there is a option for "type". Under that, there is time and time stamp. The "time" one determines the time while the "time stamp" determines the time and date. This will help in preparing a proper and detailed database system.
This video tutorial by tasktutorial shows you how to create stylish text in Photoshop. Launch Photoshop and select the type tool and choose myriad-pro font light. Create a text field and type in the text as indicated. Increase the font size and location as desired. Thereafter open the layer options, choose a gradient and create a new gradient by selecting the color as required. Apply a white color outer glow change the size, range and opacity. If you want to add more text create a new layer a...
This video is truly a god send for the ladies and gents who wear glasses, and want to look good wearing them. The lady in this video explains and teaches about the various types of makeup that is good to use, especially if you wear spectacles. The lady in the video tell people who, wear glasses about the makeup they can use to look better wearing glasses, alternative makeup for different types of spectacles is the agenda, methods about how to make your eyes look smaller behind those big focal...
This lynda.com video tutorial shows how to use container fields with FileMaker Pro 10. When you want to create fields in FileMaker database you have the choice on what kind of fields you want to make. Many general fields are self explanatory like text, date etc., but there is a special kind of field called the container field. FileMaker Pro container field is a versatile data type in that it can store any kind of binary data. Container fields can be used to hold binary data in four broad clas...
Fix the 2 packs of Ramen noodles as instructed on the package. You can buy 12 individual packs as they are a few cents cheaper. Some people like to coordinate my noodle flavors with the type of meat they're using. For chicken flavoring, use turkey or chicken. For beef flavoring, use beef or pork. For hrimp flavoring, use any type of seafood.
This video shows you how to make a crunchy shrimp sushi roll. The first step is to roll out the rise of a stick roller. You then lay seaweed down over the rice and add the type of meat of your choice to the roll. You then use the roller to compress all of the content together correctly. You then cut the roll into 16 identical pieces to complete the procedure. This instructor has many other videos on similar ways to make this type of sushi.
This video from Lowe's will show you how to install a deadbolt lock in just a few easy steps. You can install a deadbolt lock on almost any exterior door, including those made from wood or steel. Deadbolt locks come in several types including the conventional ones requiring a key or the newer ones that have keypads. Whichever type you choose, the principles of installation are the same. This video will show how to a drill in your door and chisel out material in your door jam. Once this is don...
You can never see too many tutorials on retouching portraits since there are so many types of imperfections and types of people. These two examples explains how different blurs can be used, and use of other retouching tools. You should have a good knowledge of the Photoshop interface and workflow before starting.
In this tutorial, we learn how to block a website. First, you will start by going to the start menu then go to "run". After this, type in "c://windows/system32.drivers/etc". After this, a new window will pop up on your screen. With this, you will drag the host into a text document. Then, type in the website that you want to block inside of this document. Once you are finished, type in the IP address of your computer next to that and save it. This will finish up the blocking of the website and...
In this tutorial, we learn how to create an annotated bibliography. Make sure to highlight all your citation information, then type it into your bibliography page. After you have it written down, type it out again in the proper citation format, making sure you use the proper type. Make sure you have all the proper information, and you don't forget any of the crucial information. An annotated bibliography is different because it will give a summary underneath the citation. This is only about f...
In this Software video tutorial you will type math equations in Open Office Writer. Double click and open up the writer. First you got to add a button to the toolbar. For this, click on the arrow at the end of the toolbar and select 'customize toolbar'. On the window that pops up, click on 'add'. Then highlight 'insert' (on left hand side) and 'formula' (on the right hand side) and then click add > close > OK. You can now see the formula button on the toolbar. To add a mathematical equation t...
With feminine florals being one of the hottest spring and summer trends, it's often recommended by the fashion elite - including Tim Gunn - that more masculine elements be included in your outfits to balance out floral girliness.
In this video, we learn how to enable the Windows default administrator account to appear at the log in screen. First, go to your "start" menu and type in "cmd". Right click "cmd" and click "run as administrator". Now click continue and type in "net user administrator /active:yes", (making sure you put the appropriate spaces), and press enter. Now it will say your command was done successfully on the space underneath where you just typed your text. When you restart your computer you will now ...
Need to change the NAT type on your wireless Linksys router to play games over the Internet on Xbox Live? Boy and/or girl, have you ever come to the right place. This home networking how-to will get you up & gaming in no time flat.
FROMAN1115 teaches you how to change your NAT type to Open on your PlayStation 3. On the PlayStation 3, go to Settings-Network Settings-Settings and Connection Status List and write down your IP. Go to your PC and start your internet browser. Type in 192.168.1.1. This will bring up the router settings page. Go to Applications and games and then DMZ. Check the first box that says Enabled. Enter your IP address below and click ok. Your settings have been saved and you can enter a new internet m...
Blip TV user Mr. Root teaches you how to mount an ISO image file using the Unbent Linux terminal. To do this and have access to the files inside of an ISO, without unarchived it, start the terminal. Type in dirk CD. Make sure the ISO image is on your desktop. Then type in sud o mount -o loop -t iso9660 and then the name of your image file, followed by CD/. This will create a new disk drive, which can be seen on the desktop. You can explore that disc like a real one. To unmounted your image, s...
This video tutorial gives you a way to access websites that you can not normally access because of a web block or filter. What you need to do is click on the ‘Start’ button and then click on ‘Run’. In the small window, type in ‘cmd.exe’; this then opens a black window. Then type in ‘ping’ and the website; this gives you an address that you type in directly to your web browser, granting you access to a normally blocked website. This comes in very handy when you are in such locations like schoo...
There are many functions in Microsoft Excel. One function that people rarely use is the Repeat function or REPT. In this video, an example used is a chart of people and their sales of a certain item. Just looking at the numbers, it is hard to compare the different sales easily, but a more visual approach may work better. Next to one of the cells, type in "=REPT(" which is the repeat function. A popup should say "=REPT(text, numbertimes)". For "text", type in *** or anything, really. For "numb...
Tim Carter discusses the different types of wood and how they are recognized and how their attributes are utilized. Informative video will help to make sure you use the proper wood for your build.
There are two main types of shafts for horse dawn carriages, U-Shaped fixed shafts and independent shafts. watch this video to learn how they work.
Managing Panoramas (henceforth known as panos) and HDR photos in Lightroom is an important step in making your life a lot easier if you like that type of photography. What happens after shooting a lot of either type of photography is that your library becomes really cluttered. As if the clutter wasn’t bad enough, it just becomes flat-out difficult to start processing these types of photos. So instead of ditching Lightroom when you shoot at pano or HDR set, check out this week’s video and give...
This is a tutorial on how to edit type in a layered file and a flattened file in Photoshop.
