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 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.
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.
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.
Unreal is, well, pretty unreal. And, in the latest installment of the UDK (Unreal Developer Kit) you can add sky (skydome, skybox) easier than ever before. Check out this video and watch how to put in sky from the existing library, or, you can create your own sky and use that. Look up, look waaaaay up and see the sky. The UDK is used for many, many games, way beyond Unreal, and you may even want to use UDK to create your own awesome game!
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 11th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate asset turnover, capital intensity, inventory turnover, days to sell inventory, receivable turnover, days to collect accounts receivab...
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.
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.
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.
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 four-part installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to find the optimal angle at which to launch a projectile.
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 unknowns in proportions 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 (or just finish your homework or 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 unpack and solve problems requiring you to rewrite and simplify an expression with th...
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). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to write a multiplication problem as an exponent problem.
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). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve problems requiring use of multiple mathematical operators at once.
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). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve problems requiring you to round whole numbers.
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). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve problems requiring you to multiply whole numbers.
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.
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 651st installment in their series of digital spreadsheet magic tricks, you'll learn see how to replace your IF function with a shorter Boolean Math formula! TRUE = 1, FALSE = 0, TRUE*2000 = 2000 and FASLE*2000 = 0.
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). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to calculate the probability of two dependent events in statistics.
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). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve word problems that require you to apply deductive reasoning.
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). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve word problems involving events and outcomes.
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). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve word problems that require you to simplify rational expressions.
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). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve word problems that require you to multiply (or divide) and express a...
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). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to find answers to rational equation problems 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 (or just finish your homework or 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 unpack and solve word problems that require you to apply rational equations.
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). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve number set problems in intermediate 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, the 636th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic frequency table and histogram chart using defined name formulas for dynamic ranges that use the INDEX function. See other formulas that use the COUNTIF, IF and ROWS functions that help to make it fully dynamic....
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 637th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic two data series line chart for blood pressures — how to look up a chart using defined names, a data validation list, and a formula using the INDIRECT function inside a picture of a chart.
