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 336th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROWS, COLUMNS, MOD, ROUND, and WEEKDAY functions to increment numbers in Excel formulas.
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 Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to remove duplicate records using the Remove Duplicate feature which was new in Excel 2007.
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 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP & data validation to make an invoice when the product list is on a different sheet or different workbook.
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 Excel tutorial from ExcelIsFun, the 263rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a completely dynamic math equation system (function of x) with formulas, data points, charts and chart labels.
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 sketch the graph a square root 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 solve problems with the Pythagorean theorem in geometry.
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 statistics tutorials, you'll learn how to use visualize data by graphing it in a box-and-whisker diagram.
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.
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 solve an equation in which to rational expressions are said to equal each other.
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 two-part installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to simplify rational expressions in algebra.
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. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to calculate the asymptote of a rational function in college-level algebra.
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 and Mr. Excel, the 45th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to extract a number from a text string.
In this Software video tutorial you will learn how to apply the Film Look effect in Final Cut Pro. This is an advanced technique. This essentially takes a video and makes it look like a film. Select the video clip that you want to work with. Then select the ‘color corrector 3 way’ filter. This is under the ‘Effects’ tab. The key to any color correction is to crush the blacks. So, decrease the blacks with the slider. Then increase the whites as films have higher white level. Depending on the s...
IShowU and Shiny White Box demonstrate how to create still image effects in Final Cut Express. First, place your scroll bar in the front of the timeline and click on the clip so that it is selected. Then, click on the motion tab in the preview window. Hit the keyframe button in the scale option. Create a keyframe also where you'd like the effect to stop on the clip. Adjust the line. When you now play the clip, the image's size will be adjusted as you have designated. You can use the same tech...
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 232nd installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally sum by array formula in Microsoft Excel.
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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use Advanced Filter to extract records from a table with 1 criteria, then use a Macro to automate the process.
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 483rd installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use both the sort and filter tools in Microsoft Excel.
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 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to prevent Excel from displaying a 13-digit number ID in scientific notation using the number formatting tool.
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 537th installment in their series of Excel magic tricks, you'll learn how to drill through a spreadsheet to speed up formatting, formula creation and editing.
In this video you will learn how to build scrolling credits in Final Cut and Photoshop CS3. He begins by showing you how to do it on Photoshop CS3. He does this by having his own finished credits and the steps you need to take to set up your own. Then, he moves on to Final Cut and drags his Photoshop credits into Final Cut. He explains how it may be off a little in size, but you can readjust everything for accuracy. This is all done through his computer and with vocals.
In this installment of the Lowe's home improvement series, host, Mike Kraft, one of Lowe's home improvement experts, demonstrates how to install lighting under your kitchen cabinets to make navigating your counter top easier. Mike lists all the necessary tools and materials you will need to complete this do-it-yourself at home project. You will learn tips and tricks for hanging the light fixtures, as well as how to run the wiring, so that the wires remain hidden from plain view.
In this installment from the Unorthodox Hacking series of Internet security tutorials, you'll learn how to get a shell on a Microsoft SQL Server (or SQL Server Express.) See how easy it is to obtain a shell in a Microsoft SQL database with this how-to.
In this installment from the Unorthodox Hacking series of computer security tutorials, you'll learn a number of methods for hacking Windows shares as well as means of mitigating those hacks. For detailed instructions on Windows shares, and what you can do with them, watch this helpful video guide.
Learn how to create a green screen effect using Boris Continuum Complete's Chroma Key filter in Apple Final Cut Studio. BCC Chroma Key is used for compositing camera footage shot using a blue, green, or orange screen as a backdrop over a new background video or a still image from a separate file. BCC Chroma Key is also included as part of Boris FX 9.2 and Boris RED 4.3. If you have access to this powerful plug-in for Final Cut Pro, watch and learn how to use it for precise chroma keying.
Hey, Bo Diddley! In this installment from his video tutorial series (in which he covers everything from improving timekeeping to creativity and orchestrations in patterns and drum fills), Brian Ferguson demonstrates how to play the famous Bo Diddley beat on your drumset.
A band leader, classical percussionist, clinician and author, Steve Houghton is also the associate professor of percussion and jazz at Indiana University-Bloomington, and is on faculty at the Henry Mancini Institute. In this installment from his video tutorial series on the fundamentals of using a drumset, Steve demonstrates how to play in the Brazilian bossa nova style (as well as an easy-to-play "cheater" approximation thereof).
Peter Erskine is best known for his versatility and ardent love of working in various musical settings. In this indispensable installment from his video lesson series in which he covers basic brush skills on the drumset, Peter will guide you through playing time with the brushes.
Gary Burton is one of the most commercially successful mallet players in history. In this installment from his Vibraphone Masterclass video tutorial series, which covers the full gamut of common questions on the instrument from its history to his famous 4-mallet grip, Gary demonstrates how to use mallet dampening. Take a look!
Gary Burton is one of the most commercially successful mallet players in history. In this installment from his Vibraphone Masterclass video tutorial series, which covers the full gamut of common questions on the instrument from its history to his famous 4-mallet grip, Gary demonstrates said famous grip, which allows for great versatility while playing.
Gary Burton is one of the most commercially successful mallet players in history. In this installment from his Vibraphone Masterclass video tutorial series, which covers the full gamut of common questions on the instrument from its history to his famous 4-mallet grip, Gary demonstrates how to use the damper and sustain pedals to make your playing more dynamic and expressive.
Gary Burton is one of the most commercially successful mallet players in history. In this installment from his Vibraphone Masterclass video tutorial series, which covers the full gamut of common questions on the instrument from its history to his famous 4-mallet grip, Gary demonstrates how to use mallet dampening. Take a look!
Pruning a neglected apple tree is not difficult. Unless the tree is seriously post-mature, diseased or very badly situated, a few simple principles and a sharp saw will see it right. In this video, yet another installment in the Fruitwise apple pruning tutorial series, learn to utilize a pruning saw to remove whole branch systems that are diseased, too low, too crowded or crossing while leaving the rest of the tree alone.
Here is the final video in the CNC Stomp Pad Tutorial Video Series. In this video, we go over the final assembly of the stomp pad. Then we watch as we used double sided... More» tape to adhere it to the snowboard. Finally we take a look at some final photos of the CNC Stomp Pad on the Snowboard. One Final Note: The Stomp Pad works perfectly. I love the fact you can customize your life with CNC.
Have you ever wondered how to create your own cartoon character? In this video tutorial you will learn to create your own cartoon head from within Macromedia Flash. This is the first installment of the two-part tutorial.
In this how-to video, you will learn how to add text and titles to videos using Final Cut Pro. First, place a time line play head where you want the text to appear. Move the mouse to the lower right corner of the viewer window and click the add text pop up menu. Select text and the viewer will change to a black box with Sample Text in the middle. Click on the tab labeled Controls. You can edit the text in this new window. You can move the text by selecting Image and Wire Frame. This will allo...
Beat level 4-3 of the iOS version of Angry Birds Free with three stars! On January 5th, 2011, Rovio released a free version of Angry Birds for iPhone, iPod Touch and iPad users. Stuck? No problem: YouTube's FujiToast has pledged to post a three-star walkthrough for each of the game's levels. In this installment, we learn how to beat level 3 of theme 4.
Beat level 3-2 of the iOS version of Angry Birds Free with three stars! On January 5th, 2011, Rovio released a free version of Angry Birds for iPhone, iPod Touch and iPad users. Stuck? No problem: YouTube's FujiToast has pledged to post a three-star walkthrough for each of the game's levels. In this installment, we learn how to beat level 2 of theme 3.
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. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to compare population proptions in stats.
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. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to solve pop. proportion problems in stats.
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. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to compare population proportions.
