About
LearnDesk
Learn  
Topics
Topics
Topics
Topics
Topics
Topics
Topics
Teach
  Teach Online
  Schedule
  Items
  Billing
  Users
  Marketing
  Analytics
  Settings
  Change School
Account
 

Microsoft Excel Basic to Advance Level

01. Excel from Scratch
01. Touring the Interface
02. Enter Data and Saving Workbook
03. Applying Formulas
04. Changing a Worksheet's Structure
05. Find, Replace and Spell Check
06. Applying Fonts, Background Colors, and Borders
07. Formatting Numbers and Dates
08. Making the Pieces Fit
09. Inserting Headers and Footers and Repeating Rows
10. Managing Large Workbooks
02. Excel Essentials
01. Formula Writing (Don't Miss This)
01. Ex - Formula Writing (Don't Miss This)
03. Sum Count Average Functionality (with Conditions)
01. SumIf and SumIfs
01. Ex - SumIf and SumIfs
02. Count Functions
02. Ex - Count Functions
03. AverageIf and AverageIfs
03. Ex - AverageIf and AverageIfs
04. Text Functions (Manipulating Text)
01. Change Case (Upper, Lower, Proper)
01. Ex - Change Case (Upper, Lower, Proper)
02. Separating Text on Symmetrical Data
02. Ex - Separating Text on Symmetrical Data
03. Separating Text on Non-Symmetrical Data
03. Ex - Separating Text on Non-Symmetrical Data
05. Logical Functions (Working with Conditions)
01. If Functionality
01. Ex - IF Functionality
02. If with AND
02. Ex - If with AND
03. If with OR
03. Ex - If with OR
04. If with AND and OR, IF with Countif
04. Ex - If with AND and OR, IF with Countif
05. Nested If (A Genie with 3 wishes)
05. Ex - Nested If
06. Lookup Functionality (Burn Simple Find Technique)
01. Vlookup (Exact Match) #1
01. Ex - Vlookup (Exact Match) #1
02. Type of References (Use of $ Sign)
03. Vlookup (Exact Match) #2
03. Ex - Vlookup (Exact Match) #2
04. Double Vlookup
04. Ex - Double Vlookup
05. Vlookup on Duplicate Values
05. Ex - Vlookup on Duplicate Values
06. Vlookup (Approximate Match)
06. Ex - Vlookup (Approximate Match)
07. Vlookup with IF (Conditional Vlookup)
07. Ex - Vlookup with IF (Conditional Vlookup)
08. Hlookup (Exact Match)
08. Ex - Hlookup (Exact Match)
09. Hlookup (Approximate Match)
09. Ex - Hlookup (Approximate Match)
10. Lookup (Don't Use This)
10. Ex - Lookup (Don't Use This)
11. Vlookup and Match (Create Magical Vlookup)
11. Ex - Vlookup and Match (Create a Magical Vlookup)
12. Match (Gives us Column and Row Number)
12. Ex - Match (Gives us Column and Row Number)
13. Index and Match (Made for Each Other)
13. Ex - (1) Index and Match (Made for Each Other)
13. Ex - (2) Index and Match (Made for Each Other)
07. Date and Time Function (a Tricky Game)
01. How Excel Records Date and Timer
02. Now, Today and Autofill
03. DateValue and TimeValue
04. Calculate Working Days
05. DatedIf
08. Financial Functions (Useful for Non-finance Guys Too)
01. Loan Calculation (PMT, PPMT, IPMT etc.)
01. Ex - Loan Calculation (PMT, PPMT, IPMT etc.)
02. Creating a Loan Table
02. Ex - Creating a Loan Table
03. Calculate Depriciation
03. Ex - Calculate Depriciation
09. Sort and Filter (Common for All)
01. Basic Sorting and Shortcut keys
01. Ex - Basic Sorting and Shortcut Keys
02. Sorting Using Custom List
02. Ex - Sorting Using Custom List
03. Horizontal Sorting
03. Ex - Horizontal Sorting
04. Basic Filter and Shortcut Keys
04. Ex - Basic Filter and Shortcut Keys
05. Filter Problem #1 (Copy Filtered Data Without Hidden Rows)
05. Ex - Filter Problem #1 (Copy Filtered Data Without Hidden Rows)
06. Filter Problem #2 (Pasting Values on Filtered Data)
06. Ex - Filter Problem #2 (Pasting Values on Filtered Data)
07. Filter Problem# 3 (Performing Calculation on Filtered Data)
07. Ex - Filter Problem #3 (Perform Claculation on Filtered Data)
08. Advanced Filter (Using Complex Criteria's)
08. Ex - Advanced Filter (Using Complex Criteria's)
10. Excel Charts (Its Time for Visual Presentation)
01. Excel Charts Introduction
02. How to Create a Chart
03. Play with Design and Layout of Chart
04. Link a Chart Title
05. How to Show Axis Title
06. How to Show Data Lable
07. Show Data with Chart in Data Table
08. Column Chart
09. Bar Chart
10. Line Chart 1
11. Line Chart 2
12. Area Chart
13. Pie Chart
14. Pie of Pie or Bar of Pie
15. Line Chart with Log Scale
16. Bubble Chart
17. Selecting Chart Elements
18. Use of Format Dialog box
19. Modifying Chart and Plot Area
20. Modifying Data Series
21. How to handle Missing Data
22. Modifying 3-D Charts
23. Creating Combination of upto 5 Different Charts
24. Creating a Chart Templates
25. Creating Picture Charts
11. Data Consolidation (Multiple Workbooks/Worksheets)
01. Consolidate Data using Excel Inbuilt Function
01. Ex - Consolidate data using Excel Inbuilt Function
12. Data Validation
01. Applying Data Validation
01. Ex - Applying Data validation
02. Dependent Dropdown List
02. Ex - Dependent Dropdown List
03. Using Data Validation with Vlookup and Match
04. Other Data Validation Examples
13. Protection of Worksheet/Workbook
01. Worksheet Level Protection
01. Ex - Worksheet Level Protection
02. Cell Level Protection
02. Ex - Cell Level Protection
03. Hiding Formulas from Formula Bar
03. Ex - Hiding Formulas from Formula Bar
04. Protecting Workbook Structure
04. Ex - Protecting Workbook Structure
05. Workbook Level Protection
05. Ex - Workbook Level Protection
14. Pivot Table and Techniques
01. Understanding Pivot Table
02. Using Pivot Table in Real Scenario
02. Ex - Using Pivot Table in Real Scenario
03. Grouping in Pivot Table
03. EX - Grouping in Pivot Table
04. Using Slicers (A Visually Attractive Filter)
04. Ex - Using Slicers (A Visually Attractive Filter)
15. What-if Analysis and Solver Add-in
01. Goal Seek (A Reverse Approach)
01. Ex Goal Seek (A Reverse Approach)
02. One Way Data Table
03. Two Way Data Table
04. Scenario Manager
05. Solver Add-In
16. Automation in Excel (Macros)
1601 Record your first Macro
1602 Record Another Macro
1603 Assigning Macros to a Shape, Button, Picture
04. Editing or Deleting a Macro
05. Security Settings of a Macro
Self Assessment Test
Self Assessment Test

11. Vlookup and Match (Create Magical Vlookup)

Microsoft Excel Basic to Advance Level 06. Lookup Functionality (Burn Simple Find Technique)
By: Lokesh Lalwani
14 minutes
Share the link to this page
Copied
  Twitter
  Email
Add the class to your calendar
Print
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$49
€44.98
£38.69
CA$66.72
A$73.12
S$65.95
HK$382.32
CHF 44.68
NOK kr526.29
DKK kr336.36
NZ$79.87
د.إ179.97
৳5,707.93
₹4,081.72
RM229.68
₦72,030
₨13,577.38
฿1,763.67
₺1,579.92
B$250.12
R898.13
Лв88.15
₩66,365.11
₪180.95
₱2,834.64
¥7,628.07
MX$813.82
QR177.76
P660.46
KSh6,360.93
E£2,294.05
ብር2,799.78
Kz41,601
CLP$43,830.38
CN¥353.93
RD$2,855.31
DA6,597.40
FJ$109.18
Q378.71
GY$10,198
ISK kr6,753.55
DH485.31
L862.48
ден2,770.99
MOP$391.73
N$891.78
C$1,794.41
रु6,498.41
S/182.03
K189.29
SAR183.75
ZK1,244.16
L224.23
Kč1,113.18
Ft17,435.90
SEK kr525.13
ARS$43,198.56
Bs336.80
COP$186,551.23
₡24,946.57
L1,206.88
₲365,221.83
$U1,901
zł191.98
Already have an account? Log In
Previous
Next
Home
Search
Saved
Trending Classes
Filter
The latest and the best classes on LearnDesk
Filter by Interest
Close
All Topics
Academics
Business
Creative
Health and Fitness
LifeStyle
Personal Development
Software
Admissions
Engineering
Hardware
Hospitality
Humanities
Chinese
Languages
Maths
Other
Pharma
Research
Science
Social Science
Teaching
Test Preparation
K-12
School
Accounting
Advertising
Analysis
Analytics
Business Communication
eCommerce
Entrepreneurship
Finance
Finance - India
Freelancing
Internet of Things
Digital Transformation
Human Resources
Industry
Management
Marketing
Media
Operations
Other
Project Management
Public Relations
Real Estate
Sales
Strategy
Arts & Crafts
Audio Editing
Audio Production
Dance
Design
Film Production
Music
Photography
Video Production
Writing
Dieting
Fitness
Food Safety
Games
Medical
Medical Professionals
Meditation
Mental Health
Pregnancy
Safety & First Aid
Self Defense
Sports
Beauty & Makeup
Food
Fashion
Gaming
Home Improvement
Parenting
Pet Care & Training
Relationships
Sustainable Living
Travel
Career Development
Learning
Religion and Spirituality
Self-Improvement
Accounting
Amazon Web Services
App Development
Continuous Integration
Backup Software
Business Automation
Computational Fluid Dynamics
Business Intelligence
Computer Aided Design (CAD)
Content Management System
Customer Relationship Management
Database
Data Mining
E-Commerce
Enterprise Asset Management
Enterprise Resource Planning
Game Development
Google Cloud
Linux
Artificial Intelligence
Machine Learning
Master Data Management
Microsoft
Music Software
Network and Security
Open Source
Operating System
Other
Process Management
Productivity Software
Programming Languages
Robotics
Supply Chain Management
Testing
Teaching
Web Development

Sign Up

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.