Home
Search results “Types of data analysis reports”

05:39
The process of doing statistical analysis follows a clearly defined sequence of steps whether the analysis is being done in a formal setting like a medical lab or informally like you would find in a corporate environment. This lecture gives a brief overview of the process.
Views: 36910 White Crane Education

18:32
Views: 65781 David Russell

06:51
Views: 642097 Kent Löfgren

02:22:43
Download File: https://people.highline.edu/mgirvin/AllClasses/210Excel2013/Ch00/Excel2013StatisticsChapter00.xlsx All Excel Files for All Video files: http://people.highline.edu/mgirvin/excelisfun.htm. Intro To Excel: Store Raw Data, Data Types, Data Analysis, Formulas, PivotTables, Charts, Keyboards, Number Formatting, Data Analysis & More: (00:08) Introduction to class (00:49) Cells, Worksheets, Workbooks, File Names (02:54) Navigating Worksheets & Workbook (03:58) Navigation Keys (04:15) Keyboard move Active Sheet (05:40) Ribbon Tabs (06:25) Add buttons to Quick Access Tool Bar (07:40) What Excel does: Store Raw Data, Make Calculations, Data Analysis & Charting (08:55) Introduction to Data Analysis (10:37) Data Types in Excel: Text, Numbers, Boolean, Errors, Empty Cells (11:16) Keyboard Enter puts content in cell and move selected cell down (13:00) Data Type DEFAULT Alignments (13:11) First Formula. Entering Cell References in formulas (13:35) Keyboard Ctrl + Enter puts content in cell & keep cell selected (14:45) Why we don’t override DEFAULT Alignments (15:05) Keyboard Ctrl + Z is Undo (17:05) Proper Data Sets & Raw Data (24:21) How To Enter Data & Data Labels (24:21) Stylistic Formatting (26:35) AVERAGE Function (27:31) Format Formulas Differently than Raw Data (28:30) Keyboard Ctrl + C is Copy. Keyboard Ctrl + V is Paste (29:59) Use Eraser remove Formatting Only (29:19) Keyboard Ctrl + B adds Bold (29:57) Excel’s Golden Rule (31:43) Keyboard F2 puts cell in Edit Mode (32:01) Violating Excel’s Golden Rule (34:12) Arrow Keys to put cell references in formulas (35:40) Full Discussion about Formulas & Formulas Elements (37:22) SUM function Keyboard is Alt + = (38:22) Aggregate functions (38:50) Why we use ranges in functions (40:56) COUNT & COUNTA functions (42:47) Edit Formula & change cell references (44:18) Absolute & Relative Cell References (45:52) Use Delete Key, Not Right-click Delete (46:40) Fill Handle & Angry Rabbit to copy formula (47:41) Keyboard F4 Locks Cell Reference (make Absolute) (49:45) Keyboard Tab puts content in Cell and move selected Cell to right (50:55) Order of Operation error (52:17) Range Finder to find formula errors (52:34) Lock Cell Reference after you put cell in Edit Mode (53:58) Quickly copy an edited formula down a column (53:07) F2 key in last cell to find formula errors (54:15) Fix incorrect range in function (54:55) SQRT function & Fractional Exponents (57:20) STDEV.P function (58:10) Navigate Large Data Sets (58:48) Keyboard Ctrl + Arrow jumps to bottom of data set (59:42) Keyboard Ctrl + Shift + Arrow selects to bottom of data set (Current Range) (01:01:41) Keyboard Shift + Enter puts content in Cell and move selected Cell up (01:02:55) Counting with conditions or criteria: COUNTIFS function (01:03:43) Keyboard Ctrl + Backspace jumps back to Active Cell (01:05:31) Counting between an upper & lower limit with COUNTIFS (01:07:36) COUNTIFS copied down column (01:10:08) Joining Comparative Operator with Cell Reference in formula (01:12:50) Data Analysis features in Excel (01:13:44) Sorting (01:16:59) Filtering (01:20:39) Introduction to PivotTables (01:23:39) Create PivotTable dialog box (01:24:33) Dragging & dropping Fields to create PivotTable (01:25:31) Dragging Field to Row area creates a Unique List (01:26:17) Outline/Tabular Layout (01:27:00) Value Field Settings dialog to change: Number Formatting, Function, Name (01:28:12) 2nd & 3rd PivotTable examples (01:31:23) What is a Cross Tabulated Report? (01:33:04) Create Cross Tabulated Report w PivotTable (01:35:05) Show PivotTable Field List (01:36:48) How to Pivot the Report (01:37:50) Summarize Survey Data with PivotTable. (01:38:34) Keyboard Alt, N, V opens PivotTable dialog box (01:41:38) PivotTable with 3 calculations: COUNT, MAX & MIN (01:43:25) Count & Count Number calculations in a PivotTable (01:45:30) Excel 2013 Charts to Visually Articulate Quantitative Data (01:47:00) #1 Rule for Charts: No Chart Junk! (01:47:30) Explain chart types: Column, Bar, Pie, Line and X-Y Scatter Chart (01:51:34) Create Column Chart using Recommended Chart feature (01:53:00) Remove Field Buttons from Pivot Chart (01:54:10) Chart Formatting Task Pane (01:54:45) Vary Fill Color by point (01:55:15) Format Axis with Numbers by Formatting Source Data in PivotTable (01:56:02) Add Data Labels to Chart (01:57:28) Copy Chart & Create Bar Chart (01:57:48) Change Chart Type (01:58:15) Change Gap Width. (01:59:17) Create Pie Chart (01:59:23) Do NOT use 3-D Pie (01:59:42) Add % Data Labels to Pie Chart (02:00:25) Create Line Chart From PivotTable (02:01:20) Link Chart Tile to Cell (02:02:20) Move a Chart (02:02:33) Create an X-Y Scatter Chart (02:03:35) Add Axis Labels (02:05:27) Number Formatting to help save time (02:07:24) Number Formatting is a Façade (02:10:27) General Number Format (02:10:52) Percentage Number Formatting (02:14:03) Don’t Multiply Relative Frequency by 100 (02:17:27) Formula for % Change & End Amount
Views: 393774 ExcelIsFun

