When you start Excel, the Excel program window appears. In this video, explore the elements of the Excel program window and learn 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. I just started Excel, and when you do, you'll see the workbook gallery. This view, which I will describe in detail elsewhere in the course, allows you to create either a blank workbook, to take a tour in Excel, or to create a new workbook based on a template. In this case, I want to create a blank workbook.
So I will make sure that template is selected, and in the bottom right corner, click Create. When I do, Excel displays a new blank workbook. As the workbook is displayed here, you can see both the body of the workbook and also the menu bar. At the top left of the workbook, you will see three buttons: red, yellow, and green. The red button, if you click it, closes the workbook.
I won't click that now. If you want to minimize your workbook, then you can click the minus sign, which I'll click here. So that minimizes the workbook, and you can see the rest of my desktop. If you want to bring it back, just go down to the bar and click it to bring it back up. And the final button, the green button, changes between full screen mode and the mode you see here. So if I click this button, it goes to full screen, and if I want to exit full screen, I can press the Escape key.
Above the program window, you see the menu bar. The menu bar remains in Excel for Mac because it is an Apple standard. And you can get to most of the facilities that you need within Excel by going through it. However, I prefer to work with the ribbon, so that is what I will teach here. And that means that I want to take advantage of as much screen space as I can. So I will click the full screen button to expand the workbook. At the top left of the program window above the ribbon, you will see the auto save feature, which you can turn or off for any file that you store in the cloud.
For example, in One Drive, Box, Google Drive, or any other facility. And then other buttons for saving, undoing actions, or redoing actions. Just below that is the ribbon, and here you see tabs for home, which contains the most commonly used formatting features and others, and also ribbon tabs to insert objects to draw and do other things. I cover the ribbon elsewhere in this course. At the top right corner, you'll see the Search Sheet box.
This allows you to find values within a worksheet. You can also click share to share your files with other users. If you want to minimize the ribbon, then you can click this button here, the collapse ribbon button. And the ribbon is collapsed. And if you want to bring it back, click the expand ribbon button, and there it is. At the bottom left corner of the worksheet, you'll see the sheet tab bar. And here we have a worksheet tab for sheet one. If I click the New Sheet button, then I get a second worksheet.
And you can switch between worksheets by clicking the tab of the sheet you want to display. At the bottom right corner of the program window, you can set your view. Currently in normal view. You can also change to page layout, which shows how your page will look when it's printed, and also page break preview. Page break preview shows where the breaks are in your page when the file is printed. To the right, you can use the zoom control to change the zoom of your window.
In this case, I'll go back to normal view. I'm currently at 100%. If I increase the zoom, then it goes up and I can see things in larger format, and if I zoom out, then everything gets smaller. The minimum zoom is 10%, and the maximum zoom is all the way up to 400%. 100% is normal.
Finally, you can use the vertical and horizontal scroll bars. The vertical scroll bar appears over on the right side when you move your mouse pointer over the right edge. And you can drag it to scroll down or scroll back up. Same thing with the horizontal scroll bar at the bottom. Just move over the bottom of the worksheet, and you can scroll to the right or back to the left. The Excel program window provides a flexible environment for you to manage your workbooks.
In particular, going to full screen mode allows you to take advantage of all your screen real estate when you're editing your workbooks.
- Creating workbooks
- Manipulating cell data
- Using core functions and formulas
- Formatting worksheet elements
- Creating PivotTables
- Collaborating with others
- Working with charts
- Adding images and shapes
- Saving workbooks
- Printing files