5 novidades no Excel - 2025 (+ bônus)

Summary

In this video, the presenter highlights five new features in Microsoft Excel that can boost productivity and ease of use. These include a focus display to help navigate large spreadsheets, a navigation pane for quick access to sheets and tables, range trimming to handle missing data, checkboxes for tracking tasks, and a translation tool for multi-language work. Additionally, Excel now supports dark mode, enhancing visual comfort. These features aim to streamline workflows, making Excel more efficient and user-friendly for all kinds of tasks.

Takeaways

• 😀 Display Focus feature highlights both rows and columns when selecting a cell, making it easier to navigate large spreadsheets.
• 😀 You can change the default color of the highlighted row and column in the Display Focus feature for better visibility.
• 😀 The Navigation Pane creates a side menu listing all sheets and tables in your workbook, making it easier to jump to any section.
• 😀 Excel’s Range Trimming automatically adjusts the data range in calculations, so incomplete data doesn’t distort results.
• 😀 You can use Range Trimming with formulas, and Excel will adjust calculations when new data is added.
• 😀 The new checkbox feature allows you to track tasks and activities by marking them with a *TRUE* or *FALSE* value.
• 😀 You can easily count the completed tasks using the COUNTIF function based on the checkbox values (TRUE/FALSE).
• 😀 Language Translation feature in Excel helps you translate text by specifying source and target languages.
• 😀 Excel can automatically detect the source language of text for translation, removing the need for manual input.
• 😀 Excel now supports Dark Mode, providing a more visually comfortable interface, especially for long working hours.
• 😀 When you switch to Dark Mode, all Office apps follow suit, creating a consistent experience across your workspace.

Q & A

What is Excel's 'Focus Mode' and how does it work?

Focus Mode in Excel helps you navigate large spreadsheets by highlighting the entire row and column of the selected cell. This makes it easier to track your position in both vertical and horizontal directions. The highlight color can be customized according to your preference.

Can I adjust the color in Focus Mode?

Yes, Excel allows you to change the default color in Focus Mode. You can customize the highlight color to suit your style or preference.

What is the new 'Navigation Pane' feature in Excel?

The 'Navigation Pane' is a new feature that appears in the 'View' menu. It creates a list of all sheets and tables within a workbook. Clicking on any item in the navigation pane takes you directly to that section, making it easier to manage large spreadsheets.

How does the 'Range Trimming' feature help with incomplete data?

The 'Range Trimming' feature automatically excludes blank data when performing calculations. For example, if you're calculating a view rate and certain months have no data, the function will adjust the calculation by excluding those months, ensuring accurate results.

Can you manually trim a range in Excel?

Yes, you can manually trim a range by adding a dot after the colon in a formula. This helps exclude unwanted data either at the bottom or top of the range, depending on where the issue lies.

How can checkboxes be used in Excel for habit tracking?

Checkboxes in Excel can be used to track daily tasks or habits. When checked, the value is 'True'; when unchecked, the value is 'False'. You can use simple formulas to count completed tasks, track progress, and even calculate percentages of tasks completed.

What are the two possible values for checkboxes in Excel?

The two possible values for checkboxes in Excel are 'True' (when checked) and 'False' (when unchecked). These values can be used in formulas to track progress or completion.

How do I calculate the percentage of completed activities using checkboxes?

To calculate the percentage of completed activities, use the COUNTIF function to count the number of 'True' values (checked checkboxes) and divide it by the total number of checkboxes. You can then multiply by 100 to get the percentage.

How does Excel's automatic language translation work?

Excel's translation feature allows you to automatically translate text from one language to another. By selecting a cell with text, you can specify the source language (e.g., Portuguese) and the target language (e.g., English) for translation. The 'Detect Language' function helps Excel identify the language of the text automatically.

What does the 'Detect Language' function do in Excel?

'Detect Language' is a function that automatically identifies the language of a text in a cell. It is especially useful when working with text in multiple languages, as it helps Excel choose the correct source language for translation.

Can the dark mode in Excel be applied to other Office applications?

Yes, when you switch to dark mode in Excel, the theme change is applied to all other Office applications, such as Word and PowerPoint. However, you can change the theme individually in each app if you prefer a different setting.

How can I switch Excel to dark mode?

To switch Excel to dark mode, go to the 'Account' settings and select the 'Black' Office theme. This will change the interface to dark mode, which reduces eye strain, especially for those who work long hours.