02:54
This video is part of the Udacity course "Intro to Programming". Watch the full course at https://www.udacity.com/course/ud000
Views: 269319 Udacity

55:13
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn the basics of Data Analysis at Highline Community College Professional Development Day 2012: Topics in Video: 1. What is Data Analysis? ( 00:53 min mark) 2. How Data Must Be Setup ( 02:53 min mark) Sort: 3. Sort with 1 criteria ( 04:35 min mark) 4. Sort with 2 criteria or more ( 06:27 min mark) 5. Sort by color ( 10:01 min mark) Filter: 6. Filter with 1 criteria ( 11:26 min mark) 7. Filter with 2 criteria or more ( 15:14 min mark) 8. Filter by color ( 16:28 min mark) 9. Filter Text, Numbers, Dates ( 16:50 min mark) 10. Filter by Partial Text ( 20:16 min mark) Pivot Tables: 11. What is a PivotTable? ( 21:05 min mark) 12. Easy 3 step method, Cross Tabulation ( 23:07 min mark) 13. Change the calculation ( 26:52 min mark) 14. More than one calculation ( 28:45 min mark) 15. Value Field Settings (32:36 min mark) 16. Grouping Numbers ( 33:24 min mark) 17. Filter in a Pivot Table ( 35:45 min mark) 18. Slicers ( 37:09 min mark) Charts: 19. Column Charts from Pivot Tables ( 38:37 min mark) Formulas: 20. SUMIFS ( 42:17 min mark) 21. Data Analysis Formula or PivotTables? ( 45:11 min mark) 22. COUNTIF ( 46:12 min mark) 23. Formula to Compare Two Lists: ISNA and MATCH functions ( 47:00 min mark) Getting Data Into Excel 24. Import from CSV file ( 51:21 min mark) 25. Import from Access ( 54:00 min mark) Highline Community College Professional Development Day 2012 Buy excelisfun products: https://teespring.com/stores/excelisfun-store
Views: 1451910 ExcelIsFun

