GHS (GH₵)
GH₵
Ghanaian cedi
€
Euro Member Countries
₦
Nigeria Naira
$
United States Dollar
Your cart is empty
Empty notifications
Login
Register
Learn
Data Analytics with Microsoft Excel
Data Analytics with Microsoft Power BI
Data Analytics with SQL
Microsoft Excel Essentials
Python for Data Science
Artificial Intelligence
Data Analytics
Guided Project
SQL
Power BI
Microsoft Excel
Python
Projects
Microsoft Excel
Python
SQL
Power BI
Project challenge
Home
Courses
Career Tracks
Bootcamps
Pricing
Teach on FestMan
Get started
Get started
Your cart is empty
Empty notifications
8.5 VLOOKUP vs XLOOKUP - EXACT MATCH
Lesson 80/93
|
Study Time: 9 Min
Course:
Excel Skills for Data Analytics
Previous Lesson
Next Lesson
THOMAS FESTUS CUDJOE
Product Designer
4.94
Profile
Book a Meeting
Class Sessions
1- 1.1 Exploring excel interface
2- 1.2 Excel backstage view
3- 2.1 Manage workbooks
4- 2.2 Manage worksheets
5- 2.3 Working rows and columns
6- 2.4 working with cells
7- 3.1 Entering data into cell
8- 3.2 Entering time and multiple values
9- 3.3 Formatting values
10- 3.4 Applying custom formatting
11- 3.5 Auto Fill
12- 3.6 Creating custom list
13- 3.6 Undo and redo
14- 4.1 Introduction to Basic Excel formulas
15- 4.2 Introduction to basic functions
16- 4.3 The IF Function
17- 4.4 Date functions
18- 4.5 Cell referencing - Relative cell reference
19- 4.6 Cell referencing - Absolute cell reference
20- 4.7 Cell referencing - Mixed cell reference
21- 4.8 Using defined names in formulas
22- 4.9 VLookUP and XLookUP
23- 4.10 VLookUP Demo
24- 5.1 Introduction to Excel charts
25- 5.9 Working with recommended charts
26- 5.2 Working with column charts
27- 5.4 Stack column chart
28- 5.3 Clustered column chart
29- 5.5 Bar chart
30- 5.6 Line chart
31- 5.7 Working with Pie chart
32- 5.8 Protips for working with pie charts
33- 6.1 Sort data chronologically
34- 6.2 Sort data alphabetically
35- 6.3 Sort data numerically
36- 6.4 Sort data by color
37- 6.6 Filter data by date
38- 6.8 Filter data by text pattern
39- 6.7 Filter numeric data
40- 6.9 Advanced Filter
41- 6.5 Multi-level sorting
42- 6.10 Freeze panes
43- 6.11 Split window
44- Introduction to the course
45- 4.11 Introduction to Text Functions
46- 4.12 UPPER, LOWER and PROPER Functions
47- 4.13 LEFT, RIGHT and MID Functions + FLASHFILL
48- 4.15 CONCAT and TEXTJOIN Functions
49- 4.17 VSTACK and HSTACK
50- 7.1 Benefits of working with Excel Tables
51- 7.2 Creating an excel table
52- 7.3 Changing table name
53- 7.4 Table Styles
54- 7.5 Sorting Table
55- 7.6 Filtering Table
56- 7.7 Calculated Columns
57- 7.8 Adding Total Row
58- 7.9 Structured Reference 1
59- 7.10 Structured Reference 2
60- 7.11 Structured Reference 3
61- 7.12 Using PivotTables with Tables
62- 7.13 Using Chart with Tables
63- 7.14 Resizing table
64- 7.15 Convert table to range
65- 4.14 Extract Text with TEXTBEFORE, TEXTAFTER
66- 4.16 Using the TRIM and REPT Functions
67- 4.18 TOCOL and TOROW Functions
68- 6.12 Remove duplicates from datasets
69- 6.13 Using the UNIQUE function
70- 6.14 The SORT AND SORTBY Functions
71- 6.15 The FILTER Function
72- 8.1 Using COUNTIFS function
73- 8.2 Using SUMIFS function
74- 8.3 Using AVERAGEIFS function
75- 8.4 Using MINIFS and MAXIFS
76- 1 Dataset Demo
77- 8.5 VLOOKUP vs XLOOKUP - EXACT MATCH
78- 2 Introduction to PivotTables
79- 8.6 VLOOKUP vs XLOOKUP - APPROXIMATE MATCH
80- 3 Navigating the areas of a PivotTable
81- What you need for this course
82- 4 Working with multiple PivotTable Fields
83- 5 Guided project 1
84- 6 Changing default PivotTable name
85- 7 Calculations: Summarize values by options
86- 8 Show Values As: % of Grand Total
87- 9 Show Values As: % of Row Total
88- 10 Show Values As: % of Column Total
89- 11 Showing running totals
90- 12 PivotTable Styles
91- 13 Customize position and layout of PivotTable Fields pane
92- Module Conclusion
93- Conclusion
18 Weeks Business Intelligence and Data Analytics
Learn advanced Excel, Power BI, SQL and AI. Become a Business Intelligence Analyst or Data Analyst.
Learn more