Option Formatting Search Results

How To: Partition an external hard drive on a Macintosh

In this video tutorial, viewers learn how to partition an external hard drive on a Mac computer. Begin by open Macintosh HD. Scroll down the list on the left and click on Applications. Double-click on Utilities and select Disk Utility. Under Volume Schemes, select 2 Partitions. Select the name of the partition and choose the format that you want for the drive. Select the second partition and do the same. Now click on Apply and click on Partition. This video will benefit those viewers who use ...

How To: Find & replace all instances of a word/number 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 160th installment in their series of digital spreadsheet magic tricks, you'll learn how to find all the occurrences of a word, number, format or formula and then change or replace all of them! See how to use the Find and Replace feature in Excel with this free video tutorial.

How To: Create a daily Gantt Chart in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this two-part Excel tutorial from ExcelIsFun, the 564th installment in their series of Excel magic tricks, you'll learn how to create a cell chart using conditional formatting with Logical TRUE FALSE formulas to create a Gantt Chart. Functions used include WORKDAY, AND, NOT, NETWORKDAY.

How To: Use ClaroRead to scan a document into Word on a Mac

Scanning is an awesome, fast way to transport a document into your computer. But, what if you want to edit it once you've scanned it? Most scanner programs will import your document as a read-only PDF or image file. With this tutorial, learn how to use the program ClaroRead on a Mac to scan your document directly into Microsoft Word for editing. This will save you a lot of time and a lot of annoying formatting and copy and pastes!

How To: Make a gradebook based on percentage scores in 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 194th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, VLOOKUP and ROUND functions to create a gradebook based on percentage scores that will calculate grade for you automatically. See also how the VLOOKUP and the percentage format can deliver the wrong grade when you dont use the ...

How To: Achieve a picture-in-picture effect in Apple iMovie

This video will show you how to take advantage of one of Apple's iMovie advanced editing feature, picture-in-picture effect. This feature allows you to embed either another video, or images into a base video. To enable this valuable tool in iMovie, go into the iMovie preferences by clicking on "iMovie" in the top left hand corner of your screen. Under the General tab make sure "Show advanced tools" is selected. Import a video from your event library by dragging it into iMovie and selecting pi...

How To: Change columns from letters to numbers in Excel 2007

Teach Excel demonstrates how to change the columns from letters to numbers in Excel 2007. The first step is to click on the Office button in the top left part of the window. Next, you click on Excel Options and click on the Formulas tab. There should be a heading labeled "Working with Formulas." The checkbox for R1C1 reference style should be unchecked by default. Check that box and click OK. This changes the column headers from letters to numbers. In order to change back to letters, simply g...

How To: Change margins in Word 2007

Mike Callahan aka Dr. Filefinder of Butterscotch explains how to adjust the margins in Microsoft Word 2007. While working on a document navigate your mouse to the 'Page Layout' tab at the top, center of the page. On the far left of the resulting page you will find 'Margins', click on that. A drop down window will display some default options that may suit your needs. If not, then click on the bottom option 'custom margins' to change the margin width to any size that you choose. You will now b...

How To: Adjust screen timeout on your Android phone

Mike Callahan will show you the tricky process of changing the screen timeout on your Android cell phone. While some people like their screen to black out right after they finish using it others prefer it to stay lit for a while. Mr. Callahan shows you how to change the setting regardless of how you like it. First tap on settings. Next, tap on sound and display. Then, you are going to want to scroll down until you get to screen time out. After selecting the screen time out option, you will ha...

How To: Configure & check the firewall in Windows 7

In this video, it demonstrate how to check and configure Windows firewall. In order to check to see if firewall is enable or not. You would click on start which locate bottom left corner of the screen. Then you would click on control panel. On this screen you would see an option for firewall, and click on it. When you click on firewall, it will let you view all the description about firewall configuration. There are also many other option which locate on the left hand side. If you are an adva...

How To: Change views & navigate documents in MS Word 2007

In this video the instructor shows how to change views in Microsoft word 2007 and navigate around the documents. In Microsoft word 2007 in the ribbon there is a view tab to the extreme right. Open the tab. Now in that bar the default layout selected is the Print Layout which is 'What you see is what you get' layout. Next to it the full screen reading option and clicking on it, the documents opens up as a two page book with all the other tool bars hidden. The next is web layout which is ideal ...

How To: Insert the current time and date in MS Word 2007

