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

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

03 Nov 11 Multi Pro Excel Food processor FP980 by Kenwood

For more information please visit: www.kenwoodworld.com With over 60 years of expertise in making food preparation products, Kenwood has developed the multipro EXCEL, a striking, bold and powerful food processor for the serious cook. The multipro EXCEL demonstrates the pinnacle of high quality food processing, and introduces the unique TOTAL SYSTEM. This sytem means that the food processor, 1.5L glass liquidiser and glass multi mill can all work from one drive at optimum speed, offering true versatility in a space-efficient footprint. Whether creating a large feast or preparing small quantities, the multiple bowl system (4L, 2.9L & 1.75L) provides extra convenience and with an impressive 55 possible functions, this food processor can master numerous culinary tasks with professional results. *Kenwood products, accessories and attachments vary between country. Please visit www.kenwoodworld.com to view a full list of our products.
Video Rating: 4 / 5

Tags: Excel, Food, FP980, Kenwood, multi, Processor

31 Aug 11 Highline Excel Class 36: Array Formulas Basics

Topics for this video: 1)Learn about the basics of array formulas 2)Entering array formulas with Ctrl + Shift + Enter 3)Array syntax 4)Operations on ranges and arrays instead of cells or individual values 5)Create array formulas in single cells and save space in spreadsheet 6)Array formula for Total Sales SUM function array formula 7)Array formula for Minimum Change MIN function array formula 8)Array formula for Maximum Change MAX function array formula 9)Array formula for Expected Returns for a Portfolio of Stocks 10)Learn how to create array formulas with arrays that are the same dimension 11)Learn how to create array formulas with arrays that are different dimension 12)Learn how to use the SUMPRODUCT function for arrays with the same dimensions (commas) 13)Learn how to use the SUMPRODUCT function for arrays with different dimensions (multiplication symbol) This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109
Video Rating: 4 / 5

Tags: Array, Basics, Class, Excel, Formulas, Highline

16 Aug 11 E1.4 Absolute ($) Cell Referencing in Excel

Using ‘$’ to prevent excel from changing formulae when copying or filling ranges
Video Rating: 4 / 5

Tags: Absolute, Cell, E1.4, Excel, Referencing

10 Aug 11 Highline Excel Class 40: VLOOKUP 11 Unusual Examples

See these 11 VLOOKUP tricks: 1.VLOOKUP algorithm 2.VLOOKUP, Named Ranges, Exact Match, COLUMNS function& Data Validation List 3.Commission Calculation: VLOOKUP, Approximate match, 3 VLOOKUPS in one formula 4.VLOOKUP with TRIM function to remove spaces from first column of lookup table, add zero to convert text back to number 5.VLOOKUP with TRIM function to remove spaces from lookup value 6.VLOOKUP and Ampersand to create Product ID 7.VLOOKUP with Table on Different Sheet 8.VLOOKUP and MID function to extract part of text string for the lookup value 9.Partial Text VLOOKUP (Exact Match) with wildcards 10.Calculate Currency Exchange with VLOOKUP Into Currency Rate Web Query 11.VLOOKUP appears incorrect because of Formatting This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109
Video Rating: 4 / 5

Tags: Class, Examples, Excel, Highline, Unusual, VLOOKUP

05 Aug 11 Excel Magic Trick #230: Dynamic Stock Chart Excel Table List

See how to use the Excel List Table feature to make a dynamic Stock Price Line Chart. Excel 2003 create a List use Ctrl + L. Then the ranges in the table are dynamic. Excel 2007 create a Table use Ctrl + T Then the ranges in the table are dynamic.
Video Rating: 4 / 5

Iceland, an island of fire and ice, a land of geysers, volcanoes and lava deserts, remote and desolate, yet full of breathtaking natural beauty. The spectacle of numerous Solfatara formations ranges from fascinating bubbling mud holes to dramatic crevices that spew out hot steam. The sulphur laden mud pools can reach a temperature of up to 100 degrees Celsius. The surrounding terrain can suddenly give way, therefore the area can be extremely dangerous and should be approached with great caution. Although a tourist destination, Námaskard is far from overcrowded. This is most likely due to the ever present and highly obtrusive odor of sulphur expelled by its mud holes. The Námaskard region is not only one of the hottest areas of the island, it also forms the geological border between Europe and North America known as The Mid Atlantic Ridge. The scenery is indeed captivating and surreal and it is hardly surprising that countless myths and legends have been created on the island. Rising from the depths of the earth, the foul-smelling vapors of the Solfatara Fields and the volcanic surroundings of Námaskard probably once stimulated the imagination of the Vikings, Iceland’s original inhabitants. Just outside the small town of Grindavik, near the capital of Reykjavik, a more down to earth though sensual ritual takes place. The Blue Lagoon is one of the most popular bathing areas on the island. Surrounded by lava, the water of this picturesque lake is a constant 38 degrees

Tags: #230, Chart, Dynamic, Excel, List, Magic, Stock, Table, Trick

02 Aug 11 Excel Magic Trick #13: SUM or COUNT only certain items! SUMIF COUNTIF functions

See how to use the SUMIF and COUNTIF functions to add and count given a certain condition. With this trick you can add only the sales for the salesperson Tina — or count them! Also, see the super fast keyboard shortcut for naming multiple ranges. Count words text based on a Condition. Count words text based on criteria. SUM Values based on a Condition. SUM Values based on criteria.
Video Rating: 5 / 5

Tags: certain, Count, COUNTIF, Excel, Functions, Items., Magic, only, SUMIF, Trick

29 Jul 11 Excel 3.2 GPM Boiler Water Heater radiant heat Open loop system

Tags: boiler, Excel, Heat, Heater, Loop, Open, Radiant, system, WATER

25 Jul 11 Excel Magic Trick #130: 3 Dimensional Database in Excel

See how to use the Table and List feature with data Validation to create a 3-dementional database (dynamic ranges) in Excel. Also see how to average with more than one criterion: AVERAGEIFS and DAVERAGE functions.

Tags: #130, Database, Dimensional, Excel, Magic, Trick

20 Jul 11 The Basics for Excel 2003 – Data Entry

A viewer recently asked me to produce a couple of videos to demonstrate basic Excel processes. eg Data Entry. This is not an unusual request. Many of my clients ask (sheepishly) for a few tips on the “1st Steps” or “Basics” in Excel. In this video, I demonstrate the correct way to enter Text, numbers, dates & times, formulas & functions. To view all of my video lessons, I invite you to visit my website – www.thecompanyrocks.com/excels
Video Rating: 4 / 5

Tags: 2003, Basics, Data, Entry, Excel