Home
Videos like this “Mysteries of VLOOKUP Function Revealed! 15 Amazing Examples! (Excel Magic Trick 1514)”
Return Multiple Match Results in Excel (2 methods)
 
14:13
Quickly learn how to lookup one value in Excel and return multiple matches. VLOOKUP and INDEX & MATCH formulas always return the first match they find inside a data table. What if you wanted to return multiple matches? I'll show you two different methods: Method 1: Uses INDEX & AGGREGATE formulas. This doesn't require CSE (control shift enter) and it works on older Excel versions. Beginning: 1:31, End: 10:20 Method 2: Uses the relatively new TEXTJOIN formula (available in Excel 2016 Office 365) and requires CSE. Beginning: 11:40, End: 13:25 Pick the method you find easier to maintain. 🡻 Download the workbook here 🡻 https://www.xelplus.com/return-multiple-match-values-in-excel/ ★ Links to related videos: ★ VLOOKUP basics: https://youtu.be/E7gQ-PgYkMc INDEX MATCH basics: https://youtu.be/F264FpBDX28 Get Unique List: https://youtu.be/7fYlWeMQ6L8 TEXTJOIN: https://youtu.be/TMZEUlFGp1U ★★ My Online Excel Courses ★★ Courses ► https://courses.xelplus.com/ 🕮 Excel Resources I Recommend 🕮 https://www.xelplus.com/resources/ ✉ Subscribe & get my Excel top 10 tips and formulas e-book for free https://www.xelplus.com/free-ebook/
Views: 84259 Leila Gharani
Intermediate Excel Skills, Tips, and Tricks Tutorial
 
20:19
If you like this video, here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel Learn many of the intermediate skills, tips, and tricks that you'll need in order to be able to use Excel effectively. This is the second of several video tutorials on Excel. Please consider watching my other video: The Beginner's Guide to Excel. In this intermediate video you'll learn some advanced formatting tools such as conditional formatting, how to save time by using the Autofill Handle, the basics of formulas and functions, sorting and filtering, and a few random useful tips such as Freeze Panes. Find my whole Excel playlist here: http://bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents Click below for more information about some of the movies mentioned in this tutorial: Dirty Rotten Scoundrels: http://amzn.to/2xTpck1 The Princess Bride: http://amzn.to/2yk3tDc Ladyhawke: http://amzn.to/2xOhLsA Stardust: http://amzn.to/2yjJvs9 Young Sherlock Holmes: http://amzn.to/2xaJJNv Mystery Men: http://amzn.to/2yRmQ3r
MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different Countries
 
21:19
Download Excel START File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-LocaleStart.xlsx Download Zipped Folder with Text Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/TextFiles012.zip Download Excel FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-LocaleFinished.xlsx Download Power BI Desktop FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-LocaleFinished.pbix Download pdf Notes about Power Query: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-Locale.pdf Comprehensive video about using Locale Settings so that Power Query interprets Dates and Numbers from different parts of the world correctly. In this Video learn about how to use the “Using Locale…” Feature and Regional Settings to import Text Files from Different Countries so that Dates and Numbers in Different Formats can be interpreted correct, and the multiple Text Files and be Appended into a single table. Also see how to change the Locale settings on individual columns. Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor. Topics: 1. (00:15) Introduction 2. (00:25) Text Files from Different Countries have Different Date and Number Formats 3. (02:40) Change Regional Settings in Power Query and Power BI Desktop 4. (04:28) Using Locale… Feature on Single Columns to interpret Dates and Numbers Correctly 5. (06:50) Convert ISO Dates to Proper Dates in Power Query 6. (08:04) Power BI Desktop: Import Multiple Text Files with Different Date and Number Formats From Folder and Append. See 1) Create Table in Power BI Desktop, 2) Build Custom Function 3) Import Text Files From Folder and Append 7. (20:30) Summary Assigned Homework: Download pdf file with homework description: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-Homework-Start.docx Zipped Text Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-TextFilesForHomework.zip Example of Finished Homework in Excel: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-HomeworkFinishedExample.xlsx
Views: 6203 ExcelIsFun
Excel Magic Trick 1226: Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples)
 
22:32
Download File: http://people.highline.edu/mgirvin/excelisfun.htm Learn how to Compare 2 Lists, Extract Items In List 2 That are NOT in List 1: 1. (00:12) Problem Description and Intro To Topic 2. (01:57) Example 1: Method 1: MATCH function Helper Column, Sort Z to A, Copy and Paste 3. (04:15) Example 2: Method 2: Advanced Filter and Criteria Area with Empty Field Name and Logical Formula Criteria 4. (07:59) Example 3: Method 3: Automat Process with Excel 2010 or later Array Formula. See the Functions: IF, ROWS, ROW, MATCH, ISNA, INDEX, AGGREGATE, SUMPRODUCT. This Array Formula does not require Ctrl + Shift + Enter. 5. (15:29) Why you should NOT use IFERROR on Data Extract Array Formulas 6. (17:17) Example 4: Method 3: Automat Process with Excel 2007 or before Array Formula. See the Functions: IF, ROWS, ROW, MATCH, ISNA, INDEX, SMALL, SUMPRODUCT. This Array Formula DOES require Ctrl + Shift + Enter. 7. (18:25) Example 5: Method 2: Extract E-mails in List 1 that are NOT in List 2. 8. (19:35) Caveat about Advanced Filter: Be sure to NOT have data below Extract Area (because it will be deleted when you run Advance d Filter. 9. (20:24) Example 6: How to Extract Items that are in BOTH lists: Learn how to slight change the formula for all three methods. Use ISNUMBER rather than ISNA. Related Videos for Comparing Two Lists and Extracting Records: Other Excel Methods for Comparing Two Lists: Excel Magic Trick 1226: Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples) https://www.youtube.com/watch?v=9h1omv60MCA Excel Magic Trick 1229 Extract Items NOT in List 1: Conditional Format Unique Values & Sort by Color https://www.youtube.com/watch?v=E3_vMI3LjJU Excel Magic Trick 1441: Power Query to Extract Items In List 1 That Are NOT In List 2 https://www.youtube.com/watch?v=JztEKJ-XkCU Excel Magic Trick 1442: DAX Query & EXCEPT Function to Extract Items In List 1 That Are NOT In List 2 https://www.youtube.com/watch?v=lLMXFLr9Aeg
Views: 45082 ExcelIsFun
Vlookup simply explained
 
07:10
Simple explanation of vlookup function and made it easy for everyone to learn.
Views: 712935 Excel to Excel
E-DAB 03: Excel Data Analysis & BI Basics: Excel Spreadsheet Formulas Old School? Or Dynamic Arrays?
 
