This video tutorial belongs to the Education category which is going to show you how to create a research binder. This binder will hold all your "how to" articles or research guides. You will need page dividers which you can make yourself or purchase. The dividers are meant to separate sections in the binder for ease of storing and retrieving all your research materials. You can have dividers for events, dates, contact details of people, places and "how to" articles. The dividers can have a f...
In this video, we learn how to draw a polar bear. Start off by drawing a round circle for the stomach, then draw the head next to the stomach. This should make it look like the polar barn is crouching low to the ground. Next, draw on the four legs to make it look like the bear is walking. After this, draw in darker lines to outline the bear further and then draw in a baby polar bear next to the mother. To add a special touch, draw in snow and ice around the bears. When finished, sign your nam...
In this tutorial, we learn how to map network driers from a remote server. First, go to run on your start menu, then type in the id address or server name for what you want to access and press enter. Now, right click on the folder you want to map and click on map network drives. Choose any letter you want from the drop down menu, then click next to the "reconnect on logon" text. Click on the finish button, then open your newly mapped network drive from your computer. You can do this for any s...
In order to clear the cell content in Excel, using a macro, you will first need to have a table. If you don't already have a spreadsheet, you will need to create one with random numbers. Next, highlight some numbers, by clicking one box and dragging in order to select a number of boxes. Click Alt + F11.
This video tutorial is in the Computers & Programming category where you will learn how to save multiple locations in Yelp. Yelp is great for finding businesses in your neighborhood. You can also search for something in other cities. You can enter the location in the 'near' box to search for something somewhere else. You can also save locations to easily search later. Click on 'account' and then on 'manage saved locations'. Here you click on 'add new location', type in the location name and t...
In this video tutorial, viewers learn how to get tabs in Finder. This can only be done on the Mac OS X computers. Users will need to download the Total Finder application from the site provided in the video. Once downloaded and installed, this program will allow users to manage multiple Finder windows in a series of tabs in a single window. In the Finder Preferences, users are able to configure the sidebar, label color, file name and trash options. This video will benefit those viewers who us...
For those of us who aren't blessed with full lips, here's an easy way you can achieve big pouty lips with just a little make-up. This tutorial allows you to get those gorgeous beestung lips naturally...sort of. Well, using natural cosmetics.
It goes by many names. The RLoD (Red Lights of Death), the RRoD (Red Ring of Death), absolute disaster. Whatever you call it, the XBox 360 error that causes many console's front LED's to turn red in rage and cessation of function has caused all sorts of headaches for consumers and Microsoft. It can be caused by a couple of different cooling-related issues, and determining the error code that has caused your console to malfunction can go a long way to helping you fix it. This video will show y...
In this video, we learn how to create a free flash website using Wix. First, log online and go to "www.wix.com" and either create a screen name or log into your account. Now, click on "create" and choose a premade template or make one from scratch. Now, change the background to a color you prefer, then add in a frame and different media to your page. You can also add a title to the website by clicking on the "text" section. You can play around with the different effects and additions, making ...
In this video tutorial viewers learn how to wear the National Working Uniform. This uniform has a strict policy and all must follow the uniform rules. The basic components of the uniform are: an eight point cap, blue cotton undershirt, shirt, trousers, belt with closed-faced buckle, black boot socks, blousing straps, black 9" steel-toed leather boots, embroider rank insignia and service & name tapes. This video is very detailed and clearly explains all the uniform expectations. This video wil...
The name of this crochet stitch says it all. Called the basket weave stitch, it consists of cubes of intersection vertical and horizontal yarns to create a unique pattern reminiscent of basket weaving.
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 636th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic frequency table and histogram chart using defined name formulas for dynamic ranges that use the INDEX function. See other formulas that use the COUNTIF, IF and ROWS functions that help to make it fully dynamic....
In this clip, learn how to make a very authentic Japanese recipe - octopus scallion karashi sumisoae. This dish is full of veggies, fish, tofu and spices and tastes incredible. Don't be afraid of it's long winded name, the recipe itself is actually quite easy.
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 and Mr. Excel, the 42nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to look up a picture in Excel. See a VBA solution and a formula Solution using the INDIRECT function and named ranges.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 15th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with tables in Excel 2007. Specifically, you'll see the following:
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 19th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about using Advanced Filter to extract data from an Excel List/Table/Database. See these 7 Advanced Filter examples:
Want to give your new Android enable mobile device a personal touch? Well, your phone comes preloaded with wallpapers that you can use, and you just have to find the right one that fits your personality. Adding the wallpaper to your phone is easy. Go to gallery, flip through the stock wallpapers, and select the one you want by clicking "select" — Best Buy has answers. The Best Buy Mobile team explains how simple it is to set the wallpaper on an Android cell phone.
In this Computers & Programming video tutorial you will learn how to format a hard drive to boot a second operating system. First, do a Google search for EASEUS partition master, download and install it. Launch the program. Right click on the unallocated space on your hard drive and then click ‘create’. Now create a new partition for the new OS. Name it Vista, select ‘primary’ in the ‘create as’ window, choose ‘NTFS’ in the ‘file system’ window, select drive letter as ‘V...
In this how-to video, you will learn how to format one of your hard drives in Windows 7. First, go to start and right click my computer. Select manage and a new window will pop up. Go to storage and select disc management. Now, right click the drive you want to format. Type in the name you want for the label and check quick format. Once this is done, press okay. Click okay to continue. This does not take too long. You have now formatted a hard drive. This video shows you the basic steps it ta...
In this Outdoor Recreation video tutorial you will learn how to tie a Prusik friction knot. In case someone has fallen into a crevasse or you want to get back on a rope, Pruisk knot is required. It is used to tie two ropes of different diameters. It basically puts a loop of cord around another rope. It is named after the Austrian mountaineer, Karl Prusik. For making the knot, take the fixed loop made on one rope and pass it around the other rope and back through the fixed loop itself. Then lo...
In this Electronics video tutorial you will learn how to tether a laptop to a Droid Smartphone for free Wi-Fi. For this you will need the android wifi tether application. Download the version for your device from here and install it. Then launch the app and press the icon to start tethering. In your laptop, go to settings and then to wi-fi. You will see a new network called android tether. Connect to the network and you will see that it works. As with any other network, you can change the nam...
In this video tutorial, viewers learn how to partition an external hard drive on a Mac computer. Begin by open Macintosh HD. Scroll down the list on the left and click on Applications. Double-click on Utilities and select Disk Utility. Under Volume Schemes, select 2 Partitions. Select the name of the partition and choose the format that you want for the drive. Select the second partition and do the same. Now click on Apply and click on Partition. This video will benefit those viewers who use ...
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 5th installment in their series of digital spreadsheet magic tricks, you'll learn how to name a cell range, use data validation to add a drop-down list, and how to use the VLOOKUP function to look up values.
This is a video tutorial that is showing its audience how to utilize the website LinkedIn after you graduate from college. The first step is to go online to the website. Then you should make a profile. Make your profile polished and professional so that you future boss can easily search for your name and look at your wonderful profile. The next step is to include at least three past positions in your profile, a photo, and what schools that you have attended. You should also be aware of your p...
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 373rd installment in their series of digital spreadsheet magic tricks, you'll learn how to select 3 numbers from 50 with no repeats. Also see how to select 3 names from a list of 10 with no repeats.
In this how to video, you will learn about Chemiluminescence and the oxidation of Luminol. The first solution is Luminol and NaOH. The second is K3 and H202. Luminol is used to detect blood in crime scenes. It reacts with Iron in Hemoglobin. As you can see in the example, it illuminates the chemicals in the dark. This is why it is very useful for crime scenes. It can be used even if the blood is not visible with day light. Thus, it is an invaluable chemical in the name of science and justice....
This HelpVids.com tutorial shows the basic options for setting an alarm on an iPhone. To begin, open the "clock" app. There are four sub-menus in the the "clock" app. Choose the "alarm" sub-menu. To create a new alarm, touch the "+" in the upper right corner of the screen. A new screen appears and the user has different options. A repeat time for the alarm can be chosen. The user can choose the sound that plays when the alarm goes off. The "snooze" option can be toggled on or off, and the ala...
New to 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 Excel tutorial from ExcelIsFun, the 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF f...
Shelley Lovett from Childcareland demonstrates sand writing as an early childhood learning activity. All you need for this activity is a baking sheet that is approx one inch deep and some sand. Colored sand makes it more fun for the kids. Shelley says the cheapest place she has found colored sand is at Wal-Mart, but it is also available at craft stores and perhaps even at Home Depot or Lowes. You spread a thin layer of the sand onto the baking sheet and try to make it pretty even. For very yo...
In this Computers & Programming video tutorial you will learn how to create a virtual machine for free using the virtual box in Mac. Open the virtual box and click on new. Click next, put in a name for the virtual machine and click next. In the next window, it gives a recommended memory, increase it slightly with the slider and click next. Click next in the subsequent 4 windows that come up and finally click ‘finish’ and click ‘finish’ again on the next window. In the next window click CD/DVD...
In this video Mike Callahan walks you through using Skype on the iPhone. To start, download it from the Apple App Store. Next, launch the application on your iPhone. It will immediately prompt you to enter your name and password. If you don't have one you can use this screen to create one. Once you've logged into your account you'll see your list of contacts. Touch one of your contacts to place a call to them. There is a call option at the bottom of the screen that will launch your dial pad. ...
In this Computers & Programming video tutorial you will learn how to hide and lock folders in Windows. When you want a private folder that you don’t want any one else to open and see. You will need this feature. For this open a new folder. Open the folder, right click on it and go to ‘customize’. Then select ‘change icon, click on a blank icon, click OK and ‘apply. Now you will see that your folder icon on the desk top will disappear; only the name will be visible. Now rename it with a small ...
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...
In this how-to video, you will learn how to change the font size with Microsoft Word 2007. First, open the program and type in a sentence or two. Now, move your cursor to where the font name is. To the right of this should be a drop down menu with numbers. These are the sizes of the font. Highlight the text. Now, click and change the number to change the size of the text. The larger the number, the bigger the font will become. This video shows you just how easy it is to change the font with t...
This video tutorial from MatthewNeer presents how to check your site's or blog's Google indexing.Type in Google word Site, press Space and then enter your site's or blog's URL address.Then press Enter or click Search button.Newly opened Google page will show all the pages from your site or blog which are already indexed in Google search engine.From search Results to the right you can see how many pages from your site are already indexed.According to the results you can reoptimize those pages ...
How to pick the right RAM for your computer
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 506th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize data from multiple sheets. For example, you'll see how take checkbook register data from multiple banks accounts and summarize it based on account names.
This video shows the method to install 'Installous' on your iPhone and iPod Touch. The first step involves opening up 'Cydia' on the iPhone or iPod Touch. After opening Cydia go to manage and then go to the option of 'Sources'. The resultant window will show an option named hackulo.us. Add this cydia.hackulo.us to the source. The resultant window which opens shows various sections. Find the section of Hackulous in the window. Go to the Hackulous section and find the option of 'Installous'. In...
This video shows how to make a eco friendly plant holder. The first thing you do is trace a fabric around the tin can this is to give it a better look. Then stamp the letters on the fabric of what you want to name your plant. After that poke about ten holes at the bottom of the can. Then glue the back of the fabric to place it on the can. Now wrap the fabric around the can on the sticky side. Lastly tie twine around the can for extra protection to hold up the fabric. Then put in the plants an...
Ken Appleby demonstrates how to mask a domain with GoDaddy. Masking a domain enables the domain owner to customize what appears in the viewer's address bar. First, log in to your GoDaddy account. Then, click on the domain manager function located on the left hand side of the page. Next, choose the domain that you would like to work with in the domain name list. Click the forwarding option. In the next window, click on the masking tab. Tick the enable masking function. Choose a masking title. ...
