Category: MS Excel

Drop down list in excel can help you to prepare clean data

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 of cut over. But while uploading the data they come across lots of error. They spent lot of time to fix the errors. They…

Read More »

How to avoid #N/A, #REF! in your sheet – Learn IFERROR in excel

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 VLOOKUP excel sheet to your client without this formula. IFFERROR in excel was introduced after MS Excel 2003 release. The idea behind this formula is…

Read More »

5 Effortless tricks to handle Duplicates in excel [with Bonus Tip]

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 an additional “Bonus tip” at the end of this article. Many times new SAP consultants lose their valuable time and dynamism in handling huge data and…

Read More »

Shortcut keys in MS excel to improve your efficiency at work

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 these shortcut keys your work efficiency will improved to a significant extent. I also request you to open an excel sheet with some dummy data and…

Read More »

Innovative use of AutoCorrect option in MS 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 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 misspelled words. It is also used to insert symbols and other piece of text. For example if you type a word “accross”, then autocorrect function…

Read More »

Transpose in excel – A simple technique to save your valuable time

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 immediately. Please share the post if you like it. Suppose you have data in vertical cells and you want to convert it into a horizontal…

Read More »

CLEAN function in MS Excel to remove non-printable characters from SAP Master Data

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 data and cut-over data. When we get data master data or legacy data from core team members, sometimes we get line breaks, special characters or…

Read More »

This excel function can help you in Master data cleansing

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 duty of core team members, but many times core team member requires help from SAP Consultant in data cleansing activities. One of the important criteria…

Read More »

3 MS Excel Functions, every SAP Consultant must know

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 gets copied in the directory (t code-AL11). This output looks like a newspaper. It’s very difficult to handle this data. Even if I know that first…

Read More »