In this video you will learn how to insert the current time and date in MS Word 2007. In order to do that, just follow these easy and quick steps and instructions. The first thing you need to do is to click the Insert tab. Now, you need to select a space where your date and time will be placed. The next step is to click the Date & Time button, and select the format that you want. Click the OK button, and you are done. If you followed the simple steps correctly, then you won't have any problem...

How To: Upgrade the Pioneer MEP-7000 Firmware 2.02

Go to DJTUTOR computer where you can download the latest firmware for free. Once downloaded you need to either burn it to a CD-R or use a USB key. Unzip the file and download it to a fat formatted USB key with nothing else on it. The firmware upgrade consists of two files. Eject any disks from the MEP and remove any USBs and make sure the unit is turned off. Next insert your USB key and push and hold USB 1 and USB 2 and turn on your unit. The MEP will then tell you when the firmware is comple...

How To: Upload HD videos to YouTube

This is a tutorial video on uploading HD quality video onto YouTube. The video is simply a screen shot view of the YouTube home page. As the narrator goes through the steps the cursor moves and clicks on what you should click on. He advises to click on upload; he clicks to choose a video. The video must have a certain resolution to be assigned HD video. He indicates that YouTube will accept a variety of file formats to upload. You must use the 44.1 kHz frequency rates to get the best resoluti...

How To: Create data in a chart to graph in MS Word 2007

In this video the instructor shows how to create charts and graphs in Microsoft Word. First, open the Word document and select an area to insert the charts. Now go to the Insert tab in the ribbon and select the Chart icon. The Insert Chart window opens up with various chart templates. There are various categories of charts like Line, Pie, Bar in the left hand side. In the right hand side you can see the sample charts available and you can select any of them that you want. Now it transfers you...

How To: Create a neon style text effect in Illustrator

Adobe Illustrator enables you to add a multitude of effects to your texts. One of the options available to you is to add a neon-style effect to the text. This video tutorial will take you through the steps needed to add this effect with detailed instructions from start to finish. You will learn which menu options to employ, how to properly select your layers and which effects to apply to your text to get the neon style you are looking for.

How To: Create & composite a 3D animation for free

This video describes the process for inserting a 3D animation into a video clip. The video starts by outlining several software programs you will need to complete this project. Don't worry, the presenter gives web addresses and titles for all of the programs needed. After all software is loaded, the presenter beings inserting key frames and x, y coordinates to make the 3D animation move along the correct path. Finally, after the animation path is complete, the video shows how to render the fo...

How To: Create a YouTube subscribe button in Illustrator

In this video tutorial by Task Tutorial we learn how to create a YouTube subscribe button using Adobe Illustrator. The first step to creating a button is to select the rectangle tool and draw a bar and then select a gradient fill. Next create the first color in the gradient and then the second color in the gradient. After that you'll want to change the gradient angle and also change the stroke width. Then you'll want to edit the stroke color to 9.6%. Then select the text tool and create your ...

How To: Create a paper scroll in Photoshop

In this video tutorial by Tasktutorial, learn how to make a paper scroll in Photoahop. Select the rounded rectangle tool and draw a shape similar to the shape shown. Open layer options. Go to gradient. Select the indicated gradient and delete the marker shown. Adjust the other markers as indicated and use the control+g shortcut to duplicate the layer. Position the shape as shown and using the pen tool draw the paper outline by clicking and holding to obtain the required shape. move the paper ...

How To: Create an easy glossy button in Photoshop

This video describes how to create an easy glossy button in Photoshop. This is done by "simpleretouch.com" website. First select the "Ellipse Tool" from the Photoshop tool bar and then drag it on the layer; it will give the ellipse shape in the layer. Select the "Blending options" from the "Layers" Menu by double click on the layer which is right below corner. From the blending options choose only the "Gradient Overlay" and in that we can choose color and its gradient as your wish. Now take a...

How To: Create a cartoon cloud in Photoshop

In this video tutorial, viewers learn how to create a cartoon cloud using Adobe Photoshop. Adobe Photoshop is a graphics editing program. In this video, viewers will learn how to use multiple layers, layer options, how to create a lighting effect and use of gradient options. This video provides voice narration and a visual demonstration for viewers to easily understand and follow along. This video will benefit those viewers who enjoy designing and creating cartoon or animation images on the c...

