Option Formatting Search Results

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: 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: 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: Save a 2007 Word docx. file as a 2003 Word doc. file

In Word 2007 a lot of things have been changed since word 2003. For instance the file menu is no longer present, it has been replaced by a glowing yellow button which is the office button. If you click on this button, a menu will pop up. In this menu click the save button. It'll give you the option to save your document with a docx extension. The problem with this is that a file with this kind of extension does not open in anything but Word 2007. Instead go into save as and save it as a word ...

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

How To: Use the Wubi installer for Ubuntu

This video describes basics about using Wubi installer for Ubuntu in Windows operating system.Wubi installer is usually used for Ubuntu family distribution installations.You can download Wubi installer from the Internet and then it will install all desired distribution automatically or you can run installer from CD or DVD.In this example Wubi is installed from Kubuntu live DVD.After inserting DVD into your computer's disk drive autoplay function offers to run Kubuntu installer. If you don't h...

How To: Format your PC external hard drive to work with a Mac

Thinking of switching to a Mac using an external hard disk, you'll need to format it so that the Mac can recognize it. In your Mac, go to finder, then applications. Scroll down to where it says disk utility and then select it. Here select your hard disk and press the partition button in the screen that comes up. Make two partitions and rename them to whatever you want. After that change the format of the partition to Mac OS extended. Now just press the apply button to apply the changes, be su...

How To: Get started with MLA in Word

The video demonstrates how to get started with MLA (Modern Language Association documentation format) for an article. One of the first things that is important to understand is how to name your paper, and add a header format that will automatically paginate your paper so that you do not have to worry about it. The entries in your Works Cited need to be alphabetized and also need to be indented. Note that there is no extra space between the entries. You do not have to know how to manually form...

How To: Create a data disc in Windows Vista

This video shows us how to burn files to a disc using Windows Vista. Insert the blank disc in your computer's recordable disk drive. Autoplay will automatically appear. Choose "Burn Files to disc using Windows". Click next when "Burn a disc" dialog box appears. Empty folder window appears. Choose files that you want to copy and drag them to the window. For example, if you want to copy a photo, click Start menu and open the Pictures folder. Select photos and drag them to the window. Photos are...

How To: Fill in the blanks with custom number format in Excel

This video teaches how to fill in the blanks with custom number format in Excel. Open any similar worksheet as shown in the video or type the same to use. Select all the cells in the columns E and F and press F5. Now click 'Specials', then select 'Blanks' and click 'OK'. All the blank cell will be highlighted, now enter the value and press 'Ctrl+Enter' to populate all the blank cells. Press 'Ctrl+1' to format cells, select custom if you want something to show up in the cell but not really be ...

How To: Use Excel date math & time formatting

Once you learn some of the basics, Excel is an easy program to use. With the use of some simple formulas, you can streamline your whole data entry process. Just by typing in =SUM you can set a row or column to show the sum of other entries. It really is that easy. This video will show how to use these formulas and take advantage of Excel date math and time formatting.

How To: Format a Windows XP hard drive

First, insert a bootable XP cd in your hard drive. Then the setup will start. Press "enter" to setup XP and then press F8 to accept the agreement. After that, press "enter" to setup Windows XP on unpartitioned space. After this press "Format using the NTFS file system". Then a new window will appear which will start the formatting process which will take several minutes depending upon the ram on the computer. This will help you quickstart your new PC on your own.

How To: Use SUMPRODUCT for weighted average cost in Excel

This video shows you how to calculate weighted average cost from a transactional data set using SUMPRODUCT function. It explains things very clearly. If you're working with a very large database transactions the SUMPRODUCT function makes it. It works as text if you do the formatting first and then type the number. We put the number in first and then format as text, then press F2 and ENTER.

How To: Format a cover letter in Standard Block format

This video goes over cover letter formats, specifically in Full Block Style. Cover Letters accompany resumes in job applications. They should be sent ahead of the resume. They go over your experience, desires and objectives. The cover letter is important to both employers and employees. A human resources or HR department often receives thousands of letters that it must review before granting a job candidate a job interview or even reading their resume. This is a LIAD Production for World of W...

How To: Get started using 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. This Microsoft Office video tutorial presents an extremely introduction to Excel. In it, you'll learn about names of bits and really simple formatting. To get started using Excel for yourself, take a look.

How To: Read a binary clock with the BCD format

Check out how to read a binary clock in this how to video. You'll see how to read the BCD (binary-coded decimal) format like so many can't. Just watch this if you have trouble determining the hours, minutes, or seconds on your binary clock. You can read it in standard or military time if you'd like.

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: Use Table Styles in Microsoft PowerPoint: Mac 2008

Sure, you can make boring tables inside PowerPoint 2008 for Mac, but who wants to add that dull element to their slideshow presentations? Nobody! Tables can be more than just numbers, they can be eye-catching and visually striking. The Microsoft Office for Mac team shows you just how to create great-looking tables by using Tables Styles in this how-to video.

How To: Format a USB flash drive to NTFS from FAT32 in XP

In this how to video, you will learn how to format a USB flash drive to NTFS. First, plug in the USB drive to your computer. Right click on My Computer and select properties. From here, go to the hardware tab and select device manager. Next, click and expand disk drives and right click your USB drive. Select properties and then click the policies tab. Choose optimize for performance and click okay. Edit the device manager and open My Computer. Next, right click the USB device on My Computer a...