Format Relies Search Results

How To: Use conditional formatting in Microsoft 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. In this MS Excel video tutorial, you'll learn about using conditional formatting in Excel to change background color. To get started learning about conditional formatting, watch this MS Office how-to.

How To: Format spreadsheets in 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. In this Excel tutorial, you'll learn about simple formatting, background colour, gridlines, alignment. For more information on formatting spreadsheets within MS Excel, watch this helpful how-to.

How To: Use TEXT & custom number formatting in Microsoft Excel

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 270000000000000000000000000000000th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use custom number formatting for cells and the TEXT function. Specifically, this lesson covers the following:

How To: Format a secondary hard drive in Windows Vista or 7

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...

How To: Make a sniper rifle for a Lego minifigure

Has your Lego arsenal grown stagnant relying on the supply of weapons offered it by the Lego corporation? Take matters into your own hands. This video features detailed instructions for building a sniper rifle out of Lego blocks that one of your Lego minifigures can hold. This will make this piece a deadly force on the Lego battlefield.

How To: Make a simple clay and ash glaze

This method of making glaze utilizes environmental supplies. That way there's no need to rely on a clay supply store, so it's great to save money or time if it's a distance to the nearest supplier. Watch this video pottery tutorial and learn how to make a simple ceramic glaze for firing out of clay remnants and wood ash. It's appropriate for use on raw glazing projects as well.

How To: Process large-format sheet film in trays

In the digital age, old fashioned film processing and developing may seem outmoded and obsolete. However, for professional and aspiring professional photographer who want o make classic-looking prints, this is far from the case. This three-part video describes how to do tray processing yourself for large-format sheets. It breaks down the equipment you will need, the advantages and disadvantages, and of course how to go about processing you own film sheets. The dark room is back!

How To: Conditionally format dates & weekends 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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply custom number formatting as well as how to conditionally format dates and weekends using a TRUE FALSE formula with the AND and WEEKDAY functions.

How To: Write a resume in the table format

In this video tutorial, viewers learn how write a resume in the table format. A table formatted resume is one of the most effective formats. It highlights metrics in a particular field that potential employers are looking for in a presentable quick overview. At the top of the table, provide your name, contact information and location. In the table, list your skill, experience, role and products from each of your previous jobs and experiences. This video will benefit those viewers who are sear...

How To: Format dynamic text in Flash

Todd Perkins shows us how to format text using action script in Flash. By understanding how to format text this way, it allows us stylize text in a text field. Perkins goes through each step in Flash on how to use an external file that will be formatted using the software program. He goes through the various codes necessary to create dynamic text. If you want to learn how to format dynamic text in Flash, follow this tutorial from Todd Perkins.

How To: Use Excel percentage number format

This video tutorial will teach you how to format percentage numbers in MS Excel. Excel is a spreadsheet application that allows you to use calculations, graphs, pivot tables and much more to create the spreadsheet you want. You can learn how to avoid common mistakes that occur with formatting percentages and how to set the program to automatically format numbers as you type. This video will guide you through formatting percentages as you learn how to use MS Excel to make spreadsheets.

How To: Format a hard drive using Windows Vista

Formatting the hard drive on Windows Vista is easy. First click Start, then Control Panel, Administrative Tools, Computer Management. When that opens up, click Storage Disk Management. This will open a window showing all the computer's partitions. It isn't possible to format C: because that is where the operating system is installed. We will format disk 2. Right click on that, and select New Simple Volume. This will open the wizard. Follow the prompts through the wizard to Finish. The compute...

How To: Export PDF files to Office formats in Acrobat 9 Pro

In this Adobe Acrobat tutorial the instructor shows how to export PDF files to other office formats. He shows how to do this with a live example. He chooses the file menu and from there goes to the export sub menu and shows all the different file format options that are available for exporting. For demonstration purposes he saves the current PDF in Microsoft Word format. He opens the converted file and shows the results of conversion. This video demonstrates the features of Adobe Acrobat 9 to...

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: Play a game of marble solitaire

During this day and age of video games and HD televisions, more kids are relying on electronics to keep them entertained. But, for many people who grew up without such things, simple board games like chess, checkers, and even Monopoly was all they needed. Another great game was marble solitaire. It was easy to play and took some strategy to win. So in this tutorial find out how to play a game of marble solitaire. You'll enjoy it and so may your friends and loved ones.

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: Count from 0 to 20 in Finnish

Finnish is an unusual language, which can make it tricky for foreigners to learn. Instead of relying on a book, the Learn Finnish video language-learning tutorial series shows a photograph of a vocabulary term while pronouncing the word in Finnish. This technique allows the student to associate the object itself, rather than the term in their native tongue, will the Finnish word, thus allowing for maximum comprehension and absorption. In this video segment, numbers, or "numerot" in Finnish, f...

How To: Count from 10-100 in Finnish

Finnish is an unusual language, which can make it tricky for foreigners to learn. Instead of relying on a book, the Learn Finnish video language-learning tutorial series shows a photograph of a vocabulary term while pronouncing the word in Finnish. This technique allows the student to associate the object itself, rather than the term in their native tongue, will the Finnish word, thus allowing for maximum comprehension and absorption. In this video segment, numbers, or "numerot" in Finnish, f...

How To: Pronounce the vowels in the Finnish alphabet

Finnish is an unusual language, which can make it tricky for foreigners to learn. Instead of relying on a book, the Learn Finnish video language-learning tutorial series shows a photograph of a vocabulary term while pronouncing the word in Finnish. This technique allows the student to associate the object itself, rather than the term in their native tongue, will the Finnish word, thus allowing for maximum comprehension and absorption. In this video segment, the vowels, "vokaalit" in Finnish, ...

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: