The Genpact DNA of Lean Six Sigma

Lean Six Sigma is a methodology for quality improvement that has been around for many years in the industrial environment.
GE under Jack Welch, was a leading proponent of Lean Six Sigma globally. Genpact (at that time known as GE Capital International Services) was the first service provider in the world to apply this methodology at scale for business processes making this practice a tremendous success.
Lean Six Sigma permeates what we do and is highly visible in our operations, people, processes, and leadership direction.
We take a different approach to implementation of Lean Six Sigma, going beyond the scope of the contract to take a comprehensive upstream/downstream view, which extends our impact on client’s businesses.

Six Sigma Key Elements

There are three key elements of Six Sigma Process Improvement.

• Customers
• Processes
• Employees

The Customer:

Customers define quality. They expect performance, reliability, competitive prices, on-time delivery, service, clear and correct transaction processing and more.
Today, Delighting a customer is a necessity. Because if we don't do it, someone else will!

The Processes:

Defining Processes and defining Metrics and Measures for Processes is the key element of Six Sigma.
Quality requires to look at a business from the customer's perspective, In other words, we must look at defined processes from the outside-in.
By understanding the transaction lifecycle from the customer's needs and processes, we can discover what they are seeing and feeling. This will give a chance to identify week area with in a process and then we can improve them.

Watch Calculation Results Immediately in Excel 2007

To watch calculations results immediately:
1. Select range of cells containing numeric data.
2. Select the Status Bar and right-click to open Status Bar shortcut menu.
Six functions are available:
Average, Count, Numerical Count, Minimum, Maximum and Sum
Results appear at the right of each formula in the shortcut menu.
Or
Check all or any other formulas you want to watch the result calculation for in the Status Bar.

Worksheet Functions

The following articles are available for the 'Worksheet Functions' topic. Click the article's title (shown in bold) to see the associated article.

Calculating Fractions of Years
When working with dates and the relationship between dates, Excel provides a variety of worksheet functions that may prove helpful. One such function is YEARFRAC, which allows you to calculate what fraction of a year is represented by the number of days between two dates.

Converting Strings to Numbers
When working with data in a macro, there are two broad categories you can manipulate: numbers and text. Sometimes you need to convert information from one category (data type) to another. Here is how you convert text to numbers.

Converting to Hexadecimal
Excel allows you to easily convert values from decimal to other numbering systems, such as hexadecimal. This tip explains how to use the DEC2HEX worksheet function.

Converting to Octal
If you need to do some work in the base-8 numbering system (octal), you'll love two worksheet functions provided by Excel for this purpose. These functions allow you to convert values to octal and convert them back again.

Counting Displayed Cells
When you filter data, Excel displays only a portion of what is really in a worksheet. If you want to count the number of cells that are displayed after filtering, then you'll want to explore the techniques in this tip.

Counting Unique Values with Functions
Using Excel to maintain lists of information is not unusual. When working with the list you may need to determine how many unique values it contains. This tip shows you how.

Functions Within Functions
Functions are the heart of Excel's power. The program allows you to compound that power by handily putting one function inside another function.

Getting Help when Entering Functions
Need a quick memory jog when entering a worksheet function? Here's a shortcut that will be invaluable.

Iterating Circular References
Does your data require that you perform calculations using circular references? If so, then you'll want to be aware of the way in which Excel handles those references.

Numbers in Base 12
Different professions use numbers in entirely unique ways. You may need to come up with a number that represents the number of 12-unit groupings. This tip examines a way this can be done.

Random Numbers in a Range
Excel provides several different functions that you can use to generate random numbers. One of the most useful is the RANDBETWEEN function, which allows you to generate a random number between a lower and upper boundary that you specify.

Returning a Blank Value
Is it possible for a formula to return a blank value? It depends on how you define your terms. This tip examines all the ins and outs of returning "nothing" from a formula and how that affects some of the more common worksheet functions.

Selecting Random Names
Got a tone of names from which you need to select a few random names? There are several ways you can extract what you need; several different ideas are explained in this tip.

Understanding Functions
Excel uses Functions to assist in creating spreadsheets that perform a multitude of calculations.

Using the WEEKNUM Function
Need to know which week of the year a particular date falls within? Excel provides the WEEKNUM function so you can easily calculate this statistic.

Working with Roman Numerals
Understanding and using a function to replace an Arabic number with Roman numerals. And, as a bonus, how to change them back.

 

Essential keyboard shortcuts

Keyboard shortcuts are the best way to navigate cells or enter formulas more quickly. We’ve listed our favorites below.
Control-Down/Up Arrow = Moves to the top or bottom cell of the current column Control-Left/Right Arrow = Moves to the cell furthest left or right in the current row
Control-Shift-Down/Up Arrow = Selects all the cells above or below the current cell
Shift-F11 = Creates a new blank worksheet within your workbook
F2 = opens the cell for editing in the formula bar
Control-Home = Navigates to cell A1
Control-End = Navigates to the last cell that contains data
Alt-= = Autosums the cells above the current cell
Excel is arguably one of the best programs ever made, and it has remained the gold standard for nearly all businesses worldwide. But whether you’re a newbie or a power user, there's always something left to learn. Or do you think you've seen it all and done it all? Let us know what we've missed in the comments.