Saturday, March 7, 2015

How to manage multiple worksheets and workbooks in Microsoft Excel

This tutorial shall focus on the following targets.
  • Formatting and editing multiple worksheets all at once.
  • Creating a cell reference to other Excel worksheets.
  • Consolidating information from multiple worksheets using the 3-D Excel References.
  • Creating and printing worksheet group.
  • Crating link to data in other workbook
  • Creating workbook reference
  • Find out on how to edit links
  • Create and use Excel work space
  • Insert hyperlink in an Excel cell
  • Creating custom template
  • Creating a Webpage


No comments:

Post a Comment