Effectively Formatted Search Results

How To: Apply formatting to Excel cells that meet a condition

See how to apply condition formatting when working in Microsoft Excel 2007. Whether you're new to Microsoft's popular word processing application application or a seasoned MS Office professional just looking to better acquaint yourself with the Word 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the useful formatting feature in your own Excel documents, watch this free video guide.

How To: Conditionally format with MS Excel's DATEDIF function

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 271st installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting and the DATEDIF function to add formatting to a cell based on the content of a different cell.

How To: Format decimals & fractions as inches 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 235th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a custom number format for inches that will allow you to type decimals or fractions and have it formatted as inches.

How To: Format an external hard drive for Mac OS X

The World Wide Geek demonstrates how to format an external hard drive for Mac OS X. External hard drives are usually formatted for windows. To change the format, you will need to use the disk utility option. Access the disk utility by going to finder and clicking on applications. Next, click on the utilities folder. Then, click on the disk utility option to open it. You can also search for disk utility in spotlight. Select your external hard drive in the options to the left of the disk utilit...

How To: Rip CDs & convert between file types in Apple iTunes 9

iTunes lets you use a variety of file formats for ripping CDs or converting music. Learn about each one: AIFF, WAV, MP3, AAC and Apple Lossless. Decide which format might work best for your music collection with this video guide from the folks at MacMost. For more information, and to get started mastering iTunes myriad file formats yourself, watch this video guide.

How To: Convert between formats within Blender 2.4 or 2.5

This clip demonstrates how to load an image into the Blender VSE and convert its format, both in size and in format (JPG->PNG) and space savings comparison. Whether you're new to the Blender Foundation's popular 3D modeling program or a seasoned graphic artist just interested in better acquainting yourself with the application, you're sure to be well served by this free video tutorial. For more information, including detailed instructions, take a look!

How To: Format a memory card with a Panasonic G1 or GH1 camera

Learn how to format a SD memory card using a Panasonic G1 or GH1 digital camera. Whether you're the proud owner of a Panasonic Lumix DMC-G1 or DMC-GH1 micro four thirds digital camera or perhaps just considering picking one up, you're sure to like this free video tutorial, which presents a complete overview of how to format a memory card when it's in a G1 or GH1 camera. For more information, including detailed instructions, watch this digital camera user's guide.

How To: Use custom number formatting with zeroes in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 73rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add custom number formatting in the format cells dialog box for 00001, 09745 and 989-85-1253. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Convert audio file formats using iTunes

In this video, learn how to convert audio file formats using iTunes. Changing file formats will come in handy if using two media players, or using audio software programs such as Final Cut Pro. Changing an audio files type is very easy in iTunes and made even easier with the help of this video!

How To: Solve algebraic equations with the y = mx+b format

This video shows us how to solve algebraic equations with the y = mx+b format. When talking about solving y=mx+b format, it’s about solving linear equations so that y is on one side and with some terms x on the other side. Here in this equation 'm' is actually the slope of the line and slope= (rise/run) and it is interrupted with the term 'b'. This can be explained by taking an example of the same format. In the example 2x+3y=9, we need to shift the term '2x' to the other side so that the equ...

How To: Format and use the ROUND function in Microsoft Excel

Adding formatting to plain Excel spreadsheet is a wonderful way of increasing the readability and improving the overall look and feel of your data. With this software how-to from ExcelIsFun, you'll learn all about using the Microsoft Office program's formatting features. As an added bonus, you'll learn about the ROUND function, which is also useful for cleaning up charts where great precision isn't required.

How To: Format your computer

Watch this video to learn how to format your computer properly. It's not as hard as you think. All you need is your startup CD. This video will work for Windows XP. Just follow the simple steps, and you'll be well on your well to a properly formatted computer that runs smoothly. For more videos on computers, search WonderHowTo for computers.

How To: Build an Air Collada Papervision3D viewer in Flex 3

If you work with the Adobe Air Collada format a lot, and have certain formats you want to bring into Collada and into Papervision through that Collada file format, you'll need to compare Collada files and graphics, which requires that you createa viewer. This video tutorial offers instructions on doing just that. For more information, and to get started making your own Collada Papervision3D viewer in Flex 3, take a look!

How To: Fix other people's Microsoft Excel spreadsheets

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 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:

How To: Format the X and Y axes in Excel

This video is about formatting the charts in Excel especially the x and y axes. The video begins by selecting a chart and right clicking the dates at the bottom of the data points. The format axis window pops up and by making changes to the style, color and the weight of lines given in the patterns tab, you can change the way the x-axis looks like. You can also change appearance of characters appearing close to the x-axis by selecting options in the font menu. You can also change the format o...

How To: Format tables in MS Word 2007

