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 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:
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 576th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a point and a dynamic label to a break-even chart that marks the breakeven point using INDEX and MATCH functions. This point is dynamic and will change if data is changed.
In this tutorial, Malou and Bob show tips and tricks to use an HP TouchSmart computer. First, you can touch the house button that will lead you to the home page. The computer is so sensitive, it will detect your touch without even having to touch the screen. When you select an object, press and hold it if you want to move it somewhere else, if you move it to the bottom on your homepage it will go into the designated area. If you press and hold your finger on the screen, it's just like right c...
Butterscotch is here to help you create a sound profile in Windows. First, go to "start", then click "settings", and then "control panel". When the "control panel" menu comes up go to and double click on "Sounds and Audio devices". Once you have that window up, click on the "sounds" tab. After doing so you'll see a menu called "program events" which is all the sounds that Windows uses. You can highlight one of the titles and click the play button on the bottom to preview the sound. But in thi...
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...
This video is about how you can change someone's eye color. The first thing to do is to load up a picture in which you want the eye color to change. The next step is to zoom in the eye that you're interested in working on. Just simply press "D" button on the keyboard and draw a rectangular shape on the eye. Now that you've zoomed in, make a selection of the iris, the part that we want to change the color on. The first thing is, you need to set up colors found on the lower left of the window. ...
In this Computers & Programming video tutorial you will learn how to change the default Windows Remote Desktop port. It is actually a registry hack. You can check the IP address of our machine by typing ipconfig into the cmd prompt. For hacking into a machine, you should have created a user for the machine and allowed remote desktop to that user. Open up the remote desktop and type in the IP address and it will ask for a login. To hack the registry, click start and type in ‘regedit’ . now go ...
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...
Kevin shows the different features and options with the program ownspy, which is through OwnSpy and is capable of tracking through phone a persons location as well as texts and phone calls. He first logs in and the first screen that opens is the tracking screen where you can sync how often the program will update the persons location. The second tab is SMS, which will show you all texts and conversations as well as the length, date, and time. The third tab lists all the persons contacts. The ...
1)Open image, go to channel. Look for the channel that gives the most contrast by going through them one by one.
Nicole Young demonstrates how to use non-destructive dodging and burning using layers in Photoshop. Your first move is to create a new layer and then hit shift + delete to select the level of opacity. You want the layer to be fifty percent grey. Now select overlay from the menu which will make anything that is fifty percent grey will be transparent. You will be dodging and burning with white and black brushstrokes. To switch from black and white background colors just hit x. Other keyboard sh...
In this video the tutor demonstrates the magnifier tool of Microsoft Windows 7. If the size of text is very small on your screen and you are facing difficulty reading it you can use the magnifier tool to resize the text to read it clearly. You can change the resolution but this makes the LCD screen look blurry. So to do this go to the Start Menu and select the Magnifier tool. Now there are two buttons with minus and plus symbol on them. Click the plus button to magnify the screen around that ...
The new Windows 7 layout is streamlined for the occasional user to the head of human relations for Microsoft. Wall papers, system sounds, and resolution settings were covered in the instructional how to video. The evaluation specialist was knowledgeable and articulate. Transitions into new areas of the operating system were appropriately placed. To make a text more readable, you should change the screen resolution. Choose your picture library to start a slide show for your weekly conferences ...
A step by step video tutorial that shows you how to change the tire from a Triathalon or road bike! Don't get stuck with a flat tire in the middle of nowhere! Gear West Bike and Triathalon show you how to: shift into the smallest gear, release the brake, open up the quick release and remove the wheel, remove the tire and tube, inspect the tube and tire, Install a new tube and remount the tire, reinstall wheel with quick release and close the breaks. Very basic, easy to understand instructions...
Learn how to use depth of field with help from this photography tutorial. Although it may seem that depth of field is a confusing factor in photography, it's actually quite easy to understand & adjust once you've gotten the hang of it. Depth of field (or, DOF) is a great way to experiment with your photography & improve your skills as a beginner photographer. When taking your photograph using DOF, it is imperative to remember that the shutter speed and aperture (or F-stop) need to change at e...
This video takes us through the procedure of creating a transform effect in Illustrator. First, choose a rectangular box and fill color in it. Input some text inside the box. The font and the color of the text can also be changed. Then position the text properly. Make a group of the shape and text. Now go to effect and choose transform. Transform is a very powerful effect which lets us create duplicates. Now select the number of copies, for example, one copy. Select preview. Now set the point...
1. This video describes how to use the application Infinidock for the iPhone and iPod Touch. This is used to set how many icons to be placed per page, this Infinidock Cracked is doing full document customization like scrolling, adjustable icon amounts and can add as many icons as you want. We can download and install in the phone 2.For using Infinidock first click the "Settings" and select the Infinidock into that you can see the "icons per page" options now you can add the number of icons yo...
Ever wondered about the flare hitting your eyes from reflective surfaces (vehicle mirrors)? Let's create one. Open Adobe Illustrator with an image and embed it. Take the flare tool from tool palette. Draw the first shape and then second shape. To change settings, go to flare options. You can change the brightness, opacity and diameter of the flare which will add life to the image(open sky). This will help bring out some cool effects as well as realism to the image.
In this video tutorial the author explains the concept of 1st Law of Exponents using an example. He shows that when we add polynomials the exponents does not change but when you multiply two polynomials their exponents change. He says that the new exponent is the sum of the first polynomial exponent and the second polynomial exponent. He further demonstrates this with a good example. This video clear shows with an example about the concept of the 1st Law of Exponents using it to multiply two ...
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 ...
This video tutorial by Tasktutorial shows you how to create a simple swatch in illustrator. Select the star tool, draw a star and select the path and scale it down as shown. Change the fill color to white, the stroke color to black and the stroke weight to 2 points as indicated. Select the rectangle tool and draw a background for the star, bring to back, change the fill color to blue and de-select the stroke as directed. Align the shapes using the align tool and select both paths and bring in...
Do you have interest in creating 3D objects? Open illustrator and draw a star tool with gradient fill in it. Then go to effects>3D>Extrude/Bevel. Select preview to view the star in 3D while changing its settings. One can rotate the star in any angle as well as change the thickness of the star. Then go to object>expand appearance and then click on the gradient. Our star is ready. It will help in creating 3D objects and shapes.
In this video from Tiffany0x we learn how to change your profile background on youtube. First she goes to google, then clicks on images and type in whatever image you're looking for for your background. Then copy the image's link in your browser. Then go to youtube. Click My Account. Then you'll see Channel Settings. Click that, then click Channel design. In Advanced Customizations you'll see a place where you can put in a Background URL. Paste the URL into that box. Once you have done that, ...
In this quick video, you are shown (and told) in a very simple way how to change your background or screen saver on your Mac computer that runs OS X. This is very simple to do, just click the apple, go to System Preferences, then click Desktop and Screen Saver. From there, you will be able to customize your background or screen saver, whether you choose to use the ones that came with your Mac, or your own pictures or downloads. This is a great video for new or inexperienced Mac users.
The replace color command is a nifty tool in Photoshop that enables you to change a color in an imagine very quickly and effectively. The tool requires that you make a copy of the original layer, as the replace color command is a destructive function. It requires parts that you want replacing to be selected first, to change the color of the desired areas. The result is a very realistically edited image, that is extremely fast and easy to accomplish.
Open a document and change the background to black. Make sure the foreground color is white, now simple use the text tool and write whatever you need to.
In order to secure a PDF with a password when opened in Adobe Acrobat 9 Pro, press the secure button and go into password security settings. Here you can change on what versions of this software the file will run on, the next option asks which portion of the document is to be encrypted when a password is placed. Further below here is where you actually choose the password, this ensures that only people who know the password will be able to see the contents of the document. Below this is the d...
In this tutorial the author shows how to derive a slope-intercept equation of a line given an X-Y table. He explains that the general form of slope intercept form which is y = m*x + b. Now he intends to find value of slope, i.e. m first. Now slope is change in y over change in x. He computes the slope using the X-Y values from the table. Next he substitutes a pair of x, y value in the equation to compute the value of y intercept b. Now finally substituting the values in the equation the slop-...
This video tutorial by Tasktutorial shows you how to create an Apple style bar in Illustrator. First, select the rectangle tool in Illustrator and draw a bar as shown. Now select the path, go to gradient and choose the black and white gradient from the swatches. Select two shades of gray and change the angle to -90 degrees as shown. Tweak the colors and go to effects-stylize and select drop shadow, change the opacity value and select black color, normal blend mode as shown. Select the type to...
Match the color of objects on Photoshop. Take a picture of your self of one shirt that the shirt is on different color mean while choose the black tea shirt because it the traditionally one of the harder colors, change the image mode to the lab color for both images then use eyedropper tool and expose the info pallet select the neutral part of the image i.e. red. Hold down shift then we can see the icon changes then add contrast to it by hue saturation present in the layer pallet.
This simple video tutorial teaches you how to change the pivot point position when using Flash. The tutorial handles drawing basic shapes, such as squares and rectangles and converting them to movie clips.
From task tutorial.com that how to create an envelope icon on illustrator. First draw a rectangle change the angle to 90 degrees then select gray color, select pen tool draw a shape and then go to layer select duplicate then rotate the shape using left mouse button by selecting the rotate tool. Now using down arrow key move the shape to down ,choose select tool and resize the shape then select the path go to gradient and change it angle to 90 degrees. Finally select the layer and go to effect...
Transforming your school uniform to express your individuality can be done very easily with a creative mind. One thing you can do to dress up a pair of pants and a plain tee is to wear different scarfs and belts. Feel free to mix and match. You can even try them with a cute vest or a jacket. Another way that you can mix things up is to change your shoes; you can get a variety of interesting colors or patterns. Also, changing your totes to something cute and different can make you stand out.
It's easy to add a new yarn color in the middle of your row. See how to change colors in the middle of the row when knitting, with this easy, up close demonstration by Judy Graham, Knitter to the Stars.
Ouch! Is your baby's bottom red and sore? Say goodbye to diaper rash with these tried-and-true remedies.
Tom Wiggins from Stuff.tv shows you how to pimp your PS3 in 3 easy steps. Here's 3 ways to get the best out of it. First up upscale to make sure you are getting 1080p. Second, change your audio output settings to get premium sound quality. This will change your output to CD quality output frequency. This will depend on your hifi. Finally, expanding your harddrive is not as easy as plug and play. You need a 2.5" laptop style harddrive add-on. Mod the stock harddrive and increase your storage s...
To play a guitar riff is to do more than simply to memorize a short musical phrase. Guitar riffs are like any other musical exercise; practicing them can be a terrific means of building manual dexterity and improving your overall playing technique. We can say of riffs, then, that they are not so much about rote repetition as making available to the guitarist new and different ways of playing. Every new riff you learn will make you a more able and versatile guitarist and better equip you to st...
Changing positions on a surfboard is one of the hardest things to learn how to do. Get expert advice on surfing techniques in this video lesson. Take action: use proper foot position, shuffle feet to make minor adjustments, and remember that sweet spots are different for every individual. Mike Jones, the instructor of this how-to video, has been surfing since he was only six years old. He was lucky enough to surf the pro tour for a few years before starting his own surf shop and clothing bran...
This instructional video shows how change traffic lights from red to green, using science, and without actually having to know anything about magnetic fields or properties! Save gas, time, and frustration in your car and during your commute! Works great! See the test results! Yay for Kipkay! The trick in this video hacking tutorial will teach you how to get green lights on your bike or motorcycle that is too small or light to trigger the traffic light.
Bangs are one of the easiest and quickest ways to change up your look. Even if you're going from slightly overgrown bangs that graze your cheekbones to blunt cut bangs on your forehead, the change is instant and can do wonders to flatter your face shape.
