Home

 
 
 
  Top - Excel Tips
 
 
 

 
Using Tabular Data in Excel Calculations Part 1 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 1 of 2 - JohnDoyle[Admin] October 7th 2010 9:18

Please ask any questions here.
This video is also available on YouTube.
Login to write comment
 
 
 
 
 
About this video
 
 
Date :07 October 2010
Views :7663
Votes :0 Rating :0
Login to vote:
 
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...
 
 
Jump to: / 1
 

We have 8 guests and 37 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.

 

 

Google Analytics Alternative