image_56.jpg
Excel 2010 Working with 3 Dimensional Sheets and Workbook Techniques
Print E-mail

Course Registration

 

Who is this course for:

This course is for Excel users who need to separate data according to use and purpose. For example, different worksheets can be used for raw data, consolidated data, list of assumptions, constants and charts

What skills and knowledge will you acquire:

This course aims to provide you with the skills to manage a three dimensional workbook effectively, you will be able to master a number of worksheet techniques

What you need to know before beginning this course:

This course assumes a basic knowledge of Excel, consistent with the skills and knowledge detailed in Getting Started With Excel 2010

Course Duration:

1 1/2 hours

Course Objectives:

  • Learn how to insert, delete, rename, move, copy and hide worksheets
  • Learn how to copy a worksheet to another workbook
  • Learn how to group worksheets to perform consistent commands and functions across all workbooks
  • Learn how to hide, restore, freeze and unfreeze rows and columns
  • Learn how to split windows to view different workbooks and worksheets at the same time
  • Gain an understanding of data linking between worksheets and workbooks
  • Work with three dimensional formulas across the worksheets and workbooks

 

 

Course Registration

 

 

Cost GBP AUD USD
  £37 $49 $64