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 619th installment in their series of digital spreadsheet magic tricks, you'll see how spaces in cells cause trouble in formulas and learn how to use the REPLACE, COUNTIF, CLEAN & TRIM functions to solve space-related formula problems.
Many lacerations feature skin flaps dangling from the wound, begging to be reattached. It is very challenging to suture such a wound and reattach the skin without causing it to bunch up or hang too loosely. This medical demonstration video features a doctor explaining how to do just that, performing a flap suture quickly and efficiently.
There are a number of diaper rashes that your baby can face. Sometimes a rash can be a great risk and hard to treat. You may need to take your baby to a doctor if you have tried treating their rash with different types of ointments/creams/medication and the rash has not gotten better. It may be more than just a wet diaper causing harm.
Many Americans have high cholesterol and the foods we eat are often the cause of the problem. In this episode of Ask Amy, learn how to choose your foods wisely and actually lower your cholesterol by eating better. You don't have to sacrifice everything you love for your cholesterol, but adding in some of these healthy alternatives will certainly help.
Learn how to knife someone in the face without using digital effects with this video tutorial. You will learn how to perform this effect without needing a computer and without actually hurting someone. You will need a hat and two identical knives. Cut the blade on one of the knives very carefully. Next, affix the knife to the hard hat or whatever hat you are using for this trick. The actor throwing the knife should pretend as though he is throwing the knife, but he won't actually be doing it....
This how video will teach you how to attach beads when crocheting. Beads can be found on purses, doilies, scarves, and more. This will take you through a step by step on how to apply. Be careful now, applying the bead at the wrong part of doing a stitch will cause problems in the future. If not attached at the proper spot, the beads will loosen and flip flop around.
Ever wondered about those digital effects in advertisements having some parts in pixels? Let's try it. Open Photoshop and take a picture. Duplicate its layer and on the new layer,select it and go to filters->pixelate->mosaic. Then you can mask the new layer with having some parts in blur and the other one's in focus or can use gradient. You can lighten or darken the mask layer for better output. This helps in creating unique styles and digitize your world.
In the video Boiling Pasta we are taught that there is actually a recipe for how much water to boil per pasta being prepared--1 liter per 100gm--and also what amount of salt--10gm salt to 100gm pasta, after boil. Most people preparing pasta may not know that adding oil while pasta is being boiled will cause it to not adhere to sauce. The video provides many useful tips in preparing pasta, most important of all when it is done just right.
In this video we learn how to make it seem like your photo is torn in half using Adobe Photoshop. The first step is to decide how you would like to have your photo "torn" up. The second step is to select the lasso tool and draw the tear line through the photo. The third step is to select the rest of the image you want to keep. The fourth step is to go into Quick Mask mode and select Filter, Brush Strokes, then Splatter. This creates the jagged edge torn effect. Finally select a smoothness bet...
In this video tutorial by photoshopuniverse you learn how to create a wood photo frame in Photoshop for your photos. Take the photo that you want to add a frame to, open it in Photoshop. Open the layers palette and double click to convert to a regular layer and increase the canvas size of the image to the required thickness of the frame. Create a new layer and fill in with the wooden pattern. Apply a mask and reveal the photo as shown. Apply the desired effects bevel and emboss to get the woo...
In this Photoshop tutorial the instructor shows how to change the dark hair color to blond. To get this accomplished you need to use a couple of very special techniques. First use the selective adjustment layer and select the outline of the hair. Now use the selective color option and change cyan and magenta settings to about minus forty. Now changing the other yellow color to achieve saturation and black colors to achieve the effect with shadows. Now next change the colors of black so that t...
This video is a how to guide on how someone can add multiple colored sections to a photograph. It goes step by step to guide viewers on how to accomplish the color effects. Although the video is only 5 minutes long it provides a great wealth of information. However the speaker is quite fast so using the pause button is highly encouraged for those not proficient with computers, or those not very quick with a mouse. A very informative video that taught me something I did not know how to do in P...
This video is a step by step demonstration of how to make a stained glass effect for cards or scrapbooking using glue, colored ink and sparkles on acetate. This is not for beginners, this is an intermediate level project for experienced stampers. You will be able to understand the process and will be able to copy it by the end of this six minute video. The audio instructions are easy to follow and the visual demonstrations make it very easy to learn.
Wondering how to get that dropped shadow, smoky eye? In this tutorial presented by the experts at Smashbox Cosmetics, learn how to get that smoky effect on your bottom lids, while leaving your top lid clear, creating the "drop shadow effect". This wearable look is stylish, sexy and sleek perfect for big occasions.
What's a proton pack without a ghost trap? Useless, that's what. Don't pay megabucks for some fake Ghostbusters costume when you can build your own with household materials.
Home security is as important as having a job. You have to protect your family and your valuables. If you can't afford a high tech security system, then maybe a fake security camera will do the trick. This security camera dud is also a cheap alternative for a film prop. Watch this video tutorial to learn how to build a fake cardboard security camera.
This video will show you a few techniques for removing stuck pixels from an LCD screen. This is not a guaranteed fix. Please only use these as a last resort, as some of them can cause more damage to the LCD. Only attempt these if you are experienced and know what you are doing.
Ex girlfriend tracking you like a stalker? Find the leaks. She may be going through your email or phishing some information. Does she want a confrontation? Lure her to a public place then get her to cause a scene in front of security. Or last case scenario, fake your own death!
One of the best extensions for Apple's Final Cut Studio is the visual effects and digital compositing application Shake. Shake is an image compositing package used for post-production, and it enables complex image processing sequences to be designed through the connection of effects "nodes" in a graphical workflow interface.
One of the best features of Final Cut Studio is the sound design feature Soundtrack Pro. With it's royalty free professional instrument loops and sound effects, you can easily compose music and edit audio for your indie film, or maybe even a professional movie.
Some governments and organizations employ proxy servers to filter web content, permitting access to some web sites while blocking others. Here are several ways to get around these censorship policies. This is employed in China with YouTube and many other voices of anti-goverment ideas.
Check out this instructional fishing video that demonstrates how to fly tie for beginners. In this fly tying tutorial, Dave demonstrates the "Baby Doll". This is the pattern that goes back to the early 1970s that caused a minor revolution in its time. This is a very simple and popular fly to tie. Learn how to fly tie a Baby Doll with this fishing video!
Does your low-budget film need an explosion, a fireball explosion? This video tutorial shows how to build a simple cremora (fireball) and safely use it. There are many filming techniques, you'll have to figure them out on your own though.
Using three layers of alpha transparent PNG files, we can can create a pseudo 3-dimensional looking background for a web page using the parallax effect. This video screencast covers how to do that from start to finish. Since Internet Explorer 6 and under do not support alpha transparency in PNG's, this screencase also covers how to create a warning message that will display only in those web browsers. You'll see how to use TextMate, Adobe Photshop, Safari, and VMware Fusion for your CSS build...
Three different prank in order to scare your roommate. The only one that will cause harm to your friend will be the first one. So be careful and be safe. Use this as inspiration for one of your April Fools Day pranks!
Ever notice the dreamy quality of a British sitcom? How about the "shellshock" look used in war movies? And we're all familiar with the look of an amateur home video, which can be...surreal. Believe it or not, these effects are created in the camera's shutter speed, and very rarely in post-production.
Pour water into a cast iron bomb. Then bathe the bomb in a dry ice acetone slush. This will cause the reaction. This is to illustrate that the volume of ice is greater than of an equal mass of liquid water.
Custom Products Paintball Tanks come with a fill nipple filter. This causes the tank to fill up EXTREMELY slow. To remove the filter, simply remove your fill nipple, and tap out the filter.
This video will show you how to pick up a fallen bike that's on its side. Video is brought to you by F650.com. They give you safety tips about how to deal with the crash or fall that caused the bike to be 'fallen'. They also show a light weight woman attempting the lift too.
I have owned quite the plethora of electronics in my life. A commonality between most of these devices' screens is frozen or dead pixels. This is probably the most annoying thing about buying new hardware—your LCD, or worse, LED display has one or more pixels that continues to stay lit. Most of the time, this will appear in the form of a brightly colored pixel that never changes, or a pixel that never displays the right color. Once you notice it's there, you just can't stop staring at it. It ...
Want to add a clickable button to your website, but want something a little more exciting than just the ordinary picture or text button? If you have Adobe Flash and After Effects CS4, then you can design yourself a really cool, electrified button with your logo on it. Click here for the source files.
Add a rollover and rollout effect your movie clips created in Adobe Flash CS3. This tutorial shows you the process to add in an extra level of interactivity to your projects created using Flash. Achieve this effect by using the Tweener Class.
In this clip, you'll learn how to achieve simple sky replacement effect in Motion 3. Whether you're new to Apple's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.
Bored with your wood floors? Want to trick your guests? Well then set yourself up with a faux rug! This video will show you the steps to not only painting it yourself, but creating the desired "fabric" effect in your paint.
Looking for an easy way to apply effects to your profile picture online? With the BeFunky image processing tool, it's simple! So simple, in fact, that this home-computing how-to from the folks at Britec can present a complete overview of the process in just over four minutes. For more information, including step-by-step instructions, watch this video guide.
Want to create a photo effect reminiscent of the film 300 in Adobe Photoshop? This clip will walk you through the process. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer 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, watch this video guide.
Unless you happen to be the real life version of Hayden Christensen's character from the movie "Jumper," who has the magical gift of teleportation, traveling from one place to another simply by will is a power restrained to science fiction novels and movies.
In this video you will learn how to create a chocolate effect using Adobe Photoshop. In order to do that, just follow these steps: Create a new file with 1000x1000 px. Then create a new layer, select the Shape Tool and create a heart with a brown color for the chocolate. Then add the same effects just like in the video in order to get the same result. The next step is to add the text. For the text use a large font and a light-brown color. If you correctly follow these instructions, the result...
YOUTUBE Logan Salter presents a video demonstrating a method to create "Crocodile Tear" Makeup. The entire video is demonstrated through visual action, with typed titles in green appearing on the screen prior to each new step, and electronica music played throughout. Logan begins by applying moisturizer, demonstrated visually in the video by applying moisturizer to his facial area and moves at an increasingly faster rate through steps visually demonstrating how to apply various powders and br...
A breakaway chair is one of the best pranks, or one of the easiest effects for your indie film project. A breakable chair can be made out of simple household items, and is very cheap. The biggest material needed is cardboard. So basically, you'll make a cardboard chair, that breaks. Watch this video tutorial to learn how to make a fake movie prop brick.
