Audio Formats Search Results

How To: Convert MySQL timestamps to the "ago" format

In this clip, you'll learn how to adjust timestamps from a MySQL database to the ago format (e.g., minutes ago, hours ago or days ago). Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look

How To: Use disk utility to format Mac drives

Gary teaches us how to use disk utility to format Mac drives in this tutorial. First, go to your utility folder in your applications folder. Now, look for all the drives connected to your computer. A disk is a physical drive and the volume is a hard disk on your machine. You can partition this to two volumes by selecting the drive and clicking "erase". Now, select the latest version of the Mac format and then choose a name. Click erase, and now a new volume will be created on your computer. I...

How To: Use CutePDF to read and create PDFs

In this video tutorial, viewers learn how to use and create portable document formats for free. This task is very fast, easy and simple to do. Users will need to download the CutePDF program provided in the video. Once downloaded and installed, the program will essentially create another printer driver in the system, allowing users to print files in the portable document format. This video will benefit those viewers who create text documents, and would like to learn how to create portable doc...

How To: Cite a webpage in APA format

When writing a school paper, many times if you use a reference, you'll need to cite it correctly. There are a couple of ways to do this and in different formats, but in this tutorial, you'll find out how to do it using the APA format. This tutorial will help you cite a webpage. It may sound like a difficult job, but it's easy to do and will make a difference in your grade. Enjoy!

How To: Change an Excel table's conditional formatting with DV

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 43rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use a data validation drop-down list to change conditional formatting in a table. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Fix poorly set up data in Microsoft 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 507th installment in their series of digital spreadsheet magic tricks, you'll learn how to take badly setup data (not in database/table format) and summarize it by date and shipping name into table format report.

How To: Conditionally format a bar chart in Microsoft 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 566th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF functions and a bar chart to create a conditionally formatted chart for students scores that exceed a given hurdle.

How To: Open/extract Winrar or Winzip & open a new text doc

Learn how to extract .rar or .zip file formats on a Windows computer. These file formats are often used to package larger files into files that take up less memory space. First, a new folder is created to house the extracted file, and the file is dragged inside. Next, the user must right-click on the .rar file to be extracted and select the "Extract Here" option from the dropdown menu. In addition, this video will also show helpful sites from which to download the WinRar or WinZip programs, w...

How To: Create a partition & format an external hard drive

This video teaches us to partition a hard drive. Open 'Disk Utility' and go to 'Seagate FreeAgent Media'. Go to 'Partitions' and select '2 partitions' in the 'Volume Scheme'. Click on 'Untitled 1' and put the name of the partition, its format as Mac OS Extended (journaled) and Partition Table from 'Options'. Name the second partition and choose 'MS DOS (FAT)' in format. Choose 'Master Boot Record' in 'Options'. Click 'Apply' and 'Partition'. This creates the two partitions of the hard drive a...

How To: Change/convert a pivot animation into an AVI video

In this video tutorial, viewers learn how to change/convert a pivot animation into an AVI video format. Begin by loading the animation in the Pivot program. Now click on File and select the Save as type to Animated gif. Nam the file and click on Save. Then open Windows Movie Maker and add the pivot animation into the time line. click on Publish Movie and select This Computer. Name the file and select the save location. Click on More Settings and select DV-AVI (PAL) and click on Publish. This ...

How To: Conditionally format an Excel column-row intersection

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 296th installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting to a row, a column and the intersection of the two with three different colors.

How To: Use text field form validation in Dreamweaver CS4

Here the New Boston shows you some tips about using the Spry Validation Text Field. To begin you will go to the Spry Validation Text Field, on Dreamweaver CS4. Looking at the bottom of the page notice the various options that are available for Properties. You find drop-down boxes for Type, Pattern, Minimum or Maximum values, Required, Enforce pattern, Format, Validate on, Blur or Change and Preview States. You can see the types of text available for validating by left mouse clicking the Type ...

How To: Apply conditional formatting to a calendar in 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 98th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a TRUE/FALSE formula and the TODAY function to format a calendar within a two-week period.

How To: Prepare a USB flash drive for your Xbox 360 memory unit

