How to do a Vlookup Using Text
In this Excel tutorial, you learn how to vlookup using string of text. This is a simple trick you will understand and use many times in Excel.
Best Excel Tutorial
The Largest Excel Knowledge Base ✅ The Best Place to Learn Excel Online ❤️
How to Vlookup Backwards
Something tricky today. Let’s create some backwards VLOOKUP formula. It’s quite easy, but not obvious. Here’s an example.
How to Use Vlookup with a Drop Down List
Let’s expand your drop-down list using this simple trick in Excel. Teach yourself here how to automatically load the values into the drop-down list using VLOOKUP function.
How to do a Vlookup with Multiple Criteria
In this Excel tutorial, you will learn how to do a vlookup with multiple criteria in Excel.
How to Countif with Partial Match
In this Excel tutorial, you will learn how to countif cells with partial match in Excel. The efficiency of using the countif partial text is its contribution to a productive end-result.
How to Use Linest Function in Excel
The Linest function helps you figure out statistics for a single line in your data. It does this by using something called “least squares” to find a straight line that matches your data closely.
Then, it gives you a set of numbers that describe that line. It does all this by taking data you put into the Linest formula and giving you back the results in an array.
How to Use Cube Functions in Excel
Excel provides several cube functions to aggregate and analyze data stored in OLAP (Online Analytical Processing) cubes, which are multi-dimensional data structures used for data analysis. Cube functions allow Excel to access data from an Analysis Services data source without using a Pivot Table.
How To Use Lambda Function in Excel (The Beginners’ Guide)
Excel has a set of pre-defined functions to perform various operations as desired. So, it is very easy to get to grips with a pre-defined function to execute any mathematical, statistical or logical operation. But there are certain circumstances where you need to deal with a custom or re-usable function in Excel.
How to Use Aggregate Function?
The aggregate function is a very useful function in Excel that can perform almost twenty different tasks with ease. It is a function that will return an aggregation in either a database or list. It has the ability to ignore certain areas that the user has chosen.