SAP is frequently known as an enterprise resource arranging (ERP) for the management of supply chain, customer relationship, item life cycle and supplier partnership. Lots of business data are generally captured into the technique. You will produce many reports that will assistance understand your organization and make smarter quality decisions. Getting a good understanding of the business enterprise to facilitate decision making usually require analysing the information in multiple perspective. Customers, sometimes, have no thought exactly what they are really looking for until they have an initial view on the data. While SAP is with the capacity of generating these reports, it is relatively expensive compared to performing it in Excel and extended wait to create the reports make it infeasible to these users, who need the info to make time sensitive decisions. As a result, users typically resort to download the raw information from SAP and analyse these information using Excel.
Importing data from SAP is usually quite straight forward. For some of my customers, this can be a uncomplicated click of the button and the information are imported into an excel worksheet. For some, they have to run pre-defined query via Microsoft Access and export the information into an excel worksheet. Whichever strategy they used, they are likely to face the problem of having to work manually with the dates. These dates are generally formatted as text and are not great for analysis working with Excel. With the suitable skills and understanding of excel, they have to have to resort to manually convert these dates, eyeballing the dates and re-form them into Excel, edit and enter the cells one record by a single records, so that they could be helpful for analysis using Excel Pivot Table or the SUBTOTAL function. But unknown to these users, there is no will need to take hours or days to manually convert these text dates into Excel readable dates. All it calls for are some formula and you might have them converted into right dates in seconds. To learn how, join import data into excel (one email per week) on the different approaches of conversion. The answers to the challenges are provided in the subsequent week. At the end of the course, you won’t only learn the dates functions to do the job, you will also find out how to do proficiently convert any type of dates in much less than 5 seconds. Need to you be keen to study the tricks, take up the 7-week SAP challenge on our Sophisticated Excel website.
About the Author
