Qualified Food Search Results

How To: Count values between a lower & upper bound in MS Excel

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.

How To: Do a reverse two-way lookup in Microsoft Excel

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.

How To: Use the MEDIAN IF function in Microsoft Excel

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.

How To: Increment numbers in an Microsoft Excel formula

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.

How To: Make an invoice from an external product list in Excel

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.

How To: Create a dynamic equation system in Microsoft Excel

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.

How To: Use macro and advanced filters 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.

How To: Sort and filter in Microsoft Excel 2007

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.

How To: Fit and replace Hotpoint carbon brushes

Check out this home repair tutorial video that demonstrates how to fit and replace your Hotpoint carbon brushes in your washing machine's motor. Follow the step by step instructions in this domestic appliance repair video to remove your Hotpoint carbon brushes. Please note that all work should be performed by a qualified engineer. Make sure to take the necessary precautions to ensure a safe removal of your Hotpoint washing machine's carbon brush.

How To: Remove door hinges to your cooker, oven, or stove

Check out this home repair tutorial video that demonstrates how to fit and replace door hinges to your oven. Follow the step by step instructions in this domestic appliance repair video to replace your cooker's door hinges. Please note that all work should be performed by a qualified person. Make sure to take the necessary precautions to ensure a safe removal of your oven's door hinges.

How To: Replace your grill element in Neff and Bosch cooker

Check out this home repair tutorial video that demonstrates how to replace your grill element in a Neff and Bosch cooker. Follow the step by step instructions in this domestic appliance repair video to remove your Neff or Bosch cooker's grill element. Please note that all work should be performed by a qualified person. Make sure to take the necessary precautions to ensure a safe removal of your cooker's grill element.

How To: Replace a cooker thermostat oven

Check out this home repair tutorial video that demonstrates how to replace the thermostat in your oven. Follow the step by step instructions in this domestic appliance repair video to remove your cooker's thermostat oven. Please note that all work should be performed by a qualified person. Make sure to take the necessary precautions to ensure a safe removal of your thermostat oven.