{"id":4847,"date":"2020-06-26T12:56:55","date_gmt":"2020-06-26T12:56:55","guid":{"rendered":"https:\/\/www.homeworkjoy.com\/infographics\/?p=4847"},"modified":"2022-07-02T05:26:34","modified_gmt":"2022-07-02T12:26:34","slug":"simple-tips-on-how-to-learn-excel-step-by-step-guide","status":"publish","type":"post","link":"https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/","title":{"rendered":"Simple Tips on How to Learn Excel | Step by Step Guide"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Sometimes excel is too good to handle the larger data. All you have to do is enter the formula, and everything will be done automatically. So lets\u2019 see how we can use this handy software.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">But before that, see some of our new posts:<\/span><\/p>\n<p><a href=\"https:\/\/www.homeworkjoy.com\/infographics\/learning\/truth-table-of-logic-gates-types-and-functions\/\"><span style=\"font-weight: 400;\">Truth Table of Logic Gates | Types and Functions<\/span><\/a><\/p>\n<p><a href=\"https:\/\/www.homeworkjoy.com\/infographics\/tips-and-learning\/what-is-wordpress-and-its-uses-students-guide\/\"><span style=\"font-weight: 400;\">What is WordPress and Its Uses | Students\u2019 Guide<\/span><\/a><\/p>\n<p><span style=\"font-weight: 400;\">The following are some tips on how to learn excel; let\u2019s have a quick look.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Interchange Rows into Columns<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">If you want to transform data from rows into columns, then this step is helpful for you.\u00a0<\/span><\/p>\n<p><b>Steps to Interchange rows into columns: <\/b><span style=\"font-weight: 400;\">Highlight the row that you want to interchange with the column. Then Right-Click it and select \u201dCopy\u201d. Paste it in your spreadsheet wherever you want.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Split up text information<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Suppose you need to split the first and last name of the people into two different columns. Thus this step will help you.\u00a0\u00a0<\/span><\/p>\n<p><b>Steps to split the text:<\/b><span style=\"font-weight: 400;\"> If you need to split the text information into two different columns, then first highlight the column you want to split. After that, go to the Data tab and select \u201cText to Columns\u201d. You\u2019ll see a module with some additional features from which you have to choose either \u201cDelimited\u201d or \u201cFixed Width.\u201d<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">How to Use Excel Formulas<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Here are some tips on how to use formulas in excel file.\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">Formulas for Simple Calculations<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Excel can help you to do simple calculations like subtracting, addition or multiplication<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">For addition use + sign<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">To subtract use &#8211; sign<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">To multiply use * sign<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">For division use \/ sign<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Also, you can use parenthesis if you have to perform two tasks together. For example (20+20)*20.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">To Calculate Average<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Doing simple calculations is easy. Even most of us can use a calculator for that. But what if you have to perform some tricky action on your data like calculating average? That is why excel is there to help you.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If you have to calculate the average of the cells, then use the formula <\/span><b><i>=AVERAGE(Cell Range)<\/i><\/b><span style=\"font-weight: 400;\">\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For the addition of the numbers, use the formula <\/span><b><i>=SUM(Cell Range).<\/i><\/b><span style=\"font-weight: 400;\">\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">To automatically change the color of the Data.<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Use conditional formatting to change the color of the Data automatically. It will help you to find particular data faster.<\/span><\/p>\n<p><b>Steps to use conditional formatting<\/b><span style=\"font-weight: 400;\">: highlight the group of cells on which you have to use conditional formatting. Choose conditional formatting from the Home Menu. Select the Logic from the dropdown. A window will pop up, which will have more information. After reading that click OK\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Thus use these steps to make your work easy on excel. Furthermore, to know more, get instant<\/span><a href=\"https:\/\/www.homeworkjoy.com\/computer-science-help\/\"> <span style=\"font-weight: 400;\">computer science assignment help<\/span><\/a><span style=\"font-weight: 400;\"> from professionals.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes excel is too good to handle the larger data. All you have to do is enter the formula, and everything will be done automatically. So lets\u2019 see how we can use this handy software.\u00a0 But before that, see some of our new posts: Truth Table of Logic Gates | Types and Functions What is [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4848,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Simple Tips on How to Learn Excel | Step by Step Guide<\/title>\n<meta name=\"description\" content=\"Here are some tips on how to learn excel. Learn some new formulas and tricks to organize your data better. For more details, check the post.\" \/>\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.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Simple Tips on How to Learn Excel | Step by Step Guide\" \/>\n<meta property=\"og:description\" content=\"Here are some tips on how to learn excel. Learn some new formulas and tricks to organize your data better. For more details, check the post.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/\" \/>\n<meta property=\"og:site_name\" content=\"Infographics - Homework Joy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Homework-Joy-246916479585340\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-26T12:56:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-02T12:26:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.homeworkjoy.com\/infographics\/wp-content\/uploads\/2020\/06\/Simple-Tips-on-How-to-Learn-Excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"594\" \/>\n\t<meta property=\"og:image:height\" content=\"1487\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"mjadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@homeworkjoy\" \/>\n<meta name=\"twitter:site\" content=\"@homeworkjoy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"mjadmin\" \/>\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.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/\"},\"author\":{\"name\":\"mjadmin\",\"@id\":\"https:\/\/www.homeworkjoy.com\/infographics\/#\/schema\/person\/9475c2c11870bd20dce9c6d71569598c\"},\"headline\":\"Simple Tips on How to Learn Excel | Step by Step Guide\",\"datePublished\":\"2020-06-26T12:56:55+00:00\",\"dateModified\":\"2022-07-02T12:26:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/\"},\"wordCount\":459,\"publisher\":{\"@id\":\"https:\/\/www.homeworkjoy.com\/infographics\/#organization\"},\"articleSection\":[\"Learning\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/\",\"url\":\"https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/\",\"name\":\"Simple Tips on How to Learn Excel | Step by Step Guide\",\"isPartOf\":{\"@id\":\"https:\/\/www.homeworkjoy.com\/infographics\/#website\"},\"datePublished\":\"2020-06-26T12:56:55+00:00\",\"dateModified\":\"2022-07-02T12:26:34+00:00\",\"description\":\"Here are some tips on how to learn excel. Learn some new formulas and tricks to organize your data better. For more details, check the post.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.homeworkjoy.com\/infographics\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Learning\",\"item\":\"https:\/\/www.homeworkjoy.com\/infographics\/learning\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Simple Tips on How to Learn Excel | Step by Step Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.homeworkjoy.com\/infographics\/#website\",\"url\":\"https:\/\/www.homeworkjoy.com\/infographics\/\",\"name\":\"Infographics - Homework Joy\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.homeworkjoy.com\/infographics\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.homeworkjoy.com\/infographics\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.homeworkjoy.com\/infographics\/#organization\",\"name\":\"Homework Joy\",\"url\":\"https:\/\/www.homeworkjoy.com\/infographics\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.homeworkjoy.com\/infographics\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.homeworkjoy.com\/infographics\/wp-content\/uploads\/2019\/12\/logof2.png\",\"contentUrl\":\"https:\/\/www.homeworkjoy.com\/infographics\/wp-content\/uploads\/2019\/12\/logof2.png\",\"width\":220,\"height\":70,\"caption\":\"Homework Joy\"},\"image\":{\"@id\":\"https:\/\/www.homeworkjoy.com\/infographics\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Homework-Joy-246916479585340\/\",\"https:\/\/twitter.com\/homeworkjoy\",\"https:\/\/www.instagram.com\/homeworkjoy\/\",\"https:\/\/www.youtube.com\/channel\/UC1xkeQFkhBGHIoq2mNVxPZg\",\"https:\/\/pinterest.com\/homeworkjoy_\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.homeworkjoy.com\/infographics\/#\/schema\/person\/9475c2c11870bd20dce9c6d71569598c\",\"name\":\"mjadmin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Simple Tips on How to Learn Excel | Step by Step Guide","description":"Here are some tips on how to learn excel. Learn some new formulas and tricks to organize your data better. For more details, check the post.","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.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/","og_locale":"en_US","og_type":"article","og_title":"Simple Tips on How to Learn Excel | Step by Step Guide","og_description":"Here are some tips on how to learn excel. Learn some new formulas and tricks to organize your data better. For more details, check the post.","og_url":"https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/","og_site_name":"Infographics - Homework Joy","article_publisher":"https:\/\/www.facebook.com\/Homework-Joy-246916479585340\/","article_published_time":"2020-06-26T12:56:55+00:00","article_modified_time":"2022-07-02T12:26:34+00:00","og_image":[{"width":594,"height":1487,"url":"https:\/\/www.homeworkjoy.com\/infographics\/wp-content\/uploads\/2020\/06\/Simple-Tips-on-How-to-Learn-Excel.jpg","type":"image\/jpeg"}],"author":"mjadmin","twitter_card":"summary_large_image","twitter_creator":"@homeworkjoy","twitter_site":"@homeworkjoy","twitter_misc":{"Written by":"mjadmin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/#article","isPartOf":{"@id":"https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/"},"author":{"name":"mjadmin","@id":"https:\/\/www.homeworkjoy.com\/infographics\/#\/schema\/person\/9475c2c11870bd20dce9c6d71569598c"},"headline":"Simple Tips on How to Learn Excel | Step by Step Guide","datePublished":"2020-06-26T12:56:55+00:00","dateModified":"2022-07-02T12:26:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/"},"wordCount":459,"publisher":{"@id":"https:\/\/www.homeworkjoy.com\/infographics\/#organization"},"articleSection":["Learning"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/","url":"https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/","name":"Simple Tips on How to Learn Excel | Step by Step Guide","isPartOf":{"@id":"https:\/\/www.homeworkjoy.com\/infographics\/#website"},"datePublished":"2020-06-26T12:56:55+00:00","dateModified":"2022-07-02T12:26:34+00:00","description":"Here are some tips on how to learn excel. Learn some new formulas and tricks to organize your data better. For more details, check the post.","breadcrumb":{"@id":"https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.homeworkjoy.com\/infographics\/simple-tips-on-how-to-learn-excel-step-by-step-guide\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.homeworkjoy.com\/infographics\/"},{"@type":"ListItem","position":2,"name":"Learning","item":"https:\/\/www.homeworkjoy.com\/infographics\/learning\/"},{"@type":"ListItem","position":3,"name":"Simple Tips on How to Learn Excel | Step by Step Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.homeworkjoy.com\/infographics\/#website","url":"https:\/\/www.homeworkjoy.com\/infographics\/","name":"Infographics - Homework Joy","description":"","publisher":{"@id":"https:\/\/www.homeworkjoy.com\/infographics\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.homeworkjoy.com\/infographics\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.homeworkjoy.com\/infographics\/#organization","name":"Homework Joy","url":"https:\/\/www.homeworkjoy.com\/infographics\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.homeworkjoy.com\/infographics\/#\/schema\/logo\/image\/","url":"https:\/\/www.homeworkjoy.com\/infographics\/wp-content\/uploads\/2019\/12\/logof2.png","contentUrl":"https:\/\/www.homeworkjoy.com\/infographics\/wp-content\/uploads\/2019\/12\/logof2.png","width":220,"height":70,"caption":"Homework Joy"},"image":{"@id":"https:\/\/www.homeworkjoy.com\/infographics\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Homework-Joy-246916479585340\/","https:\/\/twitter.com\/homeworkjoy","https:\/\/www.instagram.com\/homeworkjoy\/","https:\/\/www.youtube.com\/channel\/UC1xkeQFkhBGHIoq2mNVxPZg","https:\/\/pinterest.com\/homeworkjoy_\/"]},{"@type":"Person","@id":"https:\/\/www.homeworkjoy.com\/infographics\/#\/schema\/person\/9475c2c11870bd20dce9c6d71569598c","name":"mjadmin"}]}},"_links":{"self":[{"href":"https:\/\/www.homeworkjoy.com\/infographics\/wp-json\/wp\/v2\/posts\/4847"}],"collection":[{"href":"https:\/\/www.homeworkjoy.com\/infographics\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.homeworkjoy.com\/infographics\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.homeworkjoy.com\/infographics\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.homeworkjoy.com\/infographics\/wp-json\/wp\/v2\/comments?post=4847"}],"version-history":[{"count":5,"href":"https:\/\/www.homeworkjoy.com\/infographics\/wp-json\/wp\/v2\/posts\/4847\/revisions"}],"predecessor-version":[{"id":5852,"href":"https:\/\/www.homeworkjoy.com\/infographics\/wp-json\/wp\/v2\/posts\/4847\/revisions\/5852"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.homeworkjoy.com\/infographics\/wp-json\/wp\/v2\/media\/4848"}],"wp:attachment":[{"href":"https:\/\/www.homeworkjoy.com\/infographics\/wp-json\/wp\/v2\/media?parent=4847"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.homeworkjoy.com\/infographics\/wp-json\/wp\/v2\/categories?post=4847"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.homeworkjoy.com\/infographics\/wp-json\/wp\/v2\/tags?post=4847"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}