{"id":141,"date":"2012-04-06T08:09:22","date_gmt":"2012-04-06T16:09:22","guid":{"rendered":"http:\/\/blog.nexthop.ca\/2012\/step-up-your-game-in-excel\/"},"modified":"2012-04-06T08:09:22","modified_gmt":"2012-04-06T16:09:22","slug":"step-up-your-game-in-excel","status":"publish","type":"post","link":"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/","title":{"rendered":"Step Up Your Game in Excel"},"content":{"rendered":"<p><p>Are you gunning for a raise or a promotion? Perhaps you simply want to stand out for job security. In either case, this can be done by impressing your supervisor, but how?<\/p>\n<p>Why not consider Excel? This spreadsheet program might appear to be just a basic, albeit important, business tool, but the truth is there are several lesser-known Excel tips that can help you work more efficiently.<\/p>\n<ul>\n<li><strong>Hiding Information<\/strong>: Did you know that you can hide columns, instead of deleteing them, when printing a spreadsheet? This can be convenient, for example, if the spreadsheet has private information such as salary. In order to hide rows or columns, select the related number or letter of the row or column to highlight it, then right-click on the highlighted row or column and select the Hide option. You can Unhide a row or column in the same manner once you have printed or exhibited your spreadsheet.<\/li>\n<li><strong>Timestamping<\/strong>: You can attach a fixed date and time to your Excel spreadsheets utilizing your computer\u2019s \u201cCtrl\u201d key. To do this, hold Ctrl while you press the semicolon key. For the current date and time simply hold down the Ctrl and Shift keys while pushing the semicolon.<\/li>\n<li><strong>A Better-Looking Spreadsheet<\/strong>: Give your spreadsheet a fresh look by using Excel\u2019s Themes option. You will find this in the Excel Ribbon, at the top. Click it, and you\u2019ll be given a huge selection of fonts, and color schemes that you may apply to your spreadsheet. It\u2019s also possible to make your own!<\/li>\n<li><strong>Tracking Trends<\/strong>: This is only applicable if you have a more recent version of Excel. The feature is called Sparklines and with it you can create charts that show trends in the information in your spreadsheet. One way you can use this is to quickly and easily see how many software bundles your company\u2019s salespeople sold in the first quarter of 2011.<\/li>\n<li><strong>Conditional Formatting<\/strong>: This allows you to format only specific cells, you can select a criteria, and any cells that fall within it will be a certain color. This feature will be helpful to get a quick visual read of your spreadsheet.<\/li>\n","protected":false},"excerpt":{"rendered":"<p> Are you gunning for a raise or a promotion? Perhaps you simply want to stand out for job security. In either case, this can be done by impressing your supervisor, but how? <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-141","post","type-post","status-publish","format-standard","hentry","category-business-technology"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Step Up Your Game in Excel | Next Hop Solutions<\/title>\n<meta name=\"description\" content=\"Step Up Your Game in Excel. Check out our IT blog for the latest news, updates and resources in the world of information technology.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Step Up Your Game in Excel | Next Hop Solutions\" \/>\n<meta property=\"og:description\" content=\"Step Up Your Game in Excel. Check out our IT blog for the latest news, updates and resources in the world of information technology.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Next Hop Solutions\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/NextHop-Solutions-Inc-178242158858401\/\" \/>\n<meta property=\"article:published_time\" content=\"2012-04-06T16:09:22+00:00\" \/>\n<meta name=\"author\" content=\"FirstPage Marketing\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@NextHopSolution\" \/>\n<meta name=\"twitter:site\" content=\"@NextHopSolution\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"FirstPage Marketing\" \/>\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:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/\"},\"author\":{\"name\":\"FirstPage Marketing\",\"@id\":\"https:\/\/nexthop.ca\/it-news\/#\/schema\/person\/4b874f1cc6154d00fdb435a6c6d27a29\"},\"headline\":\"Step Up Your Game in Excel\",\"datePublished\":\"2012-04-06T16:09:22+00:00\",\"dateModified\":\"2012-04-06T16:09:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/\"},\"wordCount\":366,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/nexthop.ca\/it-news\/#organization\"},\"articleSection\":[\"Business Technology\"],\"inLanguage\":\"en-CA\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/\",\"url\":\"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/\",\"name\":\"Step Up Your Game in Excel | Next Hop Solutions\",\"isPartOf\":{\"@id\":\"https:\/\/nexthop.ca\/it-news\/#website\"},\"datePublished\":\"2012-04-06T16:09:22+00:00\",\"dateModified\":\"2012-04-06T16:09:22+00:00\",\"description\":\"Step Up Your Game in Excel. Check out our IT blog for the latest news, updates and resources in the world of information technology.\",\"breadcrumb\":{\"@id\":\"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-CA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/nexthop.ca\/it-news\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Step Up Your Game in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/nexthop.ca\/it-news\/#website\",\"url\":\"https:\/\/nexthop.ca\/it-news\/\",\"name\":\"Next Hop Solutions\",\"description\":\"IT News\",\"publisher\":{\"@id\":\"https:\/\/nexthop.ca\/it-news\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/nexthop.ca\/it-news\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-CA\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/nexthop.ca\/it-news\/#organization\",\"name\":\"Next Hop Solutions\",\"url\":\"https:\/\/nexthop.ca\/it-news\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-CA\",\"@id\":\"https:\/\/nexthop.ca\/it-news\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/nexthop.ca\/it-news\/wp-content\/uploads\/2019\/10\/NHS182-RGB-Logo-WEB-LG.png\",\"contentUrl\":\"https:\/\/nexthop.ca\/it-news\/wp-content\/uploads\/2019\/10\/NHS182-RGB-Logo-WEB-LG.png\",\"width\":785,\"height\":167,\"caption\":\"Next Hop Solutions\"},\"image\":{\"@id\":\"https:\/\/nexthop.ca\/it-news\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/NextHop-Solutions-Inc-178242158858401\/\",\"https:\/\/x.com\/NextHopSolution\",\"https:\/\/ca.linkedin.com\/in\/nexthopsolutions\",\"https:\/\/www.youtube.com\/channel\/UC7smgon3p34B39CpnR6JzvQ\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/nexthop.ca\/it-news\/#\/schema\/person\/4b874f1cc6154d00fdb435a6c6d27a29\",\"name\":\"FirstPage Marketing\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-CA\",\"@id\":\"https:\/\/nexthop.ca\/it-news\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6cd491c7e05a170cc2202b3df18c516b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6cd491c7e05a170cc2202b3df18c516b?s=96&d=mm&r=g\",\"caption\":\"FirstPage Marketing\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Step Up Your Game in Excel | Next Hop Solutions","description":"Step Up Your Game in Excel. Check out our IT blog for the latest news, updates and resources in the world of information technology.","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:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Step Up Your Game in Excel | Next Hop Solutions","og_description":"Step Up Your Game in Excel. Check out our IT blog for the latest news, updates and resources in the world of information technology.","og_url":"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/","og_site_name":"Next Hop Solutions","article_publisher":"https:\/\/www.facebook.com\/NextHop-Solutions-Inc-178242158858401\/","article_published_time":"2012-04-06T16:09:22+00:00","author":"FirstPage Marketing","twitter_card":"summary_large_image","twitter_creator":"@NextHopSolution","twitter_site":"@NextHopSolution","twitter_misc":{"Written by":"FirstPage Marketing","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/#article","isPartOf":{"@id":"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/"},"author":{"name":"FirstPage Marketing","@id":"https:\/\/nexthop.ca\/it-news\/#\/schema\/person\/4b874f1cc6154d00fdb435a6c6d27a29"},"headline":"Step Up Your Game in Excel","datePublished":"2012-04-06T16:09:22+00:00","dateModified":"2012-04-06T16:09:22+00:00","mainEntityOfPage":{"@id":"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/"},"wordCount":366,"commentCount":0,"publisher":{"@id":"https:\/\/nexthop.ca\/it-news\/#organization"},"articleSection":["Business Technology"],"inLanguage":"en-CA","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/","url":"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/","name":"Step Up Your Game in Excel | Next Hop Solutions","isPartOf":{"@id":"https:\/\/nexthop.ca\/it-news\/#website"},"datePublished":"2012-04-06T16:09:22+00:00","dateModified":"2012-04-06T16:09:22+00:00","description":"Step Up Your Game in Excel. Check out our IT blog for the latest news, updates and resources in the world of information technology.","breadcrumb":{"@id":"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/#breadcrumb"},"inLanguage":"en-CA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/nexthop.ca\/it-news\/step-up-your-game-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nexthop.ca\/it-news\/"},{"@type":"ListItem","position":2,"name":"Step Up Your Game in Excel"}]},{"@type":"WebSite","@id":"https:\/\/nexthop.ca\/it-news\/#website","url":"https:\/\/nexthop.ca\/it-news\/","name":"Next Hop Solutions","description":"IT News","publisher":{"@id":"https:\/\/nexthop.ca\/it-news\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nexthop.ca\/it-news\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-CA"},{"@type":"Organization","@id":"https:\/\/nexthop.ca\/it-news\/#organization","name":"Next Hop Solutions","url":"https:\/\/nexthop.ca\/it-news\/","logo":{"@type":"ImageObject","inLanguage":"en-CA","@id":"https:\/\/nexthop.ca\/it-news\/#\/schema\/logo\/image\/","url":"https:\/\/nexthop.ca\/it-news\/wp-content\/uploads\/2019\/10\/NHS182-RGB-Logo-WEB-LG.png","contentUrl":"https:\/\/nexthop.ca\/it-news\/wp-content\/uploads\/2019\/10\/NHS182-RGB-Logo-WEB-LG.png","width":785,"height":167,"caption":"Next Hop Solutions"},"image":{"@id":"https:\/\/nexthop.ca\/it-news\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/NextHop-Solutions-Inc-178242158858401\/","https:\/\/x.com\/NextHopSolution","https:\/\/ca.linkedin.com\/in\/nexthopsolutions","https:\/\/www.youtube.com\/channel\/UC7smgon3p34B39CpnR6JzvQ"]},{"@type":"Person","@id":"https:\/\/nexthop.ca\/it-news\/#\/schema\/person\/4b874f1cc6154d00fdb435a6c6d27a29","name":"FirstPage Marketing","image":{"@type":"ImageObject","inLanguage":"en-CA","@id":"https:\/\/nexthop.ca\/it-news\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6cd491c7e05a170cc2202b3df18c516b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6cd491c7e05a170cc2202b3df18c516b?s=96&d=mm&r=g","caption":"FirstPage Marketing"}}]}},"_links":{"self":[{"href":"https:\/\/nexthop.ca\/it-news\/wp-json\/wp\/v2\/posts\/141"}],"collection":[{"href":"https:\/\/nexthop.ca\/it-news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nexthop.ca\/it-news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nexthop.ca\/it-news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nexthop.ca\/it-news\/wp-json\/wp\/v2\/comments?post=141"}],"version-history":[{"count":0,"href":"https:\/\/nexthop.ca\/it-news\/wp-json\/wp\/v2\/posts\/141\/revisions"}],"wp:attachment":[{"href":"https:\/\/nexthop.ca\/it-news\/wp-json\/wp\/v2\/media?parent=141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nexthop.ca\/it-news\/wp-json\/wp\/v2\/categories?post=141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nexthop.ca\/it-news\/wp-json\/wp\/v2\/tags?post=141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}