Shortcut keys in MS excel to improve your efficiency at work Here is another mind blowing blog with some reliable information on Shortcut keys
Category: MS Excel
VLOOKUP in MS Excel: VLOOKUP in MS excel is an important time saving function, which is helpful to every SAP Functional Consultant in various ways.
Here I am discussing another MS excel function which is frequently used in master data cleansing. In my earlier post you have learnt TRIM function
This excel function can help you in Master Data cleansing In SAP Implementation project we provide master data template in MS Excel to core team
3 MS Excel Functions, every SAP Consultant must know I am writing this article to provide a simple solution to the issue of data handling
While working in SAP, many times I came across situation where I got a list of material master with more than 50000 records and I
Concatenate Function in MS Excel Concatenate function in MS Excel is an important and simple function, which can be learned easily. It is used to
How drop down list in excel can help you? Almost every SAP consultant had made this mistake. SAP Consultants spent lot of efforts in preparing Master
Learn IFERROR in excel in less than 5 minutes Time to say good bye to #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!. errors from your
5 Effortless tricks to handle Duplicates in Excel This is going to be the most interesting article for SAP consultants who handle duplicates in excel
Innovative use of AutoCorrect option in MS Excel You must be wondering after reading the headline of this post. You must be thinking, How does
Transpose in excel – Simple technique to save your time Transpose in excel is a simple but powerful technique to rotate your data in MS excel.