Windows Server 2016 Monitoring PRTG? No, they don’t pay me to show you this application. I really like PRTG. I’ve been using it for a while. And every time I teach Cisco, Windows Seven networking, I show PRTG as a great example of an application that you can install on your laptop and play with monitoring and all protocols that are important for you as a network engineer or as a systems administrator. PRTG is for free. You can download it off the Internet. I have PRTG up and running…

3.3.1 Filter Records Worksheets are often used to store large amounts of data. The term filter is used to describe the process by which you can extract data from a large amount of information by specifying criteria which will allow you to pinpoint exactly the data you wish to see, rather than seeing all of the available data. Filtering does not change the content of your worksheet, only what you see of the worksheet. No information is deleted, only the view of the data is changed. We’ve already seen that…

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…