In this video, learn how to use the help system to find the information you need.
- [Instructor] Excel is a powerful program with lots of capabilities. The good news is that you can do lots of things with it but the bad news is that its impossible to cover everything in a course like this one. Fortunately, Excel comes with help files you can view on your computer or on the official help site. In this movie, I will show you how to use the help system to find the information you need. I'm working in the getting help workbook which you can find in the chapter one folder of the exercise files collection but any one of your own files will do just as well.
The first problem in getting help with an Excel is to figure out what something is called. One great way to find out what something is called or at least how to refer to it within the help system is to hover your mouse pointer over it. So lets say that I don't know what this A with a red underscore line does or what its called. If I hover my mouse pointer over it, I see that it is font color and I also see now here that I'm in the formula bar. Let's say I want to find out how to change font color.
To get help on that topic I can go to the tell me what you want to do box. I'll click there. I can see that I have a number of suggestions such as adding a comment or inserting a table. In this case, I will say change font color and the first option is font colors so I'll point to that and I see a list or a fly out of colors that I can change. So for example I can select a color from one of the built in themes, create a standard color or use a standard color, or select from a more colors picker.
Let's say that I want to make my change to dark blue so I'll change the color to dark blue and the change was subtle but you can probably see it. Another way to get to the help is to open the help system. To do that press F1. I'm working with a pre-fee version of the program so this is still listed as Excel 2016 for Mac Help. However, I can tell you that the topics will work just as well for 2019.
So I'm here in the online help. If I want to search, I can search with an online help by looking in this text top so I'll type font color again. Press enter. And I get a set of headings or articles. So I have filter by font color, that's not what I want. And then I have format text in cells. Okay, I'll click that as category. So I click that hyperlink and you see that I now have an article. If I scroll down, that displays all kinds of things that I can do.
So here I have changing the font style, size, color, or apply effects. So if I continue scrolling down, yup, there is the font color button. When I'm done, I can click the close button to close out. The Excel helps us and provides a complete reference for all the program's capabilities. If you forget how to do something or if you want to delve more deeply into an Excel capability, searching the help system will provide exactly the information you need.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.