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.

Complete tutorial on Data Validation with formulas in excel in Hindi

Formula Used - Excel COUNTIF, COUNTIFS, SUMIF, VLOOKUP function

Data validation in excel is used to restrict the user from entering the wrong or duplicate value. The data validation function in excel is quite useful to protect or apply multiple types of retractions on data. The custom data validation function in excel provides the flexibility to customize data as per requirement by using multiple formulas.
So, this is the complete data validation video for all the users. Learn & apply

Excel drop down list | Data Validation | Drop down List

Formula Used - DATA VALIDATION TECHNIQUE

Learn to use basic and advanced levels of Drop down list in excel. How to create a dynamic and customized drop-down list in excel.: πŸ”₯πŸ”₯πŸ”₯πŸ”₯πŸ”₯
βœ”οΈ create excel drop-down list
βœ”οΈ Create Name Manager in Excel
βœ”οΈ Dynamic Drop down list in Excel

Index Match in Excel | Index Match multiple criteria

Formula Used - Excel INDEX, MATCH function

Learn to use Index Match Formulas in Excel in different scenarios: πŸ”₯πŸ”₯πŸ”₯πŸ”₯πŸ”₯
βœ”οΈ What is the Index formula in Excel?
βœ”οΈ What is the Match formula?
βœ”οΈ How to use the Index Match in excel?

Nested IF +And formula in excel | IF function excel | Excel Tutorial

Formula Used - Excel NESTED IF, AND function

This video is beneficial for everyone who is interested to learn everything about IF and AND Formula in detail. In this video, you will learn how to use the Nested IF in Excel with AND formula πŸ”₯πŸ”₯πŸ”₯πŸ”₯πŸ”₯
βœ”οΈ What is Nested IF in excel
βœ”οΈ How to use Nested IF + AND Formula

Power Query in Excel | Import data from SQL Server to Excel

Formula Used - Power Query in Excel

This video is beneficial for everyone who is interested to learn everything about IF and AND Formula in detail. In this video, you will learn how to use the Nested IF in Excel with AND formula πŸ”₯πŸ”₯πŸ”₯πŸ”₯πŸ”₯
βœ”οΈ What is Nested IF in excel
βœ”οΈ How to use Nested IF + AND Formula

How to create dynamic charts in Excel based on latest dates

This video is beneficial for everyone who is interested to learn how to create dynamic charts in Excel.
βœ”οΈ How to update the chart automatically
βœ”οΈ How to extract the data from the latest dates automatically

Excel Data Analysis | Data Analyst

Formula Used - EOMONTH Formula

In this video, you will learn how to use custom dates in Excel.πŸ”₯πŸ”₯πŸ”₯πŸ”₯πŸ”₯
βœ”οΈ How Data Analyst do analytics in Excel
βœ”οΈ Excel Data Analysis

VLOOKUP formula from A TO Z with multiple formula in multiple conditions in excel

Formula Used - IF + ISTEXT + + VLOOKUP + VLOOKUP+ MATCH + MAX + IFERROR

Learn what is VLOOKUP in excel and how to apply it in multiple conditions. πŸ”₯πŸ”₯πŸ”₯πŸ”₯πŸ”₯
βœ”οΈ Scenario 1 – IF + ISTEXT + VLOOKUP
βœ”οΈ Scenario 2 – VLOOKUP + MATCH + MAX
βœ”οΈ Scenario 3 – IFERROR + VLOOKUP + VLOOKUP

Conditional formatting in excel | Excel Tips and Tricks

Formula Used - IF + COUNTIF + LEFT Formula

In this video, you will learn how to apply Validation checks by using Advanced Conditional Formatting in Excel with formulas πŸ”₯πŸ”₯πŸ”₯πŸ”₯πŸ”₯
βœ”οΈ OR + COUNTIF Formula
βœ”οΈ OR + COUNTIF + LEFT Formula
βœ”οΈ OR + COUNTIF + COUNTIFS Formula

Conditional formatting in excel | Excel Tips and Tricks

Formula Used - IF + COUNTIF + LEFT Formula

In this video, you will learn how to use Advanced Conditional Formatting in Excel with formulas πŸ”₯πŸ”₯πŸ”₯πŸ”₯πŸ”₯
βœ”οΈ Conditional Formatting + MIN Formula
βœ”οΈ Conditional Formatting + VLOOKUP Formula

Advanced Excel Formulas | VLOOKUP Formula

Formula Used - VLOOKUP + MID + FIND + MATCH formula

