How To Manage Worksheets In Excel For Mac


show more Managing worksheets provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Managing worksheets

When you create an Excel workbook, it comes with one worksheet where you can store data, create formulas, add images, and so on. A worksheet is like a folder in a drawer; it can store lots of data and span more than one printed page. And as with file folders, the best way to organize your data is to create a separate worksheet for data in a specific set. For example, if you create a workbook to summarize yearly sales data, you could create a worksheet for each month. In this movie, I'll show you how to create, delete, and manage your worksheets. The workbook I have here, ManageWorksheets, has two sheets.

The first one is called Sheet1 - that's one we're seeing right now - and that contains monthly revenue for the years 2005 through 2010. You know that you're on Sheet1 if you look at the tab bar here at the bottom of the Excel program window. That is where you'll see Sheet1, and you'll also see that there's a tab for a second worksheet called Yearly. The active work...

Managing worksheets
Video duration: 5m 28s 6h 32m Beginner

Viewers:

Managing worksheets provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

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