In this video the instructor shows how to format tables in Microsoft Word 2007. To know how to format tables in Word, you will first have to know how to create them. This video assumes that you already know how to create tables. When you click inside a table in Word, a new tab label, Table Tools, appears above the Design tab in the tool bar. In the Design tab there are a lot of options available that can change the look of your table with just a click. To the extreme left there are three chec...

How To: Format a memory card using a card reader and a Windows PC

Sometimes it's necessary to format your memory card in your mobile phone or digital camera, just like you need to format a hard drive, because of virus problems or slower speeds. This video will show you the steps to formatting (or reformatting) the SD memory card for a cell phone, using a memory card reader. You'll also get details about a write protect error that could happen.

How To: Use the Format Painter tool in Microsoft Word

If you use Microsoft Word quite a bit and have never used the Format Painter tool, it's a technique you need to learn, and learn today, because it's a technique that will save you a lot of time and a lot of grief in the future. To learn how to use the Format Tool in Microsoft Office Word documents to streamline the formatting process, watch this how-to.

How To: Install Windows XP from a usb flash disk drive

This video tutorial is in the Computers & Programming category which will show you how to install Windows XP from a USB flash disk drive. First download USB multiboot from 911cd. Insert the XP disk and plug in the USB flash disk into your PC. Format the USB flash disk. For this click on "RMPrepUSB" and the HP format tool should pop up. Do a quick format to USB drive with ntfs file system. Close HP format tool and click go. Now you have a Windows XP bootable USB flash disk drive.

How To: Rip DVDs in Mac OS X with Handbrake

Movie DVD that you buy are large in size. So you may need to convert the movie to other smaller formats to store them in your computer or other back up disks. This process of extraction the movie from the DVD into another format is called as ripping. To do this you can use one of the various DVD ripping software available. HandBrake is one of such software which can be used to rip and encode DVD movies into other formats. Its supports a large number of formats which are compatible with iPod, ...

How To: Use Excel round function & number formatting

In this video the instructor shows how to use the Round function and also format numbers in Microsoft Excel. Normally while calculating formulas in Excel, the formatting of numbers can get you into a lot of trouble and to get around this problem you need to use the Round function. To do this take some sample data in a Excel work book and apply any formula that you want on the data to arrive at some calculation. Now because of this formatting some times you can arrive at a wrong result as show...

How To: Use Excel stylistic & number formatting

Learn how to use Excel stylistic and number formatting by watching this video. You'll learn how to format a cell. These have different types of formats like general, time, date, etc. You'll also learn how to create a table. There are different types like names, values, time and time etc. Learn to create names like employee name and fill in the borders, and create thick lines. Watch this video for more information!

How To: Format a CSS website

Being organized and using good formatting in your CSS files can save you lots of time and frustration during your development process and especially during troubleshooting. The multi-line format makes it easy to browse attributes but makes your file vertically very long. The single-line format keeps your file vertically short which is nice for browsing selectors, but it's harder to browse attributes. You can also choose how you want to group your CSS website statements. Do you do it by sectio...

How To: Read an epub-format digital book on your iPad

This tutorial will work on any Apple device running iOS 4. Besides finding books through the Apple store, you can also find unlocked epub-format books (such as through Google Books or the Gutenberg Project) and use the iBooks application to read them on your iPad, iPod Touch or iPhone. Even customize your covers!

How To: Set up and format papers in MLA style in Microsoft Word

Research papers, love them, hate them, either way, the standard for writing them are a pain in the butt if you haven't done it a lot, or at all, before. The standard is MLA style, and if you have no idea what this is or how to set up the settings in Microsoft Word, this video has everything you're looking for. You will learn how to set up the page for MLA style, add in works cited properly, page titles, and more.

How To: Convert an ebook file to ePub format in Mac OS X

If you use iBooks on your iPad or iPhone, you can only read books in EPUB format. If you have books in text or PDF format you may want to convert them to EPUB so you can read them in iBooks. You can do this with Calibre, a free open-source e-book library application. It's easy! So easy, in fact, that this home-computing how-to from MacMost can present a full overview of the process in about five minutes. For more information, including detailed, step-by-step instructions, watch this Apple lov...

How To: Delete only cell content or formatting 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 575th installment in their series of digital spreadsheet magic tricks, you'll learn how to selectively delete. Specifically, you'll se how to delete the cell contents only, formatting only, the entire cell, or formatting and content together.

How To: Format field names 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 378th installment in their series of digital spreadsheet magic tricks, you'll learn how to format field names. If field names have formatting, Excel understands that they are field names and should not be used as data.

How To: Convert songs and videos to iPod format

Like it or not, Apple rules the world right now. Well, at least the electronic gadget world. Every single person and his or her mother has some sort of i-device: iPhone, iPod, iPad. So don't go iBroke the next time you want to add more songs to your iPhone or iPod by transferring all of your media files into iTunes readable formats.