Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
The ability to format numbers in Excel is really one of its powerful features. If I click over the cell E4, and I go up to my number group on my ribbon, I can easily change the layout of that particular cell and include different numbering formats with clicks of bottoms here as well as a drop-down list from the top. If we go back to our buttons, It would allow me to add decimal places just with the click of a button. So If I hover over my first Increase Decimal button here and just click, I've added 1 decimal place.
Also notice that it's adjusted size of the column at the same time. If click again, I end up with two decimal places, so it's very, very easy to add decimal places or remove them, by selecting the other Decreased Decimal button. I can add commas, I can put in percents, if I click this on the percent, it changes that particular formatting to not be a dollar formatting but to be a percentage. Let's just undo that by clicking up on the Quick Access toolbar to do that change. So I'm brought back to where I was before.
And I also have some currency formatting I can change from the United States dollar value, over to the pound in the UK and the Euro if I wanted to see the similar formatting. And it gives me the correct sign for that particular currency as well. If I click on my downward arrow up here, you'll see that there are lots of other options that I can work with, in terms of my numeric. I can identify currency, I can work with accounting for whatever particular country I'm working in, I also have some date choices as well as times choices, and I have a custom choice.
If I click on the More Number Formats, I'm brought up with a very familiar screen for those of you that have worked in Microsoft Excel previously. If I click on the custom area here, you'll see that there is all kinds of different options that I can do. And in this case, I can actually present the information in any format that I want. So you see that the ability to change the numeric formats, in Microsoft Excel 2007, is one the easiest things that you're going to be able to do with it. Next we're going to take a look at how you can align data in the cells, to present the information in a very readable format.
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.