Home ExcelCalcs News Excel Videos for Engineers
 Excel Videos for Engineers

If you want to know how to make excel work with tabular data in a user friendly way then our latest 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.

This is just one item in our Excel Tips series. Other subjects include:

• Using Sprites in Excel Charts - Learn how to use Excel shapes with charts to create animations.
• Easy Excel Gannt Charts - 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 for...
• The Change Unit add-in for Excel - ChangeUnits is the original natural syntax unit conversion add-in for Excel. ChangeUnits understands...
• Using Excel Trendlines - Use of the LINEST function to dynamically determine equation parameters for interpolation between da...
• Reading graphs - Using Excel trendlines to generate equations from graphical or tabular data
• Matrix Operations - Learn how to work with matricies using MS Excel.
• Making great sketches with Excel.

See the full series by following this link:

### Repository News

 Uploaded Repository Download and Author Discussion Links 2010 Oct. 17 Properties of Dry Air.xls by JohnDoyle 2010 Oct. 17 External Flow Over Cylinder.xls by JohnDoyle 2010 Oct. 17 Laminate Tool.xls by vaggar99 2010 Oct. 16 Newton-Raphson method by BABACAN 2010 Oct. 11 sezione_doppio_T.xls by pz79 2010 Oct. 06 Friction Resisting Motion by stuart1 2010 Oct. 06 Elastic Collision by stuart1 2010 Oct. 06 Inelastic collision by stuart1 2010 Oct. 06 Mass Moments of Inertia by stuart1 2010 Oct. 06 Bearing Capacity by JohnDoyle 2010 Oct. 06 Escape and Orbit Velocity by stuart1 2010 Oct. 06 Analysis of a slip on a long natural slope by stuart1 2010 Oct. 06 Analysis of gabions.xls by stuart1 2010 Oct. 06 Centripetal Force and Acceleration.xls by stuart1 2010 Oct. 06 Simple Harmonic Motion by stuart1 2010 Oct. 06 String Wave Solutions by stuart1 2010 Oct. 06 Single Slit Diffraction.xls by stuart1 2010 Oct. 06 Doppler Effect by stuart1 2010 Oct. 06 Car Crash Analysis by stuart1 2010 Oct. 06 Trajectories.xls by stuart1 2010 Oct. 06 Ballistic Pendulum by stuart1 2010 Oct. 06 Buoyancy and Drag by stuart1 2010 Oct. 06 AISC-Weld calculation for built up beams by boobathi 2010 Sep. 22 Mast Design by Akinola