Category Archives: Excel

Excel tools & tricks.

Introduction to Aspen Basic Engineering (Zyqad) and Database-Driven Design

Trouble with Aspen Basic Engineering,  formerly known as Aspen Zyqad? This post will help the new user get acquainted with the program. What is Aspen Basic Engineering/Zyqad? What is Database Driven Design? Aspen Basic Engineering is one of those database-driven … Continue reading

Print Friendly, PDF & Email
Share
Posted in Database-Driven Design, Drawings and Diagrams, Excel, Simulation & Thermodynamics | Tagged , , , , , , , , , , | 1 Comment

Format databases and tables with Magic/Replace

I found a free tool that will automatically, intelligently let you format tables of data or databases: Magic/Replace Basically, you feed it columns of data, and make a change to the first row. And then it will do it’s best … Continue reading

Print Friendly, PDF & Email
Share
Posted in Excel | Tagged , , , , | Leave a comment

Sparklines: Tiny Graphs to Show Lots of Data

Sparklines are a great little idea. We all know that a good picture is worth a thousand words. Similarly, sometimes there’s no substitute for a graph of some data. Sparklines are an attempt to get the power of graphs into … Continue reading

Print Friendly, PDF & Email
Share
Posted in Drawings and Diagrams, Excel | Tagged , , , | 1 Comment

Use VLOOKUP and HLOOKUP to use Data Tables in Calculations

Small Excel tip today: use the Excel functions VLOOKUP and HLOOKUP to allow you to use tables of data in your calculations. You can configure these commands to "look for the closest match" or to "only find an exact match" … Continue reading

Print Friendly, PDF & Email
Share
Posted in Excel | Tagged , , , , , | 1 Comment

Excel Chart Selector and Chart Cleaner

Want to create quick, clean, and appropriate Excel charts? Charts that show off your data in a smart way? Charts that get rid of grey backgrounds, huge labels, and annoying fluff? (Also known as chartjunk). Juice Analytics are so-called "information … Continue reading

Print Friendly, PDF & Email
Share
Posted in Excel | Tagged , , | Leave a comment