Vlookup Formula with 2 Special Conditions (Find Roll No. on the base of Student Name and Class Name)
Watch This Video to Learn Download More Excel Files
Excel Formulas
Making GST Invoice / Billing Software in Excel with Check Box and Radio Button
Below 6 Query has been Resolved in this video:- (1). Check Box Use in Excel in Hindi full Explained (2). Radio Button Use in Excel in Hindi full Explained (3). =IF ( ) Formula in Excel in Hindi full Explained (4). =Now ( ) Formula in Excel in Hindi full Explained (5). Data Validation Command … Read more
Vlookup and Hlookup Formula in Excel (Hindi)
Below 3 Query has been Resolved in this video:- (1). Vlookup Formula in Excel Hindi (2). Hlookup Formula in Excel in Hindi (3). Transpose Command in Excel in Hindi Watch This Video to Learn Download Full Data ListDownload Vlookup, Hlookup Excel Sheet Download More Excel Files
=Sumif( ) Formula in Excel in Hindi (TOP 5: Example for Sumif and Countif)
Here below in this video, i have explained the best example for Sumif Formula and Countif Formula in Excel in the Hindi Language. Watch This Video to Learn Download More Excel Files
TOP 4 Example of Countif Advance Excel Formula (in Hindi)
Here below I have given Top 4 Countif Formula Example to get faster work in MS Excel, So below is the video of the example sheet that you can download from below given download button. Formulas Explained:- (1). Countif( ) Formula in Excel (2). If-else ( ) Formula in Excel Watch This Video to Learn … Read more
Top 19: Advanced Excel Shortcuts in Hindi
Here below I have given Top 19 Advance Excel tips to get faster work in MS Excel, So below is the video of the example sheet that you can download from below given download button. Below 19 Query has been Resolved in this video:- (01). Found of Formula Source (02). Pivot Table (03). Cell Auto … Read more
Make BarCode in Excel, What is QR Code & Bar Code
Here i have explained that how can we make Barcode in Excel, this is very easy, we need to download the Barcode Font for it and install barcode font that’it. Also, i have explained that what is QR code and how can we make the QR code for our own business. Barcode font download link is … Read more
Extract Numbers and Text in Separate Cell in Excel
Here i have explained that how can we separate Text and number in Excel Cells. watch the below video and learn. Watch This Video to Learn Practice Sheet Download Code Download Download More Excel Files
MACRO (PART-3) Advanced Excel (Powerful Function) Macro in Excel in Hindi
Here in this video, i have explained Macro in Excel in Hindi, this is the part 3rd of macro of my Channel if you want to learn more about macro please check the part-1 and part-2 as the link is given below- MACRO (PART-1) Advanced Excel (Macro in Excel in Hindi) ► https://www.youtube.com/watch?v=15wKNSqUuiE MACRO (PART-2) … Read more
How to Convert Number to Dollar or any Other Currency in MS Excel
Here i have explained that how can you convert the number to text in Dollar or Rupees or any other currency, below is the screenshot of the example sheet that you can download from below given download button. also, Macro file download link is given below- Watch This Video to Learn Example-1 Screenshot (Number to … Read more
AUTOMATIC-GST Tax Calculation by Excel in Tax Invoice (CGST/SGST/IGST)
In this video, as I have given below, you will learn that how can you create own tax calculation system in excel sheet that will help you to calculate CGST, SGST, IGST automatically in Sales Invoice. Below 4 Query has been Resolved in this video:- Data Validation Command. Automatic GST Calculation in Excel Tax Invoice. … Read more
MACRO in Advanced Excel (Powerful Function) in Hindi
Here below I have given Top Example of Macro in Excel to get faster work, So below is the video of the example sheet that you can download from below given download button. Formulas Explained:- (1). Macro with Example. (2). Record New Macro. (3). CountA ( ) Function in Excel Sheet. Watch This Video to Learn … Read more