When you start Excel, the Excel program window appears. In this video, explore the elements of the Excel program window and see how to work with it effectively.
- [Instructor] When you start Excel, the Excel program window appears. In this movie, I will describe the elements of the Excel program window and show you how to work with it effectively. When you start Excel, you will usually see the gallery. You can see here that you can create a number of different types of workbooks. The first is a blank workbook, then you can take a tour within Excel, make a list, total a list, track your tasks, and so on. In this case, I will assume that you don't want to use one of the built-in templates and instead want to create a blank workbook so I will click blank workbook which in my case was already selected and then click the create button.
Doing so displays a new Excel workbook. This is like any other window in the MAC OS, you can resize it, so for example if I want to drag it to the left to take up the entire display I can move the mouse pointer until it changes to a two-way pointing horizontal arrow and drag to the left and I can also drag down and to the right so if I go to the bottom right corner you see I have an upper left down right diagonal pointing arrow and drag down until it fills the entire screen.
You can also close, minimize, and maximize or resize windows. Those are the controls at the top left corner and you see here we have the close button, minimize which if I click minimizes the program window. I can go down to the bottom right and click that to bring it back. You can also maximize or restore by clicking the green button. The way that button operates depends on the current state of your window so, for example, if I click it here it takes up the entire screen and if I move the mouse pointer all the way over the top I get the menu bar back and I can click the button again to return it to the previous size.
My personal preference is to leave the menu bar up. However, if you prefer to have it hidden, you can always do that too. And speaking of the menu bar, if you prefer to use that, you can select user interface elements through it. However, the most common way to work with the program now is within the ribbon and those are the ribbon tabs that you see here and all the individual controls. I'll go into a lot more detail about the ribbon elsewhere in the course.
One final thing I'll note here is that you can scroll within a program window. You can see that I am currently on cell A1, that's the highlighted green cell here. If I use the right arrow button I can move to the right and start scrolling to the right and when I do you see that the scroll bars appeared at the bottom and also at the right edge of the program window. So if I move down to the bottom of the worksheet you'll see the scroll bar up here and I can drag left or right and then the vertical scroll bar is here on the right side of the program window and I can use it to drag up or down or I can move the mouse pointer over top of it and click to move within there.
So as you can see, the Excel program window provides a flexible environment for you to manage your workbooks. In particular, the ability to resize the program window or hide it without closing Excel gives you a great deal of freedom to determine how you can make Excel work for you.
- 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.