Press the function key F1 to activate the Help screen panel at once or click the Search panel and type the topic you need help on.
- [Instructor] Excel's built in help is extensive. It's available in a lot of different ways. One way is, we're about to use a button, we slide over a button, we see a description of it, and sometimes a graphic. If there's a keystroke shortcut associated with the button, we'll see that as well. For example, on the Home tab, bold, Control + B, italic, Control + I, and so on. And we can also get help, by way of a choice in the ribbon menu system. To the right of help, Tell me what you want to do. We can click here and type in for example, maybe I'm interested in a chart, maybe a line chart.
Not too sure what that means exactly. I see some choices here and lots of different approaches. Insert line or area chart. Well I could go down here, maybe start that process. Or maybe I could check this out. I don't wanna go here, don't wanna go there. Get Help on line chart. This leads me in some other directions. Maybe this. I'll click that. That activates a dialog box on the right related to that particular feature. I'm gonna close that and come back again. I'll again type line chart.
In addition to getting help on line chart, we can also use what's called Smart Lookup. This takes us out side of Excel into potentially Wikipedia or other external sources as well too. We could also get to help in the so called traditional way using the function key F1 at any time. And that activates that same screen we see off to the right. But this time we see some choices. This might even lead us into some videos, some visuals explaining how to use this feature or that feature. And again, by clicking in the panel here and using different terms and terminology in Excel, that leads us into subtopics.
I typed in chart. I might be interested in a Gant chart or some other choices here. So no matter what we do in Excel, whenever we need help we've got a lot of choices. We could either press the function key F1, as we just saw. We can use that feature, Tell me what you want to do. And of course as we use the ribbon menu system sliding over these choices, we get a lot of good on screen help as we work with Excel.
- Explain the benefits of using Excel to create and manage spreadsheets.
- Recall the appropriate action for activating shortcut menus.
- Explore data entry, editing, and autofill.
- Name three actions that can be undone in an Excel worksheet.
- Identify the correct method for saving files in Excel.
- Apply unique font styles and effects to enhance charts.
- Recognize helpful keyboard shortcuts.