{"id":1806,"date":"2012-11-26T14:31:54","date_gmt":"2012-11-26T14:31:54","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=1399"},"modified":"2023-12-30T23:11:04","modified_gmt":"2023-12-30T23:11:04","slug":"spellcheck-in-excel-and-other-proofing-tools-in-the-reviews-tab","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/spellcheck-in-excel-and-other-proofing-tools-in-the-reviews-tab\/","title":{"rendered":"Spellcheck in Excel and other proofing tools in the Reviews tab"},"content":{"rendered":"

For that professional edge it is really worth using Excel’s proofing tools to make sure that your worksheets are accurate.<\/p>\n

With more teams sharing Excel documents, adding comments and making changes, you need effective ways to track changes, check for duplicates and ensure that your business works with the most up to date and accurate information.<\/p>\n

All the tools you need, to proof your documents, are located in the Review tab. You can even use the tools in this Ribbon as your proofreading checklist.<\/p>\n

When you are upgrading from an older version of Excel, or building your skills, the Review tab is often overlooked. \u00a0Take a trip along this Ribbon and look at how it can help you get more out of your data and shared working.<\/p>\n

\"proofing-financial-modelling-courses-excel\"<\/a>
The Review tab in Excel has all the tools you need to ensure the accuracy of your worksheet.<\/figcaption><\/figure>\n

Spellcheck
\n<\/strong>Spellcheck is common in Word and even in Outlook, but in Excel it is often underused. Nothing can annoy clients more than names spelled incorrectly, but with a quick click, your worksheet can be checked and corrected.<\/p>\n

Research
\n<\/strong>Excel won’t do your work research for you, but it will take you to places that can help you research the details such as dictionaries, reference materials and even translation. Click on the Research button and a side panel appears with the reference materials ready to go.<\/p>\n

Thesaurus<\/strong>
\nThis may not be top of your list, but this is really useful if you over-use particular words and want to broaden the vocabulary – users can be distracted by the constant repetition of terms, so use this button to help you be, well, more cosmopolitan and interesting…<\/p>\n

Translation<\/strong>
\nWith international clients, translation tools are really helpful. \u00a0This can save flipping through huge hard copy dictionaries, and type the word you need and access the translation.<\/p>\n

Working with Comments<\/strong>
\nI use\u00a0<\/strong>comments often in my Excel worksheets. \u00a0I can store extra notes here and not clog up my rows and columns. \u00a0This is also where colleagues can add notes when we are sharing the same worksheet. \u00a0To help you with this,\u00a0there is a whole section devoted to Comments.<\/p>\n

\"comments-tab-financial-modelling-courses\"<\/a>
Comments section in the Review tab give you access to great tools<\/figcaption><\/figure>\n

Not only can you add comments as you need to, but when you are looking at the whole worksheet and want to review all the comments quickly, you can click on the “Show All Comments”. \u00a0And when it comes to printing your document, you have the option to hide the comments, or include them at the end.<\/p>\n

Changes – making them and protecting your worksheets from unwanted<\/strong> ones<\/strong>!
\n<\/strong>If you have spent hours setting up complex formulas and linking worksheets, the last thing you need is a well-meaning colleague changing them.<\/p>\n

\"changes-tab-financial-modelling-courses\"<\/a>
Changes tab includes recording changes, and protecting your document from unwanted ones.<\/figcaption><\/figure>\n

In the Changes tab, you can protect the sheet, or entire Workbook. \u00a0If you are sharing your workbook, using these options can save lots of time.<\/p>\n

Whether you are using Excel to plan a home project or using it for financial modelling courses in Excel can help you to get more out of the program. \u00a0Review what we can do to help you with\u00a0https:\/\/www.stl-training.co.uk\/microsoft\/excel-training-london.php<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

For that professional edge it is really worth using Excel’s proofing tools to make sure that your worksheets are accurate. With more teams sharing Excel documents, adding comments and making changes, you need effective ways to track changes, check for duplicates and ensure that your business works with the most up to date and accurate […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[251,462],"class_list":["post-1806","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-financial-modelling-courses","tag-review-tab-in-excel"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1806","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1806"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1806\/revisions"}],"predecessor-version":[{"id":6692,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1806\/revisions\/6692"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1806"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1806"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}