Editing Cell Content
You can edit the contents of a cell directly in the cell. You can also edit the contents of a cell by typing in the formula bar. When you edit the contents of a cell, Excel is operating in Edit mode. When Excel is in Edit mode, the word Edit appears in the lower-left corner of the Excel program window. In Edit mode, many commands are unavailable. For example, when Excel is in Edit mode, you cannot apply conditional formatting or change the alignment of the contents of a cell. Also, the arrow keys behave somewhat differently when Excel is in Edit mode. Instead of moving the cursor from cell to cell, in Edit mode, the arrow keys move the cursor around in the cell.
Enabling or Disabling Edit Mode
If you try to use Edit mode and nothing happens, it might be disabled. You can enable or disable Edit mode by changing an Excel option.
1. Click the Microsoft Office Button, click Excel Options, and then click the Advanced category.
2. Under Editing options, do one of the following:
- To enable Edit mode, select the Allow editing directly in cells check box.
- To disable Edit mode, clear the Allow editing directly in cells check box.
Entering Edit mode
To start working in Edit mode, do one of the following:
- Double-click the cell that contains the data that you want to edit.This starts Edit mode and positions the cursor in the cell in the location that you double-clicked. The cell contents are also displayed in the formula bar.
- Click the cell that contains the data that you want to edit, and then click anywhere in the formula bar.This starts Edit mode and positions the cursor in the formula bar at the location that you clicked.
- Click the cell that contains the data that you want to edit, and then press F2.This starts Edit mode and positions the cursor at the end of the cell contents.
Inserting, Deleting, or Replacing Cell Contents
Note the following:
- To insert characters, click in the cell where you want to insert them, and then type the new characters.
- To delete characters, click in the cell where you want to delete them, and then press BACKSPACE, or select the characters and then press DELETE.
- To replace specific characters, select them and then type the new characters.
- To turn on Overtype mode so that existing characters are replaced by new characters while you type, press INSERT.
Overtype mode can be turned on or off only when you are in Edit mode. When Overtype mode is turned on, the character to the right of the insertion point is highlighted in the formula bar, and it will be overwritten when you type.
- To start a new line of text at a specific point in a cell, click in the where you want to break the line, and then press ALT+ENTER.
Dates and times are other type of data that you may encounter frequently in Excel.
Internally, Excel treats the date and time as numeric data. Excel keeps track of the dates you enter by assigning each date with a serial number.
The first date, January 1, 1900, is assigned the number 1; January 2, 1900, the number 2; and so on. Because of this numeric representation of date/time data, Excel can perform mathematical calculations on date/time data. For example, you can find the number of days between two dates by subtracting the two dates or can find the date after specified number of days elapsed from the current date by adding the number of days to the current date.
When entering a date, you can represent the year in two-digit or full four-digit format. But a safer practice is to use all the four-digits of the year. This is because by default Excel represents the date in mm/dd/yyyy format. And when you enter year in two-digit format, Excel will internally represent the year either in 19XX or 20XX range based on the following criteria:
- If you type 00 through 29 for the year, Excel assumes the year 2000 through 2029. For example, if you enter date as 12/12/18, Excel assumes the date is December 12, 2018.
- If you type 30 through 99 for the year, Excel assumes the year 1930 through 1999. For example, if you type 10/10/70, Excel assumes the date is October 10, 1970.
Similar to date, Excel also stores time as numeric data internally. Excel represents a time as a fractional part of 24 hours. For example, time entered as 10.15 PM, will be represented by Excel as 22:15. Because of this numeric representation of time, Excel can perform mathematical calculations on time data too. But by default, Excel accepts the date in mm/dd/yyyy format. Because of this, it is safer to use all the four digits to represent the year. The reason will be clear when you understand how Excel interprets the year in a two-digit year format. This is discussed below:
- If you type 00 through 29 for the year, Excel uses the years 2000 through 2029. For example, if you type 3/18/25, Excel assumes the date is March 18, 2025.
- If you type 30 through 99 for the year, Excel uses the years 1930 through 1999.For example, if you type 10/24/47, Excel assumes the date is October 24, 1947.
Excel treats numeric data differently from text data when you type the data into cells.
Firstly, unlike text data that are left-aligned in a cell, numeric data are right-aligned in a cell.
Secondly, in text data if the content is too wide to fit, Excel extends that data past the cell width to the next adjacent cell if the next cell is blank. If the next cell is not blank, Excel displays only that much text that fits the display width.
Whereas, in case of numeric data, if the data cannot fits in the current cell width, Excel displays a series of # characters across the width of the cell to indicate that the number cannot be displayed. When entering numeric data in Excel, consider the following points:
- It should begin with the any of the following characters:
0 1 2 3 4 5 6 7 8 9 + – . ( , $ %
- It should not contain any non-numeric character, except a dot (.) or a forward slash (/), anywhere in the number.
- It can ends with a % symbol.
The dot (.) is used for entering a decimal value. Place the dot (.) at that position in the number where you want the decimal point to appear in the number. However, when a decimal value is entered with trailing zeroes, Excel, by default, ignores all the trailing zeroes after the decimal point both in display and calculation. For example, you entered the decimal number, 3020.0500, but it will be displayed by Excel as 3020.05 removing all trailing zeroes from the display.
The forward slash (/) is used for entering fractional values. To enter a fraction, type the number, a blank space, and then the fraction, such as 4 1/2. However, if the numeric data consists of only fractional value, like 3/4, you need to type a 0, a blank space, and then the fraction. Therefore to enter 3/4 in Excel, enter it as 0 3/4. If you just type 3/4, Excel thinks you mean March 4.
However, there may be situations, when you want to represent a numeric data as a text. One such case is the representation of credit card number. Excel‘s numbers are precise up to 15 digits. For example, if you enter a large value, such as 121121121121121121 (18 digits), Excel actually stores it with only 15 digits of precision. Therefore, if you represent a credit card number (16-digit long) as a numeric data in Excel, the last digit (16th digit) will be substituted by zero. This may make the credit card number invalid. Therefore, the solution is to make the credit-card number as text.
But now the question is how? This is because credit card number constitutes of all numbers and by default Excel will store it as a number. To specify a numeric data to be a text entry, the simplest technique is to prefix the number with an apostrophe (‘). Therefore, to represent the credit card number, 121121121121121121, as text entry enter it in Excel as:
In this way, you can represent any numeric data as a text.
The benefit Lean Six Sigma provides is to fix broken processes that already exist. But what if there were a way to create higher quality processes at the design stage?
A variant of Six Sigma, Design For Six Sigma (DFSS) is a methodology used to design from scratch or re-design a product or process to one that meets customer requirements and has an expected quality level of Six Sigma.
DFSS is about “getting it right the first time” instead of improving later. That’s the point where the cost of change is lowest and the ease of implementation is the highest.
We will cover this topic in detail in the upcoming posts.
After you have created the workbook or worksheet you can start entering data in it. To enter data, simply click in the desired cell, type the data and press Enter. The data is entered into the current cell and Excel makes the next cell down active. Excel allows you to enter following types of data:
Label: A label represents text data. A label can consist of only text or combination of text and numbers. For example, a name like Ramesh Kumar and an address like 991 Salt Lake City Kolkata, both is considered as a label.
Value: A value represents numeric data. A value can consist of only numbers but cannot contain any non-numeric data. However, there are certain exceptions. For example, you can use + or – symbols before the numeric data to represent positive or negative numbers. In addition, you can use the dot (.) in numeric data to represent a decimal number or the slash (/) to represent a fractional number. For example, 91, -54, 1.25, -5/8, all are considered as value.
Date/Time: A date/time data as the name suggests represent a date or time value. For example, 20/3/1998, 30-
Sep-2005, 10:10 p, are all date/time data type.
Formula: A formula represents an expression that computes numeric results. In Excel, formulas always start with
equal sign (=). For example, =3 + 4, =(2 * 5)/10, are all valid formulas in Excel.
We will be discussing more on Date/Time formats in the upcoming posts. Keep in touch.
Excel has evolved from over 25 years now and still coming up with new features. As old wine gets tastier, Excel is getting prettier to use.
From doing simple math to sophisticated statistical analysis, Excel does it all.
So, here are 5 awesome features of Excel you will definitely fall in Love with:
1. Mathematical Calculations – The very first aspect of Excel that makes it royal is its gallery of functions. There are different types of functions which allow us to manipulate the data according to our need. You can find functions for Financial, Logical, Text, Date & Time, Lookup & Reference, Math & Trigonometry and some advance functions for statistical analysis,
2. Data Analytic – Besides calculation, Excel is great tool for Business Analytic. Using advanced features like Pivot table & Statistical functions, Data Analytic is now a kids play.
3. Data Visualization – Excel supports variety of charts which includes Column, Line, Pie, Bar etc to visualize your data.
4. Automation – You can automatic your repetitive work or reports using inbuilt VBA editor. Cool, isnt it !
5. As Databases – User can import data from Access, SQL, Text or XML format into Excel easily. Excel provides inbuilt connectors to connect to various databases using credentials if required and fetches desired values.
P.S: This is guest post by Ashvin Bhatt.
Know more about him on www.ashvinbhatt.com
A “Belt” signifies experience. Practitioners are given a “Belt” title (Black Belt, Green Belt, Yellow Belt) that corresponds to their level of experience.
A Black Belt has expert knowledge and skills related to the DMAIC methodology, Lean methods, and team leadership.
Black Belts should be able to lead any team across the organization in executing Lean Six Sigma projects. Black Belts may also conduct Lean Six Sigma training and act as coaches and mentors to other Belts-in-training.
A Green Belt has strong knowledge and skills related to the DMAIC methodology and Lean methods.
Green Belts may lead simple projects under the guidance of a Black Belt or may work as a team member on a large project team.
A Yellow Belt is trained in the general Lean Six Sigma concepts and basic tools.
A company deploying Lean Six Sigma may choose to designate project team members as Yellow Belts after completing a required training course, or may use the designation for employees responsible for data collection for a Green Belt or Black Belt project.
A White Belt has received a small amount (several hours) of awareness training. Enough to be dangerous!
A project Champion is a high-ranking manager who will work with a Black Belt to ensure that barriers to project success are removed and the project team has the organizational support it needs to be effective.
Introduction to Lean Six Sigma
Is a set of tools developed to reduce the waste associated with the flow of materials and information in a process from beginning to end.
The goal of Lean is to identify and eliminate non-essential and non-value added steps in the business process in order to streamline production, improve quality and gain customer loyalty.
A term used in statistics that measures Standard Deviation. In business, it is an indication of defects in the outputs of a process and how far these outputs deviate from perfection.
Is a set of “Tools & Strategies” or “Methodology” for Process & Quality Improvement originally developed by Motorola in 1986.
More specifically, Six Sigma is a problem-solving technology that uses data, measurements, and statistics to identify the vital few factors that will dramatically decrease waste and defects while increasing predictable results, customer satisfaction and profit. Six Sigma is about data and facts.
In simple terms, “Six Sigma is a Quality Standard”.
First look of Excel:
1. Go to Start -> Programs -> Microsoft Office -> Click on Ms Excel.
2. The workbook will open in below form.
All the work that you do in Excel is stored in a workbook file. Each workbook in turn consisted of one or more worksheets, and each worksheet is made up of cells. A cell is the most basic unit of Excel to contain data. The cell can contain a value, a formula, or text. Each worksheet is accessible by clicking the tab at the bottom of the workbook. In addition to worksheets, workbooks can store chart sheets. A chart sheet is a special type of worksheet that contains only a single chart. It is also accessible by clicking a tab.
Components of Excel
When you open Excel, you will get into Excel user interface area where you interact with Excel application.
• Spreadsheet: Displays the spreadsheet in which you are currently working. The spreadsheet is displayed as a grid of columns (labeled by letter or letter combination, starting with A. Examples – A, B, AA, AB, etc.) and rows (labeled by number, starting with 1. Examples – 1, 2, 3, 10, 99, etc.).
• Column headings: Displays the column label corresponding to each column. Excel 2007 contains maximum of 16,384 columns, starting from A till XFD (the column heading for the last column).
• Row headings: Displays the row number corresponding to each row. Excel 2007 contains maximum of 1048576 rows, starting from 1.
• Active cell indicator: Represents a dark outline that indicates the current active cell (the cell on which you are currently working on).
• Name box: Displays the active cell address or the name of the selected cell, range, or object. The address of a cell is represented by column and row letter. For example, if the top left cell is the active cell, A1 will appear in the Name box. This means that the cell is the intersection of row labeled 1 and column labeled A.
• Formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.
• Sheet tabs: Displays the name of each worksheet contained in the workbook. Each worksheet name appears on a different tab. A workbook can have any number of worksheets. However, by default, each new workbook that you create contains three worksheets.
• Tab scroll buttons: Allows you scroll the sheet tabs to display tabs that aren‘t visible.
• Ribbon: The Ribbon is designed to help you quickly find the commands that you need to complete a task. Commands are organized in logical groups, which are collected together under tabs.