Heat Exchangers Design & Calculation Excel Workbook

Design and analyze the performance of your heat exchanger in a professional manner with this valuable Excel Workbook

What You Will Learn in This Course

  • Design and analyze the performance of your heat exchanger
  • Select the appropriate shell and tube heat exchanger

What is Covered in This Course

This Heat Exchanger Excel Workbook provides well-organized technical data in the form of spreadsheet calculations, tables, charts, and diagrams, indispensable for anyone involved in the design, selection, operation, maintenance, or inspection of heat exchangers.

This Excel workbook presents formulae and data for:

      1. Physical properties of the most common fluids used in heat exchangers in Oil & Gas, Petroleum, Refining, and Chemical processes
      2. Heat transfer coefficients "U" and "α."
      3. Pressure losses in shell and tube heat exchangers (tube + shell sides)
      4. Useful shell and tube geometrical calculations
      5. Geometrical data of shell and tube heat exchangers according to DIN 28184 & 28191 and TEMA Standards
      6. Guidelines for the selection of shell and tube heat exchangers
      7. Thermal conductivity of the most common material for the construction of shell and tube heat exchangers
      8. Valuable heat exchanger charts, figures, and diagrams Numerous conversion tables
      9. And much more...


      1. We assume that Microsoft Excel is installed on your computer and that you have basic knowledge of using Excel.
      2. This Excel workbook includes Visual Basic for Application function subroutines. Macros must be enabled for them to work.


This Heat Exchanger Excel Workbook is provided by WR Training "as is," and any express or implied warranties, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose, are disclaimed. In no event shall the Copyright owner or contributors be liable for any direct, indirect, incidental, special, exemplary, or consequential damages (including, but not limited to, procurement of substitute goods or services, loss of use, data, or profits, or business interruption) however caused and on any theory of liability, whether in contract, strict liability, or tort (including negligence or otherwise) arising in any way out of the use of this Excel Workbook, even if advised of the possibility of such damage.

Learning objectives

      • Design and analyze the performance of your heat exchanger professionally with this valuable Excel Workbook
      • Select the appropriate shell and tube heat exchanger for your application
      • Get access to valuable shell and tube heat exchanger design tables according to DIN 21184 - 21191 and TEMA std to properly design shell and tube heat exchangers
      • Get access to useful charts and diagrams to solve daily heat exchanger problems

Course Curriculum

WR Training

WR Training is a group of professional engineers from various disciplines (chemical, petrochemical, mechanical, electrical…) providing academic and industrial online courses.

Whether you’re trying to learn and discover a new scientific or engineering topic from scratch, or want to refresh your memory on something you’ve learnt in the past, you’ve come to the right place.

WR Training exists to help you succeed in your academic and professional life. Our goal is to spread the knowledge and promote science.

The courses, you are about to enroll in, were undertaken to give you a clear view of scientific and engineering topics through detailed examples using hands on demo and provide numerous problems with their solutions. You can also use these courses as a review for taking exams or as a vehicle for self-instruction.

Our training methodology was designed to enable individual self paced e-learning.

Each course has been undertaken to teach a specific skill.

Our courses can be watched 24/7 wherever you are.

Each of our courses has a 30-day money-back guarantee so that you can check it out, make sure it’s the right course for you, and get a refund if it’s not.

We are active online instructors and we will be here for you every step of the way. If you have questions about the course content, you can always post your questions or send us a private message. It will be our pleasure to provide assistance and answer your questions.

So with no further ado, go ahead, select the course suitable for you, click the enroll button and we'll see you in the first section !

WR Training

Spread the wings of your knowledge

Dear Student, Please note that - "This Course is not Refundable" as it contains an Excel file that, once you download it, we cannot refund you.

Course Pricing

  • This Course
  • $24.99
  • Full Lifetime Access
  • Access on Mobile App
  • Certificate of Completion
  • Buy this Bundle
  • Pay In Indian Rupee
  • Net Banking / UPI / Debit Card
  • ₹1999
  • Buy this Bundle

Trusted by Engineers

Trusted by Engineers across the globe, more than 10,000  students enrolled as of 30th Jul 2022.

Grow Your Career

You will earn the experience that will help you to fast pace your career and makes you confident in the workplace.

Save Money

Save time and money as compared to offline courses. No travel, no leave from office. Learn at your convenience.

Lifetime Access

You will get lifetime access to the courses. Watch course videos as many times as you want.

Certificate of Completion

Get the course completion certificate to show your achievement.

100% Money Back Guarantee

30 Days No question asked 100% money-back guarantee