Wednesday, 8 May 2013



Suggested Books


Introduction



A week ago a blog reader (Hakim) asked my opinion about various books regarding Excel and VBA. After suggesting him some books, I had the idea of writing this post in order to get together all the books that I would like to recommend to anyone who is interested in. So, this list could be considered as “my favorite books’ list”.

In general, books are great source of information and, personally speaking, I really enjoy reading and learning new stuff. So, the list that you will find below contains some of the books that I have read in the past and I consider remarkable. Check them out and you might find a new book to read!



Engineering



Handbooks for various engineering topics


First of all, as a reference for many engineering subjects I use ASHRAE’s handbooks. They cover in detail many theoretical topics and they also contain practical information. If you are mechanical engineer these books are an excellent addition to your library:
The cross flow heat exchanger calculation workbook for example was based on the heat transfer chapter of ASHRAE’s Fundamentals.


Fuel cells


My diploma thesis was entitled: “Simulation of a hybrid Solid Oxide Fuel Cell / micro Gas Turbine power generation system”. During the calculation of the fuel cell performance the books below helped me a lot:


Gas turbines


When I was at Cranfield (for my M.Sc. studies), the following book was something like my “holy grail”. So, if you like to learn about gas turbines this book should be a good starting point:
However, when I was writing my M.Sc. thesis the following books have also helped me a lot:
At 2009, during a short course at Cranfield (“Gas turbine design and performance”) I had the pleasure to meet and discuss with professor Saravanamuttoo. He is an expert at his field and a really nice person.


Heat transfer & heat exchangers


For heat transfer, as well as heat exchangers the following book is definitely a must have:


Hydraulics


As a freelancer, I worked on the designing of several hydraulic projects (hydro power plants, open channels, pump stations etc.). The books that follow helped me solve various designing problems:


Internal combustion engines


Whenever I have a theoretical question about internal combustion engines this book has usually the answer:


Piping, welding & pressure vessels


When I was working at a refinery project (as a quality manager) I had to learn a lot of things about piping, welding, as well as pressure vessels. As it turned out, the books below were a good choice:


Renewable energy


The topic of renewable energy is enormous. As a freelancer I have elaborated a few studies about biomass and photovoltaic projects. The books below were a valuable source of information:



Office, AutoCAD & programming



Excel

If you want to learn basic and more advanced Excel topics, then John Walkenbach is your guy. I have learned a lot of things from his books.
Excel 2003 Bible
Excel 2003 Formulas


Excel & VBA



If you are new to VBA try starting with this. The title is quite misleading since the book can smoothly introduce you to the magic world of (Excel) VBA.
If you are not a VBA-newbie, you can read about more advanced topics in these books:
Finally, if you need a book to have it as a reference, try this:


Access


I started learning Access with this book. If you enjoy learning “visually” this books is a good start. However, I should point out that the book focuses on practical things (like how you will do something) and not on the theory behind it.


Access & VBA


For more advanced Access topics, as well as VBA, check these books:


AutoCAD


During my undergraduate studies, I started learning AutoCAD from scratch at my free time using this book.


AutoCAD & VBA


Since I was familiar with VBA programming (from Office), this book was quite good for expanding my VBA knowledge to the AutoCAD field.


Visual Basic .NET


My transition from pure Visual Basic/VBA to .NET started with this book. As the title implies the author guides you step by step to the .NET world. There is no need for previous programming knowledge, so I recommend it even to programming newbies.


FORTRAN


I had some basic FORTRAN training during my undergraduate studies. However, my M.Sc. thesis was actually a large FORTRAN application/algorithm for calculating the exhaust emissions from industrial gas turbines. Since I was not so advanced programmer in FORTRAN, I tried to find more resources; the book below helped me a lot:


HTML


To tell you the truth, I started learning HTML in order to customize this blog on my own. So, apart from various online tutorials (like this one) the following book was a good source of information:



Literature






OK, I know that this is not my cup of tea, but, from time to time I really enjoy reading some non-technical books. They help me escape from the “technical world” a little bit, so, here is my short list of well-known (literature) books:
Les Misérables
The Constant Gardener
Adventures Of Huckleberry Finn
The Adventures Of Tom Sawyer
Mystic River
The 60-Second Philosopher: Expand Your Mind On A Minute Or So A Day!



Epilogue



In my humble opinion, the above list contains some very interesting books. Although some of them might be outdated, it is quite possible that a newer version might be available. I would try to update this list whenever I find a book that – according to my standards – is worth-reading. A lot of my knowledge comes from these books, so I hope that this list will help you expanding your knowledge to new areas. Happy reading!

Did you like this post? If yes, then share it with your friends. Thank you!



Categories:


Mechanical Engineer (Ph.D. cand.), M.Sc. Cranfield University, Dipl.-Ing. Aristotle University, Thessaloniki - Greece.
Communication: tel. +30-6973513308, e-mail , Facebook , Twitter , Google+ and Linkedin. Full CV