| Home : June 02 2014 Computer News : How to create 3D Worksheets in Excel 2013 |
|
How to create 3D Worksheets in Excel 2013 |
June 02, 2014
One of Excel’s greatest tricks is the dimensional or 3D reference. This feature, which allows you to create formulas that refer to the same cell or range on multiple worksheets, simplifies the creation of complex documents like monthly inventories or sales reports. In Excel 2013, Microsoft has beefed it up with enhanced options and formulas.
To illustrate the power and flexibility of 3D worksheets, we’ll create a Year-to-Date project that calculates the utility bills for a small business for each month, with the year-to-date totals on the first sheet. This workbook (which contains of all the worksheets in this project) calculates the columns, rows, and multiple spreadsheets three-dimensionally.To read this article in full or to leave a comment, please click here
Link: http://www.pcworld.com/article/2241304/how-to-create-3d-worksheets-in-excel-2013.html#tk.rss_howto
|
|
|
|
|
