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

In-depth Microsoft Excel and Business Data Analysis

Introduction
Introducing to Trainer and the Course
Data Manipulation in Excel and Setting the Foundation
How Excel Handles Different Data Types
Data Consistency, Starting With the End in View
Building Data Sheets that can Scale
Sorting
Filtering
Data Cleaning 1
Data Cleaning 2
Data Formatting
Charts
Charts Part 1
Charts 2
Creative Excel Use and Tips
Creative Excel Features Part 1
Creative Excel Features Part 2
Specials - Creative Excel Use
Special Video - Excel Keyboard Shortcuts Part 1
Special Video - Excel Keyboard Shortcuts Part 2
Business Data Analysis
Pivot Table, Pivot Chart, PowerPivot
Mail Merge
Business Data Analysis Part 1
Business Data Analysis Part 2
Business Data Analysis Part 3
Forecasting Using Excel 2016 Forecasting Tool
Data Visualization Part 1
Data Visualization Part 2
Excel Reports and Presentation
Named Range, Goal Seek, Scenario Manager Part 1
Named Range, Goal Seek, Scenario Manager Part 2
Excel Web Query
Power Excel Functions Part 1
Power Excel Function Part 2
Power Excel Function Part 3
Power Excel Function - Sum Product
New Excel Function - XLook Up
New Excel Function Unique
New Excel Function - Sort
Connect to Google Sheets From Excel
Fuzzy Lookup for Matching Inconsistently Typed Entries
Excel Macros
Userform and More Macros
Excel Store: Nigerian Market Data
Special Webinar Sessions
Webinar on Using Microsoft Excel for Investment Planning and Personal Finance
Webinar on Predictive Analysis in Microsoft Excel
Webinar on Power Query and Power Pivot
Power BI (Bonus Section Not in-Depth)
Power BI
Excel for Mac Tips
How to Enable Developer Tab in Excel for Mac
Set Calculation Options in Excel for Mac
How to Check for Excel for Mac Version
Custom Lists in Excel for Mac
How to Change Default Font Type and Size in Excel for Mac
Grouping Menu Items Titles in Excel for Mac

New Excel Function - XLook Up

In-depth Microsoft Excel and Business Data Analysis Business Data Analysis
By: Michael Olafusi
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
$19.99
List Price:  $24.99
You save:  $5
€17.23
List Price:  €21.54
You save:  €4.31
£15.08
List Price:  £18.85
You save:  £3.77
CA$27.96
List Price:  CA$34.95
You save:  CA$6.99
A$30.59
List Price:  A$38.25
You save:  A$7.65
S$25.93
List Price:  S$32.42
You save:  S$6.48
HK$155.62
List Price:  HK$194.54
You save:  HK$38.92
CHF 16.04
List Price:  CHF 20.06
You save:  CHF 4.01
NOK kr202.51
List Price:  NOK kr253.17
You save:  NOK kr50.65
DKK kr128.73
List Price:  DKK kr160.93
You save:  DKK kr32.20
NZ$34.86
List Price:  NZ$43.58
You save:  NZ$8.72
د.إ73.41
List Price:  د.إ91.77
You save:  د.إ18.36
৳2,435.82
List Price:  ৳3,045.08
You save:  ৳609.25
₹1,786.25
List Price:  ₹2,233.04
You save:  ₹446.78
RM82.60
List Price:  RM103.27
You save:  RM20.66
₦28,818.50
List Price:  ₦36,026.74
You save:  ₦7,208.23
₨5,631.61
List Price:  ₨7,040.22
You save:  ₨1,408.60
฿639.14
List Price:  ฿799
You save:  ฿159.86
₺849.29
List Price:  ₺1,061.72
You save:  ₺212.42
B$106.64
List Price:  B$133.32
You save:  B$26.67
R342.06
List Price:  R427.62
You save:  R85.55
Лв33.70
List Price:  Лв42.13
You save:  Лв8.43
₩29,337.72
List Price:  ₩36,675.82
You save:  ₩7,338.10
₪65.08
List Price:  ₪81.36
You save:  ₪16.27
₱1,172.11
List Price:  ₱1,465.28
You save:  ₱293.17
¥3,121.73
List Price:  ¥3,902.56
You save:  ¥780.82
MX$365.71
List Price:  MX$457.19
You save:  MX$91.47
QR72.65
List Price:  QR90.82
You save:  QR18.17
P285.18
List Price:  P356.51
You save:  P71.33
KSh2,581.28
List Price:  KSh3,226.92
You save:  KSh645.64
E£948.45
List Price:  E£1,185.69
You save:  E£237.23
ብር3,076.12
List Price:  ብር3,845.54
You save:  ብር769.41
Kz18,310.84
List Price:  Kz22,890.84
You save:  Kz4,580
CLP$18,552.11
List Price:  CLP$23,192.46
You save:  CLP$4,640.35
CN¥141.43
List Price:  CN¥176.81
You save:  CN¥35.37
RD$1,248.67
List Price:  RD$1,560.99
You save:  RD$312.32
DA2,595.02
List Price:  DA3,244.09
You save:  DA649.07
FJ$45.40
List Price:  FJ$56.75
You save:  FJ$11.35
Q152.70
List Price:  Q190.89
You save:  Q38.19
GY$4,170.34
List Price:  GY$5,213.45
You save:  GY$1,043.10
ISK kr2,554.22
List Price:  ISK kr3,193.10
You save:  ISK kr638.87
DH184.92
List Price:  DH231.18
You save:  DH46.25
L336.81
List Price:  L421.06
You save:  L84.24
ден1,060.38
List Price:  ден1,325.61
You save:  ден265.22
MOP$159.87
List Price:  MOP$199.86
You save:  MOP$39.98
N$341.35
List Price:  N$426.73
You save:  N$85.38
C$733.52
List Price:  C$916.99
You save:  C$183.47
रु2,852.51
List Price:  रु3,565.99
You save:  रु713.48
S/67.08
List Price:  S/83.86
You save:  S/16.77
K85.67
List Price:  K107.10
You save:  K21.42
SAR74.99
List Price:  SAR93.75
You save:  SAR18.75
ZK456.96
List Price:  ZK571.26
You save:  ZK114.29
L87.80
List Price:  L109.77
You save:  L21.96
Kč415.94
List Price:  Kč519.97
You save:  Kč104.03
Ft6,571.70
List Price:  Ft8,215.44
You save:  Ft1,643.74
SEK kr188.92
List Price:  SEK kr236.18
You save:  SEK kr47.25
ARS$28,913
List Price:  ARS$36,144.86
You save:  ARS$7,231.86
Bs137.74
List Price:  Bs172.19
You save:  Bs34.45
COP$74,661.96
List Price:  COP$93,336.79
You save:  COP$18,674.82
₡9,937.69
List Price:  ₡12,423.35
You save:  ₡2,485.66
L524.89
List Price:  L656.18
You save:  L131.28
₲139,394.55
List Price:  ₲174,260.63
You save:  ₲34,866.07
$U789.30
List Price:  $U986.73
You save:  $U197.42
zł72.79
List Price:  zł90.99
You save:  zł18.20
Subscription
$19.99
$9.99
per month
Payment Plan
$19.99
$11.99
per month
3 payments
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.