29:53
Download Start Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/E-DAB-03-FormulasStart.xlsx Download Finished Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/E-DAB-03-FormulasFinished.xlsx Pdf notes: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/E-DAB-03-Formulas.pdf This video #3 in this calss teaches about when and why to use Excel Spreadsheet Formulas for Data Analysis. We compare and Contract Old School Formulas to the new Office 365 Dynamic Array Formulas. We learn about SUMIFS, COUNTIFS and AVERAGEIFS for making Data Analysis Summary Reports.: This class : Data Analysis & Business Intelligence Made Easy with Excel Power Tools - Excel Data Analysis Basics = E-DAB Class – Sponsored by YouTube and taught by Mike Girvin, Highline College Instructor, Microsoft Excel MVP and founder of the excelisfun channel at YouTube. This is a free educational resource for people how want to learn about the Basics of Data Analysis and Business Intelligence using Microsoft Power Tools such as, PivotTables, Power Query, Power Pivot, Power BI Desktop and more. Topics: 1. (00:11) Introduction 2. (01:24) Excel Spreadsheet Formulas Uses in Data Analysis 3. (03:42) Change Default Settings for Table Formula Nomenclature (Structured References). 4. (04:39) Cell References in Formulas. 5. (04:39) Excel Functions to Make Calculations Based on one Condition, four examples: 6. (04:39) SUMIFS Function with One Condition shown on next page in cell H13 7. (08:54) SUMIFS Function with One Condition & Dynamic Array shown on next page in cell K13 8. (15:21) COUNTIFS Function with One Condition shown on next page in cell H24 9. (16:39) COUNTIFS Function with One Condition & Dynamic Array shown on next page in cell K24 10. (17:40) Excel Functions to Make Calculations Based on an AND Logical Text. 11. (17:54) SUMIFS for Summary Report Based on Adding, Old School Cell References and Dynamic Arrays. 12. (24:32)AVERAGEIFS for Summary Report Based on Averaging, Old School Cell References and Dynamic Arrays. 13. (27:52) COUNTIFS for Summary Report Based on Counting, Old School Cell References and Dynamic Arrays. 14. (28:40) Homework sheets. 15. (28:58) Summary The Power Query logo used in this video is copyright of and used with the express permission of https://powerquery.training Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!
Views: 10909 ExcelIsFun
Advanced PivotTables: Combining Data from Multiple Sheets
 
09:38
See companion tutorial and sample files on Tuts+: https://computers.tutsplus.com/tutorials/advanced-pivottables-combining-data-from-multiple-sheets--cms-21190. By Bob Flisser.
Views: 806342 Tuts+ Computer Skills
Excel Magic Trick 1515: Yearly Income Statement Using SUMIFS Function, and NO Merge & Center
 
06:46
Download Excel START File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1515Start.xlsx Download Excel FINISHED File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1515Finished.xlsx Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm In this video see how summarize the monthly Net Income Statement numbers into a Yearly Net Income Statement using the SUMIFS function. In the process, we will have to fix the Net Income Template and remove vthe Merge and Center feature and replace it with Center Across Selection.
Views: 6594 ExcelIsFun
How To Create An Excel Data Entry Form WITHOUT A UserForm
 
01:10:51
Learn The Excel Dashboard That Launched My Career Here: http://bit.ly/BestExcelDashboard Download Your FREE Excel Data Form Workbook From either of the following links: Using Your Email Here: http://bit.ly/DataEntryFrm_Wb With Facebook Messenger Here: http://bit.ly/DataEntryFrm_FbDl In this video I show you the Step-By-Step Process from beginning to end on how to create your very own Contact Manager Data Entry Form without requiring a UserForm. With this amazing 70 Minute Video Training You will Learn: ☑️ Add New, Save & Delete Records on Single Click ☑️ Create Data Mapping To Simplify your VBA Coding ☑️ Add, Size and Position Pictures anywhere you like ☑️ Create, Organize, Group & Display Buttons for your form ☑️ Load Form Data On Row Selection Got Excel Question? Let us help you with that, Join thousands of the worlds best Excel Experts in Facebook's fastest growing @Excel For Freelancers Group right here: http://bit.ly/groupexcel Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing on YouTube here: http://bit.ly/ExcelForFreelancers_FreeTraining I hope you love these videos, for More Free videos, personalized training and amazing tricks for freelancers, please find and follow us here: Twitter: https://twitter.com/RandyNAustin Website: https://www.ExcelForFreelancers.com LinkedIn: https://www.linkedin.com/in/excelforfreelancers/ Facebook: https://www.facebook.com/ExcelForFreelancers/
Views: 312834 Excel For Freelancers
Excel Macro Tutorial - Learn how macros can really speed up your work in Excel
 
09:39
Get FREE 28-page e-book "Record Your First Macro" here → https://www.launchexcel.com/get-excel-macros-ebook ----- // Episode Notes Read more at http://www.launchexcel.com/excel-in-first-gear This video is an introduction to the basics of Macros and VBA in Excel. When you see the power of macros you will want to learn how to use them yourself! Think of a macro as a tape recording. It remembers word for word what you "say" to Excel. VBA = Visual Basic for Applications. This is the language used by Excel to record macros. In the video we cover a simple use-case for the macro recorder: how to change your number formats. For an interesting example of pretty advanced VBA, check out the article on using Google Maps in Excel with VBA: http://www.launchexcel.com/google-maps-excel-demo/ This video uses this sound from freesound: ferrari355underhood4.mp3 by enginemusic -- http://www.freesound.org/people/enginemusic/sounds/43484/
Views: 698844 Launch Excel
Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports? Unbelievable! EMT 1520
 
09:16
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1518-1523.xlsx In this video learn about how to create a Fully Dynamic Cross Tabulated Report that can update when formula inputs are changed for Row Header Conditions or Column Headers Conditions and will instantly update when new data is added to the source data. This is all done with Formulas, NOT PivotTables, so everything updates instantly when source data or formula inputs change. See the New Array Functions SORT and UNIQUE, and also the older Array Function TRANSPOSE, but most fundamentally, we will see that the INDEX and MATCH Function can lookup columns of data based on formula inputs, and will be the secret ingredient that we use inside the SUMIFS function and also inside the UNIQUE Function. Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516) , https://www.youtube.com/watch?v=7jJMDGZpjSk Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm If you want totals for your dynamic Croos Tab report, check out this video: Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports With Totals!!!!! EMT 1528https://www.youtube.com/watch?v=wHeXjYQGvX8
Views: 8414 ExcelIsFun
Stunning Example for Vlookup and Hlookup in Excel in Hindi || Full Explanation Vlookup & Hlookup
 
