285 Total views
285 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 »
265 Total views
265 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 »
285 Total views
285 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 »
307 Total views
307 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 »
250 Total views
250 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 »
192 Total views
192 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 »
179 Total views
179 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 »65 Total views
65 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 »77 Total views
77 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 »