Generate Format Search Results

How To: Create value-based formatting using data bars in Excel

See how to create value-based formatting using data bars and color scales in Excel 2007. See how to use the Format Cells dialog box and the pop-up mini-toolbar in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, w...

How To: Use the Format Cells dialog box in MS Excel 2007

See how to use the Format Cells dialog box and the pop-up mini-toolbar in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.

How To: Learn the most useful Excel 2007 formatting shortcuts

Speed up your MS Excel workflow with these handy formatting key commands. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.

How To: Format a drive for both Mac OS X and Microsoft Windows

Have an external hard drive that you'd like to use with both an Apple computer and a Microsoft Windows PC? With the FAT32 file format, it can be done! And this home computing how-to from the folks at CNET TV will show you how. For more information, including detailed instructions, and to get started sharing your own HDs between Mac and Windows computers, watch this free video tutorial.

How To: Format every nth value in Excel with MOD & ROW

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 467th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting every nth value using the SUMPRODUCT, MOD and ROW functions.

How To: Conditionally format odd & even numbers 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 370th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to even and odd numbers using a TRUE/FALSE formula with the MOD function.

How To: Clear formatting from a cell 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 7th installment in their series of digital spreadsheet magic tricks, you'll learn how to remove the formatting from a given Excel cell without erasing the cell content!

How To: Open/copy/save files & create folders in MS Word 2007

When you're using MS Word you should be able to see a large Microsoft office icon in the top-left icon. Clicking it opens up a menu where you should be able to see the save button. Pressing this button will save your work or overwrite a previous copy. If you press 'save as' instead, you will have the option to change what format the file is saved as and what name it is saved under so as not to overwrite the existing copy. When you've decided on the name and format and where to save, just pres...

How To: Create visually stunning compositions from 3D renders in After Effects

Compositing and color correction are important and integral steps in processing a 3D render after it is generated in Cinema 4D, 3D Studio Max or any other 3D package. Compositing transforms simple renders and provides them with life, vibrancy and atmosphere. In this demonstration, Greyscale Gorilla breaks down a 5 second project from Rich Hinchcliffe and demonstrates how Rich uses Adobe After Effects, color correction, blurs, ReelSmart Motion BLur, Frischluft Lens Care and Lens Flares to tran...

How To: Apply formatting to text in Adobe Flash Professional CS5

Need help figuring out how to format text within Flash CS5? It's easy! And this clip will show you how it's done. Whether you're new to Adobe's popular Flash-development platform or a seasoned web developer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, and to get started making your own Flash-based twinkling starscapes, watch this video guide.

How To: Format an SD card

Is your SD memory card getting a little too full? Is it not working? Try reformatting it. It's the first and sometimes last step to troubleshooting card problems. So, if your SD card has become too cluttered, this guide will restore it to a like-new condition with a simple format.

How To: Generate 3D text in Adobe Photoshop CS4

Looking for an easy way to create 3D text logos? With Adobe Photoshop, the process is simple. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from the folks at IT Stuff TV. For more information, including step-by-step instructions on how to generate your own 3D text headers, watch this graphic designer's guide.

How To: Randomly generate letters in an Excel spreadsheet

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 18th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROW, CHAR and RANDBETWEEN functions to randomly generate letters. See also how to randomly create letter sequences.

How To: Get a nice, even stain on wood

You will learn how to get a nice, even stain on wood in this Home and Garden video tutorial brought to you by TheSoapGuy. It’s really easy and simple to do. Get a finished piece of wood. You should work in a well ventilated area because wood stain generates a lot of fumes. Wood stain comes in aerosol spray and in cans. Mix the stain in the can by rolling the can. Don’t shake it, it will generate bubbles. Open the can and apply the wood stain with a brush evenly on the surface. The more coats ...

Exploit Development: How to Read & Write to a Program's Memory Using a Format String Vulnerability

Format strings are a handy way for programmers to whip up a string from several variables. They are designed to save the programmer time and allow their code to look much cleaner. Unbeknownst to some programmers, format strings can also be used by an attacker to compromise their entire program. In this guide, we are going to look at just how we can use a format string to exploit a running program.

How To: Insert an SD Card into a Samsung Galaxy Y

If you have an older Samsung Galaxy Y smartphone, one thing you should be doing is using an microSD or microSDHC memory card to help improve your Android's processing speed and make it easier to transfer large or small files easily. These cards are also compatible with certain cameras and can be inserted into some computers. While all this is all good and well, you'll still need to know how and where to put your SD card in order to indulge in any of these benefits. Your Samsung Galaxy Y (the ...

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!