10:13
Download Vlookup and Hlookup Practice Sheet Here: ► http://www.techguruplus.com/vlookup-and-hlookup-formula-in-excel-hindi/ My Instagram: ► https://www.instagram.com/TechGuruPlus ╔════════════════════════════════╗ Advance Excel All Videos ♠ https://www.youtube.com/playlist?list=PLAZbpmhZaCGfPYOe9ASCiS5cFSgnHYjmr All TDL Files for Tally ERP9 ♠ https://www.youtube.com/playlist?list=PLAZbpmhZaCGclmFoTecRKcJy4I4XDoIzC Tally ERP 9 All Videos ♠ https://www.youtube.com/playlist?list=PLAZbpmhZaCGd4Li45MLB8qzhSy1FvLZL1 My Channel: Tech Guru Plus All Videos ♠ https://www.youtube.com/playlist?list=PLAZbpmhZaCGdTEOxQYVO8_v-fdMZTwP6u ╚════════════════════════════════╝ Download 40 Invoice Format in Excel ► http://www.techguruplus.com/download-top-30-invoice-format-in-excel-xls/ Top 10: Advanced Excel Tips 2018 ► https://www.youtube.com/watch?v=I3NFERUdyg4 Top 20: Advanced Excel Tips 2018 ► https://www.youtube.com/watch?v=rP3y8jM2Eic Generate 100 Salary Slip in 1 Minute ► https://www.youtube.com/watch?v=anm59H3JIec Top 3: Advanced Excel Tips 2018 ► https://www.youtube.com/watch?v=yv85cuRND-4 Extraordinary Data Formatting (2018) with ADVANCE EXCEL ► https://www.youtube.com/watch?v=1BJQz1N3scs Advance Excel (2018): Making of "Stunning Invoice" with Spin Button ► https://www.youtube.com/watch?v=nCulnjxxI5Q MACRO (PART-1) Advanced Excel 2018 ► https://www.youtube.com/watch?v=15wKNSqUuiE MACRO (PART-2) Salary Dashboard with Macro & Command Button with Developer Tab ► https://www.youtube.com/watch?v=OaaxoX5Kdp0 "ADVANCE EXCEL" Blank Cell Formula-2018 (Powerful Technique) ► https://www.youtube.com/watch?v=5Jt_btS0MWM Amazing EMI Calculator in Excel (.xls file) || Make Bank Re-payment Schedule ► https://www.youtube.com/watch?v=oOJYtMWLrHg Convert Last Name to First Name in MS Excel with Text to Column Function ► https://www.youtube.com/watch?v=MTa3maLh4x8 "Gmail Advance" Hidden Feature-2018 (Powerful, Unique & Faster!!) ► https://www.youtube.com/watch?v=Y5HeduYd90Y Below 3 Query has been Resolved in this video:- (1). Vlookup Formula in Excel Hindi (2). Hlookup Formula in Excel in Hindi (3). Transpose Command in Excel in Hindi All Right Reserved © Tech Guru Plus This video is the copyright content of Tech Guru Plus (techguruplus) without permission using any of audio or visual of this content may bound us to take strict legal action against you. we will take further actions against any copyright Infringes. ★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★ Channel Owner: Nazim Khan [ Contact for- Brand Promotion / Sponsorship / Product Review ] ► [email protected][email protected] ★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★ Subscribe Here: https://www.youtube.com/TechGuruPlusIndia Website :► http://www.techguruplus.com Twitter :► https://twitter.com/TechGuruPlus Facebook :► https://www.facebook.com/TechGuruPlus Instagram :► https://www.instagram.com/TechGuruPlus ★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★ Please: Like ✔ Comment✔ Share ✔ Subscribe ✔ #TechGuruPlus
Views: 114926 Tech Guru Plus
Top 25 Excel 2016 Tips and Tricks
 
27:44
The Top 25 tips and tricks for Excel 2016. Use these tips and tricks to improve your efficiency using Excel. I am sure you will discover some that you have not seen before and others that you have been using incorrectly. My personal favorite is #21. Become more productive using Excel at work, school and home. Check out the Advanced Excel video at https://youtu.be/PU8ACyYxJBk. Another 15 Excel 2016 Tips & Tricks: https://youtu.be/L9SKTj2gevA Introduction to Excel for Beginners: https://youtu.be/WxUQLHJn77Q Contents: 1. Quick Analysis Tool 0:47 2. Filter 1:44 3. Drop-Down List 2:25 4. AutoFit Column Width 3:12 5. Transpose 3:47 6. Remove Duplicates 4:13 7. Goal Seek 5:23 8. VLOOKUP 6:55 9. Flash & Auto Fill 9:06 10. Paste Special Values 10:47 11. Images in Charts 11:50 12. IF Function 12:28 13. Insert Screenshot 13:40 14. Absolute Cell Reference 14:15 15. Show Formulas 15:54 16. Text to Columns 16:57 17. Conditional Formatting 18:11 18. PowerPivot 19:36 19. Freeze Panes 20:46 20. Ctrl-Arrow Keys 21:40 21. 3D References 21:58 22. Forecast Sheet 23:43 23. SUMIFS Function 24:16 24. IFERROR Function 25:38 25. Filled Maps 26:30
Views: 1384845 Sele Training
Excel For Accountants: VLOOKUP & PivotTables Complete Lessons: Basic to Advanced: CWU Seminar
 
01:32:45
Download Files: Start File: http://people.highline.edu/mgirvin/YouTubeExcelIsFun/ExcelForAccountantsVLOOKUPivotTablesSTART-FILE.xlsx Finished File: http://people.highline.edu/mgirvin/YouTubeExcelIsFun/ExcelForAccountantsVLOOKUPivotTablesFINISHED-FILE.xlsx Link Page with all files for all videos: http://people.highline.edu/mgirvin/excelisfun.htm Comprehensive Lessons for VLOOKUP and PivotTables. Lessons in Number Formatting, Keyboard Shortcuts and general Excel Efficiency Tricks throughout video. Topics in video: (00:01) Introduction (01:45) Why lookup is so common 1. (03:45) Exact Match VLOOKUP to get Product Price & Data Validation Dropdown List 2. (12:32) VLOOKUP & IFERROR Functions to build Invoice. Learn about Relative and Absolute (Locked) Cell References. 3. (23:05) Approximate Match VLOOKUP to get Commission Amount. Discussion of importance of Number Formatting in Excel. 4. (31:47) Approximate Match VLOOKUP to get Commission Rate. More about Number Formatting. Learn about General Number Formatting to wipe away all Number Formatting. 5. (34:43) Approximate Match VLOOKUP to get Tax Amount 6. (35:30) Approximate Match VLOOKUP add Helper Column to Payroll Data Set. 7. (41:45) VLOOKUP & MATCH function to retrieve an Employee Record 8. (49:45) VLOOKUP "Helper Column" to "Extend" Data Set for Complicated Reports. See 5 examples of Helper Columns to build complete Data Set for a PivotTable Report. 9. (58:25) Introduction to PivotTables as the best tool to take data in a Proper Data Set and create Summary Reports that contain Calculations with Conditions or Criteria. Learn how to use Tabular Report Layout and how to add Number Formatting to a PivotTable. 10. (01:09:01) Create Cross Tabulated PivotTable Reports. This is a PivotTable Summary Report that has Calculations made with two Criteria. 11. (01:11:20) Pivoting a PivotTable 12. (01:15:30) Add Slicer to PivotTable. This is a PivotTable Summary Report that has Calculations made with three Criteria. Discussion about logic of criteria and how it applies to PivotTable. 13. (01:17:40) Create PivotTable Reports for Large Data Sets on a New Sheet. 14. (01:19:40) Grouping Dates by Year and Month 15. (01:21:32) Using Show Values As to Create % Change Reports 16. (01:25:45) PivotTable to show Total, Average, Min and Max Values for each Region (01:30:43) Summary of all 16 examples Excel for Accountants. How to Use VLOOKUP in Accounting. How to Use PivotTables in Accounting. CWU Excel Lessons. CWU Excel. Central Washington Excel. CWU Lynwood Excel. Central Washington Excel at Lynnwood.
Views: 206231 ExcelIsFun
5 Bite-Size Vlookup Tricks for Excel - Workbook Included
 
12:59
Excel File: https://www.teachexcel.com/excel-tutorial/2056/5-bite-size-vlookup-tricks-for-excel?nav=yt Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt 5 tricks for using Vlookup on data that might not always be 'friendly.' This includes: Removing extra spaces. Working with multi-part lookup values. Dealing with Vlookup errors. Removing extra characters. Fixing Text/Number value issues.
Views: 5612 TeachExcel
How to do a Vlookup in Excel - Learn how in 5 minutes!
 
