Watching:

Importance of a Spreadsheet in MS Excel 2007


show more Why use a spreadsheet? provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Why use a spreadsheet?

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.

Why use a spreadsheet?
Video duration: 1m 25s 5h 13m Beginner

Viewers:

Why use a spreadsheet? provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...