Downloadable Formats Search Results

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: Use the Toolbox in Microsoft Office: Mac 2008

The Toolbox in Office 2008 for Mac is more than just a simple formatting palette. There's so much you can do, so much you accomplish, but you need to know how to take advantage of everything offered in the Office Toolbox, whether in PowerPoint, Entourage, Word, or Excel. The Microsoft Office for Mac team shows you just how to format, insert, research, and clip with the Toolbox in this how-to video. Check out all of the things it can do!

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