Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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.
Get unlimited access to all courses for just $25/month.Become a member
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.
Your file was successfully uploaded.