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