1,587 Total views
1,587 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 »
1,341 Total views
1,341 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,732 Total views
1,732 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 »
1,577 Total views
1,577 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 »
1,213 Total views
1,213 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 »
1,065 Total views
1,065 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 »
948 Total views
948 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 »349 Total views
349 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 »329 Total views
329 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 »