New to 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 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...
New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 368th installment in their series of digital spreadsheet video tutorials, you'll learn how to create and use an array formula that will permit you to count unique items within a column while specifying more than one criterion. This guide uses the SUM, IF FREQUENCY, MATCH, ROW, and ISNUMBER functions (in a somewhat unusual combi...
New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 308th installment in their series of digital spreadsheet video tutorials, you'll learn how to extract data to a new workbook by array formula. Functions used include IF, ROWS, INDEX, TEXT, ROW and SUMPRODUCT.
New to 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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...
This video instructs you how to use the "Finder" Button if you own a Mac on OS X. The "Finder" window shows the Mac user the contents of the hard drive. It describes functions of the Finder folder: i.e., adding an untitled new folder in the Finder file. It also discusses how you can view the "Finder" in a variety of layouts: grids, lists, etc. The video shows you how to use the buttons on the upper left hand corner of the "Finder" screen to maximize, minimize, or close the window. It also dis...
This how-to video produced by Photoshop Universe gives step-by-step instructions on how to batch automate a process in Adobe Photoshop. With this tutorial you'll be able to learn to correct white balance, enhance colors, resize, and save for the web whole folders' worth of images in one go. The first step to doing this is to open up one of the images in your folder and correct the white balance, enhance the colors, resize the photo and save. The next thing you want to do is to record all of t...
Got a Canon Powershot whose resolution or functions are not cutting it for you? Then amp up its abilities - without flat out buying a new camera - by checking out this digital camera hack video. By modifying the camera's firmware you'll be able to add games as well as a manual mode for ultimate control of how you produce your images.
The Professor of Silliness returns with some paper. Watch this instructional video to make a tall tree out of newspaper. You need an old newspaper, masking tape, and scissors. Simply lay out the newspaper pages from end to end and tape them together. Then roll it up at a diagonal, starting from one corner, and pack i it into a compact tube. Use tape to keep the tub intact Use the scissors to cut vertical lines half way down the newspaper tube. Pull out the inner most layer and turn your recyc...
The brachial plexus is a collection of nerves that supply the upper limb. It has three functions; motor innervation of skeletal muscles, sensory innervation of skin and muscles, and sympathetic innervation of the skin, specifically the sweat glands, and blood vessels.
Many MicroKorg enthusiasts focus on it's synthesizer functions, but it's also a vocoder, and nowhere is that more apparent than in this video. It will teach you how to connect an electric guitar and a mic to your MicroKorg and use them together so that you can hear your voice on your guitar. It's very worth it.
HTPC. It stands for Home Theater PC. Some refer to it as simply a Media Center. But no matter what you call it, you're going to learn how to build one today. Why would you want to do that? Because one of the main advantages of creating your own home theater system is that you are control, not only of the cost, but the features and functions, as well.
In this Family video tutorial you will learn how to teach kids how to eat right. First you got to educate your children. Robin from greensmoothiegirl.com presents this video along with her kids. The 1st step is to educate the kids. For example, in the video, she explains the functions of the parts of a wheat kernel. She tells them that the white bread is made up of only the glue from the kernel which carries no nutrients. Whereas, the brown bread is made out of the whole kernel and it carries...
In this 14th video in a series about JAVA game development, "thenewboston" (Bucky Roberts) explains how to redefine your screen to avoid annoying flickering. Flickering in JAVA games often occurs because of time lags as the viewer watches the computer draw a new screen, pixel by pixel. Pre-installed code in JAVA can be used to eliminate this problem by taking advantage of "Buffering" and "Page Flipping". These functions permit you to delay the composition of a new screen until it is finished,...
Systm is the Do It Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. We will help you avoid pitfalls and get your project up and running fast. Search Systm on WonderHowTo for more DIY episodes from this Revision3 show.
In the following series of videos we will establish a particle stream that is then used to create a surface that evolves over time in Houdini 9 software.
As each new version of the award winning Adobe Photoshop is released certain functions remain the same from prior versions while other functions are changed. In the latest version of Photoshop, Adobe Photoshop CS4, the patch tool works significantly differently than prior versions. In this video we are shown how the patch tool originally worked in Adobe Photoshop CS2 compared to how it now functions in Photoshop CS4. Finally the author gives us step by step instructions on how to operate the ...
Assign custom shortcut keys to your most commonly used Adobe Photoshop CS4 functions to help speed up your workflow. Whether you're new to Adobe's popular graphic editing program or a seasoned design professional looking to better acquaint yourself with the new features and functions of this particular iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this designer's guide.
Are you a newbie when it comes to Gmail? Watch this video and learn. It starts of with a brief overview of the registration procedure. Then proceeds to explain the welcome screen and then the main interface.
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 684th installment in their series of digital spreadsheet magic tricks, you'll learn how to do single-condition lookup adding for both the VLOOKUP and HLOOKUP functions. You'll also learn how to use an array constant in the row/column num argument for the HLOOKUP and VLOOKUP functions.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use comparative operators; logical TRUE/FALSE formulas, IS functions (ISTEXT, ISNUMBER, ISBLANK, ISERROR, ISNONTEXT); IF functions (1 of 2 words in a cell, 1 of...
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 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...
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...
Probability computation is a complex process and even using a calculator can be difficult. But normal probability calculations can be performed quickly with the help of calculator once you know how to use it. So when you have to calculate a probability from a normal distribution you can use the functions on your scientific calculator. You can use the normal CDF function from you calculator to compute the area under a normal curve. The function requires lower band and upper band values, the me...
Some savings plan pays interest 365 days in a year but you make deposit monthly. You can use Excel functions to calculate the maturity value of the of the monthly plan. To do this you have to use the nominal and effect functions before using the future value functions. First enter the know data like the monthly payment, the number of years of payment, the number of days in a year, and the annual percentage rate. First take the nominal rate and calculate the effective rate with the help of eff...
New to 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 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to streamline filtering when you have categories of criteria using an array formula that uses the functions COUNTIF, VLOOKUP, ROWS, IF, INDEX, SMALL, and ROW. Also see how to put OR criteria into the IF function as well as how to do an OR coun...
This video describes how to use excel basics formulas to do math. Shows how to create new formulas so that you can complete math functions and how many formulas in excel work. Each step is displayed step by step with an explanation on what is going on so it may be understood. Keyboard short cuts among other tips and trick to help you navigate through microsoft's excel. After this video you would be able to use excel to do a variety of functions to complete math equations.
So you've just installed iMovie on your Mac... but now what? This tutorial walks a budding director through all the basic functions and features available in iMovie, and shows you how you use them to best effect when creating your own film projects.
In this video tutorial, we learn how to create an alpha channel within Adobe Photoshop CS5. 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.
In this video tutorial, we learn how to arrange art around a circular grid when designing a CD cover in Adobe Photoshop CS5. 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.
In this video tutorial, we learn how to create two separate exposures for the same image with Camera Raw when retouching a digital photograph in Adobe Photoshop CS5. 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.
In this video tutorial, we learn how to use advanced search parameters like "define" and "site" to access hidden functions of the Yahoo! search engine. For more information, including a complete demonstration and detailed, step-by-step instructions, watch this how-to from the folks at CNET TV.
In this clip, you'll learn how to use Recolor Artwork when working within Adobe Illustrator CS5. Whether you're new to Adobe's popular vector graphics editor or a seasoned graphic arts professional interested in better acquainting yourself with the new features and functions of Illustrator CS5, you're sure to benefit from this free software tutorial. For more information, and to get started using this trick in your own Illustrator projects, watch this video guide.
In this clip, you'll learn how to tell the difference between pixel dimension and resolution when working in Adobe Photoshop CS5. Whether you're new to Adobe's popular vector graphics editor or a seasoned graphic arts professional interested in better acquainting yourself with the new features and functions of Illustrator CS5, you're sure to benefit from this free software tutorial. For more information, and to get started using this trick in your own Illustrator projects, watch this video gu...
PhotoKey is a cheaper alternative to Photoshop if all you want to do is work with green screen effects. This tutorial shows you the basic Chroma Key functions available to editors in PhotoKey, so you can start adding your own backgrounds and special effects.
This Adobe Flash CS4 tutorial shows you how to create a graphic symbol. Creating a graphic symbol lets you reuse the image in other projects, and set up a few other interactive and dynamic functions when you incorporate graphic symbols into your animations.
The CS4 version of Adobe Flash has altered the appearance and layout of your screen. If you draw often in Flash, this tutorial shows you how find and use the Smooth and Straighten functions efficiently and add them to a menu using the history and saving as a command.
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 720th installment in their series of digital spreadsheet magic tricks, you'll learn how to use filtering, the AND, TODAY and EDATE functions, and conditional formatting to show values between two dates.
This clip presents a whirligig tour of the various functions and features available on the Apple iPhone 4. Whether you're the proud owner of an Apple iPhone 4 or perhaps just considering picking one up, you're sure to benefit from this free video tutorial. For more information, including complete, step-by-step instructions, take a look.
In this clip, you'll learn how to use a few simple compositing tricks to blend indoor and outdoor architecture within Photoshop CS5. 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.
Cordell Connect is useful software for managing projects for your business. One of the functions of this program is being able export your reports to either an Excel spreadsheet or a PDF document for a greater ease of data manipulation and communication.
