Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Introduction to Alteryx
      • Power BI
        • Power BI – Beyond the Basics
        • Power BI
      • Qlik Sense
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Sign Up
Home > Microsoft Excel > Using the Tell Me Feature in Microsoft Excel 2016

Using the Tell Me Feature in Microsoft Excel 2016

During this Microsoft Excel 2016 training tutorial video, we will discuss one of the new features in this version of Excel – Tell Me. We will demonstrate how you can utilize Tell Me and where to find additional help regarding this particular feature.


Facebook Linkedin Twitter

Like what you see? Get our complete Microsoft Excel 2016 training courses for beginner, intermediate and advanced learners. Click here to learn more. >>

Video Transcript:

In this section we’re going to take a look at the new Tell me feature. I think it’s important to cover this early in the course because you should find it quite helpful, particularly if you’re new to Excel. And even people with quite a bit of experience might well find useful things in this new feature.

Now before we look at Tell Me in detail I’d like to talk about Help a little bit more. I mentioned it before. I showed you how to bring up Help. I’m going to press the F1 key now to bring up Help. One of the things that’s going to become more and more of a feature of Office, I think, is that one day you will look at Help and it will say one thing and the next day you look at it and you have a completely different list of topics. It does tend to be much more dynamic than it used to be. And particularly if you’re using Excel via Office 365 you may get a few surprises. Now Help, today, on Excel 2016 Help contains very different things to what it contained yesterday. And amongst the things that are in there there is a Get Started category and within the Get Started category there’s a What’s New in Excel 2016 for Windows and within that, that’s a page or similar to a page that we looked at earlier. If you go down there you will find a description of the Tell Me feature.

Now generally speaking it’s always worth having a look at Help for any new feature that I introduce to get, if you like, Microsoft’s official view of that feature. Having said that, the level at which topics are covered in the Microsoft Excel 2016 Help is a much less detailed level than the coverage that I give you.

Let’s just go back Home again within the Help and again going back to Get Started there is actually Excel 2016 training and there are, for example, a couple of courses there. One of them is a Create your first workbook. Click on Go to course and it actually takes you through a relatively short course on Excel 2016. Again that’s well worth a try.

Want More? Get Started With a Free Excel 2016 Course! Click Here

Now if I do a Search on Help now for Tell Me, first of all I do things quickly with Tell Me and as you can see there’s a link there with a frame from a Microsoft video about Tell Me and a very small amount of printed information below it. So again, make sure you take a look at the Help on these topics although quite often it is very limited.

So let’s now try the Tell Me feature.

The first thing I’m going to do is to click in that Tell Me box. I’m going to type the word Bold. Now when I’ve typed Bold it basically gives me three options. Now it won’t always be exactly three but in this case three is good because it really gives me three types of options generally.

Now the first option is that it will actually give me access to the Bold command. Of course we’ve used the Bold button already. It’s in the Font Group on the Home Tab. We used it to make the word Hello bold much earlier on. And if there is a command that either matches what I’ve typed or seems to closely match what I’ve typed or involved in some way one or more of the words that I’ve typed then it will offer me that command. So in this case it offers me access to the Bold command.

It also offers me access to Help on that subject. So let’s have a look at the Help on Bold.

Now as with much of the online Help in Excel 2016 I don’t find it particularly impressive because I’ve sort of like the first item there to basically something like how to make something bold. Now there is help buried away in this long list of links that would help me to do that but I would have to dig around a bit to find it. But how successful, how good the links are in Help is very variable and sometimes you get some very good help and some very good links. So in this case the help on Bold would perhaps be a little bit awkward.

The third option was Smart Lookup on Bold. And what this does is to basically lookup the term for me and get me some help. Let’s look at a better example of something where I might want to do a Smart Lookup.

Let’s suppose that I’m doing some statistical work in Excel and I want to find out what Standard Deviation means. So what I’m going to do is type in the term Standard Deviation. Now you notice it offers me a couple of links related to commands which are available. It says Get Help and the third option is Smart Lookup. So let’s click on Smart Lookup. It opens a panel on the right called the Insights panel and then it gives me a number of links to helpful information about Standard Deviation such as, for example, a Wikipedia link and some Bing image search results. So I’ve got useful information on the right there where I can find out more about what Standard Deviation means.

Now in terms of actually executing a command let me try something different there. Let’s not have Bold. Let’s try Insert Table. Now with Insert Table selected you can see a whole list of potential commands that involve something like inserting a table. Now that one you see that has the word Table in one of the commands, Data Table. Format as Table has got Table in it. Insert has got the word Insert. But right at the top is the actual command with literally the name Insert Table. So it gives me the one that’s closest to the term I’ve entered first. That’s Insert Table. And if I click that now it will do exactly the same thing that would have happened if I had pressed Insert Table from the Ribbon in Excel 2016. So that gives me direct access to whatever Insert Table does and it does exactly the same thing as Insert Table.

Want More? Get Started With a Free Excel 2016 Course! Click Here

So there we are. That’s a bit of a whistle stop tour of the options in Tell Me. Be using it from time to time in the course. I suggest you give it a try. I think particularly in the early days you’ll find it a very useful feature.

That’s it for this section. I’ll see you in the next one.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

30 day vertical banner

Most Popular Posts

  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15
  • How to Create Charts and Graphs in Microsoft Excel 2016

START LEARNING Using the Tell Me Feature in Microsoft Excel 2016 ON SIMONSEZIT.COM

START MY MEMBERSHIP

Similar Posts

Creating Reports in QuickBooks 2019 – Part 2

Using Budget Resources in Microsoft Project 2013

How to Custom Sort Excel Data? 2 Easy Steps

Tune Windows 7 for Optimal Performance

How to Create Deposits in QuickBooks 2019

How to Use the Ribbon in Microsoft Word 2013

Course Categories

  • Web Development
  • QuickBooks
  • Microsoft
  • Adobe
  • Data Analysis

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebook
© 2022 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)