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

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    

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

if else formula, time formula, penalty formuala, max formula, if else formula in excel, time formula in excel, penalty formuala in excel, max formula in excel, excel hidden formula, excel secret formula,

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

How to Make Word-Cloud for Official Presentation for PowerPoint / Word / Excel or for Website

Friends, Lots of times when we make any type of presentation, we need an effective image as related to our topic as we are presenting. If you search on the internet, you will find that people enter a word cloud in their presentation, or in a file or on their website post. so here in … Read more

Automatic Pricing in Sales Invoice in EXCEL

Automatic Pricing in Sales Invoice in EXCEL || Combination of IF Formula, Vlookup Data Validation

Friends, Here in this video, i have explained about some formula combination in excel. we have solved a big problem in excel invoicing that is automatically picking the pricing from Pricing Table into our Sales Invoice format. So we have used Data Validation command and Vlookup Command with IF Else Function to solve this problem … Read more

TOP-3 Excel Hidden Shortcut keys & Commands Best Time-Saving Tricks

Friends here in this video i have explained about AutoCorrect Command and how can we use AutoCorrect Command in our daily routine. We can save lots of time by using this command in excel. I have applied Auto Correct Command in our Billing Format. Also, i have explained that how to play with months in … Read more

Make Sales Commission Report in Excel (in Hindi)

sales commission tracker template for excel , sales commission template excel , employee commission template , sliding scale commission excel template , google sheets commission template , sales commission calculator , sales commission statement , free sales commission report template

Here we have used IFS Formula in Excel to calculate and prepare the Sales Commission Report for our Sales Man. IFS Formula is not available in Excel 2007 but you can use it in the latest version of excel. Watch This Video to Learn      

Match 2 Data in Excel || Compare 2 Data in Excel || Compare Two Lists in Excel (in Hindi)

Match 2 Data in Excel Compare 2 Data in Excel Compare Two Lists in Excel (in Hindi)

Here in this video, i have explained that how to compare two data lists in excel and extract the unmatched data in a new sheet. so watch this video completely to learn how to match 2 data in an excel sheet. Watch This Video to Learn      

Excel Hidden Command in Excel – Fill Justify Command in Excel (in Hindi)

Tech Guru Plus,TechGuruPlus,excel justify shortcut,excel fill justify,how to add justify button in excel,left justify in excel,how to auto align in excel,how to align colon in excel,excel justify across selection,align data in excel

Fill justify is a lifesaver option. The single-core motive to use fill justify in Excel is to merge the data from multiple cells…..into a single cell. And, if you have any other idea to merge text into one cell, leave it. Fill justify is a better option. So today, in this post, you will learn … Read more

Excel Hidden Trick (in Hindi) || Copy Only Visible Filter Data in Excel

advanced excel tricks pdf , advanced excel tips and tricks 2016 , excel tips and tricks 2018 , excel tips and tricks 2018 pdf , excel tips and tricks 2019 , hidden excel features , excel tricks youtube , excel tricks 2018 , how to copy and paste filtered data in excel 2016 , copy visible cells only excel 2010 , copy visible cells only shortcut ,

In this video, i have explained that how can you copy visible cell’s data and paste to another area in excel. Mostly in Filter, it happens that when doing filter and copy the filtered cells and paste to another area, all data appears after pasting, but we want only visible filtered data to another area … Read more

Attendance Data Problem Solution in Excel (in Hindi) by TechGuruPlus

Here in this video, i have explained that how can you merge 2 excel data in one excel sheet. I have taken an example of the Big Attendance sheet of a company, there i need to merge the Attendance sheet with Leave avail sheet and finalize a data with the merge sheet. so how it … Read more

MACRO (PART-6) Passport Form Data Filling in Excel Data AutoSave in Next Sheet

Tech Guru Plus,TechGuruPlus,macro in excel macro in excel in hindi,macro in excel for beginners,macro in excel 2007 with example,macro in excel 2007 with example in hindi,excel macro tutorial for beginners,excel macro tutorial for beginners in hindi,excel macro in hindi,macro in excel 2013

Hi, in this video i have explained that how to save data from one sheet to another sheet in excel via Macro Function, So i have taken the Passport Application form data in excel to make it understand. so watch this video and learn. Watch This Video to Learn