16:47
Views: 23308 Miles Beckler

06:20
The kind of graph and analysis we can do with specific data is related to the type of data it is. In this video we explain the different levels of data, with examples. Subtitles in English and Spanish.
Views: 749474 Dr Nic's Maths and Stats

06:36
Impact evaluations need to go beyond assessing the size of the effects (i.e., the average impact) to identify for whom and in what ways a programme or policy has been successful. This video provides an overview of the issues involved in choosing and using data collection and analysis methods for impact evaluations
Views: 51201 UNICEF Innocenti

06:43
Data falls into several categories. Each type has some pros and cons, and is best suited for specific needs. Learn more in this short video from our Data Collection DVD available at http://www.velaction.com/data-collection-lean-training-on-dvd/.
Views: 130379 VelactionVideos

01:27:18
Data Analytics for Beginners -Introduction to Data Analytics https://acadgild.com/big-data/data-analytics-training-certification?utm_campaign=enrol-data-analytics-beginners-THODdNXOjRw&utm_medium=VM&utm_source=youtube Hello and Welcome to data analytics tutorial conducted by ACADGILD. It’s an interactive online tutorial. Here are the topics covered in this training video: • Data Analysis and Interpretation • Why do I need an Analysis Plan? • Key components of a Data Analysis Plan • Analyzing and Interpreting Quantitative Data • Analyzing Survey Data • What is Business Analytics? • Application and Industry facts • Importance of Business analytics • Types of Analytics & examples • Data for Business Analytics • Understanding Data Types • Categorical Variables • Data Coding • Coding Systems • Coding, coding tip • Data Cleaning • Univariate Data Analysis • Statistics Describing a continuous variable distribution • Standard deviation • Distribution and percentiles • Analysis of categorical data • Observed Vs Expected Distribution • Identifying and solving business use cases • Recognizing, defining, structuring and analyzing the problem • Interpreting results and making the decision • Case Study Get started with Data Analytics with this tutorial. Happy Learning For more updates on courses and tips follow us on: Facebook: https://www.facebook.com/acadgild Twitter: https://twitter.com/acadgild LinkedIn: https://www.linkedin.com/company/acadgild

04:17
Purchase the spreadsheet (formulas included!) that's used in this tutorial for \$5: https://gum.co/satisfactionsurvey ----- Soar beyond the dusty shelf report with my free 7-day course: https://depictdatastudio.teachable.com/p/soar-beyond-the-dusty-shelf-report-in-7-days/ Most "professional" reports are too long, dense, and jargony. Transform your reports with my course. You'll never look at reports the same way again.
Views: 332634 Ann K. Emery

11:16

07:21
In this video, I discuss how to check your Facebook advertising stats. To check out the full course, click here: http://kingpinning.com/crushing-e-commerce/
Views: 8562 Kingpinning

04:13
This video introduces students to Analytical Reports, which are a common form of communication in the technical workplace. These reports present research addressing a specific problem or research question. The typical arrangement of an Analytical Report contains the following sections: Introduction, Methods, Results and Discussion (the IMRaD pattern). In this video, these sections are discussed by highlighting examples from a student report.
Views: 23284 umnWritingStudies

17:44
Guide for my students on producing data analysis reports using R Markdown in the R Studio IDE.
Views: 13201 Homer White

