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 315th installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use the SUMIF & SUMPRODUCT functions.
If you use After Effects you have become familiar with the Work Area, a range of time that allows you to focus on a specific range of time. You can work exclusively in this area, or work in the larger time of the composition, only to preview or render that area of time when you go out to final. In CINEMA 4D, users can achieve similar results using the Preview Range. This tutorial will show you how.
A remote control for a camera? Why not! You won't have to worry about racing the timer function any more! Build a remote control for your digital camera that will take the picture whenever you want. The range is as far as two miles!
This tutorial presents a lesson in generating high-dynamic range images (HDRI) within MAXON C4D. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including complete instructions, watch this 3D modeler's guide.
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 9th installment in his series of Excel array formula series, you'll learn create array formula that counts all the characters in a range of cells.
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 12th installment in his series of Excel name tricks, you'll learn how to use the built-in dynamic range names in Excel 2007 Tables.
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 8th installment in his series of Excel name tricks, you'll learn how to name cell ranges with relative cell references instead of the default absolute 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 307th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, ROWS, COLUMNS, LARGE, SMALL functions to create 4 different formulas that will invert a range of values.
This is an excellent video showing you how to open up the dynamic range of your Canon DSLR camera in order to see into the highlights and shadows better. By giving you a flatter image, you have more ability to manipulate the image in post-production, having lost less available information.
This video shows us the method to find the median and the inter-quartile range. The first step involves the arrangement of the numbers in the ascending order. Median is the middle number. The middle number is the number at (number of numbers + 1)/2 if the number of numbers is odd or the (number of number)/2 if the number of numbers is even. In the example the number is located at [(11+1)/2] or the 6th number. The inter-quartile range is higher quartile - lower quartile. The higher quartile is...
Need to calculate the domain and range of a graphed piecewise function? Learn how with this free video lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test).
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 252nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use a cell range typed into a cell in a function.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to use statistical range, variance and standard deviation to measure dispersion in a data set.
All of these four videos are excellent. You will notice that while all the videos and articles have slightly different design dimensions, they are fundamentally very similar. I urge you to view and read everything I am serving up. Then, my final words of advice are simply....choose between a barbeque switch and a taser gun. (Hint: there is a right choice, and there is a wrong choice.)
Sometimes it's hard to find the time to watch your diet. When you're in a rush, you'll eat whatever you can. Many people grab snacks without considering food quality. But there are healthy vending options.
Update: August 1, 2014 Earlier today, President Obama signed into law the Unlocking Consumer Choice and Wireless Competition Act, making the act of unlocking your unsubsidized cell phone 100% legal.
Remember those Choose Your Own Adventure novels? If your school was anything like mine, they were so popular you were lucky to find one to check out at the library. But there's no worries now, thanks to this handy HTML5 app, which makes it easy to write and share your own 'choose your own adventure' novels. inklewriter is a free tool designed to make writing interactive stories simple. Basically, you start typing and inklewriter helps you organize your story, making it easy to add, remove and...
There is a new function in MS Excel 2010 called ‘Sparkline’ which helps you quickly find trends associated with a set of data. To create Sparkline, you can go to ‘Insert’ tab and then select ‘Sparkline’ section and then select the graph type. After you enter the data range and location range, the Sparkline will show up indicating the trend based on the data range you identified earlier. You can change the types and styles of your Sparkline easily. As the video demonstrates, whenever you use E...
Training to be a deadly assassin? Why not practice on something a little less dangerous, and make a homemade paper blowgun to begin with? In this two-part video tutorial, learn how to make a sturdy paper blowgun that shoots steel-top darts, and can shoot up to fifty feet. To make this paper weaponry, you will need: An old school notebook, scissors, tape, a hot glue gun, a soda bottle, and 2 paper clips.
Do you like chess? How about Japanese chess? Aren't there different chess variants in Japan though? Maybe, but this specific chess variant is called Shogi. The chess-like game Shogi is won by capturing the king, just like chess, but defeat is conceded at mate, or when mate becomes unavoidable.
Kipkay shows you how to increase the range of your remote control for your television. You use electrical tape to make sure that the leads do not come into contact with the reflector.
Check out this video guide to WiFiFoFum, an app available through Cydia that will extend the WiFi range of your iPhone, iPod Touch, or iPad. If you have a jailbroken iDevice and you want to be able to use it in more places, watch this video.
This video goes in depth in to the map Firing Range on Call of Duty: Black Ops multiplayer mode. Maximize your strategy and master your tactics when you use this map, probably second in popularity only to the Nuketown map.
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 630th installment in their series of digital spreadsheet magic tricks, you'll learn how to copy formula through a huge range using keyboard shortcuts.
Need to calculate the domain and range of a function in algebra? Learn how with this free video lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test).
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 389th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a ctrl-period keyboard shortcut to quickly move the active cell in a selected range.
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 4th installment in their series of digital spreadsheet magic tricks, you'll learn how to add data or a formula to a range of cells by using the Excel's ever-useful ctrl+enter keyboard shortcut.
Name ranges of data to make formulas a bit easier to read and write when working in Microsoft Excel.
Chuck Gaskin at Dorchester Shooting Preserve teaches young teen girl the basics of shotgun shooting on skeet range. Watch and learn!
Summer time is the best time to have fun with fashion. And since you're probably going to be spending most of your time beachcombing, nomming on large ice cream sundaes, and attending hot late night parties, your clothing choices should be as comfortable as possible.
If you've never iced a cupcake before, then first of all, put down that spatula (we know it's SO much easier and faster, but your cupcake will also look like crap in the end and you know it).
What's better— forking out the dough for a new headlight or simply restoring it to its original beauty? The latter is definitely the choice for penny-pinchers, and is easy to accomplish with a restoration kit from 3M. This video will show you how to use the 3M Headlight Lens Restoration System to restore your headlight's shine.
Want to receive daily, weekly or monthly updates on a subject of your choice? With Google Alerts, it's easy! So easy, in fact, that this home computing how-to from the folks at Easily can present a complete (and somewhat talky) overview of the process in just under five minutes' time. For the specifics, and to get started setting up and using Google Alerts yourself, just watch this handy how-to.
In this clip, learn all about kelation therapy. Kelation therapy is a simple procedure administered in a qualified physician's office that may reverse and even slow the progression of age-related and degenerative diseases such as atherosclerosis. In this tutorial, Francesca will explain all about this procedure so you can help decide if it is the right choice for you.
Rear suspension bikes are the bikes of choice for most hardcore mountain bikers. This video features a professional mountain bike rider offering a quick tip on how to set the rear suspension of your bike properly to give it the right amount of travel and maximize its effectiveness.
Ever wonder what those bars and lines on the LCD screen on your digital camera do? In this great tutorial, Ethan Wilding demonstrates how to read one of the most useful features on your camera: the histogram.
Learn how to do the "melt through" coin and pen magic trick. This magic trick will make a pen slide right through a coin of your choice without any gimmicks. It's a pretty simple trick for anyone, if you're a fast enough magician. The melt thru is perfect for beginners.
This is a how to video on choosing the right surf wax for the conditions you will be surfing in. You got tons of choices. It's pretty easy. Gauge the water temp by checking Surfline.com. Then you just check the labels to find out what kind of wax you want. They feel and smell different.
Weight loss will occur naturally with healthy choices and exercise. So weight loss should start with a healthy metabolism. Learn how to get started losing weight from a registered dietician in this diet and health how-to video.
Satin fabric is luxurious, delicate, and surprisingly sturdy and resilient. To learn more about embroidering on satin: stabilizer choices, needles, and design selections, watch this embroidery video tutorial. Master the art of satin embroidery!
