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 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various probabilities for a binomial distribution when there are additional complicating factors. This is accomplished with recourse to Excel's BINOMDIST, NORMSDIST, SUMIF, SUM, INDEX and MATCH functions. See also how to create th...
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 248th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the PERCENTILE and QUARTILE functions to calculate percentiles, quartiles and deciles in basic statistics.
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 124th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a box plot or box-&-whisker chart using a stacked bar chart and a open-high-low-close stock chart. You'll also learn how to use the QUARTILE function.
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 180th installment in their series of digital spreadsheet magic tricks, you'll learn how to count specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values that are NOT equal to an amount, words that end in es, all words, all numbers, all content, all blanks, all things which aren't words ...
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...
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 243rd installment in their series of digital spreadsheet magic tricks, you'll learn how to find typical values, or averages – a single value that allows you to talk about all the data points in a given spreadsheet. Specifically, you'll learn how to find the mean, median, mode and standard deviation for a set of numbers.
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 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF function to sum with specific criteria.
Drawing is an excellent exercise for the brain that also lets your mind wander. This video tutorial demonstrates how to draw a serene mountain landscape using charcoal techniques. Begin with a simple sky and mountain range, then add trees and a beach. Pencilling in water will help to bring the trees to the foreground. Finally, add shadows and a waterfall to provide a sense of depth to the entire rendering.
Nick from Greyscale Gorilla shows you the basics of setting up a project file, creating a scene, and rendering a final image in Cinema 4D. He also does a basic tutorial for post-production HDR lighting.
New user to Windows 7? Microsoft has put out a series of video tutorials explaining how to maximize your Windows 7 experience. Follow along with this computer lesson and learn how to:
Shatter glass with your mind!… Um, no… with speakers! This little video shows you how to shatter wine glasses with your own speakers. Yep, those normal, everyday home speakers that you have can break a wine glass just like a jackhammer.
Welcome to a tennis lesson from FuzzyYellowBalls, the the best place to learn how to play tennis online. Our free video tennis lessons teach you how to play the game in a new way that combines technical analysis, visual learning, and step-by-step progressions.
They don't call them salad days for nothing; you probably can't afford to eat anything else. But there are ways to trim your food budget—and they're even good for you. Learn how to eat cheaply on a budget.
This network security tutorial addresses how to create a Meterpreter reverse connecting executable. It can be ported to a U3 device for pentests. For detailed, step-by-step instructions on how to create Meterpreter executable, or .exe, files, watch this hacking how-to.
Learn how to use MapForce FlexText to analyze and parse arbitrary text files using an intuitive visual interface in this video. The resulting structured data can be used in any MapForce data mapping.
Take a look at this instructional video and learn how to hack into your iPod's firmware on a Mac. In order to hack into the 5.5g iPod's firmware, you need to download the Alterpod, a firmware editing software. With this program, you'll be able to download themes onto your iPod. Keep in mind that this hack is for the 5.5 generation iPod and does not work for the 6th generation or the older ones before 5.5. When downloading themes, make sure to download the correct version.
Ever wondered about the reproductive tract of a female pig? Well, these video tutorials will tell you all you need to know about the anatomy of a sow's reproductive tract.
Many video camera companies are beginning to manufacture tapeless camcorders, which record footage as files on hard disks, solid state drives, or optical disks. It's easy to transfer file-based footage to your Mac using Final Cut Express. Just connect your camcorder to the USB port.
When you've finished a LiveType project, you can import it directly into Final Cut Express. The LiveType projects looks and behaves like an ordinary clip, but it has a .ipr file extension. Edit it like a normal clip, and you can change its attributes after importing by right clicking and selecting "Open in Editor." Final Cut Express automatically updates the imported file.
Whenever you right click a file in Windows it opens up the context menu, which gives you options of what to do with the file. Learn how you can add your own custom options to the context menu by editing the Windows registry.
Blogger Jimmy R. demonstrates how you can embed hidden files into an innocent-looking JPEG image using the free 7-Zip and the Windows command line.
The Zumocast app allows you to stream music, movies, or pictures directly from your work or home computer to your Droid Bionic smartphone. The Android device can also access documents or other files located on your PC using the program. This Motorola support video will walk you through the process.
In this video, you'll learn how to convert format files accurately and for free in two different ways. You can use a program called Format Factory, which you can download here, or you could use a website called Zamzar.
The Golden Egg is perhaps more of a state of mind than a posture in yoga. The Golden Egg involves sustaining and concentrating your core strength, creating what Sadie Nardini calls an "abdominal balloon."
In this video we learn how to increase & decrease the size of web page content. First, click and hold down the control key and move the mouse wheel up and down. After you do this, you will start to see your web page content get larger and smaller right before your eyes. You can also use the plus and minus keys on the keyboard to get the same effect. Keep in mind you will need to do this for each of the different pages as you access them. For a more permanent fix, you will need to go to the to...
Is it possible to look put together without actually, you know, having to put in the work to look put together? We're glad to tell you that there is.
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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve the cell address of the minimum value in column. To accomplish this, you'll use the ADDRESS, MATCH, INDEX, MIN, ROW and LOOKUP functions.
Add a background .mp3 file to play music when visitors come to your website. You can also build buttons to allow users to pause, mute or play the file while they're on your website. This tutorial shows you how to build this system using Action Script 3 and Adobe Flash CS4.
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 724th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if quantities are the same in two lists and show the differences if not, list the word "equal" if they are the same, and "not in list" if the lookup items is not in list using the MATCH, INSA, VLOOKUP and IF functions.
Hardened steel is very durable, but nearly impossible to work with at home. If you are trying to choose a piece of steel and can't tell if it's hardened or not, you're in luck, because this video contains a quick method for doing so. All you do is try to file an indentation in the steel with a file. If that doesn't make a mark, you've probably got hardened steel.
You can make a magic memory stick on your PSP in some very easy steps. So first thing you need to do is download the files. Now extract the dc8 file on your desktop and drag that 500.pbp file on your desktop. Now plug in your PSP in your computer and copy the dc8 folder and go to PSP, game in your PSP memory stick and past it there. Now copy the 500.pbp file and go to the root of your memory and paste it on there. Now in your PSP, run the files which is mentioned in the video and you are done.
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 712th installment in their series of digital spreadsheet magic tricks, you'll learn how to take bad data set up in one column and make a proper table of data for a mail merge as well as how to extract name and e-mail data from a list in one column where records are entered inconsistently.
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 700th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve every other cell in a row as you copy the formula across the columns.
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 702nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up two values at once and return then both to one cell using 2 VLOOKUP functions and concatenation (Ampersand &) or two cells using a single VLOOKUP and the COLUMNS function.
If your little girl loves jewelry making but you're scared she's going to poke her eye out with a wire when you're not looking, sleep soundly at night by teaching her how to craft shrink plastic jewelry. Perhaps the safest and easiest forms of jewelry making, it involves only shrink plastic and a mini oven (which you would help out with).
In this video, we learn how to tailor your resume for foreign countries. When you are writing the resume, you need to keep in mind the: length, content, demands, passport, and hobbies. You should make sure the content is descriptive and you focus on your accomplishments. Don't focus on the family and references, these are not required on the resume. The recruiter wants to know more about your professional life, and if you have a passport to travel. Depending on the country you are traveling t...
In this video, we learn how to improve your yoga with the hara breath. Start by sitting down on your yoga mat and become centered in your body. You will start to breathe in different poses by placing your hands underneath your navel. Close your eyes and envision the center of energy that's in your body. Close your eyes and deep breathe, inhaling and screening energy into your body. Feel your body fueling up with energy and block out all the negative thoughts from your mind. As you do this, fe...
Worried about a hard drive failure? Or a virus that destroys your operating system? Well, don't worry… Windows 7 lets you backup and restore your Windows 7 operating system and all of the files and folders you choose.
In this clip, you'll learn how to log into a Blackboard course and upload files, edit and manage files. Whether you're new to Blackboard's popular content management system or CMS or are a seasoned web instructor just looking to better acquaint yourself with the features and functions of versions 9 and 9.1, you're sure to be well served by this free video software lesson.