05:36
http://www.howtovlookupinexcel.com. This is a video tutorial which shows you how to use the vlookup function in Microsoft Excel to quickly retrieve data. It works in all versions of Excel including Excel 2003, Excel 2007, Excel 2010 and Excel 2013. We also cover 10 reasons why your vlookup may not work on this website: http://howtovlookupinexcel.com/10-common-problems-with-vlookups/
Views: 392343 Excel Stuff
MSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, More
 
01:07:27
Download Excel START Files: Excel Start: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/009-MSPTDA-ValuesExpressionsFunctions-Start.xlsx Zipped Folder: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/009-ParameterQueryTables.zip Download Excel FINISHED Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/009-MSPTDA-ValuesExpressionsFunctions-Finished.xlsx Download pdf Notes about Power Query: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/009-MSPTDA-ValuesExpressionsFunctions.pdf Assigned Homework - these are problems for you to practice your new M Code skills: Download Excel File with Homework: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/009-MSPTDA-Homework-Start.xlsx Example of Finished Homework: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/009-MSPTDA-Homework-Finished.xlsx In this Video learn the basics of M Code, the computer language behind queries in Power Query. Topics: 1. (00:15) Introduction 2. (03:46) Edit M Code: Applied Steps 3. (03:46) Edit M Code: Formula Bar 4. (03:46) Edit M Code: Advanced Editor 5. (09:50) Expressions 6. (09:50) let expressions 7. (17:34) Comments in M Code 8. (21:11) Values: Primitive, List, Record, Table, Function 9. (30:45) Lookup or Projection and Selection. Learn about Row Index Lookup and Key Match lookup 10. (42:50) Primary Keys 11. (50:20) Custom Functions 12. (57:44) Parmenter Queries 13. (01;02:27) Underscore Character _ 14. (01:06:17) Summary Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Views: 17527 ExcelIsFun
Advanced Excel - Using the IF Function in Excel to Program Your Spreadsheets
 
05:43
Learn how to use the IF function in Excel to "program" your spreadsheets to show you certain data. You can create If ________ then _______ statements that can produce powerful results in Excel. #excel #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents
VLOOKUP EXPLAINED - 2 Practical Excel Lookup Examples
 
12:16
Quickly learn the ins and outs of Excel's VLOOKUP formula. I show 2 practical examples of the VLOOKUP formula. I also explain why your VLOOKUP formula might not be working correctly. Summary: The Excel VLOOKUP formula looks up a value in an Excel table and returns a value from an adjacent column. "V" stands for vertical lookup. This is one of most common lookup functions in Excel. If your data table is not sorted, it's important to look for an exact match - this means you can't omit the last argument of vlookup. You need to set that argument to "false" or to 0. 🡻 Download the workbook here 🡻 https://www.xelplus.com/basics-vlookup-hlookup/ ★ Links to related videos: ★ For reverse or 2-way lookup problems use INDEX & MATCH: https://youtu.be/F264FpBDX28 Relative & Absolute referencing: https://youtu.be/FRu48zy-Djk ★★ My Online Excel Courses ★★ Courses ► https://courses.xelplus.com/ 🕮 Excel Resources I Recommend 🕮 https://www.xelplus.com/resources/ ✉ Subscribe & get my Excel top 10 tips and formulas e-book for free https://www.xelplus.com/free-ebook/
Views: 86815 Leila Gharani
Top 15 Advanced Excel 2016 Tips and Tricks
 
22:07
This is a continuation of my Top 25 Excel 2016 Tips & Tricks. It includes more advanced features and some additional tricks to help you become more productive using Excel and Office 365. Check out the original Excel 2016 video at https://youtu.be/EdnAeqxqdzM. Another 15 Excel 2016 Tips 7 Tricks: https://youtu.be/L9SKTj2gevA Contents: 1. Advanced Transpose 0:39 2. Calendar Picker 1:38 3. Slicers 3:05 4. Scenario Manager 4:22 5. CONVERT Function 7:09 6. Convert Currency Live 8:03 7. Hide Cells 10:14 8. Remove Blanks 10:48 9. People Graph 11:17 10. Track Changes 12:40 11. Advanced Filter 15:10 12. Analysis Tools 17:52 13. NETWORKDAYS Function 18:51 14. Embedding 19:38 15. Advanced Select 20:50
Views: 1019640 Sele Training
How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX
 
15:54
When you need to find and extract a column of data from one table and place it in another, use the VLOOKUP function. This function works in any version of Excel in Windows and Mac, and also in Google Sheets. It allows you to find data in one table using some identifier it has in common with another table. The two tables can be on different sheets or even on different workbooks. There is also an HLOOKUP function, which does the same thing, but with data arranged horizontally, across rows. See the companion tutorial on Tuts+ at https://computers.tutsplus.com/tutorials/how-to-extract-data-from-a-spreadsheet-using-vlookup-match-and-index--cms-20641. By Bob Flisser.
Views: 2820353 Tuts+ Computer Skills
Excel Magic Trick 1316: VLOOKUP with Multiple Lookup Tables: IF, INDIRECT, SWITCH, IFS, or CHOOSE?
 
15:52
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to use VLOOKUP when there are multiple Lookup Tables with these methods: 1. (00:15) Problem Set up 2. (01:48) IF Function 3. (05:57) IFS Function (Excel 2016 Insider Program) (Formula from XLarium at YouTube) 4. (08:47) SWITCH Function (Excel 2016 Insider Program) 5. (11:26) Names Ranges & INDIRECT Function? 6. (15:15) Summary
Views: 83128 ExcelIsFun
Introduction to Power Query & Power Pivot Data Model in Excel 2016 (Excel Magic Trick 1468)
 
50:06
Download Excel File #1: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1468.xlsm Download Excel File #2: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1468Finished.xlsm Download Zipped Folder: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1468TextFiles.zip Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm Buy excelisfun products: https://teespring.com/stores/excelisfun-store Learn about how Topics: 1. (00:16) Introduction 2. (00:51) Discussion about the two different Data Ribbon Tabs and Get & Transform groups that you may see in Excel 2016 3. (03:51) Example #1: Clean Data and create Excel PivotTable Report, then add new data and refresh report! 4. (17:06) Example #2: Transform Cross Tabulated Table into Proper Data Set 5. (21:50) Example #3: Import 1.2 Million Rows of Data from Text Files into Power Pivot and create a Data Model PivotTable, then add new data and refresh our report. 6. (22:34) Diagram to understand Data Model and Power Pivot 7. (46:46) Unhanded Exception Error. 8. (48:02) Summary Reference Video: Highline Excel 2016 Class 03: Data Analysis Fundamentals: PivotTables, Power Query & Data Model https://www.youtube.com/watch?v=Jzt-I4mt8sQ
Views: 216413 ExcelIsFun
How to use VLookup to get multiple values
 
12:54
How to use VLookup to get multiple values from a data table with VBA automatically. Details: https://www.exceltrainingvideos.com/how-to-use-vlookup-to-get-multiple-values/
Views: 259062 Dinesh Kumar Takyar
Index Formula in Excel - Vlookup से भी Powerful कैसे है ये index function - देखिये
 
