984 Total views
984 Total views 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 Data templates and transaction data templates in implementation projects and roll out projects. Because they have to upload the data into SAP at…
Read More »
863 Total views
863 Total views 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 excel sheet. Time to learn a new awesome function IFERROR in excel. I am 100% sure that you will not take chance to send…
Read More »
1,030 Total views
1,030 Total views 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 on daily basis. I know that you are thinking about the “Remove Duplicate” function in excel. But this article is far beyond that….
Read More »
941 Total views
941 Total views Shortcut keys in MS excel to improve your efficiency at work Here is another mind blowing blog with some reliable information on Shortcut keys in MS excel. Do not worry I will not talk about Cut, Copy, Paste. It is beyond that. I am 100% sure that…
Read More »
769 Total views
769 Total views 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 autocorrect option in MS excel could be helpful to an SAP Consultant. In general, autocorrect function in MS excel is used to correct…
Read More »
687 Total views
687 Total views 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. This article will help those who are beginners in MS excel. Someone who is new in MS excel will like this technique and…
Read More »
571 Total views
571 Total views 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 and LEN function in MS excel. This time I am discussing CLEAN function in MS excel. This function helps an SAP consultant while…
Read More »223 Total views
223 Total views 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 members. they prepare the relevant SAP master data in those MS excel sheets and finally that data comes to SAP Consultant. Master Data…
Read More »185 Total views
185 Total views 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 in FTP. Suppose I send data to a third party system using FTP (File transfer protocol). At that time system creates a file with data….
Read More »