30:35
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to use Power BI Desktop to import, clean and transform Sales Tables from Multiple Excel Files and consolidate into a Single Proper Data Set that can be linked in a Relationship to other tables, and then build DAX Calculated Columns & Measures for Gross Profit that can be used in a Dynamic Dashboard with Map, Column Chart, Line Chart, Card and Slicer visualizations. During the whole process we will compare and contrast how the process is similar and different from Excel’s Power Query and Power Pivot DAX. The steps we will see in this video are: 1. (00:17) Introduction to entire process for Power BI Desktop, including looking at the finished Dashboard 2. (04:50) Import Multiple Excel Files From Folder 3. (05:44) Name Query 4. (06:02) Transform extension column to lowercase 5. (06:34) Filter Files to only include “.xlsx” file extensions 6. (07:05) Remove Columns 7. (07:18) November 2016 Power Query Update Problem 8. (08:05) Add Custom Column with Excel.Workbook Function to extract the Excel Objects from each File. 9. (09:40) Delete Content Column 10. (10:41) Filter to only include Excel Sheet Objects 11. (11:06) Filter to exclude sheets that contain the word “Sheet” 12. (11:40) Remove Columns 13. (11:51) Expand Data and Sheet Name Columns 14. (12:06) Change Field Names 15. (12:22) Change Data Types 16. (14:05) Add Custom Column to calculate Net Revenue Column then round Number.Round function. Then Add Fixed Decimal Data Type. 17. (15:59) Remove columns for Amount and Revenue Discount 18. (16:10) Close and Apply to add to Data Model 19. (17:05) Import Excel Manager Table. Change Data Types to Text. Close and Apply 20. (18:10) Create Relationship between Zip Code Columns 21. (19:03) Create DAX Calculated Column with the IF Function to Categorize Retail Data. Change Data Type. 22. (21:53) Create DAX Measures for: Total Revenue, Total COGS and Gross Profit. Add Currency Number Formatting with No Decimals Showing. 23. (24:28) Create DAX Measures for: Gross Profit Percentage. Add Percentage Number Formatting with Two Decimals Showing. 24. (25:35) Create Map Visualization for Zip Code & Gross Profit Data (Zip Code with relationship to Managers) 25. (26:20) Create Clustered Bar for Manager Names & Gross Profit Data (Zip Code with relationship to Managers) 26. (27:15) Create Clustered Column for Product & Gross Profit Data, with a Line Chart for Gross Profit Percentage 27. (28:19) Create Clustered Column for Payment Method & Gross Profit Data, with a Line Chart for Gross Profit Percentage 28. (28:45) Create Slicer for States. 29. (29:00) Create Card Visualization for Total Revenue, Total COGS, Gross Profit and Gross Profit Percentage. 30. (29:57) Summary Learn Power BI Desktop Basics. Introduction to Power BI Desktop. Getting Started with Power BI Desktop. Create Impactful Reports With Power BI Desktop. Microsoft Power BI.
Views: 105916 ExcelIsFun

05:12
Microsoft Certified Trainer Melissa Esquibel shows you how to slice and dice data and present it in an attractive visual package.

02:10
This video was completed as part of a Masters project in DCU. It is the Introduction to a series of videos on Data Collection Methods
Views: 84102 Scott Crombie

15:09
Learn how to analyze product sales data using Excel features like pivot tables and charts. For more info. pls. visit http://chandoo.org/wp/2010/09/22/analyzing-product-launch-sales/

11:40
Views: 7657 Measureschool

01:46:44
Views: 40955 Data Science Dojo

06:43
Views: 3454 Jonathan Ng

03:04
In this video, Sylvain, COO of SEO.fr will show you three types of Google Analytics reports designed to help you get a better grasp on your data and improve the decision-making process on your site. Contact the expert : http://bit.ly/2sgfG9o PrestaShop website: https://www.prestashop.com/ PrestaShop on Twitter: https://twitter.com/PrestaShop PrestaShop on Facebook: https://www.facebook.com/prestashop/
Views: 5187 PrestaShop Official

09:56
Views: 256 Ian Patzius

39:54
This tutorial provides an overview of statistical analyses in the social sciences. It distinguishes between descriptive and inferential statistics, discusses factors for choosing an analysis procedure, and identifies the difference between parametric and nonparametric procedures.
Views: 207186 The Doctoral Journey