07:18
Index Formula in Excel - See how to use the INDEX function to lookup something in a table based on given a row position and column position. Yes, it's true: You can look something up at the intersecting cell given a row number and a column number! Understand how to use INDEX formula, what is its syntax, how it can help you extract and analyze any data. and index is very powerfull with match function. and also its very powerfull than vlookup. VLOOKUP VIDEO SERIES: 1. vlookup in excel with example in Hindi https://youtu.be/S2rF6bHIbdA 2. How to use vlookup for multiple values || Trick to use vlookup for large data https://youtu.be/oSE4wSy02s8 3. Vlookup in multiple sheets in excel || In Hindi https://youtu.be/fpslxPp3_Cw 4. How To Use Double VLookup in Excel-Nested vlookup https://youtu.be/REBdKbbvwG0 5. Dynamically Updated Vlookup Formula in Excel https://youtu.be/IHD6XIDrCfk 6. How To Use Vlookup With Multiple Excel Workbooks https://youtu.be/CiHIbsRM3cg 7. VLOOKUP With MATCH Function In Excel https://youtu.be/O19XraNl9ZQ 8. HLOOKUP in excel with example in Hindi https://youtu.be/DyH3PY3qbIE 9. Hlookup With Match Function in Excel in Hindi https://youtu.be/JIN0NBVuEsg Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं ________________________________________________ ADVANCED MS EXCEL ► https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS ► https://goo.gl/bbHYu2 MS WORD ► https://goo.gl/B4TeSA HTML5 & CSS3 ► https://goo.gl/2PFgs8 COMPUTER Tips & Tricks ► https://goo.gl/paZmpn --------------------------------------------------------------------------- --------------------------------------------------------------------------- Subscribe to my channel ► https://www.youtube.com/deepakeduworld Like my Facebook page ► https://www.facebook.com/deepakeduworld Follow on LinkedIn ► https://www.linkedin.com/in/deepakeduworld Facebook Group ► https://www.facebook.com/groups/cse92/ ********************************************** Thanks for Watching Happy Learning ER DEEPAK NEHRA [ M.Tech. ] **********************************************
Views: 101370 Deepak EduWorld
Excel Magic Trick 1500: Lookup All Products For Supplier & Join in Single Cell TEXTJOIN & IF
 
05:54
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1499-1500.xlsx Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm In this video learn how to lookup a supplier name in a lookup table and return all the products in a single cell. This is a Text Formula that is also an Array Formula. This formula uses the IF Function and the TEXTJOIN Function. List all Products in Single Cell. TEXTJOIN Function, Array Formula. Text Formula.
Views: 4942 ExcelIsFun
Using VLOOKUP with large tables | Excel | lynda.com
 
03:44
Learn about using VLOOKUP functions with large tables in Excel. Watch more Excel tutorials at http://www.lynda.com/Excel-tutorials/Using-VLOOKUP-large-tables/126129/135753-4.html?utm_campaign=aeh_lkAnxAU&utm_medium=social&utm_source=youtube-earned This tutorial is from the Excel 2013 Tutorials: Advanced Formulas and Functions course presented by lynda.com author Dennis Taylor. In the complete course, Dennis demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use. Connect with lynda.com: Facebook: http://bit.ly/fbldc Twitter: http://bit.ly/ldctw Google Plus: http://bit.ly/gplusldc LinkedIn: http://bit.ly/linkldc
Views: 52160 LinkedIn Learning
Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel
 
13:10
In this Excel tutorial I show you how to lookup values from multiple Excel Sheets or tabs. In Excel it's relatively easy to lookup values in one specific tab. But how do you lookup values in multiple tabs using just one single formula? In the video, I show you different versions of getting this done. One version uses VLOOKUP and direct worksheet and cell references. The other version uses INDEX & MATCH and Excel table names and references. The key here is the INDIRECT function which acts as the messenger which returns the correct address to the different lookup formulas. Of course, you can apply this (indirect) method inside other formulas. 🡻 Download the workbook here: http://www.xelplus.com/lookup-values-across-multiple-worksheets-excel/ Links to related videos: VLOOKUP explained ► https://youtu.be/E7gQ-PgYkMc INDEX MATCH Basics ► https://youtu.be/F264FpBDX28 INDIRECT explained ► https://youtu.be/GUClkvJ7Gag ★ My Online Excel Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel
Views: 125279 Leila Gharani
Learn Vlookup Formula For Beginners in Excel
 
07:50
Vlookup formula is the most used formula in Excel and is used to lookup data in MS Excel. Vlookup formula is very easy use and can be learnt in just under 5 minutes . See this video and you will be able to learn Vlookup in the easiest manner possible . 10 Most Used Formulas MS Excel https://www.youtube.com/watch?v=KyMj8HEBNAk Learn Basic Excel Skills For Beginners || Part 1 https://www.youtube.com/watch?v=3kNEv3s8TuA 10 Most Used Excel Formula https://www.youtube.com/watch?v=2t3FDi98GBk **Most Imporant Excel Formuls Tutorials** Learn Vlookup Formula For Beginners in Excel https://www.youtube.com/watch?v=vomClevScJQ 5 Excel Questions Asked in Job Interviews https://www.youtube.com/watch?v=7Iwx4AMdij8 Create Speedometer Chart In Excel https://www.youtube.com/watch?v=f6c93-fQlCs Learn the Basic of Excel for Beginners || Part 2 https://www.youtube.com/watch?v=qeMSV9T1PoI Create Pareto Chart In Excel https://www.youtube.com/watch?v=2UdajrDMjRE How to Create Dashboard in Excel https://www.youtube.com/watch?v=RM8T1eYBjQY Excel Interview Questions & Answers https://www.youtube.com/watch?v=Zjv1If63nGU To watch more videos and download the files visit : http://www.myelesson.org To Buy a Excel Course DVD visit : http://www.myelesson.org/products 10 Most Used Formulas MS Excel https://www.youtube.com/watch?v=KyMj8HEBNAk Learn Basic Excel Skills For Beginners || Part 1 https://www.youtube.com/watch?v=3kNEv3s8TuA 10 Most Used Excel Formula https://www.youtube.com/watch?v=2t3FDi98GBk **Most Imporant Excel Formuls Tutorials** Learn Vlookup Formula For Beginners in Excel https://www.youtube.com/watch?v=vomClevScJQ 5 Excel Questions Asked in Job Interviews https://www.youtube.com/watch?v=7Iwx4AMdij8 Create Speedometer Chart In Excel https://www.youtube.com/watch?v=f6c93-fQlCs Learn the Basic of Excel for Beginners || Part 2 https://www.youtube.com/watch?v=qeMSV9T1PoI Create Pareto Chart In Excel https://www.youtube.com/watch?v=2UdajrDMjRE How to Create Dashboard in Excel https://www.youtube.com/watch?v=RM8T1eYBjQY Excel Interview Questions & Answers https://www.youtube.com/watch?v=Zjv1If63nGU
Views: 1127412 My E-Lesson
Excel for Accountants: Formulas, Functions & Formatting to Build Account Templates (37 Examples)
 
