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

Top 6: Advanced Excel Shortcuts (Powerful & Faster) in Hindi

(Last Updated: 30 Nov 2024)

If you want to increase your working speed in excel then this video is for you, here in this video i have explained MS Excel Top 6 amazing shortcut keys that will help to work faster and easier. Watch This Video to Learn Download More Excel Files

Penalty Formula IF employee reach Office Late with =IF( ),=TIME(hr,mm,sec), =MAX( )

(Last Updated: 30 Nov 2024)

Friends, in this video i have explained a formula with the help of which you can calculate the Penalty Amount if Office Employee Reach office late time after office timing. So here i have used MAX FORMULA, IF-ELSE FORMULA AND TIME FORMULA to solve the issue. I hope it will be very helpful for you. … Read more