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 after reading…
Read More »
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. Many times functional consultants come across situations where they have to search data in a certain column in ms excel sheet and match the data…
Read More »
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 handling master…
Read More »
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 cleansing is…
Read More »
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. This file…
Read More »
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 had to find out and remove unwanted space at the end or starting of the text. I always used the TRIM function to do that….
Read More »
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 join two or more strings (Text) to make one string. Let us understand the syntax first: text1: It is a mandatory field. Here we can…
Read More »
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 the time…
Read More »
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 your next…
Read More »
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. There is…
Read More »
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 typos and…
Read More »
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 learnt it…
Read More »