How To: Use the quick start screen in FileMaker Pro 10

This video demonstrates how users of the FileMaker Pro 10 software can easily start using this software from the quick start menu. It is demonstrated to users how to create a database or open an existing database from this quick start page. Also demonstrated is how users might be able to find further information using the "Learn More" option at the bottom of the menu. This option shows users the basics via videos, tours, and tutorials. A must see for those new to this software.

How To: Securely erase files on a Mac

Did you know that even after you've emptied your Mac's trash can, the data still has not been permanently removed from your system? Anyone who knew where to look could easily unearth this data. You can prevent this by using the secure empty trash option on your Mac. Whenever you put something in the trash, instead of pressing delete, go into 'finder' up top and press 'secure empty trash'. What this will do is replace the data that is left behind on your hard drive with random ones and zeros. ...

How To: Screen record anything on your desktop with CamStudio

This is a highly informative video tutorial on how to use the software CamStudio to screen record anything on one's desktop. One simply has to open a search engine like Google, type in 'camstudio' and hit the search button. On Google, the official website, camstudio.org, is the first one in the search results. Once that is opened, just scroll down, click on the link camstudio20.exe, and then click 'save file'. Once downloaded, this software can capture all the audio and video activity on the ...

How To: Compare two PDF documents in Adobe Acrobat 9 Pro

In this Adobe video tutorial the instructor shows how to compare two PDF documents. He says to go to the documents menu and choose the option to compare PDF's in Adobe Acrobat 9. This brings up a pop-up window where you can choose the files to be compared and all the various other options to choose from. This is the compare documents dialog box. Now he selects the old versions and new versions and performs other settings and shows how to perform comparisons. This video demonstrates the abilit...

How To: Create a web button in Illustrator

In this online video training tutorial, Task Training shows us, how to create a web button using Adobe Illustrator. The 1st step is to select the rectangular tool in Illustrator and set the size you want your button to be. The 2nd step is holding the shift key you can re-size your shape. The 3rd step is to give the button some color such as a gradient. The 4th step is to add a drop shadow to the button by going to Styles and then selecting Drop Shadow. The 5th step is add text to the button t...

How To: Set up Windows XP mode in Windows 7

An interesting feature of Windows 7 is the ability to run Windows XP in a virtual machine in order to use applications that don't currently work with Windows 7. This is different than using other virtual machine options because in the final version of Windows 7, several versions will ship with this for free as opposed to other options such as purchasing VMWare and an XP license.

How To: Activate Prius Hybrid electric only & stop using gas

The EVMODE electric only option is a must have Toyota Prius Hybrid accessory. Prius owners, improve hybrid MPG, activate the factory EV MOD option for electric only mode. Known as EV Mode or EVMODE allows you to switch to electric-only mode for increased fuel efficiency and performance up to 34mph. Easy installation with no wire cutting necessary. Make your green car more eco-friendly. Stop using gas!!

How To: Stencil your own shirt

Check out this interesting video to make photorealistic stencils for t-shirts, bags, and other accessories. This video documents how to make a Nikola Tesla shirt. With Adobe Photoshop, it is possible to simplify a found image into a graphic format perfect for stenciling. You can then print out the altered image into mylar or another water resistant paper. After carefully cutting out the stencil, place the mylar over an ironed t-shirt. Complete the stenciling process by dabbing paint into all ...

How To: Add music to a PDF slideshow from Lightroom in Acrobat

At first glance there doesn’t look like a way to save your slideshows into a format that you can send to some one. If you look a little further you’ll see you can indeed export them though. It exports the whole slideshow into a PDF Presentation (much like Photoshop’s PDF presentation automation). However, it won’t include any music tracks you’ve added in Lightroom. Well there’s a workaround if you’ve got Acrobat Professional. You can go in after the fact and embed the music to the presentatio...

How To: Install an Off-the-Shelf Hard Drive in an Xbox 360 (Get 10x the GB for Your Money)

Since the day of the Xbox 360 release, storage space for the device has been overpriced beyond belief. OEM 250GB HDD models still cost $110 USD! A 250GB hard drive should not destroy my wallet, Microsoft. Storage space, especially on HDDs, is cheap. You can buy a removable 2TB external for only $100 USD, so it's a little beyond my comprehension to see how they calculate their MSRP to yield such a large profit. On the other hand, Xbox 360 had very impressive hardware specs back in the day, equ...