Existing Data Search Results

How To: Create a blog roll on your WordPress blog

Learn how to create a blog roll (blogroll) of your favorite sites on your WordPress blog with this free video software tutorial. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.

How To: Embed HTML code into a WordPress post or page

This clip presents a general tutorial on how to work with and embed HTML code into your WordPress posts and pages. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.

How To: Create main and subpages on your WordPress blog

See how to create a main page with a drop down menu revealing secondary pages — also known as parent/child or main and sub pages (subpages). Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.

How To: Insert an image gallery in a WordPress 3 blog post

If you need to display thumbnails on a WordPress page and link the smaller thumbs to the original larger pictures, this post shows the process involved, using the Lightbox plugi,n which creates a special overlay effect when an image link is clicked on. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also mak...

How To: Transfer iTunes playlists from PC to Mac

This video will show people who are switching from a PC to a Mac how to move your iTunes playlists to your new computer. From your PC, you should go to the File tab of iTunes and go to your library, choosing "Export Playlist". Next, go to your Mac and select the "Import Playlist" option on the drop down menu. On your Mac, open the file for the PC playlist and use the "Find" option from the Edit menu in order to replace the parts of the address which are different from that of the format which...

How To: Convert an mp3 file to wav format with Audacity

Want to convert an MP3 to a WAV? With Audacity, it's easy! And this clip will show you just how it's done. Whether you're new to computer recording, new to the Audacity DAW (digital audio workstation) or just looking to pick up a few new tricks, you're sure to benefit from this video software tutorial. For more information, including detailed, step-by-step instructions, watch this free video Audacity lesson.

How To: Replace a Nintendo DS Lite game socket

Nintendo has been the king of handheld gaming devices since the introduction of the Game Boy. Over the years since the Game Boy's reveal, Nintendo has improved their tehcnology quite a bit and now during the 21st century, the Game Boy is gone and what now exists is the Nintendo DS. DS for dual screens, this nifty little device uses touch screen technology to interact with characters in the game. Despite the technological advancement, there are times when things can go wrong. In this tutorial,...

How To: Find outliers using the Z-score method

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 49th installment in his "Excel Statistics" series of free video lessons, you'll learn how to find outliers with the +/- 3 Z-score rule and the ABS function. See how to do a box plot by hand and in Excel. For th...

How To: Use Microsoft Excel 2007 as a complete beginner

If you're a novice looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! This free video MS Excel lesson, the very installment in said tutorial series, covers the following topics:

How To: Use database functions in Microsoft Excel 1997-2003

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.

How To: Build confidence intervals given the sigma in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 81st installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma (population standard deviation) is known. See how the CONFIDENCE and NO...

How To: Make calculations in Excel with formulas & references

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...

How To: Run Pwnage tool on Windows & make your own firmware

Learn how to run the PWNAGE tool on your Windows PC by following the steps outlined in this video tutorial. To begin, you will need to download utorrent at utorrent.com. You will also need to download three other files, the links of which are listed in this video's description. Once you are done downloading those files, you will need to download and install the VMware Workstation. Once the installation is complete, shut down your computer to make sure the installation is complete. Next, unzip...

How To: Check to see if a string contains a value in MS Excel

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 530th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR, SEARCH and ISNUMBER functions to see if the descriptions in a data set contain a given value (in this case, "Repair" or "Rework").

How To: Find, replace & sort in MS Excel

In order to Find, Replace, and Sort, using MS Excel, become familiar with your home tab. When you click on Sort, it will give you the opportunity to sort in different ways: e.g. alphabetically. If you accidentally shift your table, you can undo it by using Ctrl + Z. Custom Sort will allow you to be very specific in the way you want your data sorted. You can add or remove a filter with the same drop down menu, in order to be even more precise.

How To: Make simple wire hoop earrings

The video describes to make wire hoop earrings. Take a steel metal of anything and take a eighteen gauge wire and wrap a few length of it around the taken piece of metal which is cylindrical in shape. Cut the wire at the desired part and remove from metal.The wire takes the shape of a standard spring. Again cut it into two or three pieces. Hold the wire again and straighten the edge and after that once again bend it down holding at the place where bent begins. Put some on it to design and the...

How To: Connect a USB hard drive to an Xbox 360

In this how-to video, you will learn how to connect a USB hard drive to your Xbox 360. This will be useful if you want storage for additional media and do not have enough space for it. First, turn on your system and then go to disk management and delete the partition. Back up any data before doing this. Next, create a new partition on the drive. Set it to FAT32 and enter a name for the label. Your USB drive will now be used on your Xbox 360. This video shows how easy it is to connect a USB ha...

