{"id":1358,"date":"2015-06-15T16:04:45","date_gmt":"2015-06-15T14:04:45","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1358"},"modified":"2024-05-25T19:57:55","modified_gmt":"2024-05-25T17:57:55","slug":"top-10-excel-productivity-tips","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-10-excel-productivity-tips\/","title":{"rendered":"Top 10 Excel Productivity Tips"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Top10ExcelProductivityTips.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1380 size-large\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Top10ExcelProductivityTips-1024x535.png\" alt=\"Top10ExcelProductivityTips\" width=\"1024\" height=\"535\" title=\"\"><\/a><\/p>\n<p>Excel is used by more than 750 million people around the world and only 5% really know how to use its full suite of tools.<\/p>\n<p>In this post I will show you the top 10 Excel productivity tips that you need to know in order to complete your tasks much quicker within Excel, so you can go home a tad bit earlier.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-10-excel-productivity-tips\/#TIPS_TRICKS\" title=\"TIPS &amp; TRICKS\">TIPS &amp; TRICKS<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-10-excel-productivity-tips\/#1_Excel_Sheet_Navigator\" title=\"1. Excel Sheet Navigator\">1. Excel Sheet Navigator<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-10-excel-productivity-tips\/#2_Status_Bar_Metrics\" title=\"2. Status Bar Metrics\">2. Status Bar Metrics<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-10-excel-productivity-tips\/#_3_Format_Painter_Multiple_Cells\" title=\"\u00a03. Format Painter Multiple Cells\">\u00a03. Format Painter Multiple Cells<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-10-excel-productivity-tips\/#4_Fill_Down_Formulas\" title=\"4. Fill Down Formulas\">4. Fill Down Formulas<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-10-excel-productivity-tips\/#5_Unhide_Rows_Columns\" title=\"5. Unhide Rows &amp; Columns\">5. Unhide Rows &amp; Columns<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-10-excel-productivity-tips\/#KEYBOARD_SHORTCUTS\" title=\"KEYBOARD SHORTCUTS\">KEYBOARD SHORTCUTS<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-10-excel-productivity-tips\/#1_CTRL_F1\" title=\"1. CTRL + F1\">1. CTRL + F1<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-10-excel-productivity-tips\/#2_CTRL_SHIFT_ARROWS\" title=\"2. CTRL + SHIFT + ARROWS\">2. CTRL + SHIFT + ARROWS<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-10-excel-productivity-tips\/#_3_CTRL\" title=\"\u00a03. CTRL + -+ \">\u00a03. CTRL + -+ <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-10-excel-productivity-tips\/#4_CTRL_DR\" title=\"4. CTRL + D\/R\">4. CTRL + D\/R<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-10-excel-productivity-tips\/#5_CTRL_ENTER\" title=\"5. CTRL + ENTER\">5. CTRL + ENTER<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"TIPS_TRICKS\"><\/span><span style=\"color: #0000ff\">TIPS &amp; TRICKS<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"1_Excel_Sheet_Navigator\"><\/span><span style=\"color: #ff0000\"><strong>1. Excel Sheet Navigator<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you have lots of worksheets in your workbook and you quickly want to navigate to the last worksheets, all you need to do is Right Click in the bottom left hand corner of your workbook where the sheet arrows are located and this will bring up a list of all your worksheets.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/bkvz883ZKD4?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">?<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_Status_Bar_Metrics\"><\/span><span style=\"color: #ff0000\"><strong>2. Status Bar Metrics<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you select a range of cells you can quickly see key metrics like the <em>Sum, Count, Minimum, Maxi mun and Average.<\/em><\/p>\n<p>To activate this you will need to Right Click on the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/status-bar-in-excel\/\" target=\"_blank\" rel=\"noopener\">Status Bar<\/a> at the bottom of your workbook and choose the metrics that you want to show.\u00a0 Once selected, these option remain saved for all future workbooks.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/ge9ROeDjh6E?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">?<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"_3_Format_Painter_Multiple_Cells\"><\/span><span style=\"color: #ff0000\"><strong>\u00a03. Format Painter Multiple Cells<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The Format Painter copies formatting from one place and applies it to another but this can also be extended to multiple cells.<\/p>\n<p>To activate this hidden gem you need to <strong>double click<\/strong> on the Format Painter and then go crazy with the paint brush!<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/p77b5bMAAPs?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">?<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"4_Fill_Down_Formulas\"><\/span><span style=\"color: #ff0000\"><strong>4. Fill Down Formulas<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you have a <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a> that you want to copy down your table quickly, you can do it the slow way by dragging down the bottom right hand corner of the cell, or the quick way, which is to double click the bottom right hand corner of the cell.<\/p>\n<p>As long as there is data to the left hand side of the formula you want to copy downwards, this trick will work.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/jA1ta-fEMio?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">?<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"5_Unhide_Rows_Columns\"><\/span><span style=\"color: #ff0000\"><strong>5. Unhide Rows &amp; Columns<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>A quick way to &#8220;unhide&#8221; multiple Rows or Columns within an Excel sheet is to select all the cells and then double click between any Rows or Columns and BAM!<\/p>\n<p>You have all the Rows and Columns visible once again.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/bg8l9746-nc?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">?<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-21.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 10 Excel Productivity Tips\" class=\"alignnone wp-image-6145 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/revised_728x90.jpg\" alt=\"Top 10 Excel Productivity Tips\" width=\"728\" height=\"90\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/revised_728x90.jpg 728w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/revised_728x90-300x37.jpg 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"KEYBOARD_SHORTCUTS\"><\/span><span style=\"color: #0000ff\">KEYBOARD SHORTCUTS<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em>(Note that the + sign should be interpreted as &#8220;and&#8221;, so you need to hold the CTRL button and then hit the next command)<\/em><\/p>\n<h2><span class=\"ez-toc-section\" id=\"1_CTRL_F1\"><\/span><span style=\"color: #ff0000\"><strong>1. CTRL + F1<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong> <em>Hide\/Unhide the Ribbon<\/em><\/strong><\/p>\n<p>If you want to have more space in your workbook you can hide the Ribbon menu by pressing CTRL + F1.<\/p>\n<p>Another way is to click on the ^ icon which is located on the far right hand side of the Ribbon menu.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/ECF52lTbGv0?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">?<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_CTRL_SHIFT_ARROWS\"><\/span><span style=\"color: #ff0000\"><strong>2. CTRL + SHIFT + ARROWS<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong> <em>Move\/Highlight Cells<\/em><\/strong><\/p>\n<p>If you want to quickly move to the last cell of your table\/data you can press CTRL + <b>?<\/b>?<\/p>\n<p>If you want to quickly highlight up to the last cell of your table\/data you can press CTRL + SHIFT + <b>??<\/b><br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/tuoxgUlks6o?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">?<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"_3_CTRL\"><\/span><span style=\"color: #ff0000\"><strong>\u00a03. CTRL + -+ <\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong><em>Insert or Delete Rows and Columns in Excel<\/em><\/strong><\/p>\n<p>One of my favourite Excel keyboard <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\" title=\"shortcut\" data-wpil-keyword-link=\"linked\">shortcut<\/a> and one that I use hundreds of times per week is the insert or delete rows and columns.<\/p>\n<p>All you have to do is select the whole row or column with your mouse and then press the following:<\/p>\n<p><strong>CTRL<\/strong> + <strong>&#8211;<\/strong> to <em>delete<\/em> or <strong>CTRL<\/strong> + <strong>+<\/strong> to <em>insert<\/em><br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/7Gf7DMc1zps?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">?<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"4_CTRL_DR\"><\/span><span style=\"color: #ff0000\"><strong>4. CTRL + D\/R<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong> <em>Copy Down\/Right<\/em><\/strong><\/p>\n<p>A quick way to copy whatever is directly above or to the left of you is to press CTRL + D to copy DOWN or CTRL + R to copy RIGHT.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/3QhLFd7WIDw?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">?<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"5_CTRL_ENTER\"><\/span><span style=\"color: #ff0000\"><strong>5. CTRL + ENTER<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong> Fill Down<\/strong><\/em><\/p>\n<p>If you want to make a change to a cell and reflect that change to a selection of cells, then pressing CTRL + ENTER will fill down or copy your action to the selected cells.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/opnVVR8STB4?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">?<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>I hope you enjoyed these Excel tips and the best way to memorize\u00a0 them is to apply them to your work on a daily basis.<\/p>\n<p>If you enjoyed the above tips and want to get more Excel tutorials delivered straight to your inbox, then you can click on the following link now:<\/p>\n<p>&nbsp;<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"button small\" href=\"https:\/\/myexcelonline.leadpages.co\/leadbox\/146331173f72a2%3A17c5e0714b46dc\/5688160465977344\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\" data-leadbox=\"&quot;https:\/\/myexcelonline.leadpages.co\/leadbox\/146331173f72a2%3A17c5e0714b46dc\/5688160465977344\/\"> CLICK HERE TO SUBSCRIBE TO OUR FREE WEEKLY EXCEL LESSONS <i class=\"fa fa-download\"><\/i><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p>You can also check out our free <span style=\"color: #0000ff\"><a style=\"color: #0000ff\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Table webinar<\/a><\/span> which goes through the main tools that you need to know in order to become Pivot Table confident and create awesome analytical reports.\u00a0 Click on the banner below to register for free today:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"Adding Data Labels To An Excel Chart\" class=\"alignnone wp-image-1017 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/11\/728x90.jpg\" alt=\"Adding Data Labels To An Excel Chart\" width=\"728\" height=\"90\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/11\/728x90.jpg 728w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/11\/728x90-300x37.jpg 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/p>\n<p>Feel free to contact me if you have any queries or need any Excel help at john@myexcelonline.com<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel is used by more than 750 million people around the world and only 5% really know how to use its full suite of tools. In this post I will show you the top 10 Excel productivity tips that you need to know in order to complete your tasks much quicker within Excel, so you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1380,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Top 10 Excel Productivity Tips","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[7,10],"tags":[61,62],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1358"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=1358"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1358\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/1380"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1358"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}