Excel Formulas

Tally to Excel Big Problem’s Solution, Remove Debit and Credit in Excel

(Last Updated: 30 Nov 2024)

Whenever we export our Tally Data into Excel file, it shows the amount in Debit & Credit Format and the problem is that we can’t apply any formula or function in that data due to the symbols of Dr. and Cr. So in this video, i will explain to you that how to Remove debit … Read more

=IF( ) Formula Auto Serial No. in Sales Invoice (Hindi)

(Last Updated: 30 Nov 2024)

Watch This Video to Learn Download More Excel Files

Merge/Combine Multiple Excel Files into one File Excel File (HindI)

(Last Updated: 30 Nov 2024)

In this video, i have explained that how to merge or combine multiple excel files data into one single file or sheet in Microsoft Excel. Watch This Video to Learn 4 Ways-Combine & Merge Multiple Excel File Download More Excel Files

Excel में Mobile Data कैसे Filter करें || Len Formula in Excel (Hindi)

(Last Updated: 30 Nov 2024)

Watch This Video to Learn Download More Excel Files

EXCEL Pivot-Table के ये ज़बरदस्त Features आपको नहीं पता होंगे, Pivot-Table in Tabular Form

(Last Updated: 30 Nov 2024)

Watch This Video to Learn Download More Excel Files

MACRO (PART-7)-VBA Code for Unhide All Excel Sheet with a Shortcut

(Last Updated: 30 Nov 2024)

Here is the code to unhide all excel sheets at one click:-  Sub UnhideSheet() Dim Sheet As Worksheet For Each Sheet In Worksheets: Sheet.Visible = True: Next Sheet End Sub Watch This Video to Learn Download More Excel Files

=MAX( ) =MIN( )Formula in Excel,Show Negative-Positive Value Separately

(Last Updated: 30 Nov 2024)

Here in this video, i have explained how to separate negative value and positive value in different cells. To separate the negative and positive value we have used =MIN & =MAX formula. Watch This Video to Learn Download More Excel Files