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.
When you open up Microsoft Excel by using the Office button and selecting the New command, you're asked whether or not you want to select a template to work from. And in this movie, we're going to review and explore some of the different templates that you can use in the 2007 version of Excel. The one that we've been working with most often is our blank worksheet so we're not going to bother taking a look at that. Let's see what's under the Installed Templates list. These are templates that come with the Microsoft Excel desktop version. You have your business options such as Billing Statements and Expense Reports, and you have some personal ones, such as Blood Pressure Tracker. And as you mouse over each of them, you will see the descriptor, and if you click on it, if there's a preview available, it will show over here in the preview screen. So these are nice, and they're fairly standard to work with. At least it gives you a starting point.
You also have the ability to create your own templates, and if you select the new template options, you will then be given the choice to select some of the templates that you may have created in previous versions of Excel. And you can open those ones up to work with. You also can create new templates based on existing worksheets. So as I click on the New from existing workbook option, it takes me back to my exercise workbooks, so that I can use those as a basis for creating templates.
I think the most exciting piece of this particular feature though, is the ability to go to the Microsoft Office Online library of templates. You do have to be connected to the Internet for this to work. Let's just take a look at the different templates that you can get from the Microsoft Office library. Here's the one that's featured this particular month. You have the Monthly family budget. This is probably something that I should be downloading right now, but maybe in the next year. You can use Agendas for meetings, you can take a look at calendars and because we're working at the very and of the year here, I'm going to be taking a look at the 2007 calendar just to see what's coming up in the new year. But you have different calendar options, you can do a portrait calendar, you could do the calendar here that I like, it's the one that you can actually right in. So not only can you look at the 2007 calendars, you could use this as a template to create 2008 calendars or if you go back to your calendar view by clicking on the Back button here, you could select a 2008 calendar right away.
You have academic year calendars, previous year calendars, multiple-year calendars, all kinds of information to work with. If you're starting a brand new business, you can use expense reports, forms and inventory templates to work with and for those of you that are using this at home, you have different planners. Let's take a look at this. You can use a weekly menu planner, if you're like me and on a never-ending diet, this might be something that you'd want to use. If you're planning a party, you could use a party planner. Here's one specifically for a baby shower, and on and on and on. Let's just see what it looks like when you bring one of these templates into the Microsoft 2007.
Let's use the baby shower planner just for fun. I select the template that I want to work when, and I click Download. It then confirms that I am a genuine Office user, and I say, " Yes, I want to continue." And there we have it. We have our template all in front of us. And isn't this wonderful? I have my graphics, I have my color themes, I even have it pre- populated with the names and addresses. So here you go. There's not much more that you need to do in terms of using templates. Go and take a look at them, and explore for yourself, and see what kind of information you can pull down, and what kind of ideas you can get with working with the 2007 Microsoft Excel.
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.