How To: Format/partition an external hard drive on a Mac

In this Computers & Programming video tutorial you will learn how to format/partition an external hard drive on a Mac. This is really very easy and simple to do and takes practically no time. Click on spotlight search and look for disk utility. That will bring up the list of hard drives. Click on the external hard drive and click ‘erase’. Then on ‘security options’ select ‘zero out data’ and click OK. This will remove everything from the hard drive. Your external hard drive is now...

How To: Create an Excel table in Excel 2007

First, open the Excel worksheet you have previously created that you would like to create a table for. Click on any of the cell that contains data for your table. On the menu found on the upper portion of the application, go to the Insert Tab. Find and click Table. Your entire worksheet will now be selected. When a prompt window appears, click OK. Your table should now be created automatically.

How To: Configure Microsoft Entourage for a Gmail account

Log in to your account. Go to settings, then go to Forwarding and POP. Then, check in the box for enable POP for all mail. Next, save the changes. Then go back to the settings page and check the first box (to include the mail that has already been downloaded). Save your changes again. Next, select tools>account. In the box that pops up, select POP for the account type and hit OK. Name the account and fill in your email address and POP address. For the SMTP server, put in smtp.gmail.com. Then,...

How To: Burn CDs and DVDs on a Mac with the Burn application

In this video tutorial, viewers learn how to burn a CD or DVD on a Mac computer with the Burn application. Burn is able to create data, audio and video discs. The Inspector window allows users to edit extra information about the disc. To open Inspector, press the Command and I button. It is also able to create disc copies. To burn a disc, name the disc and select a format. Them simply drag the file(s) into the program and click Burn. This video will benefit those viewers who have a file on th...

How To: Sort columns in MS Excel

In this how to video, you will learn how to sort columns in Excel with the Excel Experts. This is great if you want to learn the basics of sorting in the program. First, you must have Excel installed and running. Open up a spreadsheet that needs columns to be sorted. Select the column. Go to data and sort. Click options and select left to right. Choose the row you want to use and select the order. To undo this, go to sort and change the sort order. This video offers straight forward advice fo...

How To: Run a Windows app on a Mac OSX using Crossover

In this Computers & Programming video tutorial you will learn how to run a Windows app on a Mac OSX using Crossover. Search for the program, download and install it. Open the program, go to configure and then to manage bottles. Then click on the little ‘+’ button, name your bottle, select a version of windows and click ‘create’. This will take a few minutes to create the bottle. Now click on applications > install software. In the crossover software installer window, click on ‘insta...

How To: Use shapes & stamps in Photoshop CS3

The shape stamp tool in Photoshop is similar to using old fashioned clip art. Shapes are extremely easy to access and you will get the hang of them quickly. These shapes can be used to enhance your existing photos or to create graphics like banners and icons. In this tutorial, you will learn exactly how to access and use the shape stamp tool in Photoshop CS3. You will no doubt have this down pat in no time and will soon be on your way to using stamps - just one of Photoshop's many helpful tools.

How To: Fix the "open tray" problem on your XBox 360

This video is for XBox owners who are experience the "open tray" problem. This is when you insert the disc, a few seconds later, it'll ask you to open tray again, and then it won't even acknowledge that there's a disc in the tray. Assuming you know how to open up your XBox, you'll be able to see the parts of the disc drive. It consists of two parts, the part where the disc spins on, and the laser, which reads the disc and it sits just a little bit away from the middle of the drive. The proble...

How To: Set up POP3 settings for Outlook 2003/Outlook Express

POP3 stands for Post Office Protocol, a way in which you receive mail on the internet, paralleling how mail is received in your mailbox. To set up your POP3 for Outlook, go to tools, click “view or change existing e-mail accounts’ and press next. You’ll be able to see a list of your current email accounts that you can change or remove. When you select an email and press change, you’ll be able to see the account in detail: the email address, the POP3 and SMTP server information, and th...

How To: Put PS3 controller on a PC

Initially, you are directed to the control panel where you will navigate to your existing connected devices. You are then directed to the appropriate software to install the PS3 controller to your computer. Daddyezee then shows how once the appropriate driver is installed, you will see the program in your start menu program groups. If that does not work, or the controller freezes, you are presented with another program to facilitate the original install. You are then presented with an illustr...

How To: Sum the values from many cells to a single Excel cell

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 298th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and MOD function to add up all hours in one cell worked by employees when time in and time out data are entered as time values.

