Nathan had Excel for Office 2019 and I had Excel for Office 365. Neither of us even knew there were different versions of Excel, much less how one would compete against the other. As it turns out, I smoked Nathan at all the tasks, thanks to the help of artificial intelligence (AI) and a feature called Data Types in Excel for Office 365. With Microsoft 365 for the web (formally Office 365) you can edit and share Word, Excel, PowerPoint, and OneNote files on your devices using a web browser.
MO-200: Microsoft Excel (Excel and Excel 2019)
Languages: en en-my nl fr de id-id ko pt-br es it ru ja pl el-gr zh-cn zh-tw ar-sa
Retirement date:
This exam measures competency in the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions, and creating charts and objects. The exam covers the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data entry logs.
Price based on the country in which the exam is proctored.
for Microsoft Excel (Excel and Excel 2019) All objectives of the exam are covered in depth so you'll be ready for any question on the exam.
-->Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
This article provides detailed steps for administrators to set the default font for Microsoft Office applications, such as Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.
Set the default font for Word
Note
There are no direct Group Policy Objects (GPOs) to set the default font in Word (for both Office 365 and 2016).
- Create a blank file that is configured by using the font and styles that you want to set as the default.
- Select File > Save As.
- Select the .dotm file name extension.
- Save the file to %Appdata%MicrosoftTemplates.
- Replace the Normal.dotm file.
- After the Normal.dotm file is created on the administrator's computer, you can deploy the same file to the %Appdata%MicrosoftTemplates location on users' computers.
For more information, see Change the default settings for new documents.
Set the default font for Excel
- Set a cloud policy (for Office 365):
- Create a font policy from Policy Management.
- Apply the cloud policy to a security group that target users are members of.
- Set a GPO (for Excel 2016):
File name Policy setting name Scope Policy path Category Registry information Part Default setting Possible settings Supported on Help text excel16.admx Font User Microsoft Excel 2016Excel OptionsGeneral General HKEY_CURRENT_USERsoftwarepoliciesmicrosoftoffice16.0exceloptionsfont
Name, Size
Arial, 10[ ] At least Windows Server 2008 R2 or Windows 7 Specifies the 'Standard font' font name and size.
Set the default font for PowerPoint (for both Office 365 and Office 2016)
To set default font for PowerPoint, set a default theme, and save it as a .potx file.
Note
Setting the default template requires the following items:
- The correct file name: Default Theme.potx
- The correct location: %Appdata%MicrosoftTemplatesDocument Themes
To set the default theme, follow these steps:
Microsoft Excel Office 365 Version
- Start PowerPoint.
- Open an existing PowerPoint template that you have configured by using the font and styles that you want to set as the default.
- Select File > Save As.
- Select PowerPoint Template (*.potx) in the file type list. This automatically changes the folder location to Custom Office Templates (a personal template folder).NoteDon't save it here because this enables you to view your template under Custom Office Templates.
- Select More options to opens a file name dialog box, replace the whole file name with %Appdata%MicrosoftTemplates, and then press Enter.
- In the Templates folder, open the Document Themes folder. If you see a Default Theme.potx file existing in the folder, you can also make a backup of the file. To do this, select the file, press Ctrl+C, and then press Ctrl+V.
- Enter the name 'Default Theme' to manually name the file, and then save it. If a Default Theme.potx file exists, you can also select the Default Theme.potx file, and then select Save to overwrite it.
- Close PowerPoint, and then select File > New. Now, you see the default template that's displayed as an option.
Microsoft 360 Excel
For more information, see Change the default font in PowerPoint.