Excel Tutorial

How to use cell Referencing in Excel | How to freeze data in Excel

There are 3 types of cell references in excel:
Absolute Referencing
Relative Referencing
Mixed Referencing.
Relative Referencing: It is the default referencing in excel where the formula is working dynamically. If the formula is copied from one cell and pasted to the different cell(s), the relative positions of rows and columns will change accordingly.

Learn to use VLOOKUP with Multiple Criterias in Excel

Formula Used - VLOOKUP function and CHOOSE formula

Excel function Vlookup is used to look up and retrieve data from a particular column in the table in Excel. In this vlookup tutorial you will learn:
✔️ How to use the vlookup function with multiple criteria 
✔️ How to use the vlookup formula and choose formula together
✔️ How to use Vlookup with duplicate values in the column or if multiple criteria come in the data.

Excel pivot table grouping | Grouping fields in pivot table

Formula Used - Nested IF

Pivot table grouping helps to show a subset of data to analyze in detail. Most of us know, how to create pivot tables in excel. But very few of us know what is pivot table grouping and how to use grouping fields in pivot table. 🔥🔥🔥🔥What you will learn in this Pivot Table tutorial:
✔️ What is pivot table grouping
✔️ How to apply pivot table grouping

Complete tutorial on AUTO REFRESH PIVOT TABLE in #excel

Formula Used - Pivot table automatically with VBA Code

Most of us know, how to create pivot tables in excel. But very few of us know how automatically update the pivot tables when source data changes. In this video, you will learn, how to automatically refresh the pivot table when data in the sheet changes.🔥🔥🔥What you will learn in this Auto-refresh Pivot table tutorial:
✔️ Refresh Pivot table automatically with VBA Code

Set notification & reminder of expiry date in #excel

Formula Used - Excel filter function & conditional formatting

Learn how to set automatic notifications and reminders of expiry dates in excel. How to use advanced filter function and advanced conditional formatting to set notification alert in excel. To get expiry or due date notifications or messages in excel is beneficial for the user of the data. In this set notification or reminder of due date tutorial, you will learn:
✔️ How to use filter function and conditional formatting for due or expiry date alert.
✔️ How to extract only data that is going to expire within 30 days

How to add and link target line with scrollbar in charts in excel

Formula Used - Excel IF

Most of us work on excel on daily basis and deal with huge data. It is very important to understand how to present your huge data in the form of graphs and charts which can be presented to the management and helps in decision making.
🔥🔥 What you will learn in this add target line with scrollbar tutorial:
✔️ How to add target line in excel chart
✔️ How to link scrollbars with target line in excel

Conditional formatting in excel | Excel cell borders | Dynamic borders excel

Formula Used - Dynamic borders excel

Multiple times we do the data entry or copy & paste the data in excel from different sources and then we do all borders or use conditional formatting borders in excel manually. Learn to apply dynamic borders on data in excel without using VBA. In this automatic borders apply tutorial, you will learn:
✔️ How to add border in excel automatically in specific cells
✔️ How to apply borders automatically in the complete row

Excel pivot table auto refresh | Advanced pivot tables

Formula Used - OFFSET, COUNTA

Learn 2 ways to automatically refresh the pivot table in excel, when the data sources change. You will also learn, to automatically refresh the pivot table when data in the sheet changes.🔥🔥
What you will learn in this video:
✔️ Refresh Pivot table automatically with formula
✔️ Refresh Pivot table automatically without formula

Link/Combine and consolidate data of two (multiple)spreadsheets in excel

Formula Used - Link two excel files together

Learn how to make a data connection between two excel workbooks along with a set timer to automatically refresh linked excel file data every 5 minutes. When we need the reference of a data on daily basis then the best option is to link data from different excel sheets and workbooks which saves a lot of time. In this tutorial you will learn:
✔️ How to link cells in different excel spreadsheets
✔️ Data refresh in Excel Automatically every 2 or 5 minutes

Restrict copy and paste in excel | protect cells from editing

Formula Used - Protect data in an excel sheet

Learn to protect data in excel is important which you can restrict users from copying and pasting data in excel. It is very easy to lock cells and protect sheets in excel but most of us don’t know how to restrict users from copying the data. 🔥🔥🔥🔥🔥 Learn in this video:
✔️ How to protect data in an excel sheet
✔️ Restrict users from copying and pasting data in excel sheet

Use Dynamic Scroll Bars in Excel without VBA | Scroll bar in excel

Formula Used - Excel INDEX Function

On regular basis, we all work on huge data with multiple rows and columns. But have you ever thought if we can squeeze 5000 rows & 20 columns of data in just 10 rows and 10 columns?🔥🔥🔥🔥🔥 What you will learn in this video:
✔️ How to use horizontal scrolling
✔️ How to use Index formula in excel
✔️ How to squeeze 5000 rows & 20 columns of data in just 10 rows and 10 columns

Userform combobox | How to use Combo box in Excel without VBA

Formula Used - Excel FILTER Function

The user can select the options from the excel Combobox dropdown list based on which the filtered data will be extracted from the other sheet automatically. No manual efforts are required to copy & paste the data from one sheet to another. Everything is going to happen without VBA. 🔥🔥🔥🔥🔥
What you will learn in this video:
✔️ How to activate developer tab to the ribbon
✔️ How to use excel filter function