01:37:02
Download File: Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/WAATP2017TacomaAccountingExcelConferenceStart.xlsx Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/WAATP2017TacomaAccountingExcelConferenceFinished.xlsx Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm Excel Accounting Seminar: 2017 WAATP Tacoma Accounting Conferences at La Quinta Inn, July 12 This is the first video in a series of two videos. This video will teach you everything you need to know about Excel for your Accounting Job : ) Topics in Video: (00:08) Introduction to video topics and Excel files and how to navigate large workbook and video 1. (02:13) Keyboards Rule Because They Are Fast 2. (04:33) Number Formatting is a Façade 3. (07:01) How to Add Quickly 4. (10:15) Date Calculation Templates 5. (10:50) TODAY and (19:50) EDATE functions 6. (12:24) Angry Rabbit Mouse Copy Trick 7. (14:46) Date Number Formatting 8. (17:05) Formulas for Date Calculations 9. (20:21) Absolute & Relative Cell References 10. (22:15) Excel's Golden Rule 11. (24:46) Payroll Quickly 12. (24:46) ROUND Function Importance 13. (24:46) Formulas Can NOT See Number Formatting 14. (31:40) Create Cosumer Loan Amortization Table 15. (33:13) PMT Function to calculate PMT on Annuity with Regular PMT and Constant Rate 16. (36:44) Fill Series to generate list of numbners from 0 to 360 17. (38:51) Smart Tags to Fill End of Month Only (And it knows Leap Year!!!) 18. (40:01) Borders to enhance Report 19. (42:48) Calculations for Amortization Table with Relative and Absolute Cell References 20. (47:10) Invoice Template 21. (47:24) VLOOKUP Function 22. (52:40) Data Validation, List to add Drop-Down List to Cell 23. (54:32) IF Function 24. (54:32) ISBLANK Function 25. (24:46) ROUND Function (link back to earlier part of video) 26. (01:02:35) FV of Investment Template 27. (01:02:35) Mixed Cell References 28. (01:05:50) F4 Key to cycle through 4 different types of Cell References (Merry Go Round) 29. (01:08:05) FV Function 30. (01:11:00) SUMIFS and COUNTIFS to create Summary Reports. Also: Advantage of Formulas Over PivotTable. 31. (01:18:38) Check Book Register Example 32. (01:19:02) Border Formatting 33. (01:20) Formula with Relative Cell References to calculate Balance 34. (01:21:29) IF Function 35. (01:21:29) ISNUMBER Function 36. (01:23:44) 1) Data Validation For Reconciling Column. 2) Conditional Formatting for whole row using Mixed Cell References 37. (01:29:50) Flash Fill to extract and clean Data Quickly Learn Excel Basics, Learn how to build Accounting Templates, Learn Excel Tricks for your Accounting Job. Event Sponsored by: Puget Sound/Tacoma Chapter WAATP Vice President Darlene Sondergaard Location: La Quinta Inn 1425 E 27th St, Tacoma, WA 98421 Event Details: Wednesday, July 12 at 8 AM
Views: 175947 ExcelIsFun
How to use Excel Index Match (the right way)
 
11:32
Quickly learn all you need to know about INDEX & MATCH to get a quick start. Complete Excel Dashboard course: https://courses.xelplus.com/p/professional-excel-dashboards Check out my other courses below. Download workbook here: http://www.xelplus.com/excel-index-and-match How to do Index Match in Excel: The basics. Watch this video tutorial to find out how you can use Index & Match for more complex lookup problems. This video shows you how Index Match works with simple and to the point explanation. It first shows you how Index works on it's own and then how Match works and then puts the two Excel functions together. Why index match is better than vlookup & why use index match instead of vlookup? Here are 3 reasons why Excel experts generally substitute VLOOKUP with INDEX and MATCH. 1. Unlike VLOOKUP, which searches only to the right, INDEX and MATCH can look in both directions – left and right. 2. INDEX & MATCH can perform two-way lookups by both looking along the rows and along the columns to find the intersection within a matrix. 3. INDEX & MATCH is less prone to errors. Assume you have a VLOOKUP where the final value you want returned is in column N. Your lookup value is in column A. You need to highlight the entire A to N range and then provide your index number to be 14. If you happen to delete any of the in-between columns, you would have to update that index number. You don’t need to worry about this when you use INDEX & MATCH. All in all, INDEX and MATCH is more flexible than VLOOKUP. Here are some of the reasons why Excel experts generally substitute VLOOKUP with INDEX and MATCH. Note: Index match is not case sensitive Index explained: The first argument of INDEX is to give it an array. This array (range) should include your answer. You then need to specify how many rows to go down and how many columns to move to find the correct value. You cannot move outside the INDEX range. The syntax of INDEX is: • The range where the return value resides. • Number of rows to move down (the row index) • Number of columns to move to the right (the column Index). This argument is optional. If you only have one column, you can leave the column argument empty, otherwise, you need to specify the number of columns to move over, in the range. The MATCH function’s syntax is as follows: • Like VLOOKUP, Match needs a lookup (target) value. The user can reference a cell or directly type the value into the formula. • Lookup_array: The “list” (range) where the return values are located. • Match_type: 0 for an “exact” match. Index MATCH used together: When INDEX and MATCH are used together, the MATCH function finds the look up value’s row / column index and then hands this value off to the INDEX function to get the lookup value. ★ My Online Excel Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel
Views: 558167 Leila Gharani
Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula?
 
09:02
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to do a VLOOKUP to a different Sheet using: 1. Sheet References 2. Defined Names 3. Table Formula Nomenclature (Structured References)
Views: 681478 ExcelIsFun
10 Most Used Excel Formula ☑️
 
16:40
10 Most Used Excel Formula. If you learn these 10 Excel formulas then you would be able to do more than 70% of your work in Excel ! So just watch this 1 video in excel and know almost 70% of excel ! 10 Most Used Formulas MS Excel https://www.youtube.com/watch?v=KyMj8HEBNAk Learn Basic Excel Skills For Beginners || Part 1 https://www.youtube.com/watch?v=3kNEv3s8TuA 10 Most Used Excel Formula https://www.youtube.com/watch?v=2t3FDi98GBk **Most Imporant Excel Formuls Tutorials** Learn Vlookup Formula For Beginners in Excel https://www.youtube.com/watch?v=vomClevScJQ 5 Excel Questions Asked in Job Interviews https://www.youtube.com/watch?v=7Iwx4AMdij8 Create Speedometer Chart In Excel https://www.youtube.com/watch?v=f6c93-fQlCs Learn the Basic of Excel for Beginners || Part 2 https://www.youtube.com/watch?v=qeMSV9T1PoI Create Pareto Chart In Excel https://www.youtube.com/watch?v=2UdajrDMjRE How to Create Dashboard in Excel https://www.youtube.com/watch?v=RM8T1eYBjQY Excel Interview Questions & Answers https://www.youtube.com/watch?v=Zjv1If63nGU To watch more videos and download the files visit http://www.myelesson.org To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788 Connect with us on Facebook - https://www.facebook.com/excelmadeasy/ Connect with us on Twitter - https://twitter.com/Excelmadeasy 10 Most Used Formulas MS Excel https://www.youtube.com/watch?v=KyMj8HEBNAk Learn Basic Excel Skills For Beginners || Part 1 https://www.youtube.com/watch?v=3kNEv3s8TuA 10 Most Used Excel Formula https://www.youtube.com/watch?v=2t3FDi98GBk **Most Imporant Excel Formuls Tutorials** Learn Vlookup Formula For Beginners in Excel https://www.youtube.com/watch?v=vomClevScJQ 5 Excel Questions Asked in Job Interviews https://www.youtube.com/watch?v=7Iwx4AMdij8 Create Speedometer Chart In Excel https://www.youtube.com/watch?v=f6c93-fQlCs Learn the Basic of Excel for Beginners || Part 2 https://www.youtube.com/watch?v=qeMSV9T1PoI Create Pareto Chart In Excel https://www.youtube.com/watch?v=2UdajrDMjRE How to Create Dashboard in Excel https://www.youtube.com/watch?v=RM8T1eYBjQY Excel Interview Questions & Answers https://www.youtube.com/watch?v=Zjv1If63nGU
Views: 1863727 My E-Lesson
Advanced Excel - VLOOKUP Basics 2017 Tutorial
 