20:01
Basic introduction to correlation - how to interpret correlation coefficient, and how to chose the right type of correlation measure for your situation. 0:00 Introduction to bivariate correlation 2:20 Why does SPSS provide more than one measure for correlation? 3:26 Example 1: Pearson correlation 7:54 Example 2: Spearman (rhp), Kendall's tau-b 15:26 Example 3: correlation matrix I could make this video real quick and just show you Pearson's correlation coefficient, which is commonly taught in a introductory stats course. However, the Pearson's correlation IS NOT always applicable as it depends on whether your data satisfies certain conditions. So to do correlation analysis, it's better I bring together all the types of measures of correlation given in SPSS in one presentation. Watch correlation and regression: https://youtu.be/tDxeR6JT6nM ------------------------- Correlation of 2 rodinal variables, non monotonic This question has been asked a few times, so I will make a video on it. But to answer your question, monotonic means in one direction. I suggest you plot the 2 variables and you'll see whether or not there is a monotonic relationship there. If there is a little non-monotonic relationship then Spearman is still fine. Remember we are measuring the TENDENCY for the 2 variables to move up-up/down-down/up-down together. If you have strong non-monotonic shape in the plot ie. a curve then you could abandon correlation and do a chi-square test of association - this is the "correlation" for qualitative variables. And since your 2 variables are ordinal, they are qualitative. Good luck
Views: 486843 Phil Chan

14:06
Use simple data analysis techniques in SPSS to analyze survey questions.
Views: 772976 Claus Ebster

07:00
Views: 283 Steve TechWriting

01:09
Statistical Analysis Report on Copilot
Views: 98 Briana Keith

12:06
One of my viewers asked for my help in creating an Executive Summary Report - because her manager will not allow her to use a Pivot Table. Here are the tips and techniques that I demonstrate in this lesson: 1) Use Excel's Advanced Filter to Extract a list of unique customer names from a filed with over 4,000 records. 2) Convert a normal range of data cells into an Excel 2007 / 2010 Table (as a List in Excel 2003) - so that range references will update automatically when you append records. 3) Create Named Ranges of Cells that you can use in Formulas & Functions. 4) Use the SUMIF, AVERAGEIF and COUNTIF Functions in the Summary Report. I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to view all of my video tutorials. Danny Rocks The Company Rocks
Views: 1042891 Danny Rocks

15:00
This video presents a "formula" for writing qualitative findings paragraphs in research reports. It presents the Setup-Quote-Comment model (SQC).

11:58
In this tutorial we learnt how to conduct aging analysis using Excel with different basic formulas. Complete aging analysis tutorial with conditional formatting and sparklines: https://goo.gl/LJi5nE To practice along please download the Excel exercise book at: https://goo.gl/PzQ4eG For more Excel Tutorials visit: http://pakaccountants.com/excel/ Social: Fb: http://facebook.com/exceltoexcel/ Tw: http://twitter.com/exceltoexcel/
Views: 17404 Hasaan Fazal

41:51
Join Data Studio Product Manager Nikhil Roy and Google Analytics Advocate Louis Gray live from Google HQ on August 17th to learn about how to design and deliver exceptional reports in Google Data Studio.
Views: 127620 Google Analytics

04:11
In this Quick Tip video, learn how to access your Optimize data in Google Analytics and get tips on the types of analysis you can do with the experiment ID, name, and variant ID, in Google Analytics.
Views: 1560 Google Analytics

01:29:29
This is the first session for Data Analysts Career path for 21st May 2016 batch. Understanding the core of RDBMS and SQL programming is one of the skills that make a good analyst. This session is focused on introducing students to IT and Relational Database Management System (RDBMS) By the end of the week you would have finished learning, and achieving the below • Getting familiar with Information Technology • Background and historical knowledge of SQL • Configuring the server environment • Connecting to the server • Creating a database If you will like to get real hands-on with SQL and Data Analytics, join other hundreds of learners in our community. Send us an email [email protected]
Views: 30873 Dare Olufunmilayo

12:13
Views: 12624 ExcelIsFun

11:39
This video will help you prepare for focus groups and interviews by discussing moderator skills, troubleshooting common problems, and offering tips for how to get started with the analysis process and report results. Learn more about program evaluation for driving safety at https://www.teendriversource.org/advocacy-education/program-evaluation-for-driving-safety.

