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.

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.