{"id":817,"date":"2018-07-25T16:21:43","date_gmt":"2018-07-25T06:21:43","guid":{"rendered":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?p=817"},"modified":"2026-02-18T15:25:55","modified_gmt":"2026-02-18T04:25:55","slug":"11-excel-2016-easy-tips-and-tricks-that-you-should-know","status":"publish","type":"post","link":"https:\/\/www.dynamicwebtraining.com.au\/blog\/11-excel-2016-easy-tips-and-tricks-that-you-should-know","title":{"rendered":"11 Excel Easy Tips and Tricks That You Should Know!"},"content":{"rendered":"\n<p>Microsoft Excel, Microsoft Word, and Microsoft Outlook are the heavyweights in the suite of Microsoft Office. It is no secret that Microsoft Office and especially Excel is a boon to all entrepreneurs and data entry professionals whose sole job is to keep the data and information stored in an organized manner online. It is a standard spreadsheet tool that is needed in most industries these days.<\/p>\n\n\n\n<!--more-->\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"628\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/11-Excel-2016-Tips-and-Tricks.jpg\" alt=\"11 Excel 2016 Tips - And Tricks - Dynamic Web Training\" class=\"wp-image-819\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/11-Excel-2016-Tips-and-Tricks.jpg 1200w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/11-Excel-2016-Tips-and-Tricks-300x157.jpg 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/11-Excel-2016-Tips-and-Tricks-1024x536.jpg 1024w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div>\n\n\n\n<p>Excel 2016 is a giant of tools that enable a user to analyze, organize, manipulate and format a set of data into a spreadsheet. It is the lifeblood of all corporate houses, financial outfits, and research firms but its needs are not just limited to those users. People have started using Excel in their daily lives too whether it is for managing a household budget, putting in your students\u2019 attendance or maintaining an inventory.<\/p>\n\n\n\n<p>Excel 2016 is full of tips and tricks that will surprise you and assist you in making your life easier. Let\u2019s check out the top 11 Excel 2016 tips and tricks that you should know!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Microsoft Excel: Tips &amp; Tricks<\/h2>\n\n\n\n<h4 class=\"wp-block-heading p1\">1. Add or Remove Cells, Rows or Columns<\/h4>\n\n\n\n<p>Inserting or deleting cells, rows or columns in an Excel is easy with the commands \u201cInsert Cells\u201d and \u201cDelete Cells.\u201d You have to go to the Insert button and select the option you desire.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"637\" height=\"378\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_remove_cells_2.png\" alt=\"Excel 2016 Tips - Add Remove Cells 1 - Dynamic Web Training\" class=\"wp-image-822\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_remove_cells_2.png 637w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_remove_cells_2-300x178.png 300w\" sizes=\"auto, (max-width: 637px) 100vw, 637px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div>\n\n\n\n<p>Similarly, you can use the Delete option and choose the appropriate icon to delete a cell, row or column.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"636\" height=\"362\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_remove_cells_1.png\" alt=\"Excel 2016 Tips - Add Remove Cells 2 - Dynamic Web Training\" class=\"wp-image-821\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_remove_cells_1.png 636w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_remove_cells_1-300x171.png 300w\" sizes=\"auto, (max-width: 636px) 100vw, 636px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p>To make things easier, you can also right click on any row or column to add\/delete a cell.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"655\" height=\"396\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_remove_cells_3.png\" alt=\"Excel 2016 Tips - Add Remove Cells 3 - Dynamic Web Training\" class=\"wp-image-823\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_remove_cells_3.png 655w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_remove_cells_3-300x181.png 300w\" sizes=\"auto, (max-width: 655px) 100vw, 655px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading p1\">2. Resize Rows and Columns<\/h4>\n\n\n\n<p>The size of Excel\u2019s rows and columns is pretty standard, so there\u2019s a fair chance that you will have to adjust their size to accommodate all the data that you need to put in there.<\/p>\n\n\n\n<p>It is relatively simple to change the width or height of a cell by going to the Home icon, clicking on Format and choosing Column Width as the option.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"355\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_resize_cells_1.png\" alt=\"Excel 2016 Tips - Add Resize Cells 1 - Dynamic Web Training\" class=\"wp-image-824\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_resize_cells_1.png 628w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_resize_cells_1-300x170.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p>Then, you need to enter the number you\u2019d like the cell to be and click ok.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"634\" height=\"365\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_resize_cells_2.png\" alt=\"Excel 2016 Tips - Add Resize Cells 2 - Dynamic Web Training\" class=\"wp-image-825\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_resize_cells_2.png 634w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_resize_cells_2-300x173.png 300w\" sizes=\"auto, (max-width: 634px) 100vw, 634px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p>It is also straightforward to manually adjust the rows and columns by placing the pointer anywhere between a row and a column and dragging and expanding the row\/column till you reach your desired size.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1366\" height=\"768\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_resize_cells_3.png\" alt=\"Excel 2016 Tips - Add Resize Cells 3 - Dynamic Web Training\" class=\"wp-image-826\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_resize_cells_3.png 1366w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_resize_cells_3-300x169.png 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_add_resize_cells_3-1024x576.png 1024w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading p1\">3. Freeze Panes<\/h4>\n\n\n\n<p>The Freeze Panes function comes in quite handy when you want to scroll through a part of the spreadsheet without losing your focus on a particular part of the sheet.<\/p>\n\n\n\n<p>To Freeze Panes, select the column or the row where the data commences, select the View option and click on the menu that says Freeze Panes to do the job!<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"355\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_freeze_panes.png\" alt=\"Excel 2016 Tips - Freeze Panes - Dynamic Web Training\" class=\"wp-image-827\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_freeze_panes.png 628w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_freeze_panes-300x170.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading p1\">4. Change the Alignment of Text in the Cells<\/h4>\n\n\n\n<p>It is easy to use the Format Cells dialogue in the Excel if you wish to create labels or a register so that you can adjust the text alignment in a cell. To apply the formatting, right click on the selected row\/column and hit Format Cells.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1366\" height=\"768\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_change_alignement_1.png\" alt=\"Excel 2016 Tips - Change Alignement 1 - Dynamic Web Training\" class=\"wp-image-828\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_change_alignement_1.png 1366w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_change_alignement_1-300x169.png 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_change_alignement_1-1024x576.png 1024w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p>Then choose the Alignment tab, change the text orientation according to your choice and hit ok.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1366\" height=\"768\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_change_alignement_2.png\" alt=\"Excel 2016 Tips - Change Alignement 1 - Dynamic Web Training\" class=\"wp-image-829\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_change_alignement_2.png 1366w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_change_alignement_2-300x169.png 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_change_alignement_2-1024x576.png 1024w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading p1\">5. Cell Prevention to Prevent Someone from Editing a Particular Part of the Sheet<\/h4>\n\n\n\n<p>The Cell Prevention feature can prove to be quite beneficial if you wish to prevent someone from editing a specific part of the Excel. It dramatically limits accidental editing and saves you from a lot of extra work.<\/p>\n\n\n\n<p>Protecting a group of cells is easy. Just turn on the feature of Protect Sheet by going on the Format menu.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"636\" height=\"367\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_prevent_editing_1.png\" alt=\"Excel 2016 Tips - Prevent Editing 1 - Dynamic Web Training\" class=\"wp-image-830\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_prevent_editing_1.png 636w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_prevent_editing_1-300x173.png 300w\" sizes=\"auto, (max-width: 636px) 100vw, 636px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p>Choose all the desired options including the password to protect the sheet and click ok.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1366\" height=\"768\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_prevent_editing_2.png\" alt=\"Excel 2016 Tips - Prevent Editing 2 - Dynamic Web Training\" class=\"wp-image-831\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_prevent_editing_2.png 1366w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_prevent_editing_2-300x169.png 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_prevent_editing_2-1024x576.png 1024w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p>You can also lock a cell if you wish to prevent someone from editing a bunch of rows or columns. To do this, select the row and columns that you want to keep pristine and hit Format \u2192 Lock Cell. And, that is it.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"355\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_prevent_editing_3.png\" alt=\"Excel 2016 Tips - Prevent Editing 3 - Dynamic Web Training\" class=\"wp-image-832\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_prevent_editing_3.png 628w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_prevent_editing_3-300x170.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading p1\">6. Apply Special Formatting in Cells to Currencies and Numbers<\/h4>\n\n\n\n<p>If you wish to insert a decimal or a particular currency in any of the cells, rows or columns, you can do that in a jiffy.<\/p>\n\n\n\n<p>Go to Format Cells by right-clicking on the selected column\/row and click on Numbers to make the desired changes to the numbers or the currency of a cell.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1366\" height=\"768\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_number_formatting.png\" alt=\"Excel 2016 Tips - Number Formatting - Dynamic Web Training\" class=\"wp-image-833\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_number_formatting.png 1366w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_number_formatting-300x169.png 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_number_formatting-1024x576.png 1024w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading p1\">7. Sum, Average, Count, Max, Min \u2013 5 Functions You Cannot Do Without in Excel<\/h4>\n\n\n\n<p>The one real power of Excel undoubtedly lies in its formulas and functions. If you do not know how to apply formulas in Excel, you know maybe 40% of the functions of Excel. Hence, it is pertinent to identify the five essential functions of Excel, i.e., Sum, Count, Average, Max, and Min. Let\u2019s check out what these functions do and how to apply them!<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Sum<\/strong> \u2013 Calculates the total sum of the selected cells<\/li>\n\n\n\n<li><strong>Count<\/strong> \u2013 Counts the number of values in the selected cells leaving empty cells or those that have no numeric data<\/li>\n\n\n\n<li><strong>Average<\/strong> \u2013 Calculates the average of the selected cells<\/li>\n\n\n\n<li><strong>Min<\/strong> \u2013 Demonstrates the minimum value of the selected cells<\/li>\n\n\n\n<li><strong>Max<\/strong> \u2013 Demonstrates the maximum value of the selected cells<\/li>\n<\/ul>\n\n\n\n<p>To use a function, go to Home, click on AutoSum, go to the drop-down menu and use the appropriate function you wish to apply to a group of cells. Before doing that, do not forget to select the group of cells you want to implement the function to.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"355\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_functions.png\" alt=\"Excel 2016 Tips - Functions - Dynamic Web Training\" class=\"wp-image-834\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_functions.png 628w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_functions-300x170.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading p1\">8. Manipulate and Create Charts<\/h4>\n\n\n\n<p>Creating and manipulating charts is probably the hallmark feature of Excel. It enables the users to present their data in a visually well-formed manner. Excel helps significantly in easing the process.<\/p>\n\n\n\n<p>To do this, highlight the part of the spreadsheet you wish to manipulate, click on the Insert tab and then choose the All Charts option from the Recommended Charts icon.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1366\" height=\"768\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_create_chart_1.png\" alt=\"Excel 2016 Tips - Create Chart 1 - Dynamic Web Training\" class=\"wp-image-835\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_create_chart_1.png 1366w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_create_chart_1-300x169.png 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_create_chart_1-1024x576.png 1024w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p>You can even see a preview by hovering over a sample to check out the final result of the chart. Once you are satisfied, click ok to insert the chosen chart into the spreadsheet.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1366\" height=\"768\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_create_chart_2.png\" alt=\"Excel 2016 Tips - Create Chart 2 - Dynamic Web Training\" class=\"wp-image-836\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_create_chart_2.png 1366w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_create_chart_2-300x169.png 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_create_chart_2-1024x576.png 1024w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading p1\">9. Reveal Formulas<\/h4>\n\n\n\n<p>Revealing all your formulas is probably the best way to validate all the calculations in your workbook. For example: A data shown below:<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"970\" height=\"187\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_reveal_formula_1.png\" alt=\"Excel 2016 Tips - Reveal Formula 1 - Dynamic Web Training\" class=\"wp-image-837\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_reveal_formula_1.png 970w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_reveal_formula_1-300x58.png 300w\" sizes=\"auto, (max-width: 970px) 100vw, 970px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n<\/div><\/div>\n\n\n\n<p>To get to the equations, click on the Formulas tab and then click on Show Formulas, You will find it in the group of Formula Auditing.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"355\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_reveal_formula_2.png\" alt=\"Excel 2016 Tips - Reveal Formula 2 - Dynamic Web Training\" class=\"wp-image-838\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_reveal_formula_2.png 628w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_reveal_formula_2-300x170.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"809\" height=\"188\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_reveal_formula_3.png\" alt=\"Excel 2016 Tips - Reveal Formula 3 - Dynamic Web Training\" class=\"wp-image-839\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_reveal_formula_3.png 809w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_reveal_formula_3-300x70.png 300w\" sizes=\"auto, (max-width: 809px) 100vw, 809px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p>Now, it is super easy to verify all your formulas and even print them if you wish. This way, you can easily find all the errors in your formulas to understand how the numbers are what they are.<\/p>\n\n\n\n<h4 class=\"wp-block-heading p1\">10. Maximize the Printing Options When You Are Printing Large Workbooks<\/h4>\n\n\n\n<p>Large and widescreen monitors are ideal for working on spreadsheets. However, sometimes, you naturally need to take a print out of your workbook. You need to be especially careful in this case, or you can end up wasting a considerable amount of paper by printing something that will mostly be unreadable and illegible.<\/p>\n\n\n\n<p>It is where; Excel comes into the picture by allowing the users to adjust the orientation and size of the page by utilizing the Backstage printing options. It is recommended to print spreadsheets on legal sized papers and by using the landscape orientation so that every word on the spreadsheet\/print out is legible and you do not waste any extra or unnecessary paper.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1366\" height=\"768\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_printing_1.png\" alt=\"Excel 2016 Tips - Printing 1 - Dynamic Web Training\" class=\"wp-image-840\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_printing_1.png 1366w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_printing_1-300x169.png 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_printing_1-1024x576.png 1024w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p>You can also adjust the margins if you wish to fit in any additional details or information in a single sheet. To do that, you can click on the Show Margins tab that is present on the right-hand side of the tab that says backstage print.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1366\" height=\"768\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_printing_2.png\" alt=\"Excel 2016 Tips - Printing 2 - Dynamic Web Training\" class=\"wp-image-841\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_printing_2.png 1366w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_printing_2-300x169.png 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_printing_2-1024x576.png 1024w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p>Then, you can adjust the margins according to your preferences to accommodate any spillover data so that it fits all in a single page.<\/p>\n\n\n\n<p>If you are finding it challenging to provide everything on a single page, you can also go to Page Setup at the bottom of the page to make additional adjustments. You can reduce the text size or use the scaling menu to make further changes so that the text is neither too small nor illegible.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1366\" height=\"768\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_printing_3.png\" alt=\"Excel 2016 Tips - Printing 3 - Dynamic Web Training\" class=\"wp-image-842\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_printing_3.png 1366w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_printing_3-300x169.png 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_printing_3-1024x576.png 1024w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p>You can additionally also dress your printing page with headers and footers using the same dialogue if desired.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1366\" height=\"768\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_printing_4.png\" alt=\"Excel 2016 Tips - Printing 4 - Dynamic Web Training\" class=\"wp-image-843\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_printing_4.png 1366w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_printing_4-300x169.png 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_printing_4-1024x576.png 1024w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading p1\">11. Select All with One Click<\/h4>\n\n\n\n<p>We saved the best for the last! For the beginners who are relatively new to the world of Excel, this will be a lifesaver!<\/p>\n\n\n\n<p>Everyone probably knows that you can select all the text on a spreadsheet by hitting the Ctrl + A shortcut at the same time! But did you know that clicking the corner button, as shown in the screenshot, can select all the data you\u2019ve entered within seconds?<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"400\" height=\"461\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_select_all.jpg\" alt=\"Excel 2016 Tips - Select All - Dynamic Web Training\" class=\"wp-image-844\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_select_all.jpg 400w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/excel_tips_select_all-260x300.jpg 260w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption class=\"wp-element-caption\">Click image to enlarge&nbsp;<i class=\"fa fa-external-link\"><\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">&nbsp;<\/h4>\n\n\n\n<h4 class=\"wp-block-heading p1\">Bottom Line<\/h4>\n\n\n\n<p>Microsoft Excel is a treasure chest of numerous other tricks and tips that are bound to surprise seasoned users and substantially assist users with beginners Excel skills in knowing how to use this handy tool. Furthermore, you can also use the Excel app on your smart phones for easy access to all your spreadsheets in the Drive.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel, Microsoft Word, and Microsoft Outlook are the heavyweights in the suite of Microsoft Office. It is no secret that Microsoft Office and especially Excel is a boon to all entrepreneurs and data entry professionals whose sole job is to keep the data and information stored in an organized manner online. It is a&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-817","post","type-post","status-publish","format-standard","hentry","category-microsoft-excel"],"yoast_head":"<title>Top 11 Microsoft Excel Easy Tips and Tricks to assist you<\/title>\n<meta name=\"description\" content=\"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights\" \/>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/11-excel-2016-easy-tips-and-tricks-that-you-should-know\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Top 11 Microsoft Excel Easy Tips and Tricks to assist you\" \/>\n<meta property=\"og:description\" content=\"Excel 2016 is full of tips and tricks that will surprise you and assist you in making your life easier. Check out the top 11 Excel 2016 tips and tricks!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/11-excel-2016-easy-tips-and-tricks-that-you-should-know\" \/>\n<meta property=\"og:site_name\" content=\"Dynamic Web Training Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-25T06:21:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-18T04:25:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/11-Excel-2016-Tips-and-Tricks.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:creator\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:site\" content=\"@dynamicwebtrain\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\",\"name\":\"Dynamic Web Training\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/DynamicWebTraining\/\",\"https:\/\/www.linkedin.com\/company\/dynamic-web-training\",\"https:\/\/twitter.com\/dynamicwebtrain\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png\",\"width\":361,\"height\":109,\"caption\":\"Dynamic Web Training\"},\"image\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/\",\"name\":\"Dynamic Web Training Blog\",\"description\":\"The Ultimate Training Experience.\",\"publisher\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/11-excel-2016-easy-tips-and-tricks-that-you-should-know#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/07\/11-Excel-2016-Tips-and-Tricks.jpg\",\"width\":1200,\"height\":628},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/11-excel-2016-easy-tips-and-tricks-that-you-should-know#webpage\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/11-excel-2016-easy-tips-and-tricks-that-you-should-know\",\"name\":\"Top 11 Microsoft Excel Easy Tips and Tricks to assist you\",\"isPartOf\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/11-excel-2016-easy-tips-and-tricks-that-you-should-know#primaryimage\"},\"datePublished\":\"2018-07-25T06:21:43+00:00\",\"dateModified\":\"2026-02-18T04:25:55+00:00\",\"description\":\"Excel 2016 is full of tips and tricks that will surprise you and assist you in making your life easier. Check out the top 11 Excel 2016 tips and tricks!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/11-excel-2016-easy-tips-and-tricks-that-you-should-know#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dynamicwebtraining.com.au\/blog\/11-excel-2016-easy-tips-and-tricks-that-you-should-know\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/11-excel-2016-easy-tips-and-tricks-that-you-should-know#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\",\"name\":\"Training Blog\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\",\"name\":\"Training\"}},{\"@type\":\"ListItem\",\"position\":3,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel\",\"name\":\"Microsoft Excel\"}},{\"@type\":\"ListItem\",\"position\":4,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/11-excel-2016-easy-tips-and-tricks-that-you-should-know\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/11-excel-2016-easy-tips-and-tricks-that-you-should-know\",\"name\":\"11 Excel Easy Tips and Tricks That You Should Know!\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/11-excel-2016-easy-tips-and-tricks-that-you-should-know#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/11-excel-2016-easy-tips-and-tricks-that-you-should-know#webpage\"},\"author\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233\"},\"headline\":\"11 Excel Easy Tips and Tricks That You Should Know!\",\"datePublished\":\"2018-07-25T06:21:43+00:00\",\"dateModified\":\"2026-02-18T04:25:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/11-excel-2016-easy-tips-and-tricks-that-you-should-know#webpage\"},\"publisher\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/11-excel-2016-easy-tips-and-tricks-that-you-should-know#primaryimage\"},\"articleSection\":\"Microsoft Excel\",\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233\",\"name\":\"Dynamic Web Training\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"caption\":\"Dynamic Web Training\"},\"description\":\"Dynamic Web Training is Australia's leading provider of instructor led software training. We offer training courses in Adobe, Web Design, Graphic Design, Photoshop, InDesign, Dreamweaver and many more.\",\"sameAs\":[\"https:\/\/www.facebook.com\/DynamicWebTraining\/\",\"https:\/\/www.linkedin.com\/company\/dynamic-web-training\",\"https:\/\/twitter.com\/dynamicwebtrain\"]}]}<\/script>","_links":{"self":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/817","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/comments?post=817"}],"version-history":[{"count":19,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/817\/revisions"}],"predecessor-version":[{"id":2383,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/817\/revisions\/2383"}],"wp:attachment":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=817"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}