3.1.1 and 3.1.2 Create an Excel Table from a Cell Range and Reverse Many worksheets consist of a rectangular block of data in which the roles of data have a common structure and format. Excel offers you the ability to define this block as a table. The reason that this is a useful facility is because you can use a variety of tools in Excel, such as selecting summary formulas, formatting, sorting and filtering. While many of these features are available available even without using tables, you’d have to manually…

2.3.1 Insert Sparklines Sparklines are a feature which allow you to create a miniature chart inside a worksheet cell. The idea is that it allows you to improve the visibility and readability of your worksheet without having to create full size charts which may take up a lot of space. Spark lines are a visual representation of each value in a horizontal or vertical range of cells. It’s essentially a mini chart art. Let’s have a look at Helpless Airlines passenger numbers for each month in 2017 and from each…

2.2.5 Apply Number Formats Excel is designed primarily to manipulate numbers. The formatting of numbers is usually the most common type of formatting applied to a spreadsheet. There are a lot of different number formats that you can use to meet a wide variety of needs. The easiest way to see the difference between the various formats is to look at one number and then we change the format to see the difference. So here we have our number one, two, three, 4. 56. If I select the cell, right…

2.2.1 Merge Cells Merging cells is a feature commonly used on text labels to identify a group of cells together. So for example, with the Helpless Airlines marketing budget, I’ve put the title in Cell A one. But what I would like is for it to be evenly distributed across columns A to F in order to make it more centralized and professional looking. I can do this by merging the appropriate cells. When you your marriage cells, Excel removes the edges separating the selected cells and treats the group…

2.1.5 Insert and Delete Cells Have a cell or range of cells selected within the body of the Worksheet, as opposed to having an entire row or column selected. Then when you right click and select Insert or Delete, you’ll see this menu. Which option you select will affect the Worksheet. So you need to be careful. If you just have one cell selected like this, then when you choose to shift cell up or down, you can see that that’s what happens. If you select entire rows or Konyuns,…

Attribute Agreement Analysis Case Studies All right, here is a case study. We have 25 patient registration forms. That is what PRF stands for. We have four appraisers, appraiser one, two, three, and four. And these four appraises evaluate the patient registration forms twice. Hey, we have two trials, trial one, trial two. For appriser two, also, we have trial one and two, and the same follows. For a price of three and four, we have the details of whether a specific patient registration form is complete or incomplete. We…

Yield – Traditional, FTY, RTY Yield is a first time right percentage. And we have first time yield and role to cookie. First time yield is used to determine quality level of individual sub process. If I multiply the first time yield of each and every sub process, I would ultimately get the role to cookie. Let us understand this with an example. Does this picture sound familiar? Formula One Race hey, let me ask you some interesting thing. According to NASCAR pit stop. If you’re concerned about what NASCAR…

Case study on Attribute Agreement Analysis_Part 2 What does this mean? Let us understand this for a while. There are 20 custom application forms which were inspected and twelve matched twelve by 20 multiplied by 116. But where am I getting this twelve from? Let us go back to the worksheet and understand. Click on this icon show worksheets older to build worksheet here’s the worksheet between appraises means between all of them if they are greater than two, probably it should be among appraisers grammatically that’s fine. False representative…

Design of Experiments Doe. We are going to discuss about the benefits of factors and levels available. Doe or Design of experiments is a structure and control method used to vary the inputs. Here, inputs are called as factors in order to find the best combination of inputs today, the desired output. What does that mean? Let us understand using this image which is provided here. What do you think this equipment here does? It does the curdling process to generate curd and to buy products. Here is the curd…

Evaluate the Generated Solutions – Pugh Matrix Pew matrix can be used to evaluate alternate solutions. Pew matrix gives the team a structured way to make decisions. Then we move on to discuss about Delphi technique. Delphi technique is another way of obtaining group input for ideas and problem solving. It is unlike the nominal group technique. The Delphi does not require face to face participation. It uses a series of carefully designed questionnaires interspersed with information, summaries and feedback from preceding responses. The next thing is multivoting. multivoting narrows…