;

What's New in the Microsoft Office
2019 Certiport Certifications?


Did you prepare for the Microsoft Office 2016 Certification Exams but now want to take the 2019 Certification Exams? We’re here to help! Check below to see what objectives Certiport has added to and removed from each of their exams. If you’re worried about your readiness for the 2019 exams, check out our Practice Tests and Courses that will help you learn and prepare.

Excel Expert 2019 New and Removed Domains

Quick Snapshot

Removed Domains
  • 1.1.1: Save a workbook as a template
  • 1.1.4: Reference data by using structured references
  • 1.1.6: Display hidden ribbon tabs
  • 1.2.6: Encrypt a workbook with a password
  • 2.3.1: Create custom color formats
  • 2.3.2: Create and modify cell styles
  • 2.3.3: Create and modify custom themes
  • 2.3.5: Insert and configure form controls
  • 2.4.1: Display data in multiple international formats
  • 2.4.2: Apply international currency formats
  • 2.4.3: Manage multiple options for +Body and +Heading fonts
  • 3.4.1: Import, transform, combine, display, and connect to data
  • 3.4.4: Use cube functions to get data out of the Excel data model
  • 3.6.1: Name cells
  • 3.6.4: Manage named ranges and objects
  • 4.1.1: Add trendlines to charts
  • 4.1.3: Save a chart as a template
  • 4.2.5: Reference data in a PivotTable by using the GETPIVOTDATA function

Excel Expert 2019 New Domains:

1.2.5: Manage comments

Attaching comments to specific cells or elements allows you to provide feedback to other editors and reviewers or to give yourself a reminder. To change the content of a comment once it’s been created, you will need to select the Edit button. Comments in Excel are different than notes in that you can reply to comments.


1.3.1: Configure editing and display languages

You can control display and editing languages through the Options menu found in the File tab. If the language you want isn’t currently available, you can install or add it using the tools provided in this window.


1.3.2: Use language-specific features

Language-specific features are features that are unique to a particular language or alphabet. For example, in English, the alphabet can be written in uppercase or lowercase letters, so formulas like LOWER, UPPER, and PROPER will affect the text. Other languages, such as Hindi or Japanese, do not differentiate between uppercase and lowercase characters but have other distinctive features.


2.1.1: Fill cells by using Flash Fill

Flash Fill is a tool in Excel that detects patterns and will fill the remaining cells following that pattern. For example, if you’re separating full names into first and last, you can separate them manually for the first few and then use Flash Fill to complete the rest. Flash Fill will show you a preview that you can accept by pressing Enter, or you can manually use Flash Fill by selecting it in the Data tab > Data Tool group.


2.2.3: Group and ungroup data

You can use the Group tool to group and summarize a list of data, or you can use it to automatically create an outline. You can also create subtotals for groups. You can find the Group and Ungroup tools in the Data tab in the Outline group.


2.2.4: Calculate data by inserting subtotals and totals

You can add subtotals to groups of data to help long lists be more easily used and understood. The Subtotal tool is found on the Data tab in the Outline group.


2.2.5: Remove duplicate records

Excel makes it easy to locate and remove matching records in a table with the Remove Duplicates tool. The Remove Duplicates tool works like the filtering tool, but it lets you choose to remove all but the first occurrence of the record. This tool only works in tables and is accessed from the Table Tools Design contextual tab in the Tools group.


3.1.1: Perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), and NOT() functions

The IF function returns one value if a condition you specify is true and another value if that condition is false. It can combine with other functions (such as SUM to create SUMIF) to make it so that the other function only happens when specific criteria is met. You can find IF and other logical functions in the Function Library group on the Formulas tab.


4.1.2: Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall charts.

Attaching comments to specific cells or elements allows you to provide feedback to other editors and reviewers or to give yourself a reminder. To change the content of a comment once it’s been created, you will need to select the Edit button. Comments in Excel are different than notes in that you can reply to comments.


GMetrix Can Help


GMetrix offers practice tests that allow you to check your readiness for the Excel Expert 2019 official certification exam. If you don’t feel ready for the practice tests, we also host Excel Expert 2019 courses from trusted partners that will teach you the ins and outs of the new and previous domains.


Excel Expert 2019 Practice Tests
Excel Expert 2019 Course (Coming Soon!)
Microsoft Office 2019 Full Suite
GMetrix interface
Your Content Host
GMetrix is the ultimate study platform
Are you a company who has made learning material for a certification? Host it here!
Email us at [email protected]
© Copyright 2021, GMetrix LLC   Privacy Policy  /  Return Policy