HOW TO USE SUBTOTAL | SUMPRODUCT | OFFSET FUNCTION IN EXCEL
#Levelupexcelskill
#Excelinhindi
#AdvanceExcel
#SUBTOTALFUNCTIONINEXCEL
#OFFSETFUNCTIONINEXCEL
#SUMPRODUCTFUNCTIONINEXCEL
In this video, we will learn about SUBTOTAL, SUMPRODUCT and OFFSET FUNCTION in Excel.
Download Important Function in Excel Practice File:
https://drive.google.com/file/d/1MZ1K...
What is covered in this video?
• How to use SUBTOTAL in excel
• How to calculate total sale price with SUMPRODUCT in excel
• How to use offset in excel
• How to make the dynamic range
This is free of cost Advanced Excel Training! I will also teach you Advance Array in Excel, Simple VBA to Advanced, and more! Stay tuned We hope you learn more! If you want to learn Advance Excel, Array, VBA simple to Advance with a sample workbook without paying any cost this channel is for you please subscribe to my channel. I just uploaded a video that will help you learn Advanced Excel, kindly go and watch all the videos till the end. Do not forget to subscribe. If you like videos please like, share, and support our channel.
A playlist is mentioned below:
1. Custom Formatting Tips - Simple to advance (Eng): • Custom Formatting Tips - Simple to advance.
2. Custom Formatting in Excel (Simple to Advanced) Hindi: • Custom Formatting in Excel (Simple to Adva...
3. Time Saving Utilities- Paste Special in excel (Eng): • Time Saving Utilities- Paste Special in excel
4. Time-saving utilities- Paste Special in excel In Hindi: • Time saving utilities- Paste Special in ex...
5. Text to Column become an Expert (English): • Time Saving Utilities - Text to Column bec...
6. Text to Column become an Expert (Hindi): • Time Saving Utilites - Text to Column beco...
7. Data Sorting & Group Outline in Excel (Hindi): • Data Sorting & Group Outline in Excel (Hindi)
8. Time-Saving Utilities - Data Sorting & Group Outline: • Time Saving Utilities - Data Sorting & G...
9. Cell Referencing in Excel: • Cell Referencing in Excel - Absolute, Mix...
10. AND OR and NOT function in Excel: • AND OR and NOT function in Excel | Logical...
11. COUNT, COUNTA, COUNTIF AND COUNTIFS function in excel | Important function: • COUNT,COUNTA,COUNTIF AND COUNTIFS function...
12. MAX-MIN, LARGE-SMALL, UPPER-LOWER-PROPER, LEFT-RIGH-MID FUNCTION IN EXCEL | Important Function: • MAX-MIN, LARGE-SMALL, UPPER-LOWER-PROPER, ...
13. MAX-MIN, LARGE-SMALL, UPPER-LOWER-PROPER, LEFT-RIGH-MID FUNCTION IN EXCEL | Important Function IN HINDI: • MAX-MIN, LARGE-SMALL, UPPER-LOWER-PROPER, ...
14. SUMIF-SUMIFS, CONCATENATE, NETWORKDAYS, NESTED IF, EXACT, AVERAGEIF-IFS | IMPORTANT FUNCTION IN HINDI: • SUMIF-SUMIFS,CONCATENATE,NETWORKDAYS,NESTE...
15. Vlookup,Index,Match,Hlookup Function in excel | Reverse Lookup | Important Function | Advance Excel: • Vlookup,Index,Match,Hlookup Function in ex...
If you want to Lean VBA from the beginning, below is the Playlist.
1. VBA INTRODUCTION IN-DEPTH | LEARNING VBA, DATA TYPE, VARIABLES AND MORE! • The A - Z Of Vba Introduction
2. Basic Calculation, How to use Data type, Variable, IF condition, Grading, Use Button | Learn VBA: • How to use Data type, Variable, IF conditi...
3. How to use Loops in VBA | While loop | Do While | Do Until | For Each | VBA Loops in Hindi: • How loops in vba will transform you
4. EXCEL VBA LOOPS IN HINDI | FOR LOOPS | DYNAMIC LOOPS | IF CONDITION | EVENT: • The Ultimate Guide To Loops In Vba
For any query
please write an email
Email ID = [email protected]
#offsetfunctioninexcelinhindi
#offsetfuntioninexcel
#functionoffsetexcel
#functionoffset
#subtotalfunctioninexcel
#subtotalinexcelinhindi
#subtotalfunctioninexcel
#subtotalinexcel
#sumproductexcel
#sumproductformulainexcel
#Excelinhindi
#Vlookupinexcel
#Vlookupformulainexcel
#Vlookupinexcelinhindi
#vlookupandhlookupinexcel
#vlookupformula
#IndexFunctioninexcel
#reverselookup
#reverslookupinexcel
#assignmentinexcel
#hlookupinexcel
#Hlookupinexcelinhindi
#hlookupfunctioninexcel
#matchfunctioninexcel
#matchfunctioninexcelinhindi
#Levelupexcelskill,
#LearningAdvanceExcel,
#ExcelinHindi,
#ImportantFunctioninExcel,
#ifandfunctioninexcelwithmultipleconditions
#maxfunctionExcel2016
#HowtocalculatecountinExcel
#sumifsumifs
#sumifandsumifsinexcel
#sumifandsumifsformulainexcel
#sumifandsumifsexcerciseinexcel
#interviewquestion
#sumifandsumifsfunctioninexcel
#workingdaysbetweentwodaysinexcel
#workingdays
#workingdaysinexcel
#workingdaysexcludingweekendexcel
#countworkingdaysinexcel
#iffunctioninhindi
#iffunctionwithmultiplecondition
#Nestedifinexcel