KPI Key Performance Indicator Dashboards in Excel Tutorial Part 1 of 6 Chandoo. Posted on August 2. All Time Hits, Charts and Graphs, Featured, Learn Excel 2. Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert. Table of Contents. Introduction. 1. 1 Overview 1. Module interactions. Flex Layout Box Model and Terminology 3 Flex Containers the flex and inlineflex display. Microsoft Word Table Minimum Column Width Google' title='Microsoft Word Table Minimum Column Width Google' />This 6 Part Tutorial on KPI Dashboards Teaches YOU Creating a Scrollable List View in Dashboard. Add Ability to Sort on Any KPI to the Dashboard. Highlight KPIs Based on Percentile. Add Microcharts to KPI Dashboards. Compare 2 KPIs in the Dashboards Using Form Controls. Show the Distribution of a KPI using Box Plots. Dashboards have become quite popular in the last few years and in spite of all the Business Intelligence software products that provide dashboards, a lot of dashboards are still implemented with Microsoft Excel. What is a DashboardI have a table cell that I cant seem to center the text accurately. Theres a minimum padding or something I cant get rid of or shrink in any way. Ive tried. Microsoft Excel Training Course Learn worksheets, databases charts. Beginners to Advanced included, 100 OFF PLUS incl free MS Word Course This July, we asked for software tips from the 2017 Microsoft Office National Champions, a set of charming teens who are officially the best at using PowerPoint, Word. By default when the admin menu is not folded the icons in the admin menu are 36px wide. Brent Ozar Unlimiteds specialized experts focus on your goals, diagnose your tough database pains, and make Microsoft SQL Server faster and more reliable. Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert. This 6 Part Tutorial on KPI Dashboards Teaches YOU Creating a Scrollable List View. According to Stephen Few, one of the world wide leading authorities on visualization and dashboard design,a dashboard is a visual display of the most important information which fits entirely on a single computer screen Information Dashboard Design, 2. The Scrolling Problem. Fitting on a single computer screen is the challenge this post will solve. Imagine you have a large list of 1. Key Performance Indicators e. The whole table will not fit on a single computer screen anymore. Most of the time it will be sufficient to show the first or largest 1. But what if the user of your dashboard wants to scroll down the table and see the rest of the data Sure, you might teach him to go to the sheet with the data and scroll up and down there. But this is not convenient, not user friendly, insecure and not the purpose of a dashboard. The solution. The table on our dashboard doesnt need much explanation. The only thing that differs from millions of other numeric tables in Excel is the slider scroll bar between the names of the items and the data. This scroll bar allows the user of the dashboard to walk through the whole list and see all items without leaving the dash board. The table is small and leaves a lot of space for tables or charts on the dashboard. Download the excel sheet containing KPI Dashboard solution to learn this better. The implementation. What next Make sure you have downloaded KPI Dashboard solution workbook to learn this better. Read the next article in this series Part 2 Add Ability to Sort on Any KPI to the Dashboard. Also, Checkout our Excel Dashboards Page for more examples and resources. Chandoos note Robert is a regular reader and commenter on this blog. Drop your comments questions here and I am sure he will answer them Share this tip with your friends. Written by Chandoo. Tags Charts and Graphs, dashboards, Excel Tips, form controls, howto, ideas, learn, microsoft, Microsoft Excel Formulas, OFFSET, spreadsheets, tricks. Home Chandoo. org Main PageDoubt Ask an Excel Question. Kerning Wikipedia. Kerning brings A and V closer with their serifs over each other. In typography, kerning is the process of adjusting the spacing between characters in a proportional font, usually to achieve a visually pleasing result. Kerning adjusts the space between individual letter forms, while tracking letter spacing adjusts spacing uniformly over a range of characters. In a well kerned font, the two dimensional blank spaces between each pair of characters all have a visually similar area. The related term kern denotes a part of a type letter that overhangs the edge of the type block. Metal typesettingedit. The glyph on the right is kerned to overlap the character following it glyphs are mirrored for printing. The source of the word kern is from the French word carne, meaning projecting angle, quill of a pen. The French term originated from the Latin cardo, cardinis, meaning hinge. In the days when all type was cast metal, parts of a sort that needed to overlap adjacent letters simply hung off the edge of the sort slug. The bit of metal that hung over the edge was called a kern. At that time, the word kerning only referred to manufacturing the sorts with kerns, while adjusting space between letters during compositing was called inter spacing or letter spacing. Because this method was not well suited to some pairs of letters, ligatures were supplied for those glyph combinations, such as the French L, or the combinations ff, fi and ffi. Digital typographyeditIn metal typesetting, kerning was labour intensive and expensive because the matrices had to be physically modified. It was therefore only employed on letter combinations which needed it the most, such as VA or AV. With the arrival of digital fonts, it became much easier to kern many glyph combinations. Kerning valueseditIn digital typography, kerning is usually applied to letter pairs as a number by which the default character spacing should be increased or decreased a positive value for an increase, a negative value for a decrease. The number is expressed in font units, one unit being a certain fraction of an em one em is the type size currently used. Different fonts may use different units, but common values are 1. Thus, for 1. 00. 0 unitsem, a kerning value of 1. The kerning units for a given font are the same as the units used to express the character widths in that font. Most kerning adjustments are negative, and negative adjustments are generally larger than positive ones. Adjustments for different pairs within a given font can range from a tiny 2 to over 1. The adjustments for a given pair vary greatly from one font to another. Negative kerning is widely used to fit capital letters such as T, V, W, and Y closer to some other capital letters on either side, especially A, and to some lower case letters on the right side, such as the combinations Ta, Te, and To. It is also used to fit a period full stop or a comma closer to these and to F and P, as well as to the lower case letters r, v, w, and y. Some other combinations that use negative kerning are FA, LT, and LY, and letters like A, L, and h followed by a quotation mark. Positive kerning is used mainly in conjunction with special characters and punctuation for example, the lower case letter f followed by right parenthesis or quotation mark. Depending on the font, some small positive kerning may also be required for accented letters and for pairs like Bo, Dw, and TY. The table below contains a few exemplifying kerning pairs and their values. These values are based on 1. The samples are taken from the kerning tables of the Minion Pro font. In other fonts the kerning may be very different. A 1. 46. W. 1. P, 1. Canoscan D646u Ex Driver For Mac. L 1. VA 1. 23. F. YA 1. 04. Te  9. AV  9. Vr  8. 6PA  8. FA  7. UA  7. 8w. Yt  7. LT  6. 4r,  6. Xv  5. Ku  4. 6D,  4. D  3. OA  3. 6Hv  3. T  3. DY  3. 0c  2. Ru  2. Sp  1. 4ro  1. 3SR  1. Ix   6e,   6st   5he   4. Fw   3us   3. Ak   3la   3. Oj   5il   5. CO   7bc   9. Xf  1. 0fr  1. 0F  1. YW  1. 3So  1. 4Co  1. VT  1. 6cv  1. 6Dv  1. OC  1. 8Bc  2. 0RX  2. T  2. 2gy  2. 4r  2. XA  2. 5ry  2. 9w  3. Which letters need to be kerned depends on which languages the font is to be used with. Since some combinations of letters are not used in normal words in any language, kerning these is not necessary. Non proportional monospaced fonts do not use kerning, since their characters always have the same spacing. Kerning tableseditIn older font formats, such as Microsofts True. Type, the kerning values are specified in a simple kern table where each entry consists of a pair of characters and their kerning value. Apple has however extended the kern table with more complex features, including contextual and class based kerning,4 that were later found in Open. Type, albeit not in the same exact form. True. Type fonts typically have several hundred pairs, but some have more than a thousand. Since Open. Type is a superset of True. Type kern tables are still supported for True. Type fonts packed as Open. Type however Post. Script based CFF Open. Type fonts do not have this option. Open. Type introduced a new, uniform way of specifying, among other things, kerning, via the Glyph Positioning Table GPOS. The more recent font releases by Adobe no longer have kern tables at all, but only specify kerning via GPOS. Since an Open. Type font may include thousands of glyphs, and consequently a huge number of pairs of characters that need kerning, Open. Type fonts may have an elaborate system of tables and subtables, designed to minimize the overall storage space. Kerning is treated as part of a broad range of new glyph positioning features which are stored in GPOS. The system is based on the concept of glyph classes instead of a one dimensional table where each entry corresponds to a pair of characters, there are two dimensional tables where each entry corresponds to a pair of classes of glyphs. A class includes several characters whose right hand outline and right side bearing is identical for kerning purposes, or several characters whose left hand outline and left side bearing is identical. All pairs of characters where the first one is from the first class and the second one is from the second class will require the same kerning value, so this value needs to be specified only once in the table. The rows in the two dimensional table correspond to first character classes, and the columns correspond to second character classes. The kerning value for a given pair of characters is found in the table at the intersection of the classes to which they belong. This system is very economical, but is necessarily limited. For example, many of the classes may be quite small. Also, a font with many types of glyphs may require several such tables. Finally, many pairs remain that cannot be represented through classes. For them, simpler, one dimensional tables are provided each table is for a particular character that is the first in many pairs, and the entries contain the characters that are the second in these pairs, together with the corresponding kerning values. Here are a few examples of glyph classes in the Minion Pro font for the first character in a kerning pair d i l u, h m n, j q, b o p, v w y, D O Q, H I, V W and for the second character in a pair f i m n r, h k l, j p t u, c d e o q, v w y, C G O Q, B D E F H I K L N P R.