Posts Tagged ‘table’
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 »
Friday, March 23rd, 2012
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn how to:
1. See how to avoid the default VLOOKUP behavior and instead find a value in the first column of the lookup table that is closest to the lookup Value.
2. Because the increment between the values in the first column of the lookup table are the same, we can round to the nearest 0.25 using MROUND or ROUND functions and force the VLOOKUP to find the nearest value instead of the default behavior” between two values”
3. See how to use MROUND function to round the lookup value so you can find the nearest value in the first column of the lookup column
4. See how to use ROUND function to round the lookup value so you can find the nearest value in the first column of the lookup column
Lookup that rounds to the nearest number
Duration : 0:3:10
(more…)
Technorati Tags: 0.25, 2003, 2007, 2010, behavior, between, can, College, column, Community, default, Dragon, equal, excel, excelisfun, first, formula, formulas, function, functions, Girvin, Highline, in, increment, instead, Lookup, Mike, MROUND, Nearest, Number, of, Round, Rounded, rounds, same, Slaying, table, that, the, to, value, values, vlookup
Tags: 0.25, 2003, 2007, 2010, behavior, between, can, College, column, Community, default, Dragon, equal, excel, excelisfun, first, formula, formulas, function, functions, Girvin, Highline, in, increment, instead, Lookup, Mike, MROUND, Nearest, Number, of, Round, Rounded, rounds, same, Slaying, table, that, the, to, value, values, vlookup
Posted in Learn Excel Formulas | 8 Comments »
Tuesday, January 17th, 2012
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn how to deal with the situation where you can see that the lookup value is the same as a value in the first column of the lookup table, but it is not giving you a match:
1. Lookup Value has an extra space
2. 1st column in Lookup Table has extra spaces
3. Lookup Value is a number stored as text and 1st column in Lookup Table has numbers
4. Lookup Value is a number and 1st column in Lookup Table has numbers stored as text
Duration : 0:8:29
(more…)
Technorati Tags: 2007, 2010, an, AND, As, College, column, Community, Dragons, excel, excelisfun, extra, first, Gel, Girvin, has, Highline, in, Lookup, Matching, Mike, not, Number, numbers, Slaying, space, spaces, stored, table, text, Trouble, value, values, vlookup
Tags: 2007, 2010, an, AND, As, College, column, Community, Dragons, excel, excelisfun, extra, first, Gel, Girvin, has, Highline, in, Lookup, Matching, Mike, not, Number, numbers, Slaying, space, spaces, stored, table, text, Trouble, value, values, vlookup
Posted in Learn Excel Formulas | 11 Comments »
Friday, December 23rd, 2011
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
1. Learn about Proportions, Probabilities and Percentages: Formulas and Formatting.
2. See the COUNTIF function and Relative and Absolute Cell References for counting with 1 criteria
3. See how to create a Basic Frequency Table with Qualitative Data including a Relative or Percent Frequency column with Percentage Number Format.
This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin.
Duration : 0:10:31
(more…)
Technorati Tags: 2010, 210, Absolute, analysis, AND, Basic, business, Busn, cell, College, Community, COUNTIF, counting, criteria, data, Dragons, Economics, excel, excelisfun, for, Format, Formatting, formulas, FREQUENCY, function, Gel, Girvin, Highline, Including, Mike, Number, Percentages, Probabilities, Proportions, Qualitative, References, Relative, Slaying, Statistical, Statistics, table, with
Tags: 2010, 210, Absolute, analysis, AND, Basic, business, Busn, cell, College, Community, COUNTIF, counting, criteria, data, Dragons, Economics, excel, excelisfun, for, Format, Formatting, formulas, FREQUENCY, function, Gel, Girvin, Highline, Including, Mike, Number, Percentages, Probabilities, Proportions, Qualitative, References, Relative, Slaying, Statistical, Statistics, table, with
Posted in Learn Basic Excel | 4 Comments »
Friday, December 23rd, 2011
Create a connection to a SQL server table
Import data into excel as a table or pivot table report
Microsoft Office Excel 2007
Duration : 0:2:59
(more…)
Technorati Tags: 2007, amazing, Application, awesome, Basic, beginner, connection, cool, demonstration, easy, education, excel, experiment, function, Help, home, instructions, learn, made, Microsoft, Movie, office, program., programing, Really, Reel, server, sheet, SQL, table, teaches, teen, tips, to, training, tutorial, video
Tags: 2007, amazing, Application, awesome, Basic, beginner, connection, cool, demonstration, easy, education, excel, experiment, function, Help, home, instructions, learn, made, Microsoft, Movie, office, program., programing, Really, Reel, server, sheet, SQL, table, teaches, teen, tips, to, training, tutorial, video
Posted in Learn Basic Excel | No Comments »
Tuesday, December 6th, 2011
Today’s Dueling Podcast asks: “Can there be Dynamic Ranges for VLOOKUP and Data Validation List for an Invoice?” In Episode #1379, Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen look at using Table Nomenclature in Validation and in VLOOKUP.
Duration : 0:8:49
(more…)
Technorati Tags: accounting, business, Data Validation List, excel, MrExcel, spreadsheets, table, technology, tutorial, validation, vlookup
Tags: accounting, business, Data Validation List, excel, MrExcel, spreadsheets, table, technology, tutorial, validation, vlookup
Posted in Learn Excel Formulas | 3 Comments »
Wednesday, November 9th, 2011
MS Excel VBA – Using Application.Speech
If you need help regarding MS Excel or need an Excel freelancer, feel free to contact me at ExcelTutorJJ@gmail.com. You can download the workbook at http://www.box.net/shared/kh3n7te2zh. Feel free to add me on LinkedIn use the the e-mail address provided in the description
Make sure to change your video quality to 720P
Duration : 0:3:13
(more…)
Technorati Tags: accounting, analysis, Basic, business, excel, finance, financial, Macro, Pivot, Quickbooks, statistic, table, tutorial, vba, Visual
Tags: accounting, analysis, Basic, business, excel, finance, financial, Macro, Pivot, Quickbooks, statistic, table, tutorial, vba, Visual
Posted in Learn Excel Macros | No Comments »
Saturday, September 17th, 2011
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
Rotate Table:
1. See how to add blank formulas and a row with a zero lookup to the lookup table to help simplify the VLOOKUP function formula
2. See COLUMNS function to increment numbers in a formula to generate column index numbers for VLOOKUP function.
Duration : 0:6:27
(more…)
Technorati Tags: 2007, 2010, Add, AND, blank, College, column, COLUMNS, Community, Dragons, excel, excelisfun, formula, formulas, function, Gel, generate, Girvin, Help, Highline, how, in, increment, INDEX, Lookup, Mike, numbers, row, See, simplify, Slaying, table, the, to, vlookup, with, Zero
Tags: 2007, 2010, Add, AND, blank, College, column, COLUMNS, Community, Dragons, excel, excelisfun, formula, formulas, function, Gel, generate, Girvin, Help, Highline, how, in, increment, INDEX, Lookup, Mike, numbers, row, See, simplify, Slaying, table, the, to, vlookup, with, Zero
Posted in Learn Excel Formulas | 19 Comments »
Tuesday, August 30th, 2011
Using Excel Active X Control to bypass 30,000 limit when insert scroll bar
Currently studying for my CPA and hopefully I will be done in May, 2011. If you need assistance regarding MS Excel, feel free to contact me at jiejenn@gmail.com
You can download the video files at http://www.easy-share.com/f/1326079403/Youtube Video Files
Duration : 0:4:10
(more…)
Technorati Tags: accounting, Basic, business, excel, Macro, Pivot, Public, table, vba, Visual, vlookup
Tags: accounting, Basic, business, excel, Macro, Pivot, Public, table, vba, Visual, vlookup
Posted in Learn Excel Macros | No Comments »
Wednesday, August 24th, 2011
Learn how to make sense of your data in Excel by using Pivot Tables to quickly filter, summarize, and group your data into a table that is ideal for presentations and reports.
Duration : 0:6:19
(more…)
Technorati Tags: 2010, data, excel, Pivot, table
Tags: 2010, data, excel, Pivot, table
Posted in Learn Basic Excel | No Comments »
