BIM and Engineering Academy
Log in / Sign up
EGP $
Home Courses Browse all courses (A–Z) BIM MEP Infrastructure Irrigation Civil Architecture Project management Diplomas Infrastructure diplomas Civil diplomas Project management diplomas Architecture diplomas MEP diplomas Services Software Instructors Certificates Forum Contact us Book a support call

Project management · All levels

Excel Diploma for Engineers

20lessons
Excel Diploma for Engineers

About this course

The diploma consists of 3 courses

  • Excel Basic Course
  • Excel Advanced Course
  • Excel Advanced Techniques Course

The course is suitable for students from middle school and high school onward, all faculties, all engineering and accounting groups, business owners, master's and PhD students, and others.

About the Course

The course starts with you from scratch, from the software installation stage. It covers the basics of the software and how to modify them, then moves on to conditional formatting of cells, filtering and tabulating data, and ways to convert data into well-organized tables. Then we study logical and nested functions and solve many examples on them, and cover drop-down lists, how to add them, and their importance in making work easier and accessing data. With that, the basic stage is complete. After that, we study the second course, covering the advanced part, starting with macros and how to make use of them. Then we study the great feature that simplifies and improves the final output, which is pivot tables, along with data entry methods. Then we come to charts within the software and linking cells and relationships to each other. After that, we move to the third course, where linear programming is used along with some programming tools such as Solver & Goal Seek and other tools, and many examples are solved from a set of scientific references on Excel.

Course Follow-up System

The course consists of high-quality recorded videos that you can watch at any time that suits you and download to your device at any time, and they stay with you. Not only that, there is also a technical support team to answer your questions and inquiries at any time, for life, not just during the course period.

Software Used

(Microsoft Office 2019 )

What the participant gets

  • A copy of the Office 2019 suite, fully activated
  • A copy of all course videos, activated for life
  • A copy of all working files
  • A copy of 1 training projects + explanation books

At the end of the course, the participant receives a certificate accredited by the academy.

Related courses

$22 $40