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 529th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a pass-fail grading formula using the IF and AND and VLOOKUP functions.
Windows 7 can be purchased online and downloaded. From the downloaded files you can create a bootable DVD. Three files are downloaded: An executable 64-bit Windows file and two .box files. Move all files to a new folder "w7p" and put the folder on the C drive. You have to download a Premastering file from here: http://depositfiles.com/files/d8zxuifur and paste it into system32 folder. Unpack .box files and click on "expanded set-up folder". Go to command prompt, enter large chunk of code (wri...
To create an apostolic or pentecostal hairstyle, start with a poof in the front of the hair. It can be ratted behind for stability. Use two bobby pins to secure the back corner of the poof. Squirt the hair with hairspray before moving on. Then create a low ponytail in the back of the hair, pulling the top up and out slightly while forming the ponytail so it creates another poof in the back of the head. Spray the ponytail with hairspray then smooth out the hair on the top of the ponytail. Wrap...
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 93rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting to create a Gantt cell chart.
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 very first installment in their series of digital spreadsheet magic tricks, you'll learn how to build your spreadsheet smartly, so it updates automatically by creating formulas with cell references!
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 219th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function so a macro to create a pivot table will work even when new records are added.
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 218th installment in their series of digital spreadsheet magic tricks, you'll learn how to an Excel 2007 table to create a dynamic range so a macro to create a pivot table will work even when new records are added.
Want to create a time-lapse video montage from photos shot on a DSLR? This tutorial presents a general overview of the equipment, settings and post procedures (e.g., cropping & color correction) necessary to create beautiful, finished-looking time-lapse clips. Get started shooting your own time-lapse segments with this free video guide.
Life on the Internet is made up of passwords. You have a password for your Facebook, a password for your email, a password or your online banking - And the list goes on. In this video, learn how to create good passwords that are easy to remember.
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 Excel tutorial from ExcelIsFun, the 263rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a completely dynamic math equation system (function of x) with formulas, data points, charts and chart labels.
In this Computers & Programming video tutorial you will learn how to create a virtual machine for free using the virtual box in Mac. Open the virtual box and click on new. Click next, put in a name for the virtual machine and click next. In the next window, it gives a recommended memory, increase it slightly with the slider and click next. Click next in the subsequent 4 windows that come up and finally click ‘finish’ and click ‘finish’ again on the next window. In the next window click CD/DVD...
How To Crochet: Double Crochet Stitch is a short video that demonstrates how to create the double stitch. As show in the video, you will need yarn as well as a crochet hook. The video shows step by step how to create this specific type of stitch. The narrator explains that the double crochet stitch is twice the height of the single stitch and also has wider spaces between each stitch. Advice is also given to count your stitches at the end of every row as the narrator cites "losing" and "gaini...
To create an origami buckyball, you must start with a piece of paper cut into a triangle with each side about two inches long. Fold the corner of each side into the middle of the opposite side and then unfold to create creases that will be your guide. Next, fold a side up to the midpoint of the creases and repeat on all sides. This will create a star-like shape. Now, fold two sides in and pinch out the extreme, outer corner and repeat on all sides. This will create a small star inside your pa...
Miss 80 Million provides viewers with a step by step tutorial on how to create a ballet slipper look for your nails. Use black sparkle nail polish. Create a French tip with a very deep smile line that goes all the way to the corner. Use the same polish to draw a line straight down the middle vertically. Let it dry. Next take white Art Deco nail polish to create a diagonal pattern across the nail first one way then the other making sure the lines meet in the middle. After it dries, apply a top...
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 Excel tutorial from ExcelIsFun, the 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.
Using HDRI Lighting and Particles in Cinema 4D, Nick from Greyscale Gorilla gives a great tutorial on creating a black and white balloon animation. These tools give a very slick and organic look to your projects.
This video in the Software category will show you how to create a real cool manipulated globe in Photoshop. You will combine a few images and distort one of them to create a 3D image of a globe. There are 3 components; the background, a hand and an image globe. First open the background image. Then open the hand image, copy and paste it over the background, resize and position it correctly. Now open the third image, choose the elliptical marquee key, draw a circle and copy and paste it over t...
This video demonstrates that just because a shoe feels loose doesn't mean it's the wrong fit. Many shoes have a back eyelet that rarely gets used, but if you put your laces through it before tightening, it will raise the fabric of the shoe to give more support to the heel. If your shoe doesn't have this extra eyelet, you can create false eyelets by creating loops with your laces on the top two eyelets of the shoe, then lacing them through those fake eyelets before tightening. Both of these me...
Learn how to make a balloon teddy bear using only one hand by following the steps outlined here in this tutorial. You will need one balloon already filled with air. At the end, create a nose. Then, add two bubbles for the back of the head. Twist the five bubbles that will comprise the head of the bear. Once the head has been formed, you will stick the nose in through your ring for the head to create the overall head and face. Pinch twist to create the ears at the top of the head. The body is ...
Kyle Hutchens with Live Strong demonstrates how to throw a good curveball. First grip the baseball on the side where the skinny seams come together. Take a normal pitching stance with one leg back, come through, bend your front leg and snap your wrist down through the ball to release it. Snapping your wrist down through the baseball creates the speed and the drop of the curveball. It creates less velocity than a fastball. Create the drop when your arm is between the 12 o'clock and 6 o'clock p...
This video teaches you how to create a system repair disc in Windows 7. Go to Start-All Programs-Maintenance-Create a System Repair Disc. This will help you boot Windows to repair or recover your system after a serious error. Once you click that, Windows 7 will prompt a new window telling you to put a blank disc in your disc drive. Make sure that you do have a blank DVD to insert, for the Windows 7 to create that System Repair Disc. Wait for the process to finish and you have yourself a syste...
Follow along as we are shown how to set a password for a new user in Windows 7. -First, go to the Start menu.
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...
This is a great look if you don't have (or want) the hair that's required of it. It's a really awesome braids hairstyle. The best thing to do is to use your own hair extensions (yes, from your own hair) which you can use over and over again, and not have to worry about it not matching completely with your hair, because it will be your hair.
Don't trash your unfashionable old skirt, but turn it into something new, something unique, something fashionable. See how to create a designer tote from a skirt in this video from GiannyL.
Tasktutorial teaches you how to create a scrolling text box using buttons and ActionScript in Flash. Create a dynamic text field and then right click and make it scrollable. Create scroll buttons using two simple rectangles. Convert those to buttons using shortcut F8. Click the button and go to Window - ActionScript. Copy the text from the video to make the buttons scroll the text. You can test the movie by going to Control and then Test Movie. This will bring up a new window and you can see ...
In this how-to, viewers will learn how to create a presentation which fades in and out among still photographs using Flash animation. First, each image is given its own layer in Flash. Then the images are converted into movie clips. A motion tween is created among each image and a few blank frames, to create the affect of a slow fade in and out. Then the layers are distributed sequentially on the Flash timeline so that as each layer fades out, the next fades in. The finished movie is tested, ...
The video explains how to make a animated banner in photoshop. The narrator explains step by step how to create the banner, what colors he used in the banner and the width and length of it as well. He also shows other techniques that he used to create the banner. The video is about ten minutes long and is very informational for those interested in creating animated banners for their website. The narrator has other instructional videos on the same subject as well.
The bouncing ball animation in Flash is usually the first assignment covered in an animation class because it demonstrates some of the most basic principles of a line across a stage. This trick is quite easy to learn and this tutorial will take you through all of it, step by step. Once you master this animation, you will find it much easier to create more complicated ones.
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.
This video describes the initial creation of a database using File Maker Pro 10. While this video does not go into anything complicated, it does give a great preview of how their particular program works. The movie indicates there are templates available, however the series of movies explains how to create them from scratch. There seems to be another six or so official movies. This three minutes movie covers new database creation, naming, importing fields, naming new fields, relationship crea...
In this video tutorial, viewers learn how to create a web 2.0 style badge using Adobe Illustrator. Adobe Illustrator is a vector graphics editor. Viewers will learn how to manipulate the Star Tool in Adobe Illustrator, how to apply a custom radial gradient to that shape and how you can create, save, and open custom swatches. This video will benefit those viewers who design websites. These web badges can be used on a website to promote a product, announce a sale, or simply draw attention.
This video describes how to create a jumping letters in Flash, first create the text for example "JUMP" and using Break the letters each and then make the layer and now convert the letters into "Movie clips" and now we should add the key frames to our "time line”. Then moves the letters up by using the up arrow now copy the key frames from font end and paste on the back again for go up and come down the letters again and add the "motion between" for each letters and now skip the key frames by...
Tasktutorial will teach you how to create a nice vector cartoon flower using Adobe Illustrator. Start by selecting Rounded Rectangle Tool, and draw a black rectangle. Then select multiple points and move it according to the video, using arrow keys. Then draw an ellipse with the Ellipse Tool, using the Shift key. Watch the video to see the remaining easy steps in creating a vector flower using Adobe Illustrator and also get some cool tips and recommendations for best results.
This tutorial will show you how to create a cool image animation using mask in Flash. First lets import image file and now lets create a new layer. Choose oval tools and now lets draw a shape just outside our scene. Then go to frame 30, and add the key frame and select transform tool. Now lets re-size our shape and go to 50 frame and add the key frame. Then go to frame 80 and add the key frame, re-size our shape and use free transform tools. Now lets create shaped in frame over 30, 50,and 80 ...
To create a Christmas ornament in Illustrator is very simple if you follow the steps below. Before starting the process one should ensure that all project files used in the tutorial is available. First by holding the shift key draw an oval, then go to gradient and create a new gradient which is at right side of the window. Now select red color and make it darker, then select 'Radiant' from the tool and switch the color positions. Select the ellipse tool once again and create a new shape on to...
You will learn to create graphs in Illustrator. The best way to visualize data is a graph, and there are several different graph choices in this program. He chooses a column graph to show how he creates his graphs. Holding the left mouse button and dragging, he creates a rectangle which will be our graph. This brings up an input screen beside the rectangle for the graph; he puts information into the screen which shows up on the graph when he is finished.
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...
Ever wondered about when your mouse moves over a website and some animation plays? Well, that's an invisible button. To create one, first type some text in Flash. Then create a new layer, draw some basic shape, and convert it to a button. Then double-click and create a new keyframe on hit. Scale the shape according to the size of the text. Now, when one moves the cursor on the text,the cursor becomes active. It really helps for some animation with greeting cards.
In this Photoshop tutorial, learn how to convert regular photos into works of art that create a painted on effect. By using the right brush tool, a regular picture can be made to look as though it was painted onto a canvas with real brush strokes. This tutorial shows us how to use different types of brush presets loaded in Photoshop in conjunction with a new layer to create a canvas effect. The result is photo converted into a painting.