11:58
If you like this video, here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel In this advanced Excel tutorial you'll learn how to get started using the VLOOKUP function in Excel. VLOOKUP can help you pull specific information from a spreadsheet based upon a piece of information that you know, for example a part number, title, name, etc. The video mentions a great book called A Wrinkle in Time, and if you're interested in learning more about it, click the link below: http://amzn.to/2BGsJoA ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents
VLOOKUP Function Beginner to Advanced 26 Examples: How To Use Excel VLOOKUP Function
 
01:08:03
Download Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/VLOOKUP-SHARK-WEEK-DoawnloadableWorkbook01-Start.xlsx Download Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/VLOOKUP-SHARK-WEEK-DoawnloadableWorkbook01-FINISHED.xlsx Entire Page with All Files for All Videos: https://people.highline.edu/mgirvin/excelisfun.htm Then scroll down to this section: "VLOOKUP "Shark" Week Downloadable Workbooks" Look for the file named: VLOOKUP-SHARK-WEEK-DownloadableWorkbook01-Start.xlsx Buy excelisfun products: https://teespring.com/stores/excelisfun-store 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 How To Use Excel VLOOKUP Function Learn Excel VLOOKUP Function VLOOKUP made easy Excel VLOOKUP Excel VLOOKUP Function
Views: 2437623 ExcelIsFun
Excel Magic Trick 1481: Multiple Table Lookup: SWITCH or INDIRECT Function? VLOOKUP too
 
11:39
Download Files: Start Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1479-1481.xlsx Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htmLearn about how to In this video learn how to how to perform lookup from multiple tables. Learn two methods: 1) VLOOKUP and SWITCH Function or 2) VLOOKUP and INDIRECT Function with Defined Names. 1) (00:01) Introduction 2) (01:30) VLOOKUP and SWITCH Function (New Excel 2016 Office 365 Function) 3) (07:20) VLOOKUP and INDIRECT Function with Defined Names. 4) (11:06) Summary
Views: 11743 ExcelIsFun
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
 
14:48
WATCH PART 2: https://www.youtube.com/watch?v=g530cnFfk8Y Download file used in the video: http://www.excelcampus.com/pivot-table-checklist-yt In this video series you will learn how to create an interactive dashboard using Pivot Tables and Pivot Charts. Works with Excel 2003, 2007, 2010, 2013 for Windows & Excel 2011 for Mac Don't worry if you have never created a Pivot Table before, I cover the basics of formatting your source data and creating your first Pivot Table as well. You will also get to see an add-in I developed named PivotPal that makes it easier to work with some aspects of Pivot Tables. Download the files to follow along at the following link. http://www.excelcampus.com/pivot-table-checklist-yt I have another video that shows how to reformat the pivot chart in Excel 2010. In the video above I'm using Excel 2013 and the menus are different from Excel 2007/2010. Here is the link to that video. http://www.youtube.com/watch?v=Jt_QqG-vRRw Get PivotPal: http://www.excelcampus.com/pivotpal Free webinar on The 5 Secrets to Understanding Pivot Tables: https://www.excelcampus.com/pivot-webinar-yt Subscribe to my free newsletter: http://www.excelcampus.com/newsletter
Views: 6840413 Excel Campus - Jon
INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3)
 
01:09:43
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm This video is a part of VLookup Week: http://vlookupweek.wordpress.com There are really about 30 example in this long video. Excel INDEX and MATCH functions How To: 1 MATCH Functions Basics (about 0:46 minute mark) 2 INDEX Basics: Two way lookup (about 9:05 minute mark) 3 One way lookup vertical (lookup Left) (about 13:07 minute mark) 4 One way lookup horizontal (about 14:50 minute mark) 5 One way lookup with lookup column and match column orientated differently (about 17:51 minute mark) 6 INDEX & MATCH to do approximate lookup on table sorted Descending (about 19:15 minute mark) 7 Lookup whole row (about 21:41 minute mark) 8 Lookup whole column (about 24:49 minute mark) 9 Lookup Cell Reference (about 26:00 minute mark) 10 Create Dynamic Range For Chart (about 26:00 minute mark) 11 Lookup from more than one table when tables are on same sheet as formula (about 36:29 minute mark) 12 Lookup from more than one table when tables are on a different sheet than the formula: CHOOSE, INDEX, MATCH functions (about 43:31 minute mark) 13 INDEX and ROWS to Filp a Table (about 47:20 minute mark) 14 Get Amount in Next Bracket (about 50:34 minute mark) 15 Select a Random Value (about 53:18 minute mark) 16 Lookup first non-blank value (about 54:24 minute mark) 17 Handle arrays that require Ctrl + Shift + Enter CSE (about 54:24 minute mark) 18 Basic lookup tool used in complex array formulas for extracting data (about 59:59 minute mark, 1 hour 1 minute 10 seconds) VLOOKUP Shark Week Buy excelisfun products: https://teespring.com/stores/excelisfun-store
Views: 670513 ExcelIsFun
Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples
 
10:37
Find out how to do a VLOOKUP in Excel and for what situations you can use Excel's Vlookup and Hlookup formulas for. Download the free Excel Vlookup workbook here: http://www.xelplus.com/basics-vlookup-hlookup/ Get the full course: https://courses.xelplus.com/ The Excel VLOOKUP formula can search for a specific category or value in an Excel data table and return the “opposing” value from adjacent columns. HLOOKUP function works exactly in the same way except that it looks horizontally rather than vertically. “V” in VLOOKUP refers to vertical and “H” in HLOOKUP refers to horizontal. If the data in your table has column headers, use the VLOOKUP function. If the data table has row headers and you need to search horizontally across the rows for a “match” then use HLOOKUP formula. Vlookup formulas do not need to have sorted lists. If your Excel table is unsorted make sure you look for an exact match by selecting "false" in the last argument of Vlookup. One major limitation of VLOOKUP is that it cannot look to the left. The values to lookup must always be on the left-most column of the range and the values to return must be on the right hand side. For two-way lookups - If you need to look up values across rows and also columns or multiple rows and columns the best function to use is the Index and Match function. Watch this video to learn more: https://youtu.be/F264FpBDX28 ★ My Online Excel Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel
Views: 519196 Leila Gharani
Most used Excel Formulas | Excel Formulas
 
