Generate Format Search Results

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: Randomly generate whole numbers 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 17th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the RANDBETWEEN function to randomly generate whole numbers as well as how to randomly assign numbers to employees.

How To: Generate a dynamic list from a table in MS Excel

New to 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 Excel tutorial from ExcelIsFun, the 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...

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: 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 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: Generate realistic clouds with the GIMP image editor

In need of a sunny, blue sky? Generate one in GIMP! Whether you're new to the GNU Image Manipulation Program, GNU's popular free graphics editor, or a seasoned designer just looking to pick up a few new tips and tricks, you're certain to enjoy this free video software tutorial. For more information, including detailed, step-by-step instructions, and to get started making realistic clouds in GIMP yourself, take a look.

How To: Randomly generate 1s, 0s & blanks with Excel's CHOOSE

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 392nd installment in their series of digital spreadsheet magic tricks, you'll learn how to randomly generate 1, 0 and blank values with the CHOOSE, RAND, RANDBETWEEN and INT functions.

How To: Generate random letters without RANDBETWEEN 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 385th installment in their series of digital spreadsheet magic tricks, you'll learn how to generate random letters without RANDBETWEEN function using the formula =CHAR(65+INT(RAND()*26)).

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: Quickly generate PHP code templates with Flash Builder 4 Data Wizard

In this clip, you'll learn how to quickly generate templates with Flash Builder 4 Data Wizard. 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: Prove that the areas of diagonal-generated triangles are equal in geometry

From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to demonstrate that a diagonal line drawn from one corner of a rectangle to another will generate two equivalent triangles.

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.