Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training , instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.
Clicking over onto the Design tab, allows you to work with the look and feel of your final Pivot Table and the way that it's going to be presented. Here, I have Pivot Table Styles under my Pivot Table Styles tab or group. And I can just click through and use my different formatting styles that we're most accustom to when we're working in Excel now in 2007. So you can visually see very, very easily, which one suits the display that you would like to have and perhaps matches some of the themes that you've worked with in the past in the 2007 version of Excel. And you can quickly and easily make your selections here to make it again, as visually appealing as possible. You also have the ability to adjust Pivot Table style options here, you can show your row headers and your column headers, which is what I'm showing here. I can band my rows, which helps it again, differentiate and help my I track, the inventory item that I'm looking at, to the total amount of inventory that I have here.
So again, that's something that I think I'm going to leave on because it does help and display the information very easily for me to read. You can also band your columns if you're interested. Over here in my layout, this is some information that I'm going to help me with my grand totals, as well as my reporting and my printing. In my Subtotals layout, it allows me to put in subtotals or create or hide Subtotals. Now, in the case of the way that I've presented the information here in my Pivot Tables, Subtotal is not going to be a relevant item for me to show because I don't have any categories that I'm summing up. But this is a nice option to be able to put in if you did have, and you wanted to see the subtotals calculated.
Grand Totals, I already have Grand Totals identified here, and I'm viewing them automatically at the end of my columns and at the end of my rows, and it gives me a nice Grand Total here. If I turned off the rows and Grand Totals, I hav4 four different ways that I can present this data. I can turn it off for all rows and columns, I could turn it on just for the rows and columns like I had before, I can turn it on for rows only, or I can turn it on for columns only.
So it really depends on the kinds of information that you want to see, and what it is that you want to key in on when you are doing your different reporting. As well, you can create charts based on the different subsections of data, and the different presentations of data, so that he can highlight it. And we'll see more about that in our next movie. Under Report Layout, you can adjust the Report Layout, the compact form optimizes the readability while the tabular and outlined forms include the field headers. So let's just see what that looks like.
If I show this report in compact form, it doesn't really show a little bit different because we have, not much data to play with. If I showed an outlined form, it's not showing any difference either, to and in tabular form, you will see that the lines are showing up. This shows up better in your Print Preview option. If you we go to our Page Layout option here, you will see that this is my tabular format, and you will see the gridlines between each of my tables here, or each of my columns, and if I move it over to the outline form, you'll see that the grids are removed from my columns. So that's the difference that you will be able to see here.
Under Blank Rows, this emphasizes groups by adding a blank line between each grouped item. We'll see insert a blank line under each item, and you'll notice that it veer so slightly included a blank line there. So, it also allows you to adjust the way that you are presenting your information. Next will take a look at the charting availability from the Pivot Table option.
Find answers to the most frequently asked questions about Excel 2007 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.