32:32
For details, visit: http://www.financewalk.com Annual Report Analysis Example, Financial Statement Analysis Financial statements analysis is divided in the following areas in this module : • Income Statement • Balance Sheet • Footnotes • Cash Flow Analysis • Director's report • Management Discussion and Analysis • Auditor's Report • Shareholding Pattern Reading the annual reports of the company gives the basic information about the company and the industry in which it operates. Reading this chapter would enable you to understand • Components of financial statements • How to use financial information • Importance of financial statements for security analysis Income Statement Components • Sales • Other Income  Profit from the sale of assets  Dividends ( from investments, in the shares of the other companies)  Rent (Lease rental earned from commercial buildings)  Interest( Interest received on deposits made and loans given to corporate bodies and others.) • Materials Cost ( Opening stock + Purchases made during the year - Closing stock) • Employment Costs -- ( Salaries + Wages + Bonus + Gratuity + Contribution to PF + Welfare Exps. ) • Operating and Other Expenses -- Costs incurred in running a company a) Selling Exps -- Advertising ,Sales promotion, commission paid to salesmen, cash discounts b) Administration Exps -- Rent of offices and factories,municipal taxes, insurance, repairs, printing and stationery, telephone, legal, electricity costs, other exps to administer a company c) Others -- Loss made on the sale of fixed assets, Donations made by the company
Views: 40639 FinanceWalk

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: 5679257 Excel Campus - Jon

03:23
After conducting a statistical analysis, you should write up the results in proper APA 6th edition style. We review some general rules for reporting significance levels and where to find results in SPSS output. Table of Contents: 00:19 - Write Up Results in APA Style
Views: 5929 RStatsInstitute

08:17
Views: 94556 SAS Software

01:01:05
Looks at the use of charts and tables both for data elicitation and clarification and to support the analysis of qualitative data. The lecture looks at a range of different ways of presenting qualitative data in diagrams and tables. It focuses particularly on how this can support the discovery of patterns in data. This was a lecture given to postgraduate (graduate) students at the University of Huddersfield as part of a course on Qualitative Data Analysis. To learn more about social research methods you might be interested in this new, inexpensive, postgraduate, distance learning course: MSc Social Research and Evaluation. The course is delivered entirely via the Internet. http://sre.hud.ac.uk/ Works referred to in the video include: Miles, M. B., & Huberman, A. M. (1994). Qualitative data analysis: a sourcebook of new methods. Beverly Hills, CA: Sage. The tables in this video are taken from this edition, but there is a new edition: Miles, M. B., Huberman, A. M. & Saldaña, J. (2014). Qualitative data analysis: a sourcebook of new methods. 3rd Ed. Los Angeles, CA: Sage. Ritchie, J., & Lewis, J. (2003) Qualitative Research Practice: A Guide for Social Science Students and Researchers. London: Sage. There is also a new edition of this book: Ritchie, J., Lewis, J., McNaughton Nicholls, C and Ormston, R (eds) (2013) Qualitative Research Practice: A Guide for Social Science Students and Researchers. London: Sage. See also my book: Gibbs, G.R. (2007) Analyzing Qualitative Data. London: Sage. See, Chapter 6 ‘Comparative Analysis’. Credits: Sounds and music: 'Fifth Avenue Stroll' from iLife Sound Effects, http://images.apple.com/legal/sla/docs/ilife09.pdf Image: Freizeitanlage Kräwinklerbrücke, Kräwinklerbrücke in Remscheid by Frank Vincentz, Wikimedia Commons, licensed under the Creative Commons Attribution-Share Alike 3.0 Unported license.
Views: 7716 Graham R Gibbs

10:39
This is a short practical guide to Qualitative Data Analysis
Views: 87366 James Woodall

06:19
Quantitative Data Analysis Report on three video cards: ATI Radeon HD 2600XT NVIDIA GeForce 7950GX2 NVIDIA GeForce 9800GX2 using 3D Mark 06 for LAN's R' Us, a local LAN gaming store.
Views: 518 chickmagntwannab

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: 2535456 Tuts+ Computer Skills

16:58