Home

Top - Excel Tips

Using Tabular Data in Excel Calculations Part 2 of 2

This video is best viewed in full screen mode. Press play and double click the screen to maximise.

Discussion

 Using Tabular Data in Excel Calculations Part 2 of 2 - JohnDoyle[Admin] October 7th 2010 9:19This thread is about Using Tabular Data in Excel Calculations Part 2 of 2 video. Please ask any questions here. This video is available on YouTube. Login to write comment

Date :07 October 2010
Views :5138

If you want to know how to make excel work with tabular data in a user friendly way then this video tutorial is for you. The first part of the tutorial describes use of the Excel INDEX function for tabular lookups and the use of a combo box for selection. A second video covers the use of data validation boxes and the Excel MATCH function. [More] [Less]
Tags:
 Embed:

Sort By

 Videos in "Excel Tips" category
 Using Tabular D... If you want to know how to make excel work with tabular data in a user friendly way then this video tutorial is for you. The first part of the tutorial describes use of the Excel INDEX function for ta... Using Tabular D... If you want to know how to make excel work with tabular data in a user friendly way then this video tutorial is for you. The first part of the tutorial describes use of the Excel INDEX function for ta... Handling Units ... How to make calculations with interchangeable units simply by the use of the XLC template. Excel Sprites f... Learn how to use Excel shapes with charts to create animations. Easy Excel Gann... How to make Gannt charts using the Excel REPT() function. In Cell Charts Make compact charts inside worksheet cells using Excel's REPT() function and Excel's conditional formatting. The Change Unit... ChangeUnits is the original natural syntax unit conversion add-in for Excel. ChangeUnits understands virtually any combination of units and automatically checks to make sure each conversion is valid. ... Using Excel tre... Use of the LINEST function to dynamically determine equation parameters for interpolation between data points. Reading graphic... Using Excel trendlines to generate equations from graphical or tabular data Matrix Operatio... Learn how to work with matricies using MS Excel. Making great sk...