How To: Jailbreak an iPhone 2G/3G on 3.0 firmware with redsn0w

This how to video will show you how to jail break the iPod Touch or iPhone to the 3.0 firmware with Redsn0w. First, download Redsn0w and the firmware. Open the file and double click the program. Click browse and navigate to the firmware. Open it and let it load. Once this is done, press next. Let the data load and then make sure Cydia is clicked. Click next and then turn off your device and plug it in. Click next and then hold the power button for 3 seconds. Without releasing the button, hold...

How To: Do dynamic range w/Excel's OFFSET function & top data

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 240th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function and a named formula when new records are added at the top instead of the bottom.

How To: Use an OFFSET as a dynamic range in an Excel VLOOKUP

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 158th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP function to retrieve data and the OFFSET function to look at just part of the desired table.

How To: Update your iPod Touch to the 3.0 firmware

1.First download correct firmware for the iPhone or iPod Touch. And change the dot extension of the file before that open the explorer and select Tools menu then go to Folder options, open view tab and deselect "Hide extension for known file types" option and click ok.2.Now right click on the file and click rename and change the extension as ".ipsw". Now open the iTunes and make sure the iPhone is connected with the data cable to the system. Now press down the home and power button of the iPh...

How To: Use Excel for daily interest and monthly deposits

Some savings plan pays interest 365 days in a year but you make deposit monthly. You can use Excel functions to calculate the maturity value of the of the monthly plan. To do this you have to use the nominal and effect functions before using the future value functions. First enter the know data like the monthly payment, the number of years of payment, the number of days in a year, and the annual percentage rate. First take the nominal rate and calculate the effective rate with the help of eff...

How To: Create a simple line chart in Excel 2007

Namuoc demonstrates how to create a line chart in Excel. To create a simple line chart in Excel 2007, first highlight the cells in your worksheet that you would like to include in the chart. Then, select the insert tab on the top of the worksheet toolbar. Next, click on the line option. Select the two dimensional line graph option from the given choices. Move the chart to a new sheet. Label the new sheet in the appropriate field and click the OK button. Your line chart will now be created usi...

How To: Use clip on bangs

In this video, we learn how to use the new clip-in bangs created by Hairdo. These bangs are made of synthetic fiber and will mix right into your hair, there are several colors available so you can match the piece to your existing hair color easily. The piece has three clips, one on top and two on the side that will slide right into your own hair without causing any damage. All you have to do is clip the hair in and make sure it's secured. Once you you've done this, you can clip them and style...

How To: Encrypt batch files with variables

Encryption is the process of converting you data in to other obscure form so that no one can read it. Encryption can also be done using batch files. Batch files are scripting programs in windows which can be used to program small automatic operations. To do this open a notepad to write the batch program. First turn of the echo by inserting the command '@echo off'. Now write the rest of the program as shown in the video. Now save the image as a bat file. Now you can encrypt this batch file. To...

How To: Protect your plants from frost

An associate from Garden Years discusses the danger frost poses to small, outdoor plants. Since you don't have a lot of control over the weather, there are a few tips you can follow to try an avoid any unwanted damage to existing plants. The host examines a peach tree to identify when a plant is blooming and thus very delicate. If a plant is fully blooming, then any temperature below freezing (32 f) can damage the blossoms. Aside from putting cloth over the plant, mulch is also very helpful i...

How To: Do the master reset on the iPhone 3G

If your iPhone has frozen and you're not sure why you're in luck because there is a way to reset it. The first thing you're going to want to do is load up iTunes do a normal reset but don't turn it back on, then plug your iPhone into the connector for your computer but don't actually connect it to the computer yet. Hold down the home button then while holding it plug the connector into the computer. While still holding the home button and have plugged in the connector wait for your iTunes to ...

How To: Track Google's trends features

In this Computers & Programming video tutorial you will learn how to track Google's trends features. This will help you find some powerful micro niches and great keywords to create content and get top rankings in search engines. Any trend on the internet first starts with an event. For example ‘mega millions’ gets lot of traffic when someone wins a jackpot or a big lottery draw is coming up. Similarly, ‘July 4th’ traffic spikes around that event and dies down. If you want traffic from this ev...

How To: Reset an iPod Touch

This video is about how to reset your iPod. The first thing that you will need to do is to make sure your iPod is turned on. Then the next step that you have to do is to hold down the sleep or off button and the home button at the same time until the screen changes. Then an image of a CD and the charger appears. Make sure that your iTunes is on your screen. Then the next step is to click on your iPod on the devices area. Once you have clicked on the iPod on the devices area, just simply click...