Excel VLOOKUP function

VLOOKUP function

This article describes the formula syntax and usage of the VLOOKUP function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.

Description

You can use the VLOOKUP function to search the first column of a range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of cells, and then return a value from any cell on the same row of the range. For example, suppose that you have a list of employees contained in the range A2:C10. The employees' ID numbers are stored in the first column of the range, as shown in the following illustration.

SAP Organizational Structure

SAP Organizational Structure 
To understand any ERP and its functions, its very important to understand its organizational structure. SAP Organizational structure includes high level hierarchy for an organization.
Basic Organizational Structure for SAP FICO is as below:
Operating concern >Controlling area >Company code > Sales Organizations /Plants/ Purchase Organizations
This is the basic organizational structure in SAP. It is true for FICO as well other modules such as Sales and Distribution (SD), Material Management (MM) and Financial Supply Chain Management (FSCM) as well.

SAP Organizational Structure

New feature of General Ledger in R12

Accounting Setup Manager
The ledger is a basic concept in Release 12. The ledger replaces the 11i concept of a set of books. It represents an accounting representation for one or more legal entities or for a business need such as consolidation or management reporting. Companies can now clearly and efficiently model its legal entities and their accounting representations in Release 12. This seems to be a major area in getting success of the shared service center and single instance initiatives where many or all legal entities of an enterprise are accounted for in a single instance, and data, setup, and processing must be effectively secured but also possibly shared.
Now, legal Entities can be mapped to entire Ledgers or if you account for more than one legal entity within a ledger, you can map a legal entity to balancing segments within a ledger.
While a set of books is defined by 3 C’s,

1. chart of accounts
2. functional currency
3. accounting calendar,

Lean Six Sigma Black Belt practice material based on IASSC LSS Black Belt Body of Knowledge (BOK)

This guide will help Lean Six Sigma Black Belt candidates prepare for a certification exam for FREE. Although this guide is based on the IASSC BOK it will still be useful for candidates seeking ASQ or other organization provided certifications.

About IASSC

The International Association for Six Sigma Certification (IASSC) is a Professional Association dedicated to growing and enhancing the standards within the Lean Six Sigma Community. IASSC is the only independent third-party certification body within the Lean Six Sigma Industry that does not provide training, mentoring and coaching or consulting services. IASSC exclusively facilitates and delivers centralized universal Lean Six Sigma Certification Standards testing and organizational Accreditation’s. Here is a link: http://www.iassc.org/.