Join Dennis Taylor for an in-depth discussion in this video Using Excel Help, part of Excel Essential Training (Office 365).
- [Instructor] Excel's built in help system is substantial and it's available in a variety of ways. You simply can slide over a button. Here's a button, here on the home tab. What does that do? Fill color, color the background of cells, and this is true of any button we slide over. If there happens to be a keystroke short cut, here's one for underline. We'll see it, control U. And at times, going back to this fill color bucket, I'm interested in this. How about tell me more? And, this activates a dialog box on the right side of the screen, couple bits of information.
This might be sufficient or I might type in something different up here, or something related to get even more information. Let's say this meets my needs. I'll just close that. So, that's certainly one way and keep in mind, as you slide over some buttons, you get a graphic and sometimes a longer description. There's at least one of these on the data tab here that's quite long, and this isn't necessarily typical but certain features here. Here's one about removing duplicates, text to columns. It really gives you some insight into the various buttons. So, that's really handy. You can also click on an area above the icons, called tell me what you want to do.
Just click in there, and type in, for example create chart. As I'm typing this it senses I'm ready to do that, in this case. Create chart, okay looks good. Create names, there it is right there. Click that, give you some information on that. And that will vary too depending on where you are in the worksheet. That's handy. And what do we see here? And actual tab in the ribbon called Help. And this is newly redesigned and there are lots of features here. Clicking help here activates that dialogue box on the right side of the screen.
You can also get to here at any time by pressing the function key F1. Maybe I'm interested in formatting, could click here. And one of these is likely to fit my needs, I'll click there. If not, it's completely self explanatory. I think you can quickly get the idea as to how you can get help here. There's an option here for feed back if you wish. Communicate with Microsoft indicating that you like a certain feature or don't like it. Or I have a suggestion. And there's a broad community of users and you can go to some of the various options here. This might lead you into an external site where you can provide or get more information on some of the features in Excel that you are interested in.
And here's one called show training. And eventually this would lead you into potentially one of the courses like the one you're watching right now by way of linked in learning. And what you'll see out here for example, if I click cells and a short video right here giving us information on this particular feature. So there's no shortage of different ways to get help on command. Remember you can press the function key F1 at any time, you can go to the help tab in the ribbon, clicking some of these buttons, or you could click into the panel just to the right of help to tell me what you want to do and type in the feature that you're interested in.
So that's going to be really helpful as you work with Excel. No question about it.
- Working with the Excel interface
- Entering data
- Creating formulas and functions
- Formatting your data
- Adjusting rows and columns
- Finding and replacing data
- Inserting and deleting sheets
- Sorting and filtering data
- Creating charts and PivotTables
- Printing and sharing worksheets
- Protecting worksheets and workbooks
Skill Level Beginner
Q: This course was updated on 1/7/2019. What changed?
A: A new video was added that covers working with Excel Ideas.