Blogs and Posts

blog

Excel’s 3D Formulas – Webinar

  • By: Garry Feldman
  • Date: October 25, 2017

  • Excel's 3D Formulas
    November 15, 2017
    10:00 am - 11:00 am

Register for Events

Excel workbooks often have important, inter-related information on multiple sheets. You may have a sheet for each month with sales data or a sheet containing production figures for each product your company produces. One of Excel’s powerful features is the ability to create formulas through multiple sheets, which we call Three Dimensional Formulas. In the webinar, we will illustrate several methods of consolidating information from many worksheets into a summary sheet, and from multiple Workbooks into one workbook. We will touch on questions such as:

– How do I add weekly sales from all of my weekly sales sheets and place the results on a Summary sheet?
– Can I consolidate my information across multiple sheets and see the detail on the Summary sheet?
– If I have data in separate workbooks that I would like to combine, how can I do that?

White Papers

Blog Archive

Blog Archives
Categories
Newsletter

Connect with USCC