Best Excel Tutorial
  • Home
  • Basic Tutorial
  • Advanced Tutorial
  • Charts
  • Tips and Tricks
  • VBA
  • Functions
  • Business Intelligence

Functions

Details
  • Functions 101
  • 6 Excel functions everyone should know
  • ABS
  • ADDRESS
  • AGGREGATE
  • AVERAGE
  • CLEAN
  • CONCATENATE
  • CORREL
  • COUNTA
  • COUNTBLANK
  • COUNTIF
  • COUNTIFS
  • CUBE functions
  • CUBEMEMBER
  • Database functions
  • DATEDIF
  • EFFECT
  • Engineering functions
  • EXP
  • FORECAST
  • FREQUENCY
  • FV
  • GAMMA.DIST
  • GROWTH
  • HLOOKUP
  • IF
  • INDEX
  • INDEX MATCH
  • INDIRECT
  • IPMT
  • IRR
  • ISERROR
  • LAMBDA
  • LEFT
  • LINEST
  • LN
  • LOG
  • LOG10
  • LOGEST
  • MATCH
  • MEDIAN
  • MID
  • MIRR
  • NORMDIST
  • NPER
  • OFFSET
  • OR
  • PMT
  • POWER
  • PV
  • QUARTILE
  • RAND
  • RATE
  • RIGHT
  • ROUND
  • SLOPE
  • SUM
  • SUMIF
  • SUMPRODUCT
  • T.DIST
  • T-TEST
  • TODAY
  • TRIM
  • VAR
  • VAR.S
  • VLOOKUP
  • XLOOKUP

Recommended lessons

  • Getting started with Excel
  • Sheet Formatting
  • Pivot table
  • Solver
  • What-If Analysis
  • Data Validation
  • Drop-down list
  • Multiple Linked Drop-Down List
  • HLOOKUP
  • Future Value
  • Present Value
  • Index function
  • Index match
  • How to calculate forecast?
  • Sumproduct Function
  • Charts 101
  • Bar Chart
  • Column Chart
  • 3 axis Chart
  • Bullet Chart
  • Chart from right to left
  • Chart with a break Y axis
  • Funnel Chart
  • Panel Chart
  • Pareto Chart
  • Budget Template
  • ROI Calculator
  • Ratio Calculation
  • Interactive Map Dashboard
  • 11 best add-ins
  • Recording macros
  • How to create own add-in?
  • What are the most common bugs in VBA code?
  • Excel's FAQ

Vlookup in Excel

  • Backwards Vlookup
  • Case Sensitive VLOOKUP
  • How to automatically load the values into the drop-down list using VLOOKUP?
  • How to do VLOOKUP with two criteria?
  • How to find common part of two columns using vlookup?
  • How to use a vlookup formula to check if a value exists?
  • Vlookup across multiple files
  • Vlookup for a range
  • VLOOKUP Function: Knowing it & 10 Examples of its Usage
  • Vlookup on multiple sheets
  • VLOOKUP text inside a string
  • Vlookup That Returns True or False

Most popular lessons

  • How to calculate the variance in Excel?
  • How to open .VCF files?
  • How to remove green triangles?
  • How to calculate logarithms and inverse logarithms in Excel?
  • How to calculate CAGR?
  • 3 axis Chart
  • How to use the integral function?
  • How to calculate ROI?
  • COUNTIF
  • Toggle button
  • BCG Matrix
  • How to apply formula to entire column?
  • How to Calculate z-score?

Our favourite lessons

  • How To Use SQL in Excel
  • How to run a SQL query in Excel VBA
  • How to convert Excel to database
  • Dynamic Chart
  • Multiple Overlay Charts
  • How To Use Slicers
  • How To Use Lambda Function
  • How to Use DAX Functions?
  • How to create own add-in?
  • How to create a folder and sub folder in Excel VBA?
  • How to use trig functions?
  • How to zoom in graph?
  • Interactive Charts

Best Excel Tutorial - the largest Excel knowledge base. Best place to learn Excel online. About Follow us: Facebook Twitter Github

Copyright © 2012-2022 Luke K