• Lesson.No : 67
  • 00:24:19

  • Tutorial 67: Lookup a full record using COLUMN function within VLOOKUP in Excel FREE Excel Course

  • Play

Course Lessons

  1. 1- Lesson 1: Introduction to Microsoft Excel Excel Interface FREE Excel Course
  2. 2- Lesson 2: SUM function in Excel Entering Text & Numbers FREE Excel Course
  3. 3- Lesson 3: Formatting Cells in Excel Make a Spreadsheet look attractive FREE Excel Course
  4. 4- Lesson 4: Multiplication Formula in Excel Replicate or Copy Formulas in Excel FREE Excel Course
  5. 5- Lesson 5: Average Function in Excel What does Average mean FREE Excel Course
  6. 6- Lesson 6: MIN & MAX function in Excel Find the Minimum and Maximum value within a range in Excel
  7. 7- Lesson 7: Count & CountA function in Excel Difference between Count and CountA function in Excel
  8. 8- Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells with TEXT data in Excel
  9. 9- Lesson 9: Subtraction Formula in Excel FREE Excel Course
  10. 10- Lesson 10: How to use the INSERT FUNCTION command in Excel FREE Excel Course
  11. 11- Lesson 11: Merge & Center in Excel Merge Across Merge Cells FREE Excel Course
  12. 12- Lesson 12: Wrap Text in Excel Break Text to Multiple Lines Shrink to Fit FREE Excel Course
  13. 13- Lesson 13: Format Cells as Currency, Date, Percentages & Decimal Places in Excel FREE Excel Course
  14. 14- Lesson 14: How to insert a HEADER in Excel Insert an AUTOMATIC FILENAME in the header in Excel
  15. 15- Lesson 15: Format the Font Color in Excel Shade or Fill Color cells in Excel FREE Excel Course
  16. 16- Lesson 16: What is Page Orientation in Excel Change Portrait orientation to Landscape in Excel
  17. 17- Lesson 17: How to PRINT spreadsheet SHOWING the formulas and functions in Excel FREE Excel Course
  18. 18- Lesson 18: What is a Formula and Function in Excel Difference between Formula & Function in Excel
  19. 19- Lesson 19: What is a Workbook & Worksheet in Excel Difference between Workbook & Worksheet
  20. 20- Lesson 20: How to select multiple NON-ADJACENT cells in Excel FREE Excel Course
  21. 21- Lesson 21: How to COPY cells from one spreadsheet to another spreadsheet in Excel
  22. 22- Lesson 22 - How to RENAME a worksheet in Excel FREE Excel Course
  23. 23- Lesson 23: Best techniques to widen columns & adjust the height of rows in Excel FREE Excel Course
  24. 24- Lesson 24 - How to SORT data in ASCENDING order in Excel FREE Excel Course
  25. 25- Lesson 25 - Everything you need to know about FREEZING PANES (rows & columns) in Excel
  26. 26- Lesson 26 - Use the AUTOSUM button to quickly ADD up cells in Excel What is the Autosum Button?
  27. 27- Lesson 27 - What is the thousand separator in Excel How to use the thousand separator in Excel
  28. 28- Lesson 28 - A simple DIVISION formula in Excel FREE Series of Microsoft Excel Lessons
  29. 29- Lesson 29 - Everything you need to know about ABSOLUTE cell references before replicating in Excel
  30. 30- Lesson 30 - Format numbers to display as PERCENTAGES in Excel FREE Series of MS Excel Lessons
  31. 31- Lesson 31 - Relative OR Absolute references in Excel Everything explained Confusion solved!
  32. 32- Lesson 32 - What is Scale to Fit in Excel How to use Scale to Fit (shrink pages) in Excel
  33. 33- Lesson 33 - How to insert an Embedded Clustered Column Chart in Excel What is a Clustered Chart?
  34. 34- Lesson 34 - What is the PLOT & CHART AREA on a chart in Excel How to SHADE the plot area in Excel
  35. 35- Lesson 35 - How to insert a NEW worksheet in-between 2 worksheets in Excel Rearrange worksheets
  36. 36- Lesson 36 - Best method to COPY a CHART to a new worksheet in Excel Making sure data is LINKED!
  37. 37- Lesson 37 - How to CHANGE the CHART from one TYPE to another in Excel Column chart to Pie chart
  38. 38- Lesson 38 - How to add DATA LABELS to charts in Excel Change colour of pie-chart segments in Excel
  39. 39- Lesson 39 - How to insert a LINE chart with MARKERS in Excel Select non-adjacent data in Excel
  40. 40- Lesson 40 - How to MOVE a chart to a new worksheet in Excel Rename a worksheet FREE Excel Lesson
  41. 41- Lesson 41 - How to display and print GRIDLINES and ROW & COLUMN HEADINGS in Excel
  42. 42- Lesson 42 - How to set and print rows & titles automatically at the top of each page in Excel
  43. 43- Lesson 43 - How to change a DATE to different FORMATS in Excel FREE Series Microsoft Excel Lessons
  44. 44- Lesson 44 - Use the IF function to work out if you are over BUDGET in Excel FREE Excel Lessons
  45. 45- Lesson 45 - How to apply borders around and in-between cells in Excel FREE Microsoft Excel Lessons
  46. 46- Lesson 46 - Find & Replace in Excel Match Case & Match Entire Cell Contents Explained thoroughly
  47. 47- Lesson 47 - How to Hide & Unhide Multiple Rows & Columns in Excel FREE Series of MS Excel Lessons
  48. 48- Lesson 48: Hide & Unhide Worksheets in Excel Hide Worksheets, so it CANNOT be unhidden easily!
  49. 49- Lesson 49: How to LINK data and ADD up cells from MULTIPLE different worksheets in Excel
  50. 50- Lesson 50: How to LINK data and ADD up cells from a DIFFERENT WORKBOOK in Excel
  51. 51- Lesson 51: How to use FILTER DATA in Excel Number Filters: Greater Than Or Equal To Less Than
  52. 52- Lesson 52: COUNTIF function in Excel FREE Series of Microsoft Excel Lessons
  53. 53- Lesson 53: COUNTIF function used to COUNT MULTIPLE different items in a column in Excel
  54. 54- Lesson 54: COUNTIFS function in Excel How to use Data Filter in Excel FREE MS Excel Lessons
  55. 55- Lesson 55: COUNT function in Excel COUNTA function in Excel COUNTBLANK function in Excel
  56. 56- Lesson 56: SUMIF function in Excel FREE Series of Microsoft Excel Lessons
  57. 57- Lesson 57: SUMIF function used to ADD MULTIPLE different items in one column in Excel SUMIF+SUMIF
  58. 58- Lesson 58: SUMIFS function in Excel to ADD multiple CRITERIONS from different columns
  59. 59- Lesson 59: FORMULATEXT function in Excel Display formulas or functions of individual cells only
  60. 60- Lesson 60: The AVERAGEIF function in Excel FREE Series of Microsoft Excel Lessons
  61. 61- Lesson 61: AVERAGEIFS function in Excel Find the average value by using many criterias in excel
  62. 62- Lesson 62: The AverageA function in Excel FREE Series of Microsoft Excel Lessons
  63. 63- Lesson 63: Create a table in Excel Convert data to Excel table Benefits of tables in Excel
  64. 64- Lesson 64: Create Drop-down lists in Excel Input message to a drop-down list FREE Excel Course
  65. 65- Tutorial 65: VLOOKUP function in Excel FREE Excel Course
  66. 66- Tutorial 66: IFERROR function with VLOOKUP in Excel Remove ERROR messages FREE Excel Course
  67. 67- Tutorial 67: Lookup a full record using COLUMN function within VLOOKUP in Excel FREE Excel Course