msgbartop
Blog About Stuff That's In Your Home | Appliances and Stuff
msgbarbottom

31 Oct 14 Siemens iQ 700 multi function oven

siemens-iq-700-multi-function-oven.jpg

Siemens iQ 700 is the built-in single multifunction oven with high resolution TFT colour display. Combining stainless steel and black glass design, the 60cm Siemens HB78GB590B makes a striking impression in your kitchen.

Functionally, this Siemens oven features advanced cookControl with 68 automatic cooking programs that are going to help you to achieve perfect results. The main 14 cooking modes give you every opportunity to prepare healthy and delicious meals. You can work with hotairEco, 3D Hot Air Oven Cooking, Defrosting, Full Width Surface Grill, Center Surface Grill, Hot Air Grilling, Intensive Hot Air, Conventional Oven, Bottom Heat, HydroBaking, Intensive Conventional Heat, Keep Warm, Plate Warming and Low Temperature Cooking.

The iQ 700 is also super efficient, carrying energy rating of ‘A -30%’. Other features of this Siemens built-in oven include digital temperature display, illuminated retractable control dial, activeClean, softClose, heating-up indicator, actual temperature display, residual heat indicator, control panel lock, door locking option, automatic safety switch off, electronic oven clock timer, automatic on/off programmer, 2 interior lights, smooth enamelled oven interior, full glass inner door, heat reflective glass, memory setting, fast pre-heating function, Sabbath setting and 5 shelf positions. Seen in stores for approximately € 1300. Siemens.


Appliancist

Tags: Function, multi, Oven, Siemens

07 Nov 11 Excel Lookup Series #1: VLOOKUP Function 1st Example

See how to use the VLOOKUP function to deliver a value to cell: 1) Find approximate value from column 2 of lookup table. 2) Find exact value from column 2 of lookup table. Use Named Range, Data Validation and VLOOKUP to make your lookup more accurate. In This Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel. This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel. Excel Magic Trick 167p2 IF function formula: 12 Examples! Excel Magic Trick 167p1 IF function formula: 12 Examples!

Tags: Example, Excel, Function, Lookup, Series, VLOOKUP

04 Nov 11 Finding the Domain of a Function

Visit : bit.ly for your 14 day free trial at Thinkwell! Videos, Quizzes, Tests and More! Finding the domain of a function, without graphing. For more free math videos, visit PatrickJMT.com
Video Rating: 4 / 5

Tags: Domain, Finding, Function

07 Sep 11 Timetron blender with Pulse function

timetron-blender-fa-2542.jpg

The stylish Timetron blender comes with 2-speed 525 Watt motor, Pulse function, 1.3 litre glass jar and stainless steel blade. Available in two colours. Timetron.


Appliancist

Tags: Blender, Function, Pulse, Timetron

05 Jul 11 Excel Magic Trick 167p1 IF function formula: 12 Examples!

Part 1. See 12 different examples of how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can be used in formulas. Also see these functions: AND, OR, SUM, AVEARAGE, STDEVP, and VLOOKUP. See how to use the IF function to put: 1 of 2 numbers in a cell or formula. 1 of 2 words in a cell or formula. 1 of 2 text strings in a cell or formula. 1 of 2 formulas in a cell or formula. 1 of 2 functions in a cell or formula. 1 of 2 cell ranges in a cell or formula. How to have more than one IF (Nested IF Ifs). When to switch to the VLOOKUP function. How to build multiple criteria formulas with the IF function. How to use the AND function with the IF function. How to use the OR function with the IF function. Excel If statement Excel Magic Trick 165p2 MACRO Advanced Filter Extract B-days Other amazing videos at YouTube: Excel Trick, Making a Gantt Chart with Excel, Recording Macros – Excel 2003, VLOOKUP in Excel 2007.
Video Rating: 4 / 5

Tags: 167p1, Examples, Excel, Formula, Function, Magic, Trick

17 Feb 11 Excel Dynamic Chart #10: OFFSET Function Dynamic Range

See how to use the OFFSET function for two different types of dynamic ranges for a chart: 1)Dynamic Range that adds latest records 2)Dynamic Range that shows only last 4 Months of data Learn about named formulas that use OFFSET function to create dynamic ranges and see how to insert named ranges into a chart. Learn about the OFFSETs 5 arguments: 1)Starting point 2)How many rows (up or down) do you want to move the starting point? 3)How many columns (left or right) do you want to move the starting point? 4)How tall is the range? 5)How wide is the range?
Video Rating: 4 / 5

Real data are used to express the usefulness of a Moving Range (MR) control chart
Video Rating: 4 / 5

Tags: Chart, Dynamic, Excel, Function, OFFSET, Range