Posts Tagged ‘Join’
Monday, April 23rd, 2012
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
This video is a part of VLookup Week: http://vlookupweek.wordpress.com
Excel VLOOKUP is one of the most important functions because everyone needs to look stuff up. Not only that, but if you want to get a job, you must know VLOOKUP.
In this video learn everything you need to know about VLOOKUP in 1 video.
Here are the topics (minute marks jump you to that part of the video):
1. VLOOKUP = V = Vertical ( min)
2. Why so common? Because everyone needs to look stuff up ( 00:43 min)
3. VLOOKUP Delivers a value to a cell: Extract Match ( 2:37 min)
4. VLOOKUP #N/A and IFERROR or IF ( 5:25 min)
5. VLOOKUP and Data Validation ( 8:10 min)
6. VLOOKUP with Named Range ( 10:34 min)
7. VLOOKUP as Formula Element ( 17:24 min)
8. HLOOKUP = H = Horizontal ( 18:25 min)
9. VLOOKUP Delivers a value to a cell: Approximate Match ( 19:40 min)
10. VLOOKUP with table on different sheet ( 24:00 min)
11. VLOOKUP with table in different workbook ( 25:56 min)
12. Show Full Record: Numbers above column header ( 27:15 min)
13. Show Full Record horizontally: COLUMNS Function ( 30:20 min)
14. Show Full Record vertically: ROWS Function ( 32:28 min)
15. Show Full Record: MATCH Functions ( 33:40 min)
16. Two Lookup Values: Add join column as first column in table ( 35:40 min)
17. Two Lookup Values: Join columns in formula and use CHOOSE function ( 38:50 min)
18. Partial Text Lookup: LEFT and SEARCH Functions ( 43:22 min)
19. Partial Text Lookup: MID Function ( 45:37 min)
20. Partial Text Lookup: RIGHT Function ( 48:08 min)
21. TRIM and VLOOKUP: Space in lookup value ( 48:57 min)
22. TRIM and VLOOKUP: Space in 1st column of table ( 51:03 min)
23. VLOOKUP with 3 lookup tables: CHOOSE Function ( 53:20 min)
24. VLOOKUP: Two Way Lookup with VLOOKUP and MATCH ( 58:36 min)
25. VLOOKUP: Variable Tax Rate, 3 VLOOKUPS in one formula ( 1:00:18 min)
26. VLOOKUP and Table feature for Dynamic ranges ( 1:05:17 min)
VLOOKUP Shark WEEK
Duration : 1:8:3
(more…)
Technorati Tags: 2003, 2007, 2010, Add, As, CHOOSE, College, column, COLUMNS, Community, different, Dragons, Element, excel, excelsifun, first, formula, function, functions, Girvin, Highline, HLOOKUP, Horizontal, in, Join, left, Lookup, match, MID, Mike, named, on, Partial, range, right(), ROWS, Search, Shark, sheet, Slaying, space, table, Tax, text, TRIM, Two, values, vlookup, Way, WEEK, workbook
Tags: 2003, 2007, 2010, Add, As, CHOOSE, College, column, COLUMNS, Community, different, Dragons, Element, excel, excelsifun, first, formula, function, functions, Girvin, Highline, HLOOKUP, Horizontal, in, Join, left, Lookup, match, MID, Mike, named, on, Partial, range, right(), ROWS, Search, Shark, sheet, Slaying, space, table, Tax, text, TRIM, Two, values, vlookup, Way, WEEK, workbook
Posted in Learn Excel Formulas | 25 Comments »
Wednesday, October 5th, 2011
See how to create a formula that will join the content of six cells and create Word Wrap using the TEXT and CHAR functions
Duration : 0:5:55
(more…)
Technorati Tags: AND, cells, CHAR, College, Community, content, Create, excel, functions, Gel, Girvin, Highline, Join, Mike, six, text, Word, Wrap
Tags: AND, cells, CHAR, College, Community, content, Create, excel, functions, Gel, Girvin, Highline, Join, Mike, six, text, Word, Wrap
Posted in Learn Excel Formulas | 5 Comments »
Thursday, September 1st, 2011
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn all about making calculations in excel with Formulas and Functions:
1. Math operators
2. Comparative operators
3. Calculating Formulas
4. Functions like: SUM, AVERAGE, MODE.SNGL, STEV.P, COUNTIF, COUNTIFS
5. Learn how to put comparative operators in double quotes to use in COUNTIF and COUNTIFS functions
6. Learn how to join comparative operator with Number in COUNTIFS formula
7. Text Formulas
8. Logical Formulas
9. Keyboard for SUM: Alt + =
10. Keyboard to jump to bottom of range: Ctrl + Arrow
11. Keyboard to highlight range: Ctrl + Shift + Arrow
This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin.
Duration : 0:29:31
(more…)
Technorati Tags: 2010, 210, Alt, analysis, Arrow, AVERAGE, business, Busn, calculating, College, Community, Comparative, COUNTIF, COUNTIFS, Ctrl, Double, Dragons, Economics, equal, excel, excelisfun, formulas, functions, Gel, Girvin, Highlight, Highline, Join, keyboard, Logical, math, Mike, MODE.SNGL, Operators, plus, quotes, range, shift, Slaying, Statistical, Statistics, STEV.P, SUM, text
Tags: 2010, 210, Alt, analysis, Arrow, AVERAGE, business, Busn, calculating, College, Community, Comparative, COUNTIF, COUNTIFS, Ctrl, Double, Dragons, Economics, equal, excel, excelisfun, formulas, functions, Gel, Girvin, Highlight, Highline, Join, keyboard, Logical, math, Mike, MODE.SNGL, Operators, plus, quotes, range, shift, Slaying, Statistical, Statistics, STEV.P, SUM, text
Posted in Learn Excel Formulas | 3 Comments »
Tuesday, March 8th, 2011
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to use the CHOOSE Function To “Mash” Join Columns from different sections of the spreadsheet in order to create one lookup table. CHOOSE uses an array constant to do this trick. Aladin, barry Houdini, DonkeyOte at Mr Excel Message Board. See the functions VLOOKUP and INDEX and MATCH
Duration : 0:7:24
(more…)
Technorati Tags: 2007, 2010, Aladin, array, At, barry, Board, by, CHOOSE, College, COLUMNS, Community, constant, Create, different, DonkeyOte, Dragons, excel, excelisfun, From, function, Gel, Girvin, Highline, Houdini, in, Join, left, Lookup, Mash, Message, Mike, Mr, of, one, Order, sections, Slaying, spreadsheet, table, the, to, using, vlookup
Tags: 2007, 2010, Aladin, array, At, barry, Board, by, CHOOSE, College, COLUMNS, Community, constant, Create, different, DonkeyOte, Dragons, excel, excelisfun, From, function, Gel, Girvin, Highline, Houdini, in, Join, left, Lookup, Mash, Message, Mike, Mr, of, one, Order, sections, Slaying, spreadsheet, table, the, to, using, vlookup
Posted in Learn Excel Formulas | No Comments »
Sunday, February 13th, 2011
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end.
Topics Covered In Video:
1. Equal Sign
2. Use Cell References for formula Inputs any time a number can change (like payroll data or an interest rate)
3. Numbers that can be typed into a formula (numbers that do not change)
4. Three ways to enter a formula (Mouse, Arrows, Typing)
5. Ampersand = Join Symbol (Shift + 7)
6. Calculating Formula
7. Text Formula
8. Search For Function using Insert Function dialog box
9. EFFECT and PMT finance functions
10. Format Cells Dialog Box
11. Currency Number formatting
12. General Number formatting
13. DOLLAR function for Text Formulas (applies Currency Formatting to number in text formulas)
14. Number Formatting is a façade that sits on the surface of the spreadsheet: the actual item (like a number) in the cell can be different than what you see on the surface of the spreadsheet.
Duration : 0:31:27
(more…)
Technorati Tags: 2010, 216, Ampersand, AND, applications, box, Busn, calculating, cell, class, College, Community, computer, currency, dialog, DOLLAR, EFFECT, excel, excelisfun, façade, finance, Formatting, formula, formulas, function, functions, Gel, Girvin, Highline, Inputs, Insert, Is, Join, Mike, numbers, office, OR, pmt, References, Symbol, text
Tags: 2010, 216, Ampersand, AND, applications, box, Busn, calculating, cell, class, College, Community, computer, currency, dialog, DOLLAR, EFFECT, excel, excelisfun, façade, finance, Formatting, formula, formulas, function, functions, Gel, Girvin, Highline, Inputs, Insert, Is, Join, Mike, numbers, office, OR, pmt, References, Symbol, text
Posted in Learn Excel Formulas | No Comments »
Tuesday, January 11th, 2011
See Mr Excel and excelisfun create five formulas that can retrieve a cell reference. See the functions: MATCH, ROW, ADDRESS, COLUMN, CELL, and SUBSTITUTE, and the Ampersand (join Symbol).
Duration : 0:5:13
(more…)
Technorati Tags: 2003, 2007, ADDRESS, Ampersand, Bill, can, cell, College, column, Community, excel, excelisfun, five, formulas, function, functions, Gel, Girvin, Highline, Jelen, Join, match, Mike, Mr, Reference, report, retrieve, row, SUBSTITUTE, Symbol, that
Tags: 2003, 2007, ADDRESS, Ampersand, Bill, can, cell, College, column, Community, excel, excelisfun, five, formulas, function, functions, Gel, Girvin, Highline, Jelen, Join, match, Mike, Mr, Reference, report, retrieve, row, SUBSTITUTE, Symbol, that
Posted in Learn Excel Formulas | 7 Comments »
Thursday, August 26th, 2010
See how to use the ADDRESS function to make labels in templates easier for user to understand. See how to use the Ampersand to join text and concatenate to make labels.
Duration : 0:8:1
(more…)
Technorati Tags: ADDRESS, Ampersand, AND, College, Community, concatenate, excel, function, Gel, Girvin, Highline, Join, Mike, text
Tags: ADDRESS, Ampersand, AND, College, Community, concatenate, excel, function, Gel, Girvin, Highline, Join, Mike, text
Posted in Learn Excel Formulas | 2 Comments »
Thursday, August 26th, 2010
See how to use the VLOOKUP function when you have two lookup values for each record. Learn how to use the IFERROR function also, and how to join two cells to add a new first column to the lookup table for the VLOOKUP function. Ampersand symbol to join cell content.
VLOOKUP with Two Lookup Values
VLOOKUP with 2 Lookup Values
VLOOKUP with Two Lookup_Value
VLOOKUP with 2 Lookup_Value
Duration : 0:4:54
(more…)
Technorati Tags: Ampersand, College, Community, excel, excelisfun, formula, function, Gel, Girvin, Highline, IFERROR, Join, Lookup, Mike, Symbol, Two, values, vlookup
Tags: Ampersand, College, Community, excel, excelisfun, formula, function, Gel, Girvin, Highline, IFERROR, Join, Lookup, Mike, Symbol, Two, values, vlookup
Posted in Learn Excel Formulas | 10 Comments »
