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 168th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a simple dynamic database in Excel using lists in Excel 2003 and tables in 2007.
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 154th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a personal budget based on past data via the SUM function, cell references, subtraction and the VLOOKUP function.
Have you ever had the urge to create your own Podcast to share with your friends and family? In this video, learn how to not only create a Podcast, but how to upload it onto iTunes for download. This process is actually quite easy... and even easier with the help of this video!
Love4Nails starts off with pink, silver, and black nail polish. First choose one of your colors to create a French tip manicure. She next takes the silver polish, starts at the bottom and creates a swirl around the nail. Swerve the silver in a way that it covers the French tip part of the nail. Then get the pink glitter and apply only on pink polished area. Place black rhinestones on the swirled area of the nail. Because you're using the pink glitter polish, if you choose not to add rhineston...
In this how-to video, you will learn how to quickly make a Windows 7 boot disk. This is essential for making backups or booting from something other than the operating system on your hard drive. First, go to the control panel and click the back up your computer option under system and security. Next, go to the left and click create a system repair disk. Put a blank DVD in to the optical drive. Select your drive and press create disk. This video shows just how quick and easy it is to make a bo...
Love4Nails teaches how to paint your nails using green polish. Start by using a lighter color. In this case, she uses white. She then side swipes the nail using dark green. Start from a corner at the bottom of your nail and using a swirling motion paint to the top. Next, she uses nail art polish in black to outline the side of her nail that's been painted in green. Creating a "V" she outlines the other side of the nail. She then uses a gold striper polish inside the "V." Use dotting paper and...
Jennifer a licensed cosmetologist demonstrates how to create a loose beach style bohemian hairdo. Jennifer starts by explaining how to part the hair in the front of the head. She does this to then show viewers how to create a French braid as many celebrities like Anne Hathaway, Jennifer Aniston and Molly Sims have been spotted wearing. She demonstrates how to zig zag the part by using a rat tail comb to place in the middle of the part and make a zig zag motion to create the look. Jennifer als...
Fimo expert Corinne Bradd and Emma Ward with The Crafts Channel and magazine Craft Beautiful demonstrate how to create a striped cane in 5 minutes. To create the stripes, cut out rectangles of black and white clay and stack them in alternating colors. Then, roll out a cane in a nice, bright color so that it matches the length of the stacked clay rectangle. Then, cut the rectangle into slices. Then, press the rectangle stripes onto the bright cane so that it completely wraps the cane. Squeeze ...
In this Computers & Programming video tutorial you will learn how to track Google's trends features. This will help you find some powerful micro niches and great keywords to create content and get top rankings in search engines. Any trend on the internet first starts with an event. For example ‘mega millions’ gets lot of traffic when someone wins a jackpot or a big lottery draw is coming up. Similarly, ‘July 4th’ traffic spikes around that event and dies down. If you want traffic from this ev...
This video demonstrates how to create an origami ninja star. Prepare a square shaped piece of paper. Lay it down on a table or on a flat surface. Fold the paper right across the middle in a vertical orientation. Fold it once more in the same manner as the first fold, now creating a more slender vertically standing rectangle. Fold the upper portion of the origami diagonally forming a small triangle on top of the rectangle. Do the same on the bottom portion of the origami. Fold the upper portio...
This video shows you, purely through demonstration, how to make a rubber band ball out of only rubber bands. It begins by showing how to create a small knot out of a few rubber bands, then wrap more rubber bands around it as one would with the small ball that is usually used as the core of a rubber band ball. The first few seconds are the most important, as forming the core of the ball out of rubber bands is the main trick to successfully creating the one hundred percent rubber band ball. Unf...
Not a very good artist? Well Joe makes it simple for anyone to create a great looking wiener dog! First he starts with the eyes. He draws two large circles then adds the dots for eyes. Joe gives them a little personality by making the eyes a little cross eyed. He next moves down to the nose where he draws a small round circle and fills it in. Next he follows his way down and creates the long body for the dog. He even includes realistic aspects such as eyebrows and a smiling mouth. Learn from ...
Do you have Adobe Flash CS3 downloaded on your PC and have no idea how to use it or what to use it for? Well in this video tutorial, witness as you will learn how to create a simple image gallery with transitions in Flash CS3. Enjoy!
In this tutorial, Yanik Chauvin teaches us how to create an old-style looking photo starting from a grayish, underexposed one, using the software "Lightroom". He starts by creating a virtual copy of it, and then he adds a Camera Calibration preset named Camera Landscape and increases the exposure. After that, he crops the image removing the blank parts of the photo, and adjusts Contrast, Blacks and Clarity to strength the image borders.
This video describes how to make a snoopy head from a type of polymer clay. You will need both black and white polymer clay, a blending tool and a ruler. It begins with the main part of the head and moves onto creating the correct structure using a blending tool. It advises using your thumbs to smooth away the creases and cracks from the surface of the snoopy head. After the main part of the face is made, it describes how to create the eyes and ears using the black clay. The eyes and ears are...
This video in the Software category will show you how to create simple panoramic images in Photoshop. This video uses only five images for this effect. Select the five images and put them in a folder. Go to File -> Automate -> Photomerge. On the Photomerge page select ‘Folder’ and browse. Find and ‘choose’ the folder you created. Under the layout panel on left hand side of the page, select ‘cylindrical ‘option and click OK. Now the panoramic image will appear that will have some blank areas. ...
This video shows you how to use Skype on a Nokia N900 cell phone. Skype can be activated from the Settings menu of the phone. You must scroll down to "VoIP and IM Accounts" and then select "Skype". After that, you must either log in to your Skype account or create a new one. If you don't have an account, then you must create one and you'll be able to sign in right away. Once you have logged in, you can create and edit contacts. Once that is done, you can use Skype to contact people. Skype set...
Want to take your bob from straight and boring to curly and sexy? This video shows you how! First, spray a heat protectant on your dry hair, then put up most of your hair so you are working with the bottom section of hair first. Take your curling iron (whatever size curls you are looking for, smaller with create tighter curls, bigger will create looser curls) and start curling about one inch strands of hair. Alternate directions for a more natural look. Repeat the process with small sections ...
Pulling a computer virus prank on your friends calls for good laughs. In this video you will learn exactly how to create a non-threatening "shutdown" command and disguise it as a real computer virus.
This wordless video shows how to draw a staircase in 3d. Start by drawing the steps in one dimension. Extend two lines at the top of the stairs the width you want the steps to be. Draw another line between them to make a square. This creates a landing. Draw two lines downward and parallel to the steps from the line at the top of the stairs. This will create a rail and a second base. Then extend lines from each jut of the one dimensional steps, stretching the lines alternately to the base and ...
In this video tutorial, viewers learn how to make a reflective text in Adobe Fireworks CS3/CS4. Adobe Fireworks a bitmap and vector graphics editor. Begin by opening Fireworks and create a new project. Create your text and then duplicate it. Align the duplicated text under the original and flip it vertically. Click on the color and select Fill Options. Select Gradient and keep the second option at Linear. Drag the opacity on the left to zero and the right to 100. This video will benefit those...
Makeoversession demonstrates how to twist flip your long pony tail. A variety of hair styles reflects personality. Long hair hanging loosely around your face is one style, but it detracts from your accessories such as your earrings. To create a long flip ponytail start by brushing your hair out. The first suggestion is to brush the sides of your hair into a ponytail, leaving the back hair long beneath the tail. Wrap a hair band to hold the ponytail. From beneath the ponytail, create a hole in...
In this video tutorial, viewers learn how to create a Pandora battery for the fat PSP. A Pandora battery allows the user the process of using exploits and hacks to execute unsigned code on the PSP. Before beginning, users are advised to completely drain the battery. Begin by taking out the battery and cut it open. Use a knife and gently pry it open. Do not damage the circuit board. You will need to break the pin under the number 4. Then put it back together and place it back into the PSP. Thi...
This video shows a user how to create a panoramic picture using Photoshop. In this video the details like how to merge a photo and other options which are very useful to a learner are shown clearly. This video is very practical for keen user as different things like the layouts and merging a photo are explained in detail. In this video a user can find different filters that are used in creating this panoramic picture. One will find it very easy and one with artistic heart will definitely appr...
This video is an instructional video to teach people how to create a wax seal in Photoshop. It helps users understand how to use different tools as well as layers to create the seal. It shows exactly what color to use and how to pick that color. It also shows the steps to creating the wax texture at a good pace so it's easy to follow. It teaches how to use textures to create pieces, and it works a lot with the pen tip and selection tools. It also shows how to insert pictures into a design suc...
David Wygant discusses how to get a woman to feel chemistry with you. First, realize that no one can create chemistry and to have something really special with someone, you need to have chemistry. Everyone is attracted to different kinds of people. Chemistry and attraction is a numbers game. You can create your odds by creating energy with people. Observe women, listen to what they have to say and converse with them accordingly. These techniques may unlock a woman's attraction for you. Howeve...
This video is from AskNarek] and in the video he describes how to create a custom HTML Facebook Fan Page Tab. To start the process, Narek gives a web address to create the page. From your home page, you will click on Edit Page and then select the "Static FBML" application. After the application is installed you can search your apps for it. Now Narek shows us how to edit the page into anything you like. You can change the title of the Tab, include a video or picture an...
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...
ITStaff teaches you how to design casino chips in Adobe Photoshop. You start off with a white or grey circle which will be the chip itself. You need to start decorating this so you create five trapezoids and space them equally from one another. Give them a dark red color. Next you create a red circle in the middle, touching the bases of those trapezoids. Add a crown or a symbol created or from the Custom Shapes menu. You also need to create a value so type in a number and add the dollar sign ...
The Flowergod demonstrates how to create a sweet pea and rose halo for a wedding or a luau. First, find and shape a dual ring of wire into a halo. Ensure that the halo fits on the head of your subject. Then weave foliage into the halo, creating a nice green bed for the flowers. After the green foliage is woven into a ring, insert the sweet pea and rose flowers in between the wires of the halo. Shape the flowers and the foliage as needed as you are weaving it through the metal rings. In a few ...
Create dramatic mask like look makeup using red, white and black color, inspired by the pantomime. Use toner to remove excess oil/grease from the face. Cover up the entire face with clown white grease paint, set the paint with white eyeshadow. Paint the outline of your face using a thick paint brush using black cake eyeliner. Remove any excess white paint outside the black line using makeup wipes. Powder eyes with white matte eyeshadow, then blend in black eyeshadow to create smoky eyes. Use ...
In this tutorial freetutorials teaches you how to create navigation style buttons using cascading style sheets, or CSS, in this the first in his series of "HTML Tips & Tricks". As you follow along, you will be shown how to setup and link your cascading style sheet to your HTML document, and where to place it in the document. Once you have done that, he will show you how to create a CSS, add a body and code the buttons in the CSS using notepad.
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.
The Pathfinder School offers bird enthusiasts this video tutorial that shows how to construct an Ojibwa Bird Trap. Using a series of sticks, anyone can learn how to create this bird trap, which works when a bird's weight triggers a snare. Learn the tips and techniques of what works and what doesn't in terms of materials to create a successful Ojibwa bird trap. The tutorial will explain what size sticks you need and how the trap should be constructed to successfully catch a bird.
This video shows you how to draw graffiti in Photoshop. The information relates to Illustrator and Adobe Photoshop CS2 or later. The presenter started in Illustrator and started to draw using the draw tool, created three letters, adjusted the thickness of the line, copied and pasted the letters to create a shadow effect. The presenter then used Photoshop. He used at least 3 layers to create the background and highlights. Three types of brushes and at five different colors (White, Black, and a...
1. The following steps describes how to Create dynamic menus with html and Javascript. 2. Open the html file in Illustrator. 3. Enter the Menu.js file with <Script> Tag. 4. Create a Bulleted List of the Menus and Its Sub Menus inside a DIV Tag. 5. For Each UI List Create a Mouse over and mouse out Event for Header Menus. 6. For Mouse over Event call a Function named set Menu with MenuSubOne id as parameters 7. For Mouse out Event call a Function named named clearMenu with MenuSubOne id as par...
This short video shows you how to create an animated fashion style logo in Flash. First he changes the background and frames per second to black and 24 respectively. He chooses the font for his text and then he converts the text into a movie clipping by hitting f8 and choosing movie clipping. He shows us how to make special effects by using the text in different frames. He creates layers and adds more text with special effects that create a flashing logo.
This video illustrates to create the skin components in Flash CS3. The procedure to create the skin components are, If you set an FLA to export for Action Script 1, or Action Script 2, the components panel will automatically refresh with the components that you are familiar with from Flash 8 Professional. If you change the file to export for ActionScript 3.0, you will see the new components. Flash will always show you all the components that you are able to use given your export target. In Fl...
Thinkingserious teaches us how to use Adobe Photoshop to transform a normal bmp or jpeg logo into a vector logo that can be MADE as small or large as desired without losing quality. He creates the text, leaves it white and then adds a stroke. He picks the exact color from the original image. The stroke should be 1. Then the gradient is done using the colors from the bmp image. This is a two-step process. First he creates the top gradient. He also adds a soft inner bevel. The end result is sav...
A Facebook page formatted specifically for non-profits can be created in a matter of minutes with this video tutorial from John Haydon. The first step you need to take is to search for any page. In this tutorial, Haydon searches for the page "Facebook Pages/Public Profiles" to use as the example. On the bottom left (of any Facebook page), you will notice that there is a link for "Create a Page for My Business." Click on that link, which allows you to begin the page creation process. Non-profi...
