Loading
Created by:pugizimopugizimo
{"id":1104777,"type":0,"block_id":"pugizimo_1368539571","theme_id":31,"user_id":381856,"path":"Microsoft-Excel-2","title":"Microsoft Excel","pubtitle":"Microsoft Excel","tags":"","public":true,"publicAccess":true,"private_link_enabled":0,"thumb":"https://s3-eu-west-1.amazonaws.com/infogram-thumbs-200/pugizimo_1368539571.jpg","width":550,"copyright":"© Nathan Pugsley 2013","properties":{"publishType":0,"transparent":false,"rtl":false,"export_settings":{"showGrid":true,"showValues":true},"whitelabel":false,"embed_button":"enabled","title_link":"infogram","custom_logo":"infogram","custom_link_url":"","embed_button_text":"Share","decimal_separator":".,"},"elements":[{"type":"particle","particle_id":16473247,"object_id":"6c6b4b60-eabe-11e4-a037-7b5f270fdca9","particle_type":"maintitle","picture":null,"text":"Microsoft Excel","content_type":"","title":null,"shrink":null},{"type":"particle","particle_id":1247872,"object_id":"pugizimo_1368539571","particle_type":"quote","picture":null,"text":"features of a speadsheet ","content_type":"","title":"nathan pugsley","shrink":null},{"type":"particle","particle_id":1248019,"object_id":"pugizimo1368540016","particle_type":"bodytitle","picture":null,"text":"Cells","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1248015,"object_id":"pugizimo1368540011","particle_type":"bodytext","picture":null,"text":"In any spreadsheet program such as Excel, each rectangular box in a worksheet is referred to as a cell. A cell is the intersection point of a column and a row. Data entered into Excel is always stored in a cell. Each cell can hold only one piece of data at a time.","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260608,"object_id":"pugizimo1368609618","particle_type":"bodytitle","picture":null,"text":"Cell Reference","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260619,"object_id":"pugizimo1368609630","particle_type":"bodytext","picture":null,"text":"In Excel, a cell reference identifies the location a cell or group of cells in the spreadsheet. Sometimes referred to as a cell address, a cell reference consists of the column letter and row number that intersect at the cell's location. Note that when listing a cell reference, the column letter is always listed first.","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260622,"object_id":"pugizimo1368609640","particle_type":"bodytitle","picture":null,"text":"Rows / Columns","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260626,"object_id":"pugizimo1368609650","particle_type":"bodytext","picture":null,"text":"Rows run horizontally in an Excel worksheet. They are identified by a number in the row header. Columns run vertically in a worksheet. Each column is identified by a letter in the column header starting with Column A and running through to Column XFD. ","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260630,"object_id":"pugizimo1368609664","particle_type":"bodytitle","picture":null,"text":"Labels","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260631,"object_id":"pugizimo1368609673","particle_type":"bodytext","picture":null,"text":"The term label has a number of meanings in spreadsheet programs.\n•\tA label most often refers to a text entry such as a heading used to identify a column of data.\n•\tThe term is also used to refer to the headings and titles in charts - such as the horizontal and vertical axes titles.\n","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260820,"object_id":"pugizimo1368610528","particle_type":"bodytitle","picture":null,"text":"Grid Lines","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260825,"object_id":"pugizimo1368610546","particle_type":"bodytext","picture":null,"text":"Lines you can add to a chart that make it easier to view and evaluate data. Gridlines extend from the tick marks on an axis across the plot area.","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260832,"object_id":"pugizimo1368610567","particle_type":"bodytitle","picture":null,"text":"Cell Ranges","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260833,"object_id":"pugizimo1368610579","particle_type":"bodytext","picture":null,"text":"A range is a group of cells in a worksheet that have been selected or highlighted. When cells have been selected they are surrounded by a black outline or border. \n\nUsing the mouse, keyboard or name box, a number of cells can be selected to create a range. Commands executed by Excel will affect the entire range. \n\nA range is identified by the cell references of the cells in the upper left and lower right corners of the range. These two references are separated by a colon ( : ) which tells Excel to include all the cells between these start and end points. \n","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260872,"object_id":"pugizimo1368610739","particle_type":"bodytitle","picture":null,"text":"Formatting","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260882,"object_id":"pugizimo1368610775","particle_type":"bodytext","picture":null,"text":"Formats are changes that are made to Excel worksheets in order to enhance their appearance and / or to focus attention on specific data in the worksheet.","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1278821,"object_id":"pugizimo1368700039","particle_type":"bodytitle","picture":null,"text":"Formulae","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1278833,"object_id":"pugizimo1368700075","particle_type":"bodytext","picture":null,"text":"Formulas in spreadsheet programs such as Excel are used to perform calculations. \nFormulas can range from basic mathematical operations - such as addition and subtraction - to complex engineering and statistical calculations.\n","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260938,"object_id":"pugizimo1368611038","particle_type":"bodytitle","picture":null,"text":"Merging Cells","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260669,"object_id":"pugizimo_1368609827","particle_type":"image","picture":"http://s3-eu-west-1.amazonaws.com/infogram-particles-700/pugizimo_1368609827.png"},{"type":"particle","particle_id":1260949,"object_id":"pugizimo1368611105","particle_type":"bodytext","picture":null,"text":"Merge cell is a function in database software that allows multiple adjacent cells to be combined into a single larger cell. This is done by selecting all cells to be merged and choosing the \"Merge Cells\" command. ","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1279039,"object_id":"pugizimo1368700831","particle_type":"bodytitle","picture":null,"text":"Graphs and Charts","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260859,"object_id":"pugizimo1368610679","particle_type":"bodytext","picture":null,"text":"A way to arrange data based on value or data type. You can sort data alphabetically, numerically, or by date. Sort orders use an ascending (1 to 9, A to Z) or descending (9 to 1, Z to A) order.","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260842,"object_id":"pugizimo1368610608","particle_type":"bodytitle","picture":null,"text":"Automatic Recalculation","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260844,"object_id":"pugizimo1368610625","particle_type":"bodytext","picture":null,"text":"By default, Microsoft Excel automatically recalculates formulas when the cells that the formula depends on have changed.","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1278898,"object_id":"pugizimo1368700333","particle_type":"bodytitle","picture":null,"text":"Functions","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1279032,"object_id":"pugizimo1368700790","particle_type":"bodytext","picture":null,"text":"A function is a preset formula in Excel. Like formulas, functions begin with the equal sign ( = ) followed by the function's name and its arguments. The function name tells Excel what calculation to perform. The arguments are contained inside round brackets.","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1260854,"object_id":"pugizimo1368610658","particle_type":"bodytitle","picture":null,"text":"Sorting Rows and Columns","content_type":"","title":"","shrink":null},{"type":"particle","particle_id":1279054,"object_id":"pugizimo1368700882","particle_type":"bodytext","picture":null,"text":"Charts are what we call graphs in math class. \nCharts are visual representations of worksheet data. Charts often make it easier to understand the data in a worksheet because users can easily pick out patterns and trends illustrated in the chart that are otherwise difficult to see. \n","content_type":"","title":"","shrink":null}],"theme":{"createdAt":"2016-04-22T04:54:07.000Z","updatedAt":"2016-12-28T10:33:43.000Z","logoImages":[""],"charts":{"treemap":{"labels":{"name":{"fontFamily":"PT Sans Narrow","fontWeight":"700"},"value":{"fontFamily":"PT Sans Narrow"}}},"wordcloud":{"labels":{"fontFamily":"Arial","fontWeight":"700"}},"table":{"cellBackground":"#ffffff","headerBackground":"#eeeeee","cellColor":"#232323","headerColor":"#232323","shapeFill":"#232323"}},"color":{"bg":"#ffffff","text":"#000000","chart":{"bg":"transparent","text":"#767676"},"element":{"bg":"transparent","text":"#000000"}},"colorPresets":[],"localFonts":[],"font":{"common":{"textAlign":"initial","fontSize":"16","fontStyle":"normal","fontWeight":"400","fontFamily":"PT Sans Narrow"},"legend":{"fontSize":"16","fontWeight":"400"},"label":{"fontSize":16,"fontWeight":400}},"fontPresets":[],"fontFamilies":["Pontano Sans","PT Sans","PT Sans Narrow","Arial Narrow"],"id":31,"title":"Light-new","usergroup":"archived","picture":"https://d1m5pq7b4fzvad.cloudfront.net/31/thumbnail.png","thumb":"/i/templates/S/grey.png","order":28,"public":0,"width":550,"fonts":"Pontano+Sans;PT+Sans+Narrow","colors":["#34a6b5","#bfbfbf","#5bb7c3","#959595","#287f8a","#4c4c4c","#005863","#000000","#9af3ff","#e2e2e2"],"logocolor":"6abac5","logoUrl":"","showLogo":"","showEmbed":"","embedButtonText":"Share","top":0,"padding":20,"spacing":10,"shrinkMargin":20,"shrinkPadding":20,"spacingElementMin":null,"spacingElementMax":null,"css":".heatmap-legend {\n\tmargin-bottom: 10px;\n\tbackground: rgba(255, 255, 255, 0.7);\n}\n.igc-textual-figure {\n\tfont-size: 45px;\n}\n.igc-sheets .igc-sheet .igc-sheet-ico,\n.igc-sheets .igc-sheet:hover .igc-sheet-ico {\n\tborder-color: #7d7d7d;\n}\n.igc-sheets .igc-sheet .igc-sheet-label,\n.igc-sheets .igc-sheet:hover .igc-sheet-label,\n.igc-sheets .igc-sheet.active .igc-sheet-label {\n\tcolor: #7d7d7d;\n}\n.igc-sheet .igc-sheet-ico,\n.igc-sheet.active .igc-sheet-ico {\n\tbackground: transparent;\n}\n.igc-sheets .igc-sheet.active .igc-sheet-ico::after,\n.igc-sheets .igc-sheet:hover .igc-sheet-ico::after {\n\theight: 14px;\n\twidth: 14px;\n\tleft: 2px;\n\ttop: 2px;\n\tbackground: #7d7d7d;\n}\ndiv[id^='table_'] .inner {\n\tbackground: transparent;\n\tpadding-left: 0;\n\tpadding-rigth: 0;\n}\n.igc-table-scroll {\n\tbackground: #eee;\n}\n.chart > .inner {\n\tpadding-top: 21px;\n\tpadding-left: 21px;\n\tpadding-right: 21px;\n}\n.chart > .igc-chart.inner\n.ig-copyright,\n#madewith a:link,\n#madewith a:active,\n#madewith a,\n#madewith a:visited,\n#madewith a:hover {\n\tcolor: #7d7d7d !important;\n}\n.ig-container {\n\tbackground: url(/i/templates/31/fons2.png);\n}\n.headline {\n\tfont-family: Pontano Sans;\n\tfont-weight: 400;\n\tfont-size: 40px;\n\tcolor: #34a6b5;\n\ttext-transform: uppercase;\n\ttext-align: center;\n\tline-height: 50px;\n}\n.chart-title {\n\tbackground: rgba(52, 166, 181, 0.7);\n\tfont-family: Pontano Sans;\n\tfont-weight: 400;\n\tfont-size: 22px;\n\tcolor: #fff;\n\ttext-align: center;\n}\n.chart-title .innertext {\n\tpadding: 3px;\n}\n.bodytext {\n\tfont-family: Pontano Sans;\n\tpadding: 20px;\n\tpadding-top: 10px;\n\tpadding-bottom: 10px;\n\tfont-size: 16px;\n\tcolor: #464646;\n}\n.quote {\n\tpadding-top: 10px;\n\tpadding-bottom: 10px;\n\tfont-family: Pontano Sans;\n\ttext-align: center;\n\tfont-weight: 400;\n\tfont-size: 27px;\n\tcolor: #34a6b5;\n\ttext-transform: uppercase;\n\tpadding-left: 30px;\n\tpadding-right: 30px;\n}\n.quotetitle {\n\tcolor: #3e4648;\n\tfont-size: 22px;\n}\n.chart .inner,\n.map {\n\tbackground: #f7f7f7;\n}\n.chart {\n\tpadding-bottom: 10px;\n\theight: auto !important;\n}\n.headline.active:hover {\n\tcolor: #0d6874;\n}\n#madewith.active a:hover {\n\tcolor: #0d6874 !important;\n}\n.titlepopup {\n\ttop: 1px;\n}\n.titlepopup1,\n.titlepopup2 {\n\tborder-color: #0d6874;\n}\n.shrink .chart > .inner {\n\tpadding-left: 10px;\n\tpadding-right: 10px;\n}\n.shrink .chart {\n\tmargin-left: 0;\n\tmargin-right: 0;\n}\n.ig-separator-line {\n\tbackground: rgba(118, 118, 118, 0.5);\n}\n.heatmap-legend-item,\n.heatmap-label {\n\tcolor: #767676;\n\tfont-size: 11px;\n\tfont-family: PT Sans;\n}\n.igc-graph-pie-piece {\n\tstroke: rgba(255, 255, 255, 0.7);\n}\n.igc-tabs .igc-tab-active {\n background: #ffffff;\n }\n .igc-tabs .igc-tab .igc-tab-content,\n .igc-tabs .igc-tab.icon-down:after {\n font-family: PT Sans Narrow;\n color: #000000;\n font-weight: 400;\n }\n .igc-tabs .igc-tab,\n .igc-tab-switcher {\n color: #000000;\n } .igc-tabs.igc-tabs-dropdown .igc-tab-name {\n font-family: PT Sans Narrow;\n color: #000000;\n font-weight: 400;\n } .captiontext {font-family: PT Sans Narrow;color: #000000;font-weight: 400;} .captiontext .innertext {line-height: 1.5;}","chartOptions":{"waterfall":{"colors":"005863 34a6b5 959595"},"candle":{"colors":"959595 34a6b5"},"map":{"showLegend":false,"countryyStroke":"#e1e1e1","countryFill":"#e1e1e1","canvasFill":"transparent"},"common":{"textStyle":{"font-family":"PT Sans Narrow, Arial Narrow","font-size":16,"cursor":"default","fill":"#5a5a5a"},"backgroundStyle":{"stroke-opacity":0,"stroke-width":0},"_gridOptions":{"fontStyle":{"font-family":"PT Sans","font-size":11,"text-anchor":"start","fill":"#767676","cursor":"default"},"lineStyle":{"stroke-width":1,"stroke":"#767676","fill":"none","stroke-dasharray":"."}},"legendOptions":{"font-size":16,"font-family":"PT Sans Narrow"},"tooltipOptions":{"nameFontStyle":{"font-family":"PT Sans Narrow","text-anchor":"start","font-weight":700,"font-size":16,"fill":"#ffffff"},"valueFontStyle":{"font-family":"PT Sans Narrow","text-anchor":"start","font-size":16,"fill":"#fff"},"containerStyle":{"stroke":"#464646","fill":"#464646"}}}},"version":1,"archived":true,"tabs":false,"zeroPaddingEmbed":true,"created_at":"2016-04-22T04:54:07.000Z","updated_at":"2016-12-28T10:33:43.000Z"},"embed":"<script id=\"infogram_0_Microsoft-Excel-2\" title=\"Microsoft Excel\" src=\"//e.infogr.am/js/dist/embed.js?54z\" type=\"text/javascript\"></script><div style=\"padding:8px 0;font-family:Arial!important;font-size:13px!important;line-height:15px!important;text-align:center;border-top:1px solid #dadada;margin:0 30px\"><a href=\"https://infogr.am/Microsoft-Excel-2\" style=\"color:#989898!important;text-decoration:none!important;\" target=\"_blank\" rel=\"nofollow\">Microsoft Excel</a><br><a href=\"https://infogr.am\" style=\"color:#989898!important;text-decoration:none!important;\" target=\"_blank\" rel=\"nofollow\">Create your own infographics</a></div>","embedIframe":"<iframe src=\"//e.infogr.am/Microsoft-Excel-2?src=embed\" title=\"Microsoft Excel\" width=\"550\" height=\"\" scrolling=\"no\" frameborder=\"0\" style=\"border:none;\"></iframe><div style=\"padding:8px 0;font-family:Arial!important;font-size:13px!important;line-height:15px!important;text-align:center;border-top:1px solid #dadada;margin:0 30px\"><a href=\"https://infogr.am/Microsoft-Excel-2\" style=\"color:#989898!important;text-decoration:none!important;\" target=\"_blank\" rel=\"nofollow\">Microsoft Excel</a><br><a href=\"https://infogr.am\" style=\"color:#989898!important;text-decoration:none!important;\" target=\"_blank\" rel=\"nofollow\">Create your own infographics</a></div>","embedWordpress":"[infogram id=\"Microsoft-Excel-2\" prefix=\"v4v\" format=\"interactive\" title=\"Microsoft Excel\"]","embedWordpressImage":"[infogram id=\"Microsoft-Excel-2\" prefix=\"DfD\" format=\"image\" title=\"Microsoft Excel\"]","embedAsync":"<div class=\"infogram-embed\" data-id=\"Microsoft-Excel-2\" data-type=\"interactive\" data-title=\"Microsoft Excel\"></div><script>!function(e,t,n,s){var i=\"InfogramEmbeds\",o=e.getElementsByTagName(t),d=o[0],a=/^http:/.test(e.location)?\"http:\":\"https:\";if(/^\\/{2}/.test(s)&&(s=a+s),window[i]&&window[i].initialized)window[i].process&&window[i].process();else if(!e.getElementById(n)){var r=e.createElement(t);r.async=1,r.id=n,r.src=s,d.parentNode.insertBefore(r,d)}}(document,\"script\",\"infogram-async\",\"//e.infogr.am/js/dist/embed-loader-min.js\");</script><div style=\"padding:8px 0;font-family:Arial!important;font-size:13px!important;line-height:15px!important;text-align:center;border-top:1px solid #dadada;margin:0 30px\"><a href=\"https://infogr.am/Microsoft-Excel-2\" style=\"color:#989898!important;text-decoration:none!important;\" target=\"_blank\" rel=\"nofollow\">Microsoft Excel</a><br><a href=\"https://infogr.am\" style=\"color:#989898!important;text-decoration:none!important;\" target=\"_blank\" rel=\"nofollow\">Create your own infographics</a></div>","embedImageAsync":"<div class=\"infogram-embed\" data-id=\"Microsoft-Excel-2\" data-type=\"image\" data-title=\"Microsoft Excel\"></div><script>!function(e,t,n,s){var i=\"InfogramEmbeds\",o=e.getElementsByTagName(t),d=o[0],a=/^http:/.test(e.location)?\"http:\":\"https:\";if(/^\\/{2}/.test(s)&&(s=a+s),window[i]&&window[i].initialized)window[i].process&&window[i].process();else if(!e.getElementById(n)){var r=e.createElement(t);r.async=1,r.id=n,r.src=s,d.parentNode.insertBefore(r,d)}}(document,\"script\",\"infogram-async\",\"//e.infogr.am/js/dist/embed-loader-min.js\");</script><div style=\"padding:8px 0;font-family:Arial!important;font-size:13px!important;line-height:15px!important;text-align:center;border-top:1px solid #dadada;margin:0 30px\"><a href=\"https://infogr.am/Microsoft-Excel-2\" style=\"color:#989898!important;text-decoration:none!important;\" target=\"_blank\" rel=\"nofollow\">Microsoft Excel</a><br><a href=\"https://infogr.am\" style=\"color:#989898!important;text-decoration:none!important;\" target=\"_blank\" rel=\"nofollow\">Create your own infographics</a></div>"}