Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Excel for Mac 2011 Essential Training, author Curt Frye gives a comprehensive overview of Excel, the full-featured spreadsheet software from Microsoft. The course covers key skills such as manipulating workbook and cell data, using functions, automating actions, printing worksheets, and collaborating with others. Exercise files accompany the course.
When you first start Excel 2011, the program can be pretty intimidating. In this movie, what I'll do is show you how to run Microsoft Excel 2011 and then walk you through the basics of the program window, showing you how to move things around and so on, and I'll also introduce the user interface elements. So, the first thing is how do you run Excel 2011? If when you first installed Office 2011 Excel ended up on your launch pad, then you can just click the Excel icon, and the program will run. If you don't see it there, then here is how you run the program.
You go to your hard disk and then go to Applications, and within the Applications list, you go to Microsoft Office 2011, and from there, double-click Microsoft Excel, and the program runs. When the program appears, you'll see the Excel Workbook Gallery. The gallery contains tools that you can use to create a new blank workbook, or you can also create workbooks based on templates. So, for example, if you are a consultant and you need to put together your time for your boss, then you can use the Consultant Time Tracker template.
If you're putting together a list of your customers for their names, addresses, phone numbers, and so on, then you can use the Customer List template. I'll get into using templates in a later movie, but for now, let's just create a blank workbook. To do that, you make sure that Excel Workbook is highlighted, and you see it here outlined in orange, and then press Return. When you do, Excel creates a blank workbook. Like any other program in the Mac operating system, there are a number of window controls that you can use. For example, here, in the top-left corner, you'll see that you have the red, orange, and green buttons.
The red button is the close button; if you click it, Excel will close the current file without closing the program. You also have the minimize button; if you click that, Excel sends the file down to the launch pad. To bring it back, click the icon, and that reappears. If you resize your window, which you can do by dragging this control here at the bottom right-hand corner and just dragging until the window is the size that you want, if you do that and you want to return the window to the full screen, just click the green button here, and it restores it to its original fullscreen size.
Some other user interface elements that you'll encounter quite a bit: The first is the menu bar here at the top of the program window. If you click Excel, you have Hide Excel, which sends it down to the launch pad and also Quit, if you want to end the program entirely. And there are other elements, so, for example, working with files, editing what is already in your workbook for copying, pasting, finding things, and so on. We'll get into all of that in a moment. The next user interface item that you'll use are the buttons on the toolbar, and those are here in this line.
So, for example, if you want to create a new workbook, you can click the New Workbook button. If you want to open another workbook, you can click the Open button, or if you want to save your work, you can click Save this workbook, and so on for printing and other items that I'll get into later. The third user interface element, the Ribbon, which is where the Home, Layout, Tables, and other tabs appear, is new in Excel 2011. If you haven't used it before, it's a new user interface organization principle that Microsoft uses to put the commands within functional groups.
So, for example, if you want to create a chart, you can click the Charts Ribbon and see all of the elements that are available for creating and manipulating charts. The workbook window itself has what are called horizontal and vertical scrollbars. So let's say, for example, that you have some data below row 26, which is the last row currently shown on the screen. To reach that data, you can go over here to the scrollbar and either drag this bar to move down, or you can use the scroll up and scroll down buttons to move within the window.
This is the scroll down button, and this upward-pointing triangle is the scroll up button. Similarly, you can use the horizontal scroll buttons to scroll right and to scroll left, or you can drag the bar. 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.
Find answers to the most frequently asked questions about Excel for Mac 2011 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.