Excel - Do things quickly with Tell Me Tutorial

In this video, you will learn about "Do things quickly with Tell Me" in PowerPoint 2016. The video covers how to use the Tell Me feature, which allows you to quickly access features and perform actions by entering related words or phrases.
You can also get help or make a Smart Lookup on the typed word.
This feature is powered by Bing and provides insights, Wikipedia articles, and top related searches from the web.
By using Tell Me, you can save time and easily find the features you need.
This tutorial will help you become more efficient in using PowerPoint 2016.

1:07
2764 views

Available in Microsoft365

Objectifs :

This video aims to introduce users to the 'Tell me what you want to do' feature in Excel 2016, demonstrating how to efficiently access tools and information within the application.

Chapitres :

Introduction to the 'Tell Me' Feature
In Excel 2016, users will find a helpful feature labeled 'Tell me what you want to do' located on the ribbon. This text field allows users to enter keywords or phrases related to tasks they wish to perform, facilitating quick access to relevant features and actions.
Using the 'Tell Me' Feature
For instance, if a user wants to add a new waterfall chart, they can simply type 'waterfall' into this field. Excel will then provide direct access to the waterfall chart feature, streamlining the process of finding and using tools.
Accessing Help and Smart Lookup
If additional information is needed, users can click on 'Get Help.' This action opens the Help window in Excel 2016, offering detailed guidance on the selected feature. Furthermore, users can utilize the Smart Lookup feature by entering a word in the 'Tell me' field. This feature conducts an internet search powered by Bing, displaying results in a pane on the right side of the document. If a user finds a relevant result, they can click on it to open the information in a new web browser.
Finding Smart Lookup
Users can access the Smart Lookup feature at any time by right-clicking on a word within Excel. This provides an easy way to gather more information without leaving the application.

FAQ :

What is the 'Tell me what you want to do' feature in Excel 2016?

The 'Tell me what you want to do' feature is a text field in Excel 2016 where users can type keywords or phrases to quickly find and access various features and actions within the application.

How do I add a waterfall chart in Excel 2016?

To add a waterfall chart in Excel 2016, type 'waterfall' in the 'Tell me what you want to do' field, and Excel will provide direct access to the feature for creating the chart.

What is Smart Lookup and how do I use it?

Smart Lookup is a feature that allows you to research a word or phrase directly within Excel. You can access it by right-clicking on a word and selecting 'Smart Lookup', which will display relevant information in a pane on the right side of the document.

Can I get help on specific features in Excel 2016?

Yes, you can get help on specific features by using the 'Get Help' option after typing your query in the 'Tell me what you want to do' field, which opens the Help window with detailed information.

What happens when I click on a Smart Lookup result?

When you click on a Smart Lookup result, it will open in a new web browser window, allowing you to view more detailed information related to your search.

Quelques cas d'usages :

Quick Feature Access

Using the 'Tell me what you want to do' feature, users can quickly find and access tools like charts, formulas, and formatting options, improving efficiency in data management tasks.

Data Visualization

Professionals can utilize the waterfall chart feature to visually represent financial data, helping stakeholders understand the impact of various factors on overall performance.

Researching Terms

Users can leverage the Smart Lookup feature to research terms or concepts directly within Excel, enhancing their understanding of data and improving decision-making.

Accessing Help Resources

When encountering difficulties with Excel features, users can quickly access the Help window through the 'Get Help' option, ensuring they can resolve issues without extensive searching.

Integrating Online Resources

By using Smart Lookup, users can integrate online resources into their Excel workflow, allowing for a more comprehensive analysis of data with external information.

Glossaire :

Excel 2016

A version of Microsoft's spreadsheet software that includes various features for data analysis, visualization, and management.

Tell me what you want to do

A text field in Excel 2016 that allows users to enter keywords or phrases to quickly access features or actions within the application.

Waterfall chart

A type of data visualization that helps to understand the cumulative effect of sequentially introduced positive or negative values, often used in financial analysis.

Get Help

A feature in Excel that opens the Help window, providing users with detailed information and guidance on specific actions or features.

Smart Lookup

A feature in Excel that allows users to research a word or phrase online without leaving the application, powered by Bing.

Bing

A web search engine owned and operated by Microsoft, used to provide search results for the Smart Lookup feature in Excel.

00:00:06

in Excel 2016 that says, "Tell me what you want to do."

00:00:10

This is a text field where you can enter words and phrases

00:00:14

about what you want to do next and quickly get to features

00:00:17

you want to use or actions you want to perform. about what you want to do next and quickly get to features

00:00:17

you want to use or actions you want to perform.

00:00:20

For example, if I want to add the new waterfall chart,

00:00:24

I type waterfall in this field.

00:00:26

Excel offers me to directly access to this feature.

00:00:30

If I want more information, I click on Get Help On.

00:00:35

This action opens Excel 2016's Help window,

00:00:38

offering you more details on what you're looking for.

00:00:42

You can also access the smart lookup.

00:00:45

The word typed in this field will be researched

00:00:47

on internet without getting out of Excel.

00:00:50

Powered by Bing, the result appears

00:00:52

in a pane at the right of the document.

00:00:55

If a result interests you, click on it.

00:00:58

You'll be opened in a new web browser.

00:01:00

Find the smart lookup at any time

00:01:02

by doing a right click on a word in Excel, for example.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

2501 Views

Video Training Microsoft Excel - Intermediate level

Increase your scope of action with our intermediate tutorials dedicated to formulas, advanced visual enhancement and data analysis with pivo...

ALL COURSES