New to Microsoft Excel 2010? Looking for a few good tips and tricks? Look no further. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 8th installment in his series of Excel 2010 video tutorials, you'll learn how to use the Excel's new T functions — namely, T.INV, T.INV.2T, T.DIST, T.DIST.RT and T.DIST.2T.
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 599th installment in their series of digital spreadsheet magic tricks, you'll learn how to ROUND only the total column using a SUM & ROUND function array formula.
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 600th installment in their series of digital spreadsheet magic tricks, you'll learn how to convert between days and hours using Excel's MOD & INT 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 601st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP & IF functions to make bonus calculations based on the number of years worked.
Ready to make your brain hurt? In this free video jazz guitar lesson from Justin Sandercoe, you'll learn about dimished/7b9 chord substitution. In short, if you have a functioning 5 chord, you can substitute a diminished chord (with one of the root notes a semitone above the root). For more information, and to get started using this substitution in your own jazz playing, watch this helpful tutorial.
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 593rd installment in their series of digital spreadsheet magic tricks, you'll learn how to add data validation to allow only Monday dates in a cell using the custom option and the WEEKDAY function.
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 596th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SERACH, ISNUMBER and SUMPRODUCT functions to count with 4 criteria including an all criteria option.
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 17th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create 5 formulas to count times greater than five minutes using Excel's COUNTIF and TIME functions.
hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 21st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the HLOOKUP and ROWS function to retrieve multiple values from a horizontal table.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 37th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with MS Excel's SUMPRODUCT function.
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 10th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a percentage increase formula.
As you might guess, one of the domains in which Microsoft Excel really excels is business 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 60th installment in his "Excel Business Math" series of free video lessons, you'll learn how to use the Excel functions FV and PMT to make a future value calculation for an annuity.
As you might guess, one of the domains in which Microsoft Excel really excels is business 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 61st installment in his "Excel Business Math" series of free video lessons, you'll learn how to use the Excel functions PV and PMT to make a present value calculation for an annuity.
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 35.2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Excel's GEOMEAN function to find geometric mean.
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 40th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate range & interquartile range for variability using the MAX, MIN, QUARTILE functions.
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 86th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals for proportions using NORMSINV function and other formulas.
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 27th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a quantitative data dot plot chart using the REPT and COUNTIF functions.
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 35th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate weighted and geometric means and see how to use the GEOMEAN function.
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 586th installment in their series of digital spreadsheet magic tricks, you'll learn how to enumerate rows that meet 3 using the SEARCH function.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 103rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use Goal Seek to change a formula input number so that the formula is a desired result. Also learn how to use the PMT function.
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 use the DSUM and DCOUNT functions to sum or count between an upper and lower limit.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to pull data from a table on one worksheet to a second worksheet using the VLOOKUP and DGET functions.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 41st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a true/false formula with the COUNTIF function to prevent duplicate entries in a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 47th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to calculate total plate cost for a print shop using the VLOOKUP function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 350th installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting and the COUNTIF function to highlight values that are repeated a given number of times.
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 333th installment in their series of digital spreadsheet magic tricks, you'll learn how to fix errors with the Excel 2007 IFERROR and the Excel 2003 IF & ISERROR 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 266th installment in their series of digital spreadsheet magic tricks, you'll learn see how COUNT and COUNTA have trouble counting only words or text and how to use a handy workaround.
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 17th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the RANDBETWEEN function to randomly generate whole numbers as well as how to randomly assign numbers to employees.
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 15th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF and COUNTIF functions to add and count above some limit.
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 331st installment in their series of digital spreadsheet magic tricks, you'll learn how to extract individual characters without extracting the leading zeroes through use of the MID, VALUE and COLUMNS 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 310th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DSUM and DMAX with date criteria.
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.
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 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create sequential numbers in formulas using the ROWS function.
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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from standard table and put a record in a column using the VLOOKUP, IF and ROWS 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 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data validation list drop-down and the hyperlink function to create a list of links.
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 568th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a SUMIFS function to tabulate a monthly running total from transaction data.
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 393rd installment in their series of digital spreadsheet video tutorials, you'll learn how to remove the last two words from column of data with the LEN, SUBSTITUTE, FIND, REPT, RIGHT and TRIM functions.
In the new Photoshop CS4, there are some minor improvements to the Photomerge function, including the new collage option. Jay Kinghorn goes over the different ways of bringing your images into photomerge, the layout options, and some quick tips for creating better quality panoramas in Photoshop CS4. The following how-to video walks you through the entire process.
This Reason 3.0 tutorial explains use of the Import Midi function and some of ways to use it for practice or remixing a popular song. Also, get tips on spicing up flat MIDI files while learning MIDI remixing and EQing in Reason 3.0
Here is a Final Cut Studio software suite tutorial on how to use the green screen function in Final Cut Pro. Footage that has been shot on a green screen can be brought in and isolated with Chroma Key settings. Once you have your subject removed from the green screen background, you are ready to apply hundreds of effects and transitions in Final Cut Pro.