In this video, you will learn how to use multiple formulas together in Excel at an Advanced level πŸ”₯πŸ”₯πŸ”₯πŸ”₯πŸ”₯
βœ”οΈ How to use Vlookup Formula in Excel
βœ”οΈ How to Fill blank values in Excel
βœ”οΈ How to use Sumif Formula with Wildcards

Advanced Excel Formulas | VLOOKUP Formula

Formula Used - VLOOKUP + LEFT + CONCATENATE formula

In this video, you will learn how to use multiple formulas together in Excel at an Advanced level πŸ”₯πŸ”₯πŸ”₯πŸ”₯πŸ”₯

Conditional formatting in excel | Excel Tips and Tricks | Conditional Formatting kya hota h

In this video, you will learn how to use Advanced Conditional Formatting in Excel with formulas πŸ”₯πŸ”₯πŸ”₯πŸ”₯πŸ”₯
βœ”οΈ How to highlight one Column based on another column’s value
βœ”οΈ How to use Formulas in Conditional Formatting in Excel
βœ”οΈ How to highlight data in one sheet based on another sheet of data

Filter in Excel | Excel Advanced Filter | excel advanced filter copy to another sheet

Filter is used to extract unique records from the large database as per requirements. Filtering can be done from basic to advanced levels.
βœ”οΈ What is filter and advanced filter in excel
βœ”οΈ How to extract unique records?
βœ”οΈ How to apply Excel Advanced Filter?
βœ”οΈ How to move data from one sheet to another without copying the information?

Custom Sort data in excel | How to sort data in excel | Sorting

In this video, you will learn how to use Advanced Sorting in Excel like: πŸ”₯πŸ”₯πŸ”₯πŸ”₯πŸ”₯
βœ”οΈ How to sort data in excel by Color?
βœ”οΈ How to sort the multiple columns together in excel?
βœ”οΈ How to sort the data in EAP order?

Learn to use MULTIPLE ADVANCED formulas together in excel in Hindi

Formula Used - IF, TEXT, EOMONTH & SUMIF formulas

Multiple Advanced Formulas together in Excel. πŸ”₯πŸ”₯πŸ”₯πŸ”₯πŸ”₯
βœ”οΈ Today’s total sales (SUMIF Formula + TODAY Formula)
βœ”οΈ Yesterday’s total sales (SUMIF Formula + TODAY Formula)
βœ”οΈ Total sales in the current month (SUMIF Formula + EOMONTH + TODAY Formula)
βœ”οΈ Total sales in the current month for “US” Order ID (SUMIFS + EOMONTH + TODAY Formula)
βœ”οΈ Calculate Total sales of the current month in all years (SUM + IF + TEXT + TODAY Formula)

Complete Excel tutorial on Advanced IF Formula with multiple conditions

Formula Used - IF, LEFT, SUMIF formulas

Learn how to use logical functions in excel like if function with multiple conditions. πŸ”₯πŸ”₯πŸ”₯πŸ”₯πŸ”₯
βœ”οΈ How to fill blank cells by IF Formula in Excel?
βœ”οΈ How to use the SUM and IF formula in Excel with array conditions?
βœ”οΈ How to use SUM, IF, and LEFT formulas with array conditions?
βœ”οΈ How to extract Unique Employee ID count?
βœ”οΈ How Extract a Unique Employee ID count in multiple conditions?

How to Extract First and Last Name

Formula Used - LEFT, RIGHT, LEN, FIND formulas

Learn how to extract the First and Last Names of the world’s richest people.. πŸ”₯πŸ”₯πŸ”₯πŸ”₯πŸ”₯
βœ”οΈ Use Text Formulas in Excel (LEFT, RIGHT, LEN, FIND).
βœ”οΈ Extract First and Last Name.

Link Charts with check boxes in excel

learn how to create Excel Dashboard in Excel with linking charts with checkboxes without using VBA πŸ”₯πŸ”₯πŸ”₯πŸ”₯πŸ”₯
Checkboxes in dashboards are used to change the data according to need.
Linking charts with checkboxes helps to show the complete data in a small space with diversifications.

Conditional formatting in excel | Excel Tips and Tricks | AND Formula in Excel

Formula Used - AND formulas with Conditional formatting

In this video, you will learn how to use Advanced Conditional Formatting in Excel with formulas πŸ”₯πŸ”₯πŸ”₯πŸ”₯πŸ”₯
βœ”οΈ How to color Excel Data Automatically
βœ”οΈ How to use Formulas in Conditional Formatting in Excel
βœ”οΈ How to color the data through Drop-Down selection