13:52
Most used Excel Formulas | Expert Level https://www.excelsuperstar.org/excel-formulas/ Doston niche kuch aise Excel Formulas in Hindi diye gaye hain, jinka upyog aap Excel mei kahi par bhee kar sakte hain. Ye vo Formulas hain jo ki aapko 75% Excel me Master banne ke liye Ready kar denge. In Excel Formulas ko Learn karte he hogi aapki Time ki bachat aur ban jaayein the Ultimate Rockstar apne doston aur colleagues ke beech. Excel Formulas in Hindi Excel Formulas in Details: 1. Counta formulas 2. Countblank formulas 3. Count formulas 4. Sum formulas 5. Max formulas 6. Min formulas 7. Average formulas 8. Vlookup formulas 9. Concatenate formulas 10. IF formulas 11. Countif formulas 12. Sumif formulas 13. Drop-down list formulas 14. Conditional formatting 15. Text to Column 16. Excel Formulas List 17. All Excel Formulas 18. Excel Formulas pdf #Excelformulas #excelinhindi #mostusedexcelformulas #excelsuperstar Excel Formulas & Function Formulas in Excel Basic Excel Formulas Excel Formulas for Beginner Microsoft Excel Formulas lear MS Excel Formulas Most used Excel Formulas Top 10 Excel Formulas Top 10 Most used Excel Formulas To watch more videos visit: https://www.excelsuperstar.org/ To Buy an Excel Course Pen drive visit: https://www.excelsuperstar.org/excel-course-hindi-english-mix/ Like us on Facebook: https://www.facebook.com/Excelsuperstar/ Subscribe to the Channel: https://www.youtube.com/c/Excelsuperstar
Views: 210857 Excel Superstar
How to do a Vlookup in Excel (2018)
 
17:48
How to do a Vlookup in Excel. This video shows you how to do a vlookup in Microsoft Excel. Whether you use Excel 97/2000 Excel 2010 or 2016, vlookups work exactly the same for each version of Excel. Vlookup in Excel is a really useful tool and it can be used for many different reasons. The Vlookup in excel is such a powerful formula it's one of the reasons why Excel is so loved. This is a great How to do a vlookup video for anyone wanting to do a vlookup in Excel. Whether you want to do a vlookup in the same sheet or a different tab, this video will help you understand how to do vlookup using Microsoft Excel. http://www.technologymadeclear.com
Views: 1365 Technology Made Clear
Excel Vlookup Formula Error #NA #REF #VALUE in Hindi
 
06:49
TeachToEach video on Excel vlookup formula error #NA #REF #VALUE in hindi. Some of the topics which we cover in this video are 1. #NA – When lookup value not search in table array of vlookup formula 2. #REF – When column index number greater than table array range of vlookup formula 3. #VALUE – When colum index number enter less than 0. It is a very difficult task to anyone. If you are really interested to learn this trick then this video never lets you down. On YouTube, only just few videos are available on this topic of understand error in excel vlookup formula. Thanks for watching. It is humble request to you please subscribe my Channel www.youtube.com/teachtoeach Some popular videos-: 1) 3 Tips to make easy Vlookup Formula in Hindi - https://www.youtube.com/watch?v=HxfPY872VCg 2) Concatenate Formula in Excel Hindi - https://www.youtube.com/watch?v=86oaZNDzeD8 3) How to calculate Shrinkage and Attrition rate Formula in Excel Hindi - https://www.youtube.com/watch?v=Lc1anyh-5CQ 4) Double VLOOKUP in Excel Hindi - https://www.youtube.com/watch?v=12KuchYnJPw 5) Split first middle and last name by using formula in excel hindi - https://www.youtube.com/watch?v=FJS8yKgnCkM 6) Create Dependent Drop Down List in Excel Hindi - https://www.youtube.com/watch?v=Z1mb1qG75e8 7) How to make a picture lookup in excel - https://www.youtube.com/watch?v=y84-JXdJSUQ 8) Relative Absolute and Mixed Cell Referencing in Excel - https://www.youtube.com/watch?v=R3GEbagnbp4 9) Excel Logical Functions IF AND OR NESTED IF in Hindi - https://www.youtube.com/watch?v=Us1wr2QrrlM 10) Reverse Lookup Formula VLOOKUP with Choose Function in Excel - https://www.youtube.com/watch?v=n8rcnbOrFYY 11) How to consolidate multiple worksheets into Pivot Table - https://www.youtube.com/watch?v=OGa6EKTFb5s
Views: 29923 Teach To Each
Excel VLOOKUP With Multiple Workbooks
 
12:14
How to use Excel's VLOOKUP function across multiple workbook files.
Views: 1093342 Maxwell Stringham
Many VLOOKUP Columns - 1123 - Learn Excel from MrExcel
 
04:18
VLOOKUP week continues.... Today, you have to lookup an account number and return the results from four columns in the lookup table. Episode 1123 shows you four possible solutions. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Views: 102021 MrExcel.com
Excel Magic Trick 1513: COUNTIFS from Multiple Cells!?!? Array Formula or Logical Formula?
 
05:26
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1513.xlsx Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm In this video see how to count values that are greater than a hurdle when the values in in noncontiguous cells (cells not next to each other). See an Array Formula that uses SUMPRODUCT and CHOOSE and a Logical Formula.
Views: 6091 ExcelIsFun
VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521)
 
09:57
FILTER Function: One or More Lookup Values Return One or More Returns Values EMT 1521 Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1518-1523.xlsx In this video learn about THE Most Amazing Lookup function for dealing with Multiple Lookup Values or Multiple Returned values when doing lookup! Learn about the FILTER Function to filter data sets, columns, or to do complicated Lookups. Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)
Views: 8838 ExcelIsFun
6 Examples of Vlookup Formula in Hindi
 
33:55
Vlookup with 6 Examples To watch more videos and download the files visit http://www.myelesson.org To Buy The Full Excel Course visit . http://www.myelesson.org/product or call 9752003788 10 Most Used Formulas MS Excel https://www.youtube.com/watch?v=KyMj8HEBNAk Learn Basic Excel Skills For Beginners || Part 1 https://www.youtube.com/watch?v=3kNEv3s8TuA 10 Most Used Excel Formula https://www.youtube.com/watch?v=2t3FDi98GBk **Most Imporant Excel Formuls Tutorials** Learn Vlookup Formula For Beginners in Excel https://www.youtube.com/watch?v=vomClevScJQ 5 Excel Questions Asked in Job Interviews https://www.youtube.com/watch?v=7Iwx4AMdij8 Create Speedometer Chart In Excel https://www.youtube.com/watch?v=f6c93-fQlCs Learn the Basic of Excel for Beginners || Part 2 https://www.youtube.com/watch?v=qeMSV9T1PoI Create Pareto Chart In Excel https://www.youtube.com/watch?v=2UdajrDMjRE How to Create Dashboard in Excel https://www.youtube.com/watch?v=RM8T1eYBjQY Excel Interview Questions & Answers https://www.youtube.com/watch?v=Zjv1If63nGU
Views: 80430 My E-Lesson
شرح "دالة vlookup" في الاكسل 2007 للبحث عن القيم بالجدول
 
05:41
شرح دالة Vlookup في برنامج الاكسل دالة البحث الرأسي في الإكسل VlookUp - استخدام الدالة Vlookup Excel 2007 لمتابعة شروحات دوال المحاسبة وملفات محاسبية جاهزة http://www.morzak.net/viewforum.php?f=272 *-*-*-*-*-*-*-*-**-*-*-*-*-*-***-*-*-*- ۩۩۩ اشترك بصفحتنا على الفيسبوك ليصلك الجديد ۩۩۩ https://www.facebook.com/altamiuze تابعنا على تويتر https://twitter.com/altamiuze
Excel Magic Trick 1501 Pt 02: INDIRECT Lookup Items From Different Sheets Based on Row Number
 
06:11
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1501-1502.xlsx Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm In this video learn how to use the INDIRECT Function to pull Data from a Spefified Sheet Based on Row Number. Also see a great INDEX formula to lookup a row number on a single sheet – formulas from Bill Szysz and pmsocho at YouTube.
Views: 5162 ExcelIsFun