Prepare a workbook for internationalization

Keyboard Shortcuts

Learn how to prepare a workbook for internationalization. Author Jen McBee reviews how to inspect a document and remove metadata and comments. She also demonstrates how to use the correct language and symbols so the information is correctly displayed and how to edit data in another language.

- [Narrator] When you share your workbooks with other users,…you should always make sure that you're not sharing…more information than you intended, such as metadata.…Now, metadata shows who created the document,…how much time was spent editing the document,…and even more information.…It also shows comments and hidden text.…Also, if you're sharing your workbook with users…in other countries who work with different languages…or currency systems, you'll want to make sure that you use…the correct language and symbols throughout the workbook.…

In this video, I'll show you how to remove that metadata…using inspect document.…I'll also show you how to change the language…in which you're editing a document,…how to change the currency symbol,…and how to insert other symbols.…Let's take a look at our 03-04 Internationalization workbook…and I'll demonstrate each of these items.…First, let's take a look at any metadata…that we may have in this document.…I can see right away that there's a comment in cell C4.…

Let's go to our file tab and look over…

Resume Transcript Auto-Scroll

Author

Released

4/17/2017

Demonstrate your advanced knowledge of Excel by becoming a Microsoft Office Specialist (MOS) Expert. This course, created by Microsoft Certified Trainer Jennifer McBee, helps you prepare for the Excel 2013 Expert Part One exam, the first part of a two-part exam. This course focuses on managing and sharing workbooks, applying custom formats and layouts, creating advanced formulas, and creating advanced charts and tables.

The course begins with an overview of the certification program and its costs. Next, Jennifer walks through all of the certification objectives, including hands-on experience with downloadable sample documents, so you can practice as you go. She wraps up with a full-length practice test that emulates exam 77-427, together with solutions to each of the exam challenges.