An introduction to excel for civil engineers

by Gunthar Pangaribuan 

Microsoft Excel is a spreadsheet program that is widely used for calculations. It is easy to operate and giving “complete” results by showing rows and columns sheet, images, text, tables, charts, and so on.

One of the strong points of Excel is its MACRO capability to shorten and simplify the repetitive works using Visual Basic Application (VBA) programming language.

At the next level macro can be developed to make useful application, such as structural analysis.
In general, in An introduction to excel for civil engineers you will learn:

1. Advancing Excel skills to a higher level by practicing VBA. The main goal is getting used to VBA macro and be able to enjoy it.

2. Using VBA to create user-defined functions.

Introducing LINEAR interpolation function that is one of the MOST USEFUL functions in civil engineering, alongside LOG and 3rd degree POLYNOMIAL interpolation function presented in this book.

3. Using VBA to automate Excel graph. It is GREAT TIME-SAVER for creating line graphs.

4. Using Excel for civil engineering applications, such as truss and frame analysis using matrix method.

5. The fastest way to create line graph in AutoCAD by automating the process with Excel.

An introduction to excel for civil engineers includes exercise files and VBA code examples that can be freely downloaded from the link inside.