Elert & Associates Technology Training
Home About Services Delivery Methods Courseware Testimonials Contact Us
Student Links Register for a Class Course Catalog Student Resources

Excel Working with Workbooks

Objective

Learn to organize your worksheets effectively by adding, deleting, moving, copying, and renaming them in workbooks. Save workbooks and worksheets as templates, work with workbook protection, and set workbooks up for sharing.

Prerequisite Skills

Course Description

Are you currently saving every Excel spreadsheet in a separate file? Did you know you can have multiple pages in a one Excel file called a "workbook?" Did you know you could create formulas that span multiple worksheets? Did you know you could share workbooks with other users?

Attend this course if you want to:

  • Learn how to keep related spreadsheets in one workbook file.

  • Name worksheet pages for easy retrieval.

  • Change the color of worksheet tabs.

  • Insert, delete, and move worksheets to where you want them.

  • Change the default number of worksheets in new workbooks.

  • Copy or move a worksheet within a workbook or to another workbook (to use as a template for new data).

  • Copy or move a range of cells within a workbook or to another workbook.

  • Group worksheets and simultaneously edit or format the data on all the worksheets.

  • Create formulas that span multiple worksheets.

  • Hide worksheets to reduce the number of worksheet tabs and prevent undesired viewing.

  • Print workbooks or selected sheets within the workbook.

  • Save a workbook or worksheet as a template, and then edit or delete that template.

  • Protect workbooks, worksheets, and cells from change.

  • Hide formulas from others using the workbook.

  • Share workbooks with other users for simultaneous updates.

Class Length

90 minutes

Delivery Options

  • Virtual classroom - public
    ($70 per student; check times and register here)

  • Virtual classroom - private (up to ten people from the same organization)
    ($480 per class; contact us for more details)

  • On-site instructor-led
    (Contact us for details)

 

   

   

   Print this page without top and side navigation

View a virtual classroom demo