{"id":124,"date":"2012-04-06T17:23:55","date_gmt":"2012-04-06T17:23:55","guid":{"rendered":"http:\/\/www.stratospherenetworks.com\/blog\/?p=124"},"modified":"2018-06-26T12:05:00","modified_gmt":"2018-06-26T17:05:00","slug":"5-tips-to-use-excel-more-efficiently","status":"publish","type":"post","link":"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/","title":{"rendered":"5 Tips to Use Excel More Efficiently"},"content":{"rendered":"<div class=\"posterous_autopost\">\n<p><a href=\"http:\/\/www.stratospherenetworks.com\/blog\/wp-content\/uploads\/2015\/04\/Happy-businesswoman-at-computer.jpg\"><img decoding=\"async\" class=\"alignleft size-medium wp-image-1436\" src=\"http:\/\/www.stratospherenetworks.com\/blog\/wp-content\/uploads\/2015\/04\/Happy-businesswoman-at-computer-300x200.jpg\" alt=\"how to excel\" width=\"300\" height=\"200\" srcset=\"https:\/\/www.stratospherenetworks.com\/blog\/wp-content\/uploads\/2015\/04\/Happy-businesswoman-at-computer-300x200.jpg 300w, https:\/\/www.stratospherenetworks.com\/blog\/wp-content\/uploads\/2015\/04\/Happy-businesswoman-at-computer-1024x683.jpg 1024w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>Are you gunning for a raise or a promotion? Maybe you only want to stand out for job <a title=\"IT Services\" href=\"http:\/\/www.stratospherenetworks.com\/it-services.html\" target=\"_blank\">security<\/a>. In either case, this can be accomplished by impressing your boss, but how?<\/p>\n<p>What about Excel? The majority of us, no matter our job, use spreadsheets in Excel. This program is a very robust <a title=\"Online Tools to Help You Manage Projects\" href=\"http:\/\/www.stratospherenetworks.com\/blog\/online-tools-to-help-you-manage-projects\/\" target=\"_blank\">business tool<\/a>; here are some tips to boost your efficiency, which is sure to impress your boss.<\/p>\n<ul>\n<li><strong>Hiding Information<\/strong>: There may be an occasion when you want to hide certain information when printing an Excel spreadsheet. For instance, maybe your spreadsheet includes sensitive salary information. Luckily, you can tell Excel not to print certain rows or columns by hiding them before you hit print. To hide rows or columns, select the corresponding number or letter then right-click on a highlighted row or column and click the Hide option. You can then choose the Unhide option to bring these columns and rows back into view.<\/li>\n<li><strong>Timestamping<\/strong>: If you want to attach a date to your spreadsheet, you can use the Timestamp feature. Just hold Ctrl as you press the semicolon key. If you would like the current date and time hold down the Ctrl and Shift keys while pressing the semicolon.<\/li>\n<li><strong>A Better-Looking Spreadsheet<\/strong>: You can beautify a boring spreadsheet with Excel&#8217;s Themes option. You will find this option in Excel&#8217;s Ribbon. Simply click on it, and you&#8217;ll discover a number of different fonts and colors that you can use on your formerly boring spreadsheets.<\/li>\n<li><strong>Tracking Trends<\/strong>: The latest version of Excel includes a feature called Sparklines. By using this feature, you can create small charts that show trends in information. For instance, you could use Sparklines to instantly figure out how many software bundles each of your company&#8217;s salespeople sold in the first half of 2011.<\/li>\n<li><strong>Conditional Formatting<\/strong>: With conditional formatting, you can automatically change the look of spreadsheet cells that meet certain conditions. For example, a cell showing that product sales rose by more than 100 percent in a given month might take on a different hue so that it quickly stands out.<\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Are you gunning for a raise or a promotion? Maybe you only want to stand out for job security. In either case, this can be accomplished by impressing your boss, but how? What about Excel? The majority of us, no &hellip; <a href=\"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/\">Read more <span class=\"meta-nav\">><\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":3391,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-124","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-knowledge-base"],"yoast_head":"<title>5 Tips to Use Excel More Efficiently - Stratosphere Networks IT Support Blog - Chicago IT Support Technical Support<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"5 Tips to Use Excel More Efficiently - Stratosphere Networks IT Support Blog - Chicago IT Support Technical Support\" \/>\n<meta property=\"og:description\" content=\"Are you gunning for a raise or a promotion? Maybe you only want to stand out for job security. In either case, this can be accomplished by impressing your boss, but how? What about Excel? The majority of us, no &hellip; Read more &gt;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/\" \/>\n<meta property=\"og:site_name\" content=\"Stratosphere Networks IT Support Blog - Chicago IT Support Technical Support\" \/>\n<meta property=\"article:published_time\" content=\"2012-04-06T17:23:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-06-26T17:05:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.stratospherenetworks.com\/blog\/wp-content\/uploads\/2020\/01\/One-color-globe.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dsparks\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dsparks\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/\"},\"author\":{\"name\":\"dsparks\",\"@id\":\"https:\/\/www.stratospherenetworks.com\/blog\/#\/schema\/person\/610effe029357cf39739d82d57e3b03c\"},\"headline\":\"5 Tips to Use Excel More Efficiently\",\"datePublished\":\"2012-04-06T17:23:55+00:00\",\"dateModified\":\"2018-06-26T17:05:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/\"},\"wordCount\":351,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stratospherenetworks.com\/blog\/wp-content\/uploads\/2020\/01\/One-color-globe.png\",\"articleSection\":[\"Knowledge Base\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/\",\"url\":\"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/\",\"name\":\"5 Tips to Use Excel More Efficiently - Stratosphere Networks IT Support Blog - Chicago IT Support Technical Support\",\"isPartOf\":{\"@id\":\"https:\/\/www.stratospherenetworks.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stratospherenetworks.com\/blog\/wp-content\/uploads\/2020\/01\/One-color-globe.png\",\"datePublished\":\"2012-04-06T17:23:55+00:00\",\"dateModified\":\"2018-06-26T17:05:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.stratospherenetworks.com\/blog\/#\/schema\/person\/610effe029357cf39739d82d57e3b03c\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/#primaryimage\",\"url\":\"https:\/\/www.stratospherenetworks.com\/blog\/wp-content\/uploads\/2020\/01\/One-color-globe.png\",\"contentUrl\":\"https:\/\/www.stratospherenetworks.com\/blog\/wp-content\/uploads\/2020\/01\/One-color-globe.png\",\"width\":1024,\"height\":1024},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stratospherenetworks.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"5 Tips to Use Excel More Efficiently\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stratospherenetworks.com\/blog\/#website\",\"url\":\"https:\/\/www.stratospherenetworks.com\/blog\/\",\"name\":\"Stratosphere Networks IT Support Blog - Chicago IT Support Technical Support\",\"description\":\"The Stratosphere Networks IT Support blog offering IT Support Services information.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stratospherenetworks.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.stratospherenetworks.com\/blog\/#\/schema\/person\/610effe029357cf39739d82d57e3b03c\",\"name\":\"dsparks\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stratospherenetworks.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1b07d2c6f91fabde958f3d699e6916d89ce9b9f2b23ebf9b18d8adb5aed7e14b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1b07d2c6f91fabde958f3d699e6916d89ce9b9f2b23ebf9b18d8adb5aed7e14b?s=96&d=mm&r=g\",\"caption\":\"dsparks\"},\"url\":\"https:\/\/www.stratospherenetworks.com\/blog\/author\/dsparks\/\"}]}<\/script>","yoast_head_json":{"title":"5 Tips to Use Excel More Efficiently - Stratosphere Networks IT Support Blog - Chicago IT Support Technical Support","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/","og_locale":"en_US","og_type":"article","og_title":"5 Tips to Use Excel More Efficiently - Stratosphere Networks IT Support Blog - Chicago IT Support Technical Support","og_description":"Are you gunning for a raise or a promotion? Maybe you only want to stand out for job security. In either case, this can be accomplished by impressing your boss, but how? What about Excel? The majority of us, no &hellip; Read more >","og_url":"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/","og_site_name":"Stratosphere Networks IT Support Blog - Chicago IT Support Technical Support","article_published_time":"2012-04-06T17:23:55+00:00","article_modified_time":"2018-06-26T17:05:00+00:00","og_image":[{"width":1024,"height":1024,"url":"https:\/\/www.stratospherenetworks.com\/blog\/wp-content\/uploads\/2020\/01\/One-color-globe.png","type":"image\/png"}],"author":"dsparks","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dsparks","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/#article","isPartOf":{"@id":"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/"},"author":{"name":"dsparks","@id":"https:\/\/www.stratospherenetworks.com\/blog\/#\/schema\/person\/610effe029357cf39739d82d57e3b03c"},"headline":"5 Tips to Use Excel More Efficiently","datePublished":"2012-04-06T17:23:55+00:00","dateModified":"2018-06-26T17:05:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/"},"wordCount":351,"commentCount":0,"image":{"@id":"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stratospherenetworks.com\/blog\/wp-content\/uploads\/2020\/01\/One-color-globe.png","articleSection":["Knowledge Base"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/","url":"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/","name":"5 Tips to Use Excel More Efficiently - Stratosphere Networks IT Support Blog - Chicago IT Support Technical Support","isPartOf":{"@id":"https:\/\/www.stratospherenetworks.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/#primaryimage"},"image":{"@id":"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stratospherenetworks.com\/blog\/wp-content\/uploads\/2020\/01\/One-color-globe.png","datePublished":"2012-04-06T17:23:55+00:00","dateModified":"2018-06-26T17:05:00+00:00","author":{"@id":"https:\/\/www.stratospherenetworks.com\/blog\/#\/schema\/person\/610effe029357cf39739d82d57e3b03c"},"breadcrumb":{"@id":"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/#primaryimage","url":"https:\/\/www.stratospherenetworks.com\/blog\/wp-content\/uploads\/2020\/01\/One-color-globe.png","contentUrl":"https:\/\/www.stratospherenetworks.com\/blog\/wp-content\/uploads\/2020\/01\/One-color-globe.png","width":1024,"height":1024},{"@type":"BreadcrumbList","@id":"https:\/\/www.stratospherenetworks.com\/blog\/5-tips-to-use-excel-more-efficiently\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stratospherenetworks.com\/blog\/"},{"@type":"ListItem","position":2,"name":"5 Tips to Use Excel More Efficiently"}]},{"@type":"WebSite","@id":"https:\/\/www.stratospherenetworks.com\/blog\/#website","url":"https:\/\/www.stratospherenetworks.com\/blog\/","name":"Stratosphere Networks IT Support Blog - Chicago IT Support Technical Support","description":"The Stratosphere Networks IT Support blog offering IT Support Services information.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stratospherenetworks.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.stratospherenetworks.com\/blog\/#\/schema\/person\/610effe029357cf39739d82d57e3b03c","name":"dsparks","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stratospherenetworks.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1b07d2c6f91fabde958f3d699e6916d89ce9b9f2b23ebf9b18d8adb5aed7e14b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1b07d2c6f91fabde958f3d699e6916d89ce9b9f2b23ebf9b18d8adb5aed7e14b?s=96&d=mm&r=g","caption":"dsparks"},"url":"https:\/\/www.stratospherenetworks.com\/blog\/author\/dsparks\/"}]}},"_links":{"self":[{"href":"https:\/\/www.stratospherenetworks.com\/blog\/wp-json\/wp\/v2\/posts\/124","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stratospherenetworks.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stratospherenetworks.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stratospherenetworks.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stratospherenetworks.com\/blog\/wp-json\/wp\/v2\/comments?post=124"}],"version-history":[{"count":7,"href":"https:\/\/www.stratospherenetworks.com\/blog\/wp-json\/wp\/v2\/posts\/124\/revisions"}],"predecessor-version":[{"id":1728,"href":"https:\/\/www.stratospherenetworks.com\/blog\/wp-json\/wp\/v2\/posts\/124\/revisions\/1728"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stratospherenetworks.com\/blog\/wp-json\/wp\/v2\/media\/3391"}],"wp:attachment":[{"href":"https:\/\/www.stratospherenetworks.com\/blog\/wp-json\/wp\/v2\/media?parent=124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stratospherenetworks.com\/blog\/wp-json\/wp\/v2\/categories?post=124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stratospherenetworks.com\/blog\/wp-json\/wp\/v2\/tags?post=124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}