Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and use simple charts in MS Excel as well as see how to use Excel's SUMIFS & AVERAGEIFS functions. Specifically, this video covers the following topics:
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the very first installment in his "Excel Formula Efficiency" series, you'll learn how a custom function (i.e., a user-defined function) can speed up calculations.
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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that will return multiple items when there are two criteria for the data extraction. Also see an INDEX and MATCH functions formula that uses the SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW fu...
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 19th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHOOSE and RANDBETWEEN functions to randomly generate words.
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 216th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a pivot table (PivotTable) with 4-variable cross tabulation. Learn to use multiple fields in a pivot table with this free video tutorial.
If you're getting into belly dancing, you should know before getting to thick into it, you have choices. Learn the differences between tribal & Egyptian style belly dancing as well as the differentiating costume that accompanies each style of dance.
This video shows the method to use differential equations to represent growth. Consider the function y=multiple of C & e raised to kx or Ce^(kx). Differentiating it with respect to x, we get dy/dx=kCe^(kx) or ky. So, the solution of the differential equation dy/dx=ky is Ce^(kx). There are two possibilities in the function y=e^(kx). It can be exponentially growth or decay function. This depends on the value of k. If k is greater than 0 or k>0, we get an exponential growth function. On the othe...
Microsoft excel is a powerful tool used to work with numbers and data by filling them down in rows and columns of a table. Excels also supports macros, which are small scripts to automate certain functions. In Microsoft Excel you can select entire rows and columns using the range property. You can also use macros to select individual rows and columns as well as multiple variations of rows, columns, and individual cells all at once. In Excel a horizontal line of data is called as row and a ver...
In this multiple part scrapbooking tutorial, learn how to make a 5"x5" fall mini scrapbook. This scrapbook uses fall-themed papers and products to create that autumn look. Use this six-part series as a guide for your next mini scrapbook creation!
Using multiple layers of clay, garden of imagination shows how to make a hamburger and fries out of polymer clay. This decorative item would then be placed into a miniature dollhouse being displayed as a food item. She rolls a peppercorn on brown clay to give it the texture of meat. She mixes together green and whit clay for lettuce, and uses another piece of clay to ruffle the edges of the lettuce. She uses small round cuts of clay for tomatoes. Using an embroidery needle with a clay handle ...
RAID, or Redundant Array of Independent Disks, lets you divide and replicate data among multiple hard disk drives for information storage security. This video tutorial demonstrates how to install Ubuntu in a RAID 0 array. Before starting, you'll need at least 2 hard drives and an Ubuntu alternate installation CD. RAID 0, or striped disks, let's you install an operating system, such as Ubuntu, on a partition, while using others for data storage, as illustrated in this instructional segment.
This video shows how to get more value on your GoDaddy account. You have to have a deluxe account to share domains. You have to pay an extra $2 a month to get this account. Once you sign in go to "hosting" then my "hosting account". To add another domain you move it over to a new folder then put the site files in there. To do this, click add domain then go to bulk. Then create a folder and name it what you desire. Sometimes the file folder doesn't always appear immediately, but it is there, i...
Swirloflight teaches you how to draw a vase with flowers using a colored pencil. Start with a regular black pencil to sketch the flowers and base. You want to start off with basic shape and draw only what you need. You will now go to the next part, using the colored pencils. Don't go into great detail and don't be afraid of going outside of the lines while coloring in. The colored pencils are good for creating rich areas of color. After you're done with the vase and flowers, create a blended ...
Mastering your Excel skills? Have a busy Excel workbook or spreadsheet that needs to some organizing? In this two-part tutorial, learn how to pull text from cells & separate them into multiple columns in MS Excel. You will learn how to use the LEN(), FIND(), LEFT(), and RIGHT() functions to pull text from Microsoft Excel 2007 cells & assign them to different columns.
Bowman shows you how to resize your photos using Shrink O'Matic. Resize your pictures by doing the following: Open Shrink O'Matic and choose your settings, for example output size, pixels, ratio, etc. Highlight the pictures you wish to resize, and drop them into Shrink O'Matic. Open the Output Folder and you will be able to see the images in their new file size.
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.
TyingItAllTogether explains that, "Pagoda is the English language term for a tiered tower with multiple eaves. Common throughout eastern Asia, most pagodas were built to serve a religious function. The Pagoda Knot was created in admiration of this sacred architecture." In this video, learn how to tie a decorative pagoda knot. Working with a single piece of string, follow along as the string is transformed into a work of art. Begin by making a series of four loops. Cross the tails, then weave ...
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...
Want to create some cool effects in illustrator? Create a new layer. Draw the ellipse tool and add radial gradient, then go to transparency and select screen. Then create the star tool and deselect stroke. Drag and place the star shape on ellipse and group them. Then duplicate that layer to make multiple sparkles on different layers. Resize other sparkles by holding down shift key. One can change colors of other sparkles. This will help you in making a good background.
This tutorial describes how to create a realistic graffiti effect in a program called GIMP. You must first make sure that you have the font "writers original" installed on your computer. If not, you must download it to create this graffiti effect. Simply open a brick background on GIMP and put whatever text you want to have. Enhance the text by creating multiple layers and create a multi-dimensional image by creating contrast among those layers. Lowering brightness opposite layers and changin...
Lay several layers of tissue paper on top of each other. At least 10 You can use different colors to make a colorful flower or one color to make a flower that is one color. Multiple color flowers are great for 4th of July celebrations (red, white and blue). And single color flowers are great for wedding receptions or graduation parties.
An interesting party decor idea is to place balloons inside other balloons. This can be accomplished easily by first inflating a large balloon. Using a small stick, push a second, smaller balloon inside the larger one and then inflate the smaller balloon while it is inside the larger one. You can then tie up the second balloon, leaving the smaller one inside the large balloon. This can be repeated with multiple small balloons, so your balloons will have a unique and interesting look. This tut...
Jessi Stensland, professional triathlete, explains how selecting the right bike can mean the difference between a comfortable ride and possible neck, back, knee or shoulder pains. Stensland first takes us through finding the right bike size with charts such as those available on Schwinn bikes. After the right size is determined, riders should determine the proper fit by adjusting their bike's handlebars and seat. Lastly, Stensland instructs bike riders on how to choose the proper saddle.
In her video, Carol describes her skin care regimen, which she claims has been very effective in treating her acne and improving her skin. This regimen is for acne-prone / combination skin types and involves the use of multiple products, including cleansers, scrubs, masques, washes and moisturizers. Carol takes us through her morning, evening and weekly cleansing routines, explaining which of various products she uses for each such routine. She also discusses each product, explaining its stre...
Is your PC too slow? Want your PC performance to increase without paying any money? Well, in this video the viewers will be taught how to speed up their PC and internet speed without spending a dime. First of all, the video goes through some of the potential applications that are draining the computers' resources, such as multiple anti-virus. The video teaches how to delete and remove unneeded applications and free up additional RAM. One of the key ideas is to close and disable applications t...
This is a helpful video provided by Math Problem Generator. It deals with the complex challenges of dividing variables. The audio is great and provides specific examples of dealing with multiple types of this problem. The video lays out three simple steps. The first being to simplify the coefficient, the second being to divide the variable, and the third being to deal with the results of the division. The information is clearly presented and best of all it's free. I think we all wish there we...
A great trick that requires you have a friend with you. When your back is turned, and the "victim" chooses a coin, your buddy puts his beer where the coin is. Known as the "nine coins" bar trick.
This is origami, but it's more of a work of art. A perfect 3D mathematical kusudama, which is created by sewing multiple identical pyramidal units together to form a 3D Japanese paper model.
In this video, an English lesson for foreign language speakers teaches viewers expressions using the work "table." There are three different expressions taught through watching, listening and defining.
Choose a cheap leaflet, get a size H hook and a ball of worsted weight yarn.
Get that Bohemian look this summer with homemade chunky jewelry! In this three-part jewelry making video tutorial, learn how to make a Cubed Herringbone Stitch for bracelets. From Auntie's Beads" "Ladder-stitched cube bead rows work as a foundation to this bracelet. The stitch is easy to learn and the tapestry like look will invite multiple color combinations!"
JusJerk and Jerk dance crew, the Stick Figures demonstrate how a "Pin Drop" is done in the world of Jerking, and later, how variations of the Pin Drop (sometimes also referred to as the "Knee Drop") can lead to multiple Pin Drops in a row and/or some pretty impressive acrobats. Later in this tutorial, the Stick Figures show how to do "The Break Leg Pin Drop" by dipping and "breaking the legs". We're guessing they mean this figuratively.
The best flotation device is the one you wear. There are many choices when it comes to picking the PFD that will keep you safe on the water. Now there is a new option, inflatable PFDs from Mustang Survival. There is one to suit just about every water activity from sailing, kayaking, paddling, boating, water skiing, wakeboarding or general pool fun!
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: Knee stall.
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: T-Shirt Trick MCNS.
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: LATW or Lemmens Around the World (ATW).
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: Elastico.
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: Knee Crossover.
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: Flick ups.
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: Hocus Pocus.
