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.
For those of you already experienced with using Excel, you know the power of using a spreadsheet over other computer applications. For those of you that are new to spreadsheets, let's explore a little bit about the power or the reasons why you might want use one. You see the table that you have in front of you here? You could easily create this table in a Word document, to get the look and feel and ability that you see here. But what's the advantage of putting it into a spreadsheet ? An advantage of putting it into a spreadsheet is shown simply by a very easy option. The point that I am showing you here is a downward arrow that allows you to select and sort all the different years in this column.
Let's say, for example, I would like just to see how my sales are doing in year 2006. I click on the downward pointing arrow, I select my year that I'm interested in, and click OK. What the applications now does, is it goes and grabs only the information for the year 2006 that I can now sort through and analyze. Let's say I'm interested in how catering's doing in particular in my organization. Having the ability to sort on the Channel column will let me grab that information in a blink of the eye. If I click on the downward pointing arrow again, and just select Catering, I'm now just presented with all of the information for the catering channel of my organization for the year 2006.
This is where you see the power of an Excel spreadsheet. We're going to explore together using a fictional company called Eat Cake, and see how you can learn to use the power of Excel to analyze information in your organization or home.
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.