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 325th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that takes a fixed daily cost and calculates the monthly total for months with different number of days.
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 319th installment in their series of digital spreadsheet magic tricks, you'll learn how to run a VLOOKUP in reverse order using the INDEX & MATCH functions and custom number formatting.
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 321st installment in their series of digital spreadsheet magic tricks, you'll learn how to match text substrings with an array formula that uses the AND, ISNUMBER and SEARCH 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 323rd installment in their series of digital spreadsheet magic tricks, you'll learn how to run a partial text lookup query using a VLOOKUP function with wild card 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 314th installment in their series of digital spreadsheet magic tricks, you'll learn four different methods for converting TRUE and FALSE values to 1 and 0 (zeroes).
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 316th installment in their series of digital spreadsheet magic tricks, you'll learn how to count & list unique values as well as how to concatenate a range of values with a separator.
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 304th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a secondary axis to a chart so that you have axes on the left and right.
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 297.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally sum from various 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 247th installment in their series of digital spreadsheet magic tricks, you'll learn how to add leading zeros to a text string with an 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 277th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUBSTITUTE and Morefunc EVAL functions to take a text string series of numbers and add them.
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 191st installment in their series of digital spreadsheet magic tricks, you'll learn how to how to extract part of a text string using a formula with the functions MID, LEFT and FIND.
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 224th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract a prefix from product ID when there is no dash or space to establish a pattern.
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 213th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a non-array formula to extract data dynamically using two different methods.
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 206th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate commissions with the VLOOKUP function when the lookup value is an account type instead of a number.
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 210th installment in their series of digital spreadsheet magic tricks, you'll learn what to do if your formula does not calculate and is showing the equal sign and the rest of the formula without calculating.
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 189th installment in their series of digital spreadsheet magic tricks, you'll learn how to count all the days except for Sunday using an array formula for a given date range with a specified start and end date.
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 188th installment in their series of digital spreadsheet magic tricks, you'll learn how to set up headers and footers across multiple sheets.
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 579th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MOD function and date math to create a column of dates where each successive date is repeated twice.
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.
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 235th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a custom number format for inches that will allow you to type decimals or fractions and have it formatted as inches.
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 226th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply names to formulas and replace existing cell ranges as well as how to name ranges from selections.
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 578th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to grade student answers where more than one possibility exists using the IF and OR functions.
Paraphrasing is a useful tool you can use to avoid plagiarism, and still use expert facts. In this tutorial, learn how to quote your research in an essay properly and avoid making illegal mistakes.
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 181st installment in their series of digital spreadsheet magic tricks, you'll learn how to count words (case sensitive) using the SUM and EXACT functions in an 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 178th installment in their series of digital spreadsheet magic tricks, you'll learn how to alculate the best value from two categories 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 175th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT function and an array of TRUE & FALSE to count values between an upper and lower bound.
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 149th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a value in a table and then return the row or column value when there are no duplicate 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 145th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will calculate the median when you have more than 1 criterion.
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 554th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to weekends and holidays with Excel's NOT and NETWORKDAYS functions.
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.
With cables as with human hair, tangles are a drag. With the proper coiling method, however, they can be avoided. And this free video guide will walk you, step-by-step through the entire process. For more information, and to get started coiling your own cables the right way, watch this useful how-to.
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.
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.
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.
In this video Darci Lorocque from Swirl Solutions gives a very handy and useful tip for Blackberry users. She says that you don't have to type apostrophes while you are sending text messages or emails or using Blackberry messenger. The apostrophe is automatically typed by the Blackberry. So for example if you want to write the word "Don't", you will simply type "Dont" in your Blackberry and as soon as the space button is hit the apostrophe will be added automatically.
Lowe's a leader in the retail home improvement business, brings you this instructional video on how to measure and prepare for hanging wallpaper, for the do-it-yourselfer at home. In this video you will learn useful tips on calculating just how much wallpaper you will need to wallpaper your room, as well as a list of the tools and materials you will need to achieve a good finish, and get the job done right the first time, every time.
This video shows you how to make a simple, DIY ring light for your point and shoot Canon G10 or G11 camera. By using either cool white or warm white LED lights, you can set your white balance presets to daylight or tungsten. Ring lights are incredibly useful in fashion photography for an even, soft light with a striking eye light.
In this tutorial, Reggie Bennett from the Mountain Shepherd Survival School teaches us how to build a tepee. First used by American Indians, the tepee remains a useful way of providing shelter in a hurry. Whether you're lost in the woods or just spending a few days camping for fun, building a tepee is a good skill to know.
