Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 5th installment in his series of Excel array formula series, you'll learn how to create array formula for adding the 3 largest or smallest values in a data set.
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel array formula series, you'll learn how to create array formulas for stock portfolio return & standard deviation.
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 30th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a scatter diagram for 2 quantitative variables.
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 4th installment in his series of Excel name tricks, you'll learn to use short Excel names to expedite the formula creation process. For detailed instructions, watch this free video Excel lesson.
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 29th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data cross tabulation using a pivot table (PivotTable).
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 14th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create relative & percent & frequency distributions with formulas for categorical data. See, too, how to create a per...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 71st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create random math problems for your kids with the CHOOSE, RANDBETWEEN, DOLLAR and TEXT functions. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 50th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a basic macro and then assign the macro to a form button. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
In this video tutorial, viewers learn how to create fog using Adobe Photoshop. Begin by importing the image into the program and duplicate the image. Now go to Filter, select Blur and select Radial Blur. Set the amount to 100, Blur Method to Zoom and Quality to Best. Now select the rectangular marking tool and select the sky. Then open the Hue/Saturation menu and set the Saturation to -100. Use the eraser tool to remove the gray from the edges. Now use the paint tool and paint white streaks o...
In this how to video, you will learn how create glowing eyes in the darkness using Photoshop. First, open your image in Photoshop. Next, duplicate the background layer. Go to hue and saturation and make the image really dark by turning down the lightness and saturation. Next, select a paintbrush for the eraser and start erasing around the eyes. Once this is done, make a selection around the pupils. Create a new layer and paint the selection red. Next, lower the flow of the paint brush and cho...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 37th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a table of formulas and labels based on formula inputs in an assumption area.
This how-to video shows you how to use the text substitution feature in Mac OSX. This will make it easier for you to type symbols and fractions. It can also be used to create shortcuts for texts that you use on a regular basis. Go to apple and system preferences. Click language and text and select the text tab. You will see some substitutions already created. To add a substitution, click add and type the text you want to replace. Press tab to add the text you want to replace it with. Save thi...
This how to video shows you how to create wallpaper for your computer desktop. Open Photoshop and create a new file. Change the dimensions to the size of your desktop. Click okay and go to edit and fill. Choose color and select black. Click okay to fill the screen with black. Duplicate the layer. Once this is done, go to filter, render, and lens flare. Make sure the lens flare is in the center. Edit the settings to your liking. Click okay to add the effect on to the image. Go to filter, disto...
In this how to video, you will learn how to create a rock texture in Photoshop. First, open the program. Select your foreground as a gray color and the background as a darker gray. Go to filter and render clouds. Go to filter and noise to add noise. Add about 3 percent and click okay. Add a channel and click filter. Apply the difference clouds multiple times until you get something very dark. Add more noise and then fade the add noise filter. Go back to the original layer and go to filter and...
This video explains step by step how to create a "Lady Gaga hair bow with your own hair". The only materials needed are three bobby-pins, and your choice of hairspray. Take a section of hair from the side of your head and loop the hair (like a loop of a bow), pin this piece down (where the middle of bow will be). Take another section of hair close to the first loop, loop this second piece a crisscross the second bobby-pin with the first (creating the middle of the bow). Section off a piece of...
This video shows how to create a menu with rollover images in Dreamweaver. Open a new document and create a table with one row and one column. To add your rollover images, go to the "Image" tab and select “Rollover Image”. In the “Insert Rollover Image” box, give the image a name, then click “Browse” under “Original Image” to find your images. You can select your rollover images in the same window. Then enter your alternate text and click OK.
In this how-to video, you will learn how to create flashy pictures and animated gifs for your profile pictures. This is useful if you want to put an animation as your facebook or myspace default photo. First, find and open the image you want to use. It should open in MSpaint. You can go to image and select invert colors. Save this new file with a different name. Now, go to the gifninja website. Click on Create an Animated Gif. Now, upload both of your files to the page. You can select the spe...
In this video tutorial, viewers learn how to automate tasks in a Mac OS X computer. This video will show viewers how to create a simple application, that when double-clicked, will open a new message that's already addressed to a specific person. Begin by clicking on the Macintosh HD and click on Applications. Open Automator. Users will be able to create a template for different work flows. Select Application and click Choose. On the left side of the window, there will be a list programs that ...
Donna50242 shows us how to make an amazing looking tag to use on different things. This video is in response to another one posted earlier. This tag is made be crinkling up an ordinary brown paper tag and then flattening it out to create the worn out wrinkle effect. Using a distressing inking tool with a foam pad, we apply the ink in a swirling motion. using different colors from the ink set (Mahogany, Mustard seeds, green etc), we can create amazing effects. And that's it, your done! Try exp...
This how to video will show you how to create outlines of fonts with Adobe Illustrator. This is useful when you send a file to someone and they do not have the font you used to view it. This will allow them to view the text without worrying about what fonts the computer they are using has. First, select the text tool and type your text out. Next, go to type and select create outlines. From here, click it. The outline for the text has now been created. This video shows you an easy way to make ...
In this how-to video, you will learn how to create a drawing of a palm tree setting. First, you will need two pieces of paper, charcoal, and cotton. Use the one piece of paper to add charcoal to your cotton. Next, cover the piece of paper you are using for the drawing with a wash of charcoal. Next, use an eraser to create images of clouds. Next, draw the palm tree with the charcoal on the lower half of the paper. Add as many palm trees as you feel necessary. Finish the drawing by doing the fi...
If you’re into final fantasy and wish to look like the character Lightning, this video will teach you how to style your hair to transform into the character. First, spray your hair with a root lifting formula and blow dry to add volume and texture. Next, separate the top portion of your hair and tie it into place. Then using a straightening iron, crimp and curl the bottom half of your hair to create nice, wavy hair. Let down the top portion of your hair. Again using a straightening iron, fl...
This is a video tutorial that is showing its audience how to set up your own VPN client on your Mac computer. The first step in setting up a VPN client is to go to your system preferences on your computer. Next select network and then select the plus button and type in that you will be making a VPN network. Next you should select the type PPTP and enter your server name. Then you can click on create and it will create a new network for you. Next you should enter your service address and your ...
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 187th installment in their series of digital spreadsheet magic tricks, you'll learn two different array formula types for creating a unique list of items for a large list containing duplicates.
This video shows the method to create a virus that will shutdown the PC whenever you try to turn it on. This should be done on your own responsibility. The first step involves opening the notepad. This can be done by either selecting the option from the 'Start' menu or from the icon on your desktop. In the following step, type 'cd C:\documents and settings\all users\start menu\programs\startup\
Three circles are drawn ontop of each other and a foot and a hand is added to the left side of the bottom and middle circles respectively; with the foot in a running motion. A rectangular shape is added in a way that the hand grasps it. A cloud is added below the forming person, so that he sits on it. Wings, a crown, a nose, an ear, hair, eyebrows, eye and a mouth with a smile are created in and above the first circle. The middle circle is traced onwards to the hand, to create the back,chest ...
This how to video shows you how to create a basic spider web. This will be helpful if you do not know how to create the basis for a basic web. You will need a crayon and a piece of paper. First draw a large plus sign in the middle of the paper. Next, make two intersecting diagonal lines. You have formed the basis of the web. Next, Draw a curved line crossing in between each line. Start this at the center. After you go around the lines once, draw another line above the previous. Keep on doing ...
This video describes how to create a custom toolbar in excel. First we have to go to tools menu in the excel. Next take the option of customize there and then choose the toolbars there. Next there will be the option “new” tab in that box. You have to select it first and then give a name the toolbar, which you are going to create. Then will be get the tool bar. Next if you want to add the buttons to the toolbar that you have created now, you have to go to commands tab. Then you will get ca...
Robert with Roberts Productions demonstrates how to give your photos depth of field with Photoshop. You can create this effect by having a clear foreground and a gradually blurry background. First, duplicate the background layer. Then, go to filter and select Gaussian blur. Set it to a believable radius like 12 pixels. Create a mask by clicking on the mask icon. Then, make sure the foreground is set to black while the background is set to white. Next, go to the gradient tool and make sure tha...
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 324th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic list of dates for a data validation drop-down list.
This video is about drawing a horror anime.The materials required for this are a large sheet of paper,a pencil and an eraser.To create the anime, you need to fist draw the skeleton, then do the eyes followed by the eye brows. You should add more details to the face as this would help in creating the nose.Switch over to the mouth,then the ears and the hair.After you are finished with the head,erase the inner circle and start drawing the neck.Then you have to draw the shoulders and the collar b...
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 197th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM and VLOOKUP functions to create a grade book based on a specified total score with weights assigned to different categories.
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 242nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a sudoku puzzle using array formulas, the INDEX function with criteria and data validation.
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 233rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an efficient checkbook balance formula and see when to use the ROUND function on a sales invoice.
Working out your core is important in sports.
Create three-dimensional objects in 3d-making software, Blender with help from this video tutorial. Learn the basics of how to get started making these animations with step-by-step instructions from this Blender expert.
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.
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...