{"id":305,"date":"2016-10-17T20:00:14","date_gmt":"2016-10-17T20:00:14","guid":{"rendered":"https:\/\/itgroove.net\/align\/?p=305"},"modified":"2023-02-23T15:43:20","modified_gmt":"2023-02-23T23:43:20","slug":"excel-for-beginners","status":"publish","type":"post","link":"https:\/\/regroove.ca\/karin\/excel-for-beginners\/","title":{"rendered":"Excel for Beginners: Why Use It? + Tips & Tricks"},"content":{"rendered":"

This blog post is aimed at Microsoft Excel beginners, and will leave you feeling confident about what Excel is used for, with a few tricks up your sleeve to boot.<\/p>\n

What is Microsoft Excel?<\/h2>\n

Excel is a program created for spreadsheets which contain data.<\/strong> Data can be numbers or text. Microsoft Excel<\/a> is the tool to use if you want to analyze data, perform calculations, or turn data into a visual graph. If you’re just looking to create a visual table without the need to manipulate data, I’d suggest Microsoft Word<\/a> or OneNote<\/a>.<\/p>\n

Getting Started in Excel<\/h2>\n

If you’re not familiar with Excel, it’s probably tough to know where to begin. This next set of tips should give you some knowledge of how to use formulas, along with some handy tricks that will help you in the wild west of Microsoft Excel.<\/p>\n

To understand what Excel is capable of, here’s a handy tab in Excel called Formulas<\/strong>, with a plethora of formulas available for you to use.<\/p>\n

\"formulas\"<\/p>\n

Even if these formulas are unfamiliar, you can see what they do at a glance by hovering over them. If you don’t have any real data, but you want to play with some formulas, you can generate random numbers by following the steps in this quick video Byte here<\/a>.<\/p>\n

\"formula-hover\"<\/p>\n

The Quick Analysis<\/strong> tool is also handy. Simply select your cells, then a little box on the side with an icon inside it will pop up. Quick Analysis gives you a list of suggestions of how to use your data, depending on what your cells contain.<\/p>\n

\"quick-analysis\"<\/p>\n

Let’s jump into an example.<\/h3>\n

Say Employee X wants to figure out how much they’ve earned per year over the past five years with their company.<\/p>\n

First, we plunk the data in. Hourly Pay<\/em> and Hours Worked Per Week<\/em>. We’ll create another column called Year’s Pay<\/em>, but we’ll leave that one blank.<\/p>\n

To format your data as a table, click Format as Table<\/strong> on the Home page.<\/p>\n

\"format-table\"<\/p>\n

Now that your table looks nice and table-y, we want to calculate how much Employee X has earned. To do that we’ll use some basic algebra.<\/p>\n

Hourly Pay x Hours Worked Per Week x 52 weeks in a year = Year’s Pay<\/em>. (Keep in mind that Excel formulas use asterisks as multiplication signs.)<\/p>\n

Our formula would be is “B3*C2*52=<\/em>“.<\/p>\n

Type that in, press enter, and voila – the calculations are made for you. In Excel 2013 or later, Flash Fill<\/strong> will do the work for the rest of the cells.<\/p>\n

If you’re interested in learning more about Flash Fill, I made a video Byte that you can check out here<\/a>.<\/p>\n

\"calculating\"<\/p>\n

Neato!<\/p>\n

Now that you have your data, how about visualizing it in a cool chart?<\/p>\n

Just head to the Insert<\/strong> tab. From there you can choose a type of chart you’d like. You can also choose Recommended Charts<\/strong> and see a list of recommended charts, then easily switch to a tab with All Charts<\/strong>. Once you’ve chosen your chart, select OK, then your chart is inserted into your spreadsheet.<\/p>\n

\"charts\"<\/p>\n

If you want to give that chart a full page of its own, here’s how.<\/p>\n

First, select your chart, then head to the Chart Tools<\/strong> > Design<\/strong> tab at the top ribbon.<\/p>\n

Click on Move Chart<\/strong>, then select New Sheet<\/strong>.<\/p>\n

You can also quickly create a chart in a new sheet by pressing F11.<\/p>\n

\"chart-page\"<\/p>\n

Another great source for some handy tips and tricks is 14 Excel Tricks That Will Impress Your Boss<\/a> by a Microsoft training website called STL.<\/p>\n

Click on the image below to head to their site and view the full infographic.<\/p>\n

\"excel-tricks-thumbnail\"<\/a><\/p>\n

If you’re still reading, please let me know which tip you found most useful in this post.
\nI would also love to connect on Twitter<\/a> or Instagram<\/a> – let’s be friends!<\/h4>\n","protected":false},"excerpt":{"rendered":"

This blog post is aimed at Microsoft Excel beginners, and will leave you feeling confident about what Excel is used for, with a few tricks up your sleeve to boot. What is Microsoft Excel? Excel is a program created for spreadsheets which contain data. Data can be numbers or text. Microsoft Excel is the tool … <\/a><\/p>\n","protected":false},"author":5,"featured_media":321,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[25,8,12,15],"tags":[65,100,101,102,103,107,108,113,149,150],"acf":[],"yoast_head":"\nExcel for Beginners: Why Use It? + Tips & Tricks - Karin Skapski<\/title>\n<meta name=\"description\" content=\"This blog post is aimed at Microsoft Excel beginners, and will leave you feeling confident about what Excel is used for, with a few tricks up your sleeve.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/regroove.ca\/karin\/excel-for-beginners\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel for Beginners: Why Use It? + Tips & Tricks - Karin Skapski\" \/>\n<meta property=\"og:description\" content=\"This blog post is aimed at Microsoft Excel beginners, and will leave you feeling confident about what Excel is used for, with a few tricks up your sleeve.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/karin\/excel-for-beginners\/\" \/>\n<meta property=\"og:site_name\" content=\"Karin Skapski\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-17T20:00:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-23T23:43:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/regroove.ca\/karin\/wp-content\/uploads\/sites\/4\/2016\/10\/Excel-icon-e1476733981461.png\" \/>\n\t<meta property=\"og:image:width\" content=\"256\" \/>\n\t<meta property=\"og:image:height\" content=\"255\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Karin Skapski (Alumni)\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Karin Skapski (Alumni)\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/regroove.ca\/karin\/excel-for-beginners\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/karin\/excel-for-beginners\/\"},\"author\":{\"name\":\"Karin Skapski (Alumni)\",\"@id\":\"https:\/\/regroove.ca\/karin\/#\/schema\/person\/c23adfde46a8fa2ce372e3dda6b15f43\"},\"headline\":\"Excel for Beginners: Why Use It? + Tips & Tricks\",\"datePublished\":\"2016-10-17T20:00:14+00:00\",\"dateModified\":\"2023-02-23T23:43:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/regroove.ca\/karin\/excel-for-beginners\/\"},\"wordCount\":639,\"publisher\":{\"@id\":\"https:\/\/regroove.ca\/karin\/#\/schema\/person\/c23adfde46a8fa2ce372e3dda6b15f43\"},\"image\":{\"@id\":\"https:\/\/regroove.ca\/karin\/excel-for-beginners\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/regroove.ca\/karin\/wp-content\/uploads\/sites\/4\/2016\/10\/Excel-icon-e1476733981461.png\",\"keywords\":[\"excel\",\"microsoft\",\"microsoft excel\",\"microsoft office\",\"microsoft tips\",\"ms excel\",\"ms office\",\"office 365\",\"tech tips\",\"tech tricks\"],\"articleSection\":[\"Excel\",\"How To\",\"Microsoft\",\"Office 365\"],\"inLanguage\":\"en-CA\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/karin\/excel-for-beginners\/\",\"url\":\"https:\/\/regroove.ca\/karin\/excel-for-beginners\/\",\"name\":\"Excel for Beginners: Why Use It? + Tips & Tricks - Karin Skapski\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/karin\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/regroove.ca\/karin\/excel-for-beginners\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/regroove.ca\/karin\/excel-for-beginners\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/regroove.ca\/karin\/wp-content\/uploads\/sites\/4\/2016\/10\/Excel-icon-e1476733981461.png\",\"datePublished\":\"2016-10-17T20:00:14+00:00\",\"dateModified\":\"2023-02-23T23:43:20+00:00\",\"description\":\"This blog post is aimed at Microsoft Excel beginners, and will leave you feeling confident about what Excel is used for, with a few tricks up your sleeve.\",\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/karin\/excel-for-beginners\/#breadcrumb\"},\"inLanguage\":\"en-CA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/karin\/excel-for-beginners\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-CA\",\"@id\":\"https:\/\/regroove.ca\/karin\/excel-for-beginners\/#primaryimage\",\"url\":\"https:\/\/regroove.ca\/karin\/wp-content\/uploads\/sites\/4\/2016\/10\/Excel-icon-e1476733981461.png\",\"contentUrl\":\"https:\/\/regroove.ca\/karin\/wp-content\/uploads\/sites\/4\/2016\/10\/Excel-icon-e1476733981461.png\",\"width\":256,\"height\":255},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/karin\/excel-for-beginners\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Karin Skapski's Blog\",\"item\":\"https:\/\/regroove.ca\/karin\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel for Beginners: Why Use It? + Tips & Tricks\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/karin\/#website\",\"url\":\"https:\/\/regroove.ca\/karin\/\",\"name\":\"Karin Skapski\",\"description\":\"Modern workplace technology and productivity insights.\",\"publisher\":{\"@id\":\"https:\/\/regroove.ca\/karin\/#\/schema\/person\/c23adfde46a8fa2ce372e3dda6b15f43\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/karin\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-CA\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/regroove.ca\/karin\/#\/schema\/person\/c23adfde46a8fa2ce372e3dda6b15f43\",\"name\":\"Karin Skapski (Alumni)\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-CA\",\"@id\":\"https:\/\/regroove.ca\/karin\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a90333ec7bb16f7f8ba9981700b10933?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a90333ec7bb16f7f8ba9981700b10933?s=96&d=mm&r=g\",\"caption\":\"Karin Skapski (Alumni)\"},\"logo\":{\"@id\":\"https:\/\/regroove.ca\/karin\/#\/schema\/person\/image\/\"},\"url\":\"https:\/\/regroove.ca\/karin\/author\/kskapski\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel for Beginners: Why Use It? + Tips & Tricks - Karin Skapski","description":"This blog post is aimed at Microsoft Excel beginners, and will leave you feeling confident about what Excel is used for, with a few tricks up your sleeve.","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:\/\/regroove.ca\/karin\/excel-for-beginners\/","og_locale":"en_US","og_type":"article","og_title":"Excel for Beginners: Why Use It? + Tips & Tricks - Karin Skapski","og_description":"This blog post is aimed at Microsoft Excel beginners, and will leave you feeling confident about what Excel is used for, with a few tricks up your sleeve.","og_url":"https:\/\/regroove.ca\/karin\/excel-for-beginners\/","og_site_name":"Karin Skapski","article_published_time":"2016-10-17T20:00:14+00:00","article_modified_time":"2023-02-23T23:43:20+00:00","og_image":[{"width":256,"height":255,"url":"https:\/\/regroove.ca\/karin\/wp-content\/uploads\/sites\/4\/2016\/10\/Excel-icon-e1476733981461.png","type":"image\/png"}],"author":"Karin Skapski (Alumni)","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Karin Skapski (Alumni)","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/regroove.ca\/karin\/excel-for-beginners\/#article","isPartOf":{"@id":"https:\/\/regroove.ca\/karin\/excel-for-beginners\/"},"author":{"name":"Karin Skapski (Alumni)","@id":"https:\/\/regroove.ca\/karin\/#\/schema\/person\/c23adfde46a8fa2ce372e3dda6b15f43"},"headline":"Excel for Beginners: Why Use It? + Tips & Tricks","datePublished":"2016-10-17T20:00:14+00:00","dateModified":"2023-02-23T23:43:20+00:00","mainEntityOfPage":{"@id":"https:\/\/regroove.ca\/karin\/excel-for-beginners\/"},"wordCount":639,"publisher":{"@id":"https:\/\/regroove.ca\/karin\/#\/schema\/person\/c23adfde46a8fa2ce372e3dda6b15f43"},"image":{"@id":"https:\/\/regroove.ca\/karin\/excel-for-beginners\/#primaryimage"},"thumbnailUrl":"https:\/\/regroove.ca\/karin\/wp-content\/uploads\/sites\/4\/2016\/10\/Excel-icon-e1476733981461.png","keywords":["excel","microsoft","microsoft excel","microsoft office","microsoft tips","ms excel","ms office","office 365","tech tips","tech tricks"],"articleSection":["Excel","How To","Microsoft","Office 365"],"inLanguage":"en-CA"},{"@type":"WebPage","@id":"https:\/\/regroove.ca\/karin\/excel-for-beginners\/","url":"https:\/\/regroove.ca\/karin\/excel-for-beginners\/","name":"Excel for Beginners: Why Use It? + Tips & Tricks - Karin Skapski","isPartOf":{"@id":"https:\/\/regroove.ca\/karin\/#website"},"primaryImageOfPage":{"@id":"https:\/\/regroove.ca\/karin\/excel-for-beginners\/#primaryimage"},"image":{"@id":"https:\/\/regroove.ca\/karin\/excel-for-beginners\/#primaryimage"},"thumbnailUrl":"https:\/\/regroove.ca\/karin\/wp-content\/uploads\/sites\/4\/2016\/10\/Excel-icon-e1476733981461.png","datePublished":"2016-10-17T20:00:14+00:00","dateModified":"2023-02-23T23:43:20+00:00","description":"This blog post is aimed at Microsoft Excel beginners, and will leave you feeling confident about what Excel is used for, with a few tricks up your sleeve.","breadcrumb":{"@id":"https:\/\/regroove.ca\/karin\/excel-for-beginners\/#breadcrumb"},"inLanguage":"en-CA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/karin\/excel-for-beginners\/"]}]},{"@type":"ImageObject","inLanguage":"en-CA","@id":"https:\/\/regroove.ca\/karin\/excel-for-beginners\/#primaryimage","url":"https:\/\/regroove.ca\/karin\/wp-content\/uploads\/sites\/4\/2016\/10\/Excel-icon-e1476733981461.png","contentUrl":"https:\/\/regroove.ca\/karin\/wp-content\/uploads\/sites\/4\/2016\/10\/Excel-icon-e1476733981461.png","width":256,"height":255},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/karin\/excel-for-beginners\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Karin Skapski's Blog","item":"https:\/\/regroove.ca\/karin\/"},{"@type":"ListItem","position":2,"name":"Excel for Beginners: Why Use It? + Tips & Tricks"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/karin\/#website","url":"https:\/\/regroove.ca\/karin\/","name":"Karin Skapski","description":"Modern workplace technology and productivity insights.","publisher":{"@id":"https:\/\/regroove.ca\/karin\/#\/schema\/person\/c23adfde46a8fa2ce372e3dda6b15f43"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/karin\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-CA"},{"@type":["Person","Organization"],"@id":"https:\/\/regroove.ca\/karin\/#\/schema\/person\/c23adfde46a8fa2ce372e3dda6b15f43","name":"Karin Skapski (Alumni)","image":{"@type":"ImageObject","inLanguage":"en-CA","@id":"https:\/\/regroove.ca\/karin\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a90333ec7bb16f7f8ba9981700b10933?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a90333ec7bb16f7f8ba9981700b10933?s=96&d=mm&r=g","caption":"Karin Skapski (Alumni)"},"logo":{"@id":"https:\/\/regroove.ca\/karin\/#\/schema\/person\/image\/"},"url":"https:\/\/regroove.ca\/karin\/author\/kskapski\/"}]}},"_links":{"self":[{"href":"https:\/\/regroove.ca\/karin\/wp-json\/wp\/v2\/posts\/305"}],"collection":[{"href":"https:\/\/regroove.ca\/karin\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/karin\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/karin\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/karin\/wp-json\/wp\/v2\/comments?post=305"}],"version-history":[{"count":1,"href":"https:\/\/regroove.ca\/karin\/wp-json\/wp\/v2\/posts\/305\/revisions"}],"predecessor-version":[{"id":1124,"href":"https:\/\/regroove.ca\/karin\/wp-json\/wp\/v2\/posts\/305\/revisions\/1124"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/regroove.ca\/karin\/wp-json\/wp\/v2\/media\/321"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/karin\/wp-json\/wp\/v2\/media?parent=305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/karin\/wp-json\/wp\/v2\/categories?post=305"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/karin\/wp-json\/wp\/v2\/tags?post=305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}