Hour 14. Working Smarter

The topics of this hour are as follows:

  • How to arrange workbooks

  • How to move between workbooks

  • How to copy and move data between workbooks

  • How to create formulas that refer to other workbooks and worksheets

  • How to create links between worksheets and workbooks

  • How to customize Excel

  • How to protect your data

  • What Excel add-ins are

This hour gives you the information you need to create formulas that link data from other worksheets and workbooks, customize Excel, protect your data, and use Excel add-ins.

At the end of this hour, you'll be working smarter in Excel with some very useful tools at your fingertips.



    Part I: Excel Basics