{"id":981,"date":"2017-05-27T09:20:00","date_gmt":"2017-05-27T09:20:00","guid":{"rendered":"http:\/\/www.repairmsexcel.com\/blog\/?p=981"},"modified":"2024-01-03T07:21:27","modified_gmt":"2024-01-03T07:21:27","slug":"30-tips-to-master-ms-excel","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel","title":{"rendered":"30 Tips &#038; Tricks to Master Microsoft Excel"},"content":{"rendered":"<div class=\"1898181a2aebca931198b7f41678d855\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\"><strong>Microsoft Excel<\/strong> is very popular and best application for managing, organizing and arranging crucial data.<\/p>\n<p style=\"text-align: justify;\">This application is used in countless ways and this is the reason numbers of features are packed inside this Microsoft\u2019s popular application.<\/p>\n<p style=\"text-align: justify;\"><!--more--><\/p>\n<p style=\"text-align: justify;\">This doesn\u2019t matter whether you are a casual user or an Excel expert, it is important to know everything in it so that you can easily use this complex application.<\/p>\n<p style=\"text-align: justify;\">Here in this article, we are describing \u2013 easy tips n tricks that will make you <strong>master Microsoft Excel:<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h4 style=\"text-align: center;\"><span style=\"color: #000000;\">Included Excel Tips and Tricks:<\/span><\/h4>\n<div class=\"su-table su-table-alternate\">\n<table style=\"height: 112px\" width=\"835\">\n<tbody>\n<tr style=\"text-align: justify\">\n<td><strong><a href=\"#t1\">Click once to Select All<\/a><\/strong><\/td>\n<td><strong><a href=\"#t2\">Open Multiple Excel Files at Once<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify\">\n<td><strong><a href=\"#t3\">Create a New Shortcut Menu<\/a><\/strong><\/td>\n<td><strong><a href=\"#t4\">Add More Than One New Row or Column<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify\">\n<td><strong><a href=\"#t5\">Apply Diagonal Borders<\/a><\/strong><\/td>\n<td><strong><a href=\"#t6\">Turn Columns into Rows<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify\">\n<td><strong><a href=\"#t7\">Hide Individual Cells<\/a><\/strong><\/td>\n<td><strong><a href=\"#t8\">Freeze Row and Column Headings<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify\">\n<td><strong><a href=\"#t9\">Quickly Move and Copy Data in Cells<\/a><\/strong><\/td>\n<td><strong><a href=\"#t10\">Delete Blank Cells Fast<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify\">\n<td><strong><a href=\"#t11\">Use Flash Fill to Save Time<\/a><\/strong><\/td>\n<td><strong><a href=\"#t12\">Add Comments to your Formulas<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify\">\n<td><strong><a href=\"#t13\">Quickly Add Up Figures<\/a><\/strong><\/td>\n<td><strong><a href=\"#t14\">Rotate Heading Text<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify\">\n<td><strong><a href=\"#t15\">Add Decimal Points Automatically<\/a><\/strong><\/td>\n<td><strong><a href=\"#t16\">Add Your Own Graphics to Charts<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify\">\n<td><strong><a href=\"#t17\">Save Charts As Templates<\/a><\/strong><\/td>\n<td><strong><a href=\"#t18\">Add the Calculator (or else) to Quick Access<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify\">\n<td><strong><a href=\"#t19\">Apply Some Conditional Formatting<\/a><\/strong><\/td>\n<td><strong><a href=\"#t20\">You can Draw Equations<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify\">\n<td><strong><a href=\"#t21\">Fast Navigation with Ctrl + Arrow Button<\/a><\/strong><\/td>\n<td><strong><a href=\"#t22\">Input Values Starting with 0<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify\">\n<td><strong><a href=\"#t23\">Rename Sheet Using Double Click<\/a><\/strong><\/td>\n<td><strong><a href=\"#t24\">Compose Text with &amp;<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify\">\n<td><strong><a href=\"#t25\">Transform the Case of Text<\/a><\/strong><\/td>\n<td><strong><a href=\"#t26\">Speed up Entering Complicated Terms with AutoCorrect<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify\">\n<td><strong><a href=\"#t27\">Generate a Unique Value in a Column<\/a><\/strong><\/td>\n<td><strong><a href=\"#t28\">Input Restriction with Data Validation Function<\/a><\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: justify\"><strong><a href=\"#t29\">Bring Selection into View<\/a><\/strong><\/td>\n<td style=\"text-align: justify\"><strong><a href=\"#t30\">Learn Excel\u2019s Best Shortcut Keys<\/a><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h2 style=\"text-align: center;\"><span style=\"color: #000000;\">Tips and Tricks to Master Microsoft Excel\u00a0<\/span><\/h2>\n<p><a name=\"t1\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">1. Click once to Select All<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-983\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/1-1.jpg\" alt=\"\" width=\"356\" height=\"431\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/1-1.jpg 356w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/1-1-248x300.jpg 248w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/1-1-300x363.jpg 300w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><\/p>\n<p style=\"text-align: justify;\">Many of us know that we can select the entire excel sheet by using the <strong>Ctrl + A<\/strong> shortcut but I guess few of us know that simply clicking once on the corner button will select the entire data in less than a second.<\/p>\n<p><a name=\"t2\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">2. Open Multiple Excel Files\u00a0at Once<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">While working on <strong>multiple excel files<\/strong>, you need to open files one by one, this is quite difficult to handle but here we will describe a handy way to open them all with one click.<\/p>\n<p style=\"text-align: justify;\">All you need to do is to select the files you like to open and press\u00a0<strong>Enter<\/strong> key, all selected files will open altogether.<\/p>\n<p><a name=\"t3\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">3. Create a New Shortcut Menu<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Using shortcuts makes the work easy. In Excel we are having three shortcuts in the top menu \u2013 <strong>Save, Undo Typing and Repeat Typing.<\/strong><\/p>\n<p style=\"text-align: justify;\">But if you want to utilize more shortcuts like <strong>Copy and Cut,<\/strong> you can set them up:<\/p>\n<p style=\"text-align: justify;\"><strong>Here know how:<\/strong><\/p>\n<p style=\"text-align: justify;\">Go to <strong>File &gt; Options &gt; Quick Access Toolbar &gt; <\/strong>Add<strong> Cut and Copy<\/strong> from the left column to the right and save it.<\/p>\n<p style=\"text-align: justify;\">Now you can see two more shortcuts added to the top menu and make the work easy for you.<\/p>\n<p style=\"text-align: justify;\">This is really very helpful to organize the <strong>Excel crucial data easily<\/strong> and become an Excel expert.<\/p>\n<p style=\"text-align: justify;\"><em><strong>Know More MS Excel\u00a0<\/strong><\/em><strong>TRICKS<\/strong><em><strong>.<\/strong><\/em><\/p>\n<p><a name=\"t4\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">4. Add More Than One New Row or Column<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Well, I think most of the Excel user must know that by selecting a row or column we can add a new one via <strong>Insert<\/strong> <strong>drop-down under Home.<\/strong><\/p>\n<p style=\"text-align: justify;\">However, here is an easy way to do so.<\/p>\n<p style=\"text-align: justify;\"><strong>Drag and select rows or columns &gt;\u00a0right click the highlighted rows or columns &gt;\u00a0select Insert from the drop down menu.<\/strong><\/p>\n<p style=\"text-align: justify;\">Now new rows will be inserted above the row or to the left of the column you first selected.<\/p>\n<p style=\"text-align: justify;\"><em><strong>NEXT&#8230;<\/strong><\/em><\/p>\n<p><a name=\"t5\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">5. Apply Diagonal Borders<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">If you got a table that requires both row and columns headers in the same cell then make use of the diagonal borders.<\/p>\n<p style=\"text-align: justify;\">Click <strong>More Borders<\/strong> at the bottom of the borders drop-down menu (<strong>on the Home tab of the ribbon<\/strong>) and diagonal buttons are by the box corners.<\/p>\n<p style=\"text-align: justify;\">Click it and <strong>save. <\/strong><\/p>\n<p style=\"text-align: justify;\">This makes the work easily understandable and presentable in your excel sheet.<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\"><strong>Additional Reading:\u00a0<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\"><strong><a class=\"row-title\" href=\"https:\/\/www.repairmsexcel.com\/blog\/improve-excel-spreadsheet-performance\/?utm_source=optimize-excel&amp;utm_medium=ref&amp;utm_campaign=blog\">11 Vital Tips for Optimizing Excel Spreadsheets and Speed-up your Excel<\/a><\/strong><\/li>\n<\/ul>\n<p><a name=\"t6\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">6. <strong>Turn Columns into Rows<\/strong><\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-982\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/tbxgixevlj7fps4ndney.jpg\" alt=\"\" width=\"725\" height=\"408\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/tbxgixevlj7fps4ndney.jpg 800w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/tbxgixevlj7fps4ndney-300x169.jpg 300w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/tbxgixevlj7fps4ndney-768x432.jpg 768w\" sizes=\"auto, (max-width: 725px) 100vw, 725px\" \/><\/p>\n<p style=\"text-align: justify;\">If you have data in columns that should be in rows or the other way then here we have tips to do so without losing anything.<\/p>\n<p style=\"text-align: justify;\">Just, copy the original block of the cell &gt;\u00a0right click on the <strong>destination cell<\/strong>\u00a0&gt; click <strong>Paste Special &gt; Transpose.<\/strong><\/p>\n<p><a name=\"t7\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">7. Hide Individual Cells<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Excel has a master trick of hiding cells. This is one of the best Excel tips and tricks<\/p>\n<p style=\"text-align: justify;\">All you need to do is to select the cell that you want to hide and right click &gt;select <strong>Format Cells<\/strong> and then set the format as <strong>Custom<\/strong> under the <strong>Number<\/strong> tab and Enter<strong><code>;;;<\/code> (three semicolons) <\/strong>as the format.<\/p>\n<p style=\"text-align: justify;\">Now the cell content disappears but they are still present there and can be used in formulas.<\/p>\n<p style=\"text-align: justify;\">This is really amazing Excel tips and tricks<\/p>\n<p><a name=\"t8\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">8) Freeze Row and Column Headings<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">This is the simple but useful trick to becoming an Excel expert.<\/p>\n<p style=\"text-align: justify;\">Freeze the row and column headings so they are always viewable when you scroll around.<\/p>\n<p style=\"text-align: justify;\"><em>To do so, LOOK<\/em><\/p>\n<p style=\"text-align: justify;\">Place the cursor in the top-left cell where the actual data starts and go to <strong>VIEW<\/strong> menu and simply select <strong>Freeze Panes and Freeze Panes.<\/strong><\/p>\n<p style=\"text-align: justify;\">Now the heading is viewable where ever you scroll.<\/p>\n<p><a name=\"t9\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">9. Quickly Move and Copy Data in Cells<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">If you want to move one column of data in a spreadsheet then the easy and fast way is to select it and move the pointer to the border after it turns to a crossed arrow icon then drag to move the column freely.<\/p>\n<p style=\"text-align: justify;\">But if you want to copy the data, .then press the <strong>Ctrl<\/strong> button before dragging to move the new column will copy all the selected data.<\/p>\n<p><a name=\"t10\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">10. Delete Blank Cells Fast<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Some of the default data will be blank for various reasons.<\/p>\n<p style=\"text-align: justify;\">So if you need to delete these to maintain accuracy, particularly while calculating the average value.<\/p>\n<p style=\"text-align: justify;\">The easy way is to filter out entire blank cells and delete them with one click.<\/p>\n<p style=\"text-align: justify;\">Choose the column you want to filter and go to <strong>Data &gt; Filter<\/strong> after the downward button shows, undo <strong>Select All<\/strong> and then pick the last <strong>Blanks <\/strong>option.<\/p>\n<p style=\"text-align: justify;\">The entire blank cell will show immediately.<\/p>\n<p style=\"text-align: justify;\">Now go to <strong>Home<\/strong> and click <strong>Delete<\/strong> directly, all will be removed clicking once.<\/p>\n<p><a name=\"t11\"><\/a><\/p>\n<h3><span style=\"color: #339966;\">11. Use Flash Fill to Save Time<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-984 \" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/jmqty2dznmhvpohbchqk.jpg\" alt=\"flash fill\" width=\"598\" height=\"336\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/jmqty2dznmhvpohbchqk.jpg 800w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/jmqty2dznmhvpohbchqk-300x169.jpg 300w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/jmqty2dznmhvpohbchqk-768x432.jpg 768w\" sizes=\"auto, (max-width: 598px) 100vw, 598px\" \/><\/p>\n<p style=\"text-align: justify;\">Flash fill makes the work easy, so if you are reformatting data in adjacent columns, then this is very helpful.<\/p>\n<p style=\"text-align: justify;\">It recognizes the patterns and fills the rest of the details for you.<\/p>\n<p style=\"text-align: justify;\">Just give excel a few examples at the top and you will see the suggestions in <strong>gray<\/strong>, hit <strong>Enter<\/strong> to accept.<\/p>\n<p><a name=\"t12\"><\/a><\/p>\n<h3><span style=\"color: #339966;\">12. Add Comments to Your Formulas\u00a0<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Add <strong>space and +N (\u201cyour comment here\u201d)<\/strong> to leave comments by your formulas for your own reference or to help other people understand your spreadsheet.<\/p>\n<p style=\"text-align: justify;\">Comments don\u2019t appear in the cell but show up in the Formula bar and they are searchable as well.<\/p>\n<p><a name=\"t13\"><\/a><\/p>\n<h3><span style=\"color: #339966;\">13. Quickly Add Up Figures<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">It is likely that you are doing a lot of addition to Excel, but here you don\u2019t need to type out SUM formulas.<\/p>\n<p style=\"text-align: justify;\">Just highlight the cell at the end of the row or the bottom of the column\u00a0 you want to add and then hit <strong>Alt+=<\/strong> ( equals) or <strong>Cmd+Shift+T<\/strong> on a Mac<\/p>\n<p><a name=\"t14\"><\/a><\/p>\n<h3><span style=\"color: #339966;\">14. Rotate Heading Text<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">If you need to add headers to very narrow columns, then rotate the text to fit.<\/p>\n<p style=\"text-align: justify;\">Go to <strong>Home<\/strong> tab and click the <strong>Orientation<\/strong> button and make your choice.<\/p>\n<p style=\"text-align: justify;\">The button is placed alongside the other text formatting options. This is another effective Microsoft Excel tips and tricks.<\/p>\n<p><a name=\"t15\"><\/a><\/p>\n<h3><span style=\"color: #339966;\">15. Add Decimal Points Automatically<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Here we will tell you the trick to add decimal automatically. There is no need to waste time manually inserting the decimal points.<\/p>\n<p style=\"text-align: justify;\">Click <strong>File &gt; Options &gt; Advanced<\/strong> and the option is near the top.<\/p>\n<p style=\"text-align: justify;\">Here you will find various useful settings on this page, covering program behavior, number formats and much more.<\/p>\n<p style=\"text-align: justify;\">Find more interesting <strong>Excel tips and tricks.<\/strong><\/p>\n<p style=\"text-align: justify;\"><em>Look&#8230;<\/em><\/p>\n<p><a name=\"t16\"><\/a><\/p>\n<h3><span style=\"color: #339966;\">16. Add Your Own Graphics to Charts<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">While making charts graphics you don\u2019t need to settle for the colored blocks that by default Excel offers.<\/p>\n<p style=\"text-align: justify;\">All you need to double-click on a <strong>bar\u00a0<\/strong>and then click paint bucket to change the fill options.<\/p>\n<p style=\"text-align: justify;\">You can also <strong>switch to gradients, a pattern, or load in an image file from disk.<\/strong><\/p>\n<p><a name=\"t17\"><\/a><\/p>\n<h3><span style=\"color: #339966;\">17. Save Charts As Templates<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">This is another handy chart related trick to make yourself the master of Excel.<\/p>\n<p style=\"text-align: justify;\">When you found a combination of <strong>layout and colors<\/strong> that are really important, save it as a <strong>template<\/strong>, so that you can utilize it again.<\/p>\n<p style=\"text-align: justify;\">Right-click on any chart created and you will see the <strong>Save as Template<\/strong> option.<\/p>\n<p><a name=\"t18\"><\/a><\/p>\n<h3><span style=\"color: #339966;\">18. Add the Calculator (or else) to Quick Access<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-989\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/ghopnu6ovjtrb8l22f1t.jpg\" alt=\"calulator\" width=\"681\" height=\"383\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/ghopnu6ovjtrb8l22f1t.jpg 800w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/ghopnu6ovjtrb8l22f1t-300x169.jpg 300w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/ghopnu6ovjtrb8l22f1t-768x432.jpg 768w\" sizes=\"auto, (max-width: 681px) 100vw, 681px\" \/><\/p>\n<p style=\"text-align: justify;\">In your excel file, you can add shortcuts like calculator, Windows Camera or Ink apps or the zoom controls.<\/p>\n<p style=\"text-align: justify;\">This makes your work easy in Excel document.<\/p>\n<p style=\"text-align: justify;\">You can do this by opening the <strong>Quick Access Toolbar (to the right of the save and undo commands on the title bar) &gt; select More Commands &gt; and add the shortcut to the menu whatever you like.<\/strong><\/p>\n<p><a name=\"t19\"><\/a><\/p>\n<h3><span style=\"color: #339966;\">19. Apply Some Conditional Formatting<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">In Excel, you can add <strong>Conditional formatting<\/strong>\u00a0this can add some pop to the sheets and helps you pick out data easily.<\/p>\n<p style=\"text-align: justify;\">It is simple to use.<\/p>\n<p style=\"text-align: justify;\">Select the data that is needed to be <strong>formatted<\/strong> &gt; click <strong>Conditional Formatting (in Home)<\/strong> &gt; and <strong>build your rules<\/strong> accordingly from the drop-down options.<\/p>\n<p><a name=\"t20\"><\/a><\/p>\n<h3><span style=\"color: #339966;\">20. You can Draw Equations<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">This feature is available in <strong>Excel 2016<\/strong> (useful if you are having a touchscreen PC).<\/p>\n<p style=\"text-align: justify;\">To draw equations you need to go to the <strong>Insert<\/strong> tab on the ribbon menu and select <strong>Equation <\/strong>and<strong> Ink Equation.<\/strong><\/p>\n<p style=\"text-align: justify;\">And after that, you can sketch in the <strong>yellow box<\/strong>. <strong>\u00a0<\/strong><\/p>\n<p><a name=\"t21\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">21. Fast Navigation with Ctrl + Arrow Button<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Here is a trick to make fast navigation in Excel many of us know that when we click <strong>Ctrl+<\/strong> any arrow button on the keyboard, you can jump to the edge of the sheet in different directions.<\/p>\n<p style=\"text-align: justify;\">But if you want to jump to the bottom line of the data, just click <strong>Ctrl+ downward button<\/strong> and easily go to the last cell.<\/p>\n<p><a name=\"t22\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">22. Input Values Starting with 0<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-986\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/0.jpg\" alt=\"zero\" width=\"349\" height=\"214\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/0.jpg 349w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/0-300x184.jpg 300w\" sizes=\"auto, (max-width: 349px) 100vw, 349px\" \/><\/p>\n<p style=\"text-align: justify;\">This is very important for the regular Excel users.<\/p>\n<p style=\"text-align: justify;\">When any input value starts with zero, Excel by default deletes the <strong>ZERO<\/strong>.<\/p>\n<p style=\"text-align: justify;\">So rather than reset the <strong>Format Cells<\/strong>, this problem is easily solved by adding a single quote mark ahead of the first zero.<\/p>\n<p><a name=\"t23\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">23. Rename Sheet Using Double Click<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">There are numerous ways for renaming sheets and many users will right click for selecting <strong>Rename,\u00a0<\/strong>this is a process.<\/p>\n<p style=\"text-align: justify;\">The easiest and fast way to rename is to click twice and rename it directly without wasting time.<\/p>\n<p style=\"text-align: justify;\">This is not the end.<\/p>\n<p style=\"text-align: justify;\">Check out more interesting<em><strong> EXCEL TIPS.<\/strong><\/em><\/p>\n<p><a name=\"t24\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">24. Compose Text with &amp;<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\"><strong>The\u00a0&amp; symbol<\/strong> is very necessary to compose any text freely.<\/p>\n<p style=\"text-align: justify;\"><strong>For example<\/strong>: below you are having four columns with different texts, but if you want to compose them to one value in one cell.<\/p>\n<p style=\"text-align: justify;\">Then first locate the cell that is to display the composed result, utilize the formation with<strong> &amp;<\/strong> and hit <strong>Enter<\/strong>.<\/p>\n<p style=\"text-align: justify;\">The entire text in cell,<strong> A2, B2, C2 and D2<\/strong> will be composed together in the <strong>F2<\/strong> cell.<\/p>\n<p><a name=\"t25\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">25. Transform the Case of Text<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">In this article, I have tried by best to avoid complication formulation.<\/p>\n<p style=\"text-align: justify;\">But there are yet some simple and handy formulations like<strong> UPPER, LOWER and PROPER<\/strong> that can transform texts for different purposes.<\/p>\n<p style=\"text-align: justify;\"><strong> Upper<\/strong> will capitalize entire characters; <strong>LOWER<\/strong> changes the text to lower case and <strong>PROPER<\/strong> only capitalizes the first character of a word.<\/p>\n<p style=\"text-align: justify;\">Really amazing&#8230;<\/p>\n<p><a name=\"t26\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">26. Speed up Entering Complicated Terms with AutoCorrect<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-988\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/aut.jpg\" alt=\"autocorrect\" width=\"422\" height=\"409\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/aut.jpg 422w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/aut-300x291.jpg 300w\" sizes=\"auto, (max-width: 422px) 100vw, 422px\" \/><\/p>\n<p style=\"text-align: justify;\">While working in an Excel file if you need to repeat same value and it is quite complicated to enter it.<\/p>\n<p style=\"text-align: justify;\">Then here know how to do it easily by using the <strong>AutoCorrect function.<\/strong><\/p>\n<p style=\"text-align: justify;\">Doing this will replace the text with the correct text.<\/p>\n<p style=\"text-align: justify;\"><strong>For example<\/strong>: Take any name like <strong>Amy Jackson<\/strong>, and replace it<strong> AJ<\/strong>, and after that every time you enter <strong>AJ<\/strong>, it will autocorrect to <strong>Amy Jackson.<\/strong><\/p>\n<p style=\"text-align: justify;\">This is really an interesting and useful Excel trick.<\/p>\n<p style=\"text-align: justify;\"><strong>To do so: <\/strong><\/p>\n<p style=\"text-align: justify;\">Go to <strong>File &gt; Options &gt; Proofing &gt; AutoCorrect Options<\/strong> and enter <strong>Replace<\/strong> text with correct text in the red rectangular area,<\/p>\n<p><a name=\"t27\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">27. Generate a Unique Value in a Column<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Many of the Excel users are well aware of the key function of <strong>Filter\u00a0<\/strong>but few of them utilize the <strong>Advanced Filter.<\/strong><\/p>\n<p style=\"text-align: justify;\">This helps the users to repeatedly apply when you need to filter a unique value from data in a column.<\/p>\n<p style=\"text-align: justify;\"><strong>Follow the Process:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Click to select the column and go to <strong>Data &gt; Advanced &gt;<\/strong> a pop-up window appears<\/li>\n<li>Next click <strong>Copy to another location<\/strong>, which is in the second rectangular area<\/li>\n<li>And after that specify the target location by entering the value or clicking the area choosing button.<\/li>\n<li>Now the unique age is generated from<strong> column C<\/strong> and will appear in <strong>Column E<\/strong>.<\/li>\n<li>You also need to select <strong>Unique records <\/strong>in the pop-up<\/li>\n<li>Click <strong>OK<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Now, the unique value showing in column E could be a contrast of the original data in C.<\/p>\n<p style=\"text-align: justify;\">This is the reason why it is recommended to copy another location.<\/p>\n<p><a name=\"t28\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">28. Input Restriction with Data Validation Function<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">To retain the validity of data, in some cases it is required to restrict the input value.<\/p>\n<p style=\"text-align: justify;\">And offer some tips for further steps.<\/p>\n<p style=\"text-align: justify;\"><strong>For Example,<\/strong> Age in the excel sheet should be in whole numbers and the participant in the survey should be between 18 and 60 years old.<\/p>\n<p style=\"text-align: justify;\">So to make sure, data outside of this age range should not be entered.<\/p>\n<p style=\"text-align: justify;\">Go to <strong>Data &gt; Data Validation &gt; Setting,<\/strong> input the circumstances and modify to Input Message to give prompts. Like\u00a0<strong>(Please input age in the whole number and should in the range from 18 to 60).<\/strong><\/p>\n<p style=\"text-align: justify;\">Users will automatically get this prompt while hanging the pointer in this area as well as get a warning message if given information is unqualified.<\/p>\n<p><a name=\"t29\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">29: Bring Selection into View<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-987\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/83449824-e968-4fd5-b0d6-e8f324aa59ff.jpg\" alt=\"\" width=\"220\" height=\"144\" \/><\/p>\n<p style=\"text-align: justify;\">This Excel tips will help you to easily recognize the selection area.<\/p>\n<p style=\"text-align: justify;\">Suppose if have selected some areas of cells and scrolled away and now you are unable to see it<\/p>\n<p style=\"text-align: justify;\">&#8230; then, in this case, hit <strong>Ctrl + Backspace key<\/strong> this will brings that selection into view.<\/p>\n<p style=\"text-align: justify;\">And if you hit <strong>Shift + Backspace<\/strong> it will bring the selection into view but reduces the selection to the active cell.<\/p>\n<p><a name=\"t30\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #339966;\">30. Learn Excel\u2019s Best Shortcut Keys<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Well, this is the last tips and tricks of our article and this is very helpful for the Microsoft Excel users to fix the error.<\/p>\n<p style=\"text-align: justify;\">You should learn some <strong>shortcut keys<\/strong>\u00a0to increase your productivity in Excel.<\/p>\n<p style=\"text-align: justify;\">Here we have included some shortcut keys that are useful for regular work.<\/p>\n<ol>\n<li style=\"text-align: justify;\"><strong>Ctrl +[Down|Up Arrow Key]:<\/strong> This is used to move to the top or bottom cell of the current column and using <b>C<\/b><strong>trl <\/strong>with<strong> Left|Right Arrow<\/strong>\u00a0key, moves to the cell furthermost left or right in the current row<\/li>\n<li style=\"text-align: justify;\"><strong>Shift + Ctrl +\u00a0Down\/Up Arrow:<\/strong> It will select entire cells above or below the current cell<\/li>\n<li style=\"text-align: justify;\"><strong>Ctrl+ Home:<\/strong>\u00a0Go to cell A1<\/li>\n<li style=\"text-align: justify;\"><strong>Ctrl+End: <\/strong>To go to the last cell that contains data<\/li>\n<li style=\"text-align: justify;\"><strong>Alt+F1:<\/strong> It will create a chart based on the selected data set.<\/li>\n<li style=\"text-align: justify;\"><strong>Ctrl+Shift+L<\/strong>: This will activate an auto filter to the data table<\/li>\n<li style=\"text-align: justify;\"><strong>Alt+Down Arrow:<\/strong> For opening the drop-down menu of the auto filter. \u00a0To use this shortcut:<\/li>\n<li style=\"text-align: justify;\"><strong>Alt+D+S:\u00a0F<\/strong>or sorting the set data<\/li>\n<li style=\"text-align: justify;\"><strong>Ctrl+O:<\/strong> Open a new workbook<\/li>\n<li style=\"text-align: justify;\"><strong>Ctrl+N:<\/strong> Create a new workbook<\/li>\n<li style=\"text-align: justify;\"><strong>F4:<\/strong> To select the range and press F4 key, this will change the reference to absolute, mixed and relative.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">End Note:<\/span><\/h3>\n<p>Hope after reading this article, you get the ample information about the Excel features.<\/p>\n<p>You can make use of the tips and tricks to increase your productivity in Excel and get all your work done quickly.<\/p>\n<p>So start using the features included in this article and become an Excel expert now.<br \/>\n<a href=\"https:\/\/www.repairmsexcel.com\/blog\/master-excel\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1743 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/Excel_promo_img.jpg\" alt=\"Excel_promo_img\" width=\"650\" height=\"325\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/Excel_promo_img.jpg 650w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/Excel_promo_img-300x150.jpg 300w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/a><\/p>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel is very popular and best application for managing, organizing and arranging crucial data. This application is used in &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"30 Tips &#038; Tricks to Master Microsoft Excel\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel#more-981\" aria-label=\"Read more about 30 Tips &#038; Tricks to Master Microsoft Excel\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":990,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[322,321,320],"class_list":["post-981","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips","tag-excel-expert","tag-excel-tips-and-tricks","tag-master-microsoft-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>30 Tips &amp; Tricks to Master Microsoft Excel<\/title>\n<meta name=\"description\" content=\"Read the article, to know 30 handy tips n tricks to master Microsoft Excel. These are valuable for new and regular user to increase productivity in Excel...\" \/>\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.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"30 Tips &amp; Tricks to Master Microsoft Excel\" \/>\n<meta property=\"og:description\" content=\"Read the article, to know 30 handy tips n tricks to master Microsoft Excel. These are valuable for new and regular user to increase productivity in Excel...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-27T09:20:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-03T07:21:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/master-in-excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Priyanka Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/30-tips-to-master-ms-excel#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/30-tips-to-master-ms-excel\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"30 Tips &#038; Tricks to Master Microsoft Excel\",\"datePublished\":\"2017-05-27T09:20:00+00:00\",\"dateModified\":\"2024-01-03T07:21:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/30-tips-to-master-ms-excel\"},\"wordCount\":2680,\"publisher\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/30-tips-to-master-ms-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/master-in-excel.png\",\"keywords\":[\"excel expert\",\"excel tips and tricks\",\"master microsoft excel\"],\"articleSection\":[\"Tips\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/30-tips-to-master-ms-excel\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/30-tips-to-master-ms-excel\",\"name\":\"30 Tips & Tricks to Master Microsoft Excel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/30-tips-to-master-ms-excel#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/30-tips-to-master-ms-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/master-in-excel.png\",\"datePublished\":\"2017-05-27T09:20:00+00:00\",\"dateModified\":\"2024-01-03T07:21:27+00:00\",\"description\":\"Read the article, to know 30 handy tips n tricks to master Microsoft Excel. These are valuable for new and regular user to increase productivity in Excel...\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/30-tips-to-master-ms-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/30-tips-to-master-ms-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/30-tips-to-master-ms-excel#primaryimage\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/master-in-excel.png\",\"contentUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/master-in-excel.png\",\"width\":600,\"height\":300,\"caption\":\"master in Microsoft excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/30-tips-to-master-ms-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"30 Tips &#038; Tricks to Master Microsoft Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Repair MS Excel\",\"description\":\"Get Tips, Tricks and Fixes of MS Excel Issues\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Repair MS Excel\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Repair MS Excel\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/ab2250dcc6b25c12e617748b1fc166e3\",\"name\":\"Priyanka Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"caption\":\"Priyanka Sahu\"},\"description\":\"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.\",\"sameAs\":[\"https:\\\/\\\/www.repairmsexcel.com\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/priyanka-sahu-2794a1242\"],\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/author\\\/priyanka\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"30 Tips & Tricks to Master Microsoft Excel","description":"Read the article, to know 30 handy tips n tricks to master Microsoft Excel. These are valuable for new and regular user to increase productivity in Excel...","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.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel","og_locale":"en_US","og_type":"article","og_title":"30 Tips & Tricks to Master Microsoft Excel","og_description":"Read the article, to know 30 handy tips n tricks to master Microsoft Excel. These are valuable for new and regular user to increase productivity in Excel...","og_url":"https:\/\/www.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel","og_site_name":"Excel File Repair Blog","article_published_time":"2017-05-27T09:20:00+00:00","article_modified_time":"2024-01-03T07:21:27+00:00","og_image":[{"width":600,"height":300,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/master-in-excel.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"30 Tips &#038; Tricks to Master Microsoft Excel","datePublished":"2017-05-27T09:20:00+00:00","dateModified":"2024-01-03T07:21:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel"},"wordCount":2680,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/master-in-excel.png","keywords":["excel expert","excel tips and tricks","master microsoft excel"],"articleSection":["Tips"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel","url":"https:\/\/www.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel","name":"30 Tips & Tricks to Master Microsoft Excel","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/master-in-excel.png","datePublished":"2017-05-27T09:20:00+00:00","dateModified":"2024-01-03T07:21:27+00:00","description":"Read the article, to know 30 handy tips n tricks to master Microsoft Excel. These are valuable for new and regular user to increase productivity in Excel...","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/master-in-excel.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/05\/master-in-excel.png","width":600,"height":300,"caption":"master in Microsoft excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"30 Tips &#038; Tricks to Master Microsoft Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.repairmsexcel.com\/blog\/#website","url":"https:\/\/www.repairmsexcel.com\/blog\/","name":"Repair MS Excel","description":"Get Tips, Tricks and Fixes of MS Excel Issues","publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization","name":"Repair MS Excel","url":"https:\/\/www.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Repair MS Excel"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3","name":"Priyanka Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","caption":"Priyanka Sahu"},"description":"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.","sameAs":["https:\/\/www.repairmsexcel.com\/","https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242"],"url":"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka"}]}},"_links":{"self":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/981","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=981"}],"version-history":[{"count":1,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/981\/revisions"}],"predecessor-version":[{"id":7774,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/981\/revisions\/7774"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/990"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=981"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=981"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}