As engineers and geologists, we frequently use Excel charts to communicate data…but which chart types are the best at communicating data, and which ones should be avoided? This is one Excel charting expert’s views on the issue. [Source: Peltier Tech Blog. Image: Peltier Tech]
Related Articles
Using Excel statistical functions for trend analysis
VBA and Excel for Engineers and Scientists
Visual Basic for Applications or VBA used in conjunction with Microsoft Excel is a tool that many scientists and engineers have yet to take full advantage of. This article is the first in a series designed to provide you with the basic understanding of how to use VBA and Excel in your practice.
VBA and Excel for Engineers and Scientists – Part 2
In this long awaited second article in the series, I will dive into the meat of the VBA programming language, including code containers, data types, variables, math operators, built-in functions, flow control, and even debugging.. In the end, you should be able to code some fairly complex things including custom worksheet functions that you can use in your spreadsheet just like a regular formula. Also in this article I give you a sample spreadsheet with some useful utilities that you can use right away.