Option Formatting Search Results

How To: Use VLOOKUP across worksheets in MS Excel 2007

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 VLOOKUP in one worksheet to look up values located in a second worksheet. For more on using VLOOKUP across Excel worksheets, watch this MS Office how-to.

How To: Use VLOOKUP in Microsoft Office Excel 2007

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 VLOOKUP to look up values located in a table. To learn more about VLOOKUP, watch this MS Office Excel how-to.

How To: Use nested IF statements 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 MS Excel video tutorial, you'll learn about using nested IF functions to calculate a grade from an average mark. For more information on using conditional statements, watch this MS Excel how-to.

How To: Use absolute ($) cell referencing in 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 '$' to prevent excel from changing formulae when copying or filling ranges. For more on absolute cell referencing, watch this Microsoft Excel how-to.

How To: Calculate averages 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 MS Excel video tutorial, you'll learn about using Excel to calculate average values and to pick max and min values. For more on this handy feature of Excel, watch this how-to.

How To: Use simple formulae 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 MS Excel video tutorial, you'll learn about simple addition, subtraction, multiplication and division in Excel. For more on using simple formulae, watch this video how-to.

How To: Use the image processor in Photoshop CS3

This image editing software tutorial shows you how to use the image processor tool in Photoshop CS3 to convert your corrected RAW files to a format more suited for printing or retouching; jpeg and Tiff. The image processor is can be used in the Bridge as well as in Photoshop and allows you to convert multiple files at once. See how in this Photoshop CS3 tutorial.

How To: Export a Keynote presentation in multiple formats

If you travel a lot for work and give presentations, you know that, sometimes, you're forced to use another person's computer system. And sometimes your Keynote presentation just doesn't look right. In this video tutorial from Apple, you'll learn how to save a Keynote presentation so you can assure that the look and feel is consistent across platforms.

How To: Share Keynote presentations in OS X

Keynote allows you to make some amazing and creative presentations, but were you aware it allows you to share said presentations just as creatively? In this video, you'll learn to take full advantage of Keynote's export feature, which will permit you to save your work in a wide variety of formats. For more, watch this OS X video tutorial.

How To: Shoot panoramic photographs

Watch this instructional photography video on how to shoot Panoramic photographs with What Digital Camera Magazine. Panoramic photography is a format of photography that creates images with exceptionally wide fields of view. You don't have to use a tripod but it's much easier than eye balling it while taking a series of photos of the landscape, and you won't have to crop as much.

How To: Install Ubuntu in Windows with Wubi

If you're interested in trying out Linux but afraid of accidentally formatting your hard drive, take heart. In this tutorial, Linux Journal Gadget Guy, Shawn Powers, takes you through installing Ubuntu on a machine running Windows with the Wubi installer. Install and uninstall Linux as if it were a Windows application with this how-to.

How To: Use Word Viewer to open or print documents

Even if you don't have Microsoft Office Word 2007, you can open Word documents with Word Viewer. In this instructional video, a Microsoft employee shows how you and your coworkers can download Word Viewer and the Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats. With these 2 downloads, you can open, print, or copy and paste from Word documents without having to install Word on your computer.

How To: Add pictures to a document from a scan in Word 2007

If you're baffled about how to get your own photographs into your Microsoft Office Word 2007 documents, watch this instructional video. A Microsoft employee who uses Word himself shows you how to insert your picture or digital photo into a document and format it the way you want. He addresses questions about terms like "inline" and "floating," and explains how easy it is to set up a watermark.

How To: Organize and gather information in OneNote

STake a look at this instructional video and learn how to organize and gather information with OneNote 2007 from Microsoft. Microsoft Office OneNote 2007 is an easy-to-use note-taking and information-management program where you can capture ideas and information in electronic form. Insert files or Web content in full-color, searchable format or as icons that you can click to access.

How To: Create a custom user control in ASP.Net

In this video tutorial, Chris Pels will demonstrate how to create a custom user control in ASP.NET that can be used throughout a web site or across many web sites. Start out by learning the basics of creating a user control that will be used in multiple pages including validation, controlling formatting using style elements, and loading/saving data for the user interface elements. Throughout the video considerations for building user controls that can be easily maintained and used across mult...

How To: Use VLC free media player

Learn the basics of VLC player - a free media player that plays almost all video formats (including Flash .flv) as well as DVDs. Learn how to use VLC player to play videos and DVDs as well as how to adjust the aspect ratio, filter videos, or adjust audio quality.

How To: Convert between DOC and PDF file formats with doPDF

In this video tutorial, viewers learn how to convert word documents to PDF format. This task is very easy, simple and fast to do. Users will need to download a program from this site: DoPDF. Once downloaded and installed, open the program and open the file that you want to convert. Then click on File and select Print. Choose the printer name as "doPDF" and click OK. When a window pops up, select the location where you want to save the file. This video will benefit those viewers who have a tex...

How To: Make a bootable ISO file/disc

The video is about making a ISO file or a disc.To enable this you must have ISO installed on your system.The video begins by opening the Image burn setup wizard file.Once you have opened it , keep clicking next until you are finished with the installation. Then you have to insert a blank CD into the drive. Once you have done that a window will pop open displaying options for the CD.Click on the mode option in the window and select ec mode and then click on the first option displayed which is ...

How To: Convert AVI files to DVD format with Xilisoft

In this how to video, you will learn how to convert an AVI file to a DVD with Xilisoft. First, you will need to download the Xilisoft AVI to DVD Converter. Next, click the add video files icon on the left and select the AVI file that you want to convert. Select it and click open. Next, change the destination so that it is saved as an ISO file. Enter the new name of the file and click save. Click start burn on the right side. Now your AVI will be converted to DVD format. Once it is finished, y...

How To: Download and install the Handbrake DVD ripping tool

This video tutorial from dproxisback presents how to download and install Handbrake DVD ripping tool.To avoid installation problems, carefully choose application version for each type of computer and operating system.Open your internet browser and visit http://handbrake.fr/?article=download web page.Choose correct version for your type of operating system (MacOS, Linux, Windows).Download and install the application. Run Handbrake once it's installed.Click File-Select Source. Browse for your f...

How To: Design a professional looking resume

In this video, groddin99 describes the correct way to write a resume and fashion a cover letter. Groddin99 knows the importance of a clean and formatted resume, and he gives advice and tips on formatting your resume properly, and how to list your previous jobs and your skill set. He also explains how inappropriate it is to draw pictures on the margins of the paper your resume is printed on. Groddin99 has written many books on this subject, and with his tips, you can write and fashion an attra...

How To: Prepare for a clean isntallation of Windows XP

This video demonstrates how to reformat a hard drive and perform a clean installation of Windows XP operating system. The tutor first advises to make a back up of everything, including the drivers and my folders. He explains various methods by which one can take the backup of the data in a system. Now he shows how to format the C drive where you can now install Windows. He also shows software that is used to take the backup of important data before formatting. This video shows how to reformat...

How To: Undelete and recover your files

In this Labrats video tutorial the instructors Andy Walker and Seab Carruthers show how to undelete the deleted files and recover them. When you save data to your computer, the computer stores the data in the binary format on the hard disk. To keep track of the files, the Operating System maintains a file table that shows the location of the data on the hard disk for a specific file. There are many file formats like FAT, NTFS etc. So when you are erasing the file only the entry in the file ta...