How to delete blank rows in excel | how to remove blank rows in excel

Formula Used - Excel IF, ROW, SMALL, INDEX, IFERROR, FILTER Function

Learn 3 different tricks on how to delete blank cells and clean data in excel without VBA. Learn how to do data cleaning in Excel quickly without VBA which can save a lot of time in excel.. 🔥🔥🔥🔥🔥
What you will learn in this video:
✔️ How to delete blank rows in excel with formula
✔️ Office 365 formulas

Sumproduct Formula in multiple conditions (from basic to advanced)

Formula Used - Excel SUMPRODUCT, SUMIFS function

Sum product function in excel help us to save a lot of time. The sumproduct function in excel is the combination of product and sum formulas in excel. Let’s see how to use sumproduct with multiple criteria in hindi.🔥🔥🔥🔥🔥 What you will learn in this video:
✔️ How to apply sumproduct function in excel in Hindi
✔️ How to use sumproduct formula in multiple conditions in excel

Vlookup and if function together | VLOOKUP with if function in Hindi

Formula Used - Excel IF, VLOOKUP, IFERROR function

Have you ever thought about which is a better formula – IF or VLOOKUP. Actually, both are good formulas because both of them have their own importance. But today, in this video we are going to discuss which can be the possible scenarios where the VLOOKUP formula can replace the IF formula in excel and how to use the IF and VLOOKUP formula together.

Excel filter function | Filter formula in excel || Dynamic filters | Advanced filter or criteria

Formula Used - Excel filter, Sum & Text formula

Most of us know how to apply filter in excel. When data is filtered, it shows only the rows which meet the filter criteria, and the other rows will be hidden. We use the filter function in excel manually but excel 365 gives the flexibility to use the filter as a formula which helps to extract the data dynamically. In this video, you will learn what is excel filter function and how to extract the data from one sheet to another automatically using this formula.

Xlookup can only replace multiple formulas in excel | xlookup vs vlookup

Formula Used - Excel Vlookup, Hlookup, Xlookup, Match. Iferror, Sum, Wildcards, Offset function

Learn what is excel xlookup and how xlookup is different from vlookup formula. We all are familiar with excel vlookup formula. There is a new formula which is available as of now only in office 365 Xlookup, which can replace multiple formulas in excel completely and vlookup is one of them. This is the part 1 of xlookup formula.

Excel xlookup | Xlookup hindi | Xlookup vs Vlookup in Excel

Formula Used - Excel Vlookup function

We all are familiar with excel vlookup formula. There is a new formula which is available as of now only in office 365 Xlookup, which can replace multiple formulas in excel completely and vlookup is one of them. This is the part 1 of xlookup formula.What you will learn in this video:
✔️ What is xlookup in excel
✔️ Benefits of excel xlookup function
✔️ xlookup vs vlookup in excel

Stop use to enter any wrong information in excel | Custom Data validation

Formula Used - Excel AND, LEN, ISNUMBER function

On daily basis, we use excel, but it will be a challenging and time-consuming task when we get unstructured data from the user. So, in this video, we are explaining 3 different scenarios of how you can stop the user from entering the wrong data in Excel. After using these tricks, you can prepare the data in such a way that the user will enter only the information which you allow him to enter.🔥🔥🔥🔥🔥

How to extract numbers from text in excel | Extract number formula excel

Formula Used - Excel CONCAT, IF, ISNUMBER, MID, ROW, INDIRECT, LEN function

Learn how to extract numbers from text in excel using formulas and without formulas. 🔥🔥🔥🔥🔥 What you will learn in this video:
✔️ How to extract numbers from text in excel
✔️ How to clean the data
✔️ How to use Add-Ins in excel
✔️ How to separate text and numbers in excel

Extract data from multiple sheets in a single sheet in excel in #Hindi

Formula Used - Excel SUM, INDIRECT function

Extract values from multiple sheets into a single sheet WITHOUT using excel VBA in HINDI. The indirect function in excel is one of the advanced excel formulas which is commonly asked in interviews nowadays.
What you will learn in this video:
✔️ What is Indirect Formula in excel in Hindi
✔️ How to use Indirect with sum function or sum with indirect formula in excel

Offset Function in Excel | Excel Offset Function | Excel Offset range

Formula Used - Excel COUNTIF, OFFSET, MATCH, AVERAGE function

Learn what are other formulas in excel that we can use to replace Vlookup and Match or Index and Match at basic, intermediate, and advanced levels. 🔥🔥🔥🔥🔥
✔️ What is the offset function in excel and how to use it in excel
✔️ How to use offset with index and match Formula in Excel

How to create excel drop down list | Drop Down List in Excel | Data Validation in Excel

Formula Used - Excel IF, COUNTIF, ROW, INDEX, SMALL, IFERROR, OFFSET function

If you are interested in learning advanced topics in Excel then, this video is for you, where you will learn to create excel drop-down list by using the data validation function in excel. 🔥🔥🔥🔥🔥
✔️ How to create an excel drop-down list.
✔️ How to use IF, Coutif, Row, Index, Small, Iferror, Offset, and Name manager to create drop-down list.