Have you ever wondered how to prepare a USB drive to flash an Xbox 360? Here is the how-to -video on how to create an USB drive for flashing your Xbox 360 benq drive. To make a bootable flash drive and to prepare it to flash XBox benq drive you have to download the “Xbox benq flashing files for USB” folder from the below mentioned link.http://www.MegaShare.com/1721713

How To: Convert .docx format files to .doc in Microsoft Office

In this how-to video, you will learn how to convert a file from .docx to .doc. First, go to the Microsoft Office website and install the Open XML Converter program. Open the program. Navigate to the file you want to convert. Drag the file into the program. The program will convert the file to a .rtf file. Microsoft Word will open the document. The file will be saved in the same folder as the original document. You will be able to use files created in the latest version of Office in older vers...

How To: Sync songs with PowerPoint

Microsoft PowerPoint is used to create presentations. These presentation can contain images and animations. You can even add sound to the presentation. To do this go to the insert and select movies and sounds. Select the sound file from it. Make sure that the file inserted is in .wma format. Go to the slide show and select custom animation. Right click the song in the animations window. Under the effect option in the effect tab, there is the stop playing partition. Select the number of slides...

How To: Format your PC external hard drive to work with a Mac

Thinking of switching to a Mac using an external hard disk, you'll need to format it so that the Mac can recognize it. In your Mac, go to finder, then applications. Scroll down to where it says disk utility and then select it. Here select your hard disk and press the partition button in the screen that comes up. Make two partitions and rename them to whatever you want. After that change the format of the partition to Mac OS extended. Now just press the apply button to apply the changes, be su...

How To: Get started with MLA in Word

The video demonstrates how to get started with MLA (Modern Language Association documentation format) for an article. One of the first things that is important to understand is how to name your paper, and add a header format that will automatically paginate your paper so that you do not have to worry about it. The entries in your Works Cited need to be alphabetized and also need to be indented. Note that there is no extra space between the entries. You do not have to know how to manually form...

How To: Fill in the blanks with custom number format in Excel

This video teaches how to fill in the blanks with custom number format in Excel. Open any similar worksheet as shown in the video or type the same to use. Select all the cells in the columns E and F and press F5. Now click 'Specials', then select 'Blanks' and click 'OK'. All the blank cell will be highlighted, now enter the value and press 'Ctrl+Enter' to populate all the blank cells. Press 'Ctrl+1' to format cells, select custom if you want something to show up in the cell but not really be ...

How To: Use Excel date math & time formatting

Once you learn some of the basics, Excel is an easy program to use. With the use of some simple formulas, you can streamline your whole data entry process. Just by typing in =SUM you can set a row or column to show the sum of other entries. It really is that easy. This video will show how to use these formulas and take advantage of Excel date math and time formatting.

How To: Format a Windows XP hard drive

First, insert a bootable XP cd in your hard drive. Then the setup will start. Press "enter" to setup XP and then press F8 to accept the agreement. After that, press "enter" to setup Windows XP on unpartitioned space. After this press "Format using the NTFS file system". Then a new window will appear which will start the formatting process which will take several minutes depending upon the ram on the computer. This will help you quickstart your new PC on your own.

How To: Use SUMPRODUCT for weighted average cost in Excel

This video shows you how to calculate weighted average cost from a transactional data set using SUMPRODUCT function. It explains things very clearly. If you're working with a very large database transactions the SUMPRODUCT function makes it. It works as text if you do the formatting first and then type the number. We put the number in first and then format as text, then press F2 and ENTER.

How To: Format a cover letter in Standard Block format

This video goes over cover letter formats, specifically in Full Block Style. Cover Letters accompany resumes in job applications. They should be sent ahead of the resume. They go over your experience, desires and objectives. The cover letter is important to both employers and employees. A human resources or HR department often receives thousands of letters that it must review before granting a job candidate a job interview or even reading their resume. This is a LIAD Production for World of W...

How To: Get started using Microsoft Office Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. This Microsoft Office video tutorial presents an extremely introduction to Excel. In it, you'll learn about names of bits and really simple formatting. To get started using Excel for yourself, take a look.

How To: Read a binary clock with the BCD format

Check out how to read a binary clock in this how to video. You'll see how to read the BCD (binary-coded decimal) format like so many can't. Just watch this if you have trouble determining the hours, minutes, or seconds on your binary clock. You can read it in standard or military time if you'd like.