Home arrow ExcelCalcs News arrow Excel Videos for Engineers
Excel Videos for Engineers
Monday, 18 October 2010

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.

Using Tabular Data in Excel Calculations Part 2 of 2

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

This month we are particularly grateful to Stuart Gaunt a Civil Engineering student from Nottingham University in the UK. He uploaded enough content to earn a listing as a featured author. Remember that XLC ED subscribers can view the calculations online but you will need an XLC Pro subscription to  download them. An Excel Pro subscription gives you access to downloads for one year and unrestricted use of our XLC software. It only costs $90 for which we’ll do our level best to help you make great calculations to solve all your technical problems. Review your subscription...

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

Please sign in or register to add a comment.

We have 9 guests and 36 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.