Excel Intermediate: Enhance Productivity with Excel
- Lifetime access
- Interactive Video Lessons
- Learn from Industry Expert
Why enroll
Your instructor
Team EveryEng
Engineer
Mechanical Engineering
Is this course for you?
You should take this if
- You work in Energy & Utilities or Automotive
- You're a Chemical & Process / Data Science & Analysis professional
- You have some foundational knowledge in the subject
- You prefer self-paced learning you can revisit
You should skip if
- You're looking for an introductory overview course
- You need a different specialisation outside Chemical & Process
- You need live interaction with an instructor
Course details
Course suitable for
Key topics covered
Course content
The course is readily available, allowing learners to start and complete it at their own pace.
- Data Sorting and Filtering17 min
- Conditional Formatting11 min
- Conditional Formatting 26 min
- Creating and Customizing Charts9 min
Opportunities that await you!
Career opportunities
Why people choose EveryEng
Industry-aligned courses, expert training, hands-on learning, recognized certifications, and job opportunities-all in a flexible and supportive environment.
What participants say about this course
Coming into this course, I had some prior exposure to the subject, mostly from seeing finite difference schemes buried inside larger tools. What was missing was a clear sense of how the equations actually turn into code. This course helped close that gap. The examples around 1D heat conduction translated well to an automotive context, especially thinking about temperature gradients in an engine block during warm-up. On the aerospace side, the discussion on spatial discretization and stability tied directly to past work I’ve done looking at simplified airflow and boundary-layer behavior on airfoils. Seeing how those problems are set up from scratch in Python was useful, not just academically. One real challenge was wrapping my head around stability limits and time step selection. The CFL condition tripped me up at first, and a couple of my early scripts blew up before I understood why. Working through that pain made the lessons stick. A practical takeaway was learning how to quickly prototype and sanity-check a finite difference solver instead of treating it like a black box. That’s already helping when reviewing simulation assumptions at work. The content felt aligned with practical engineering demands.
At first glance, the topics looked familiar, but the depth surprised me. The course walks through EPC cost estimation in a way that lines up reasonably well with how estimates are built in oil & gas projects, especially around FEED-level estimates and early CAPEX framing. Coverage of quantity takeoffs for piping and equipment, along with contingency setting, reflected what’s typically done under AACE Class 4 or 5 estimates. One challenge was translating the simplified examples into real-world scenarios like brownfield tie-ins, where labor productivity and indirect costs behave very differently than greenfield work. That edge case is usually where junior estimators struggle, and it took some effort to mentally map the course logic to those conditions. Escalation and vendor quote uncertainty were also presented cleanly, though actual market volatility tends to be messier than shown. A practical takeaway was the emphasis on documenting estimate basis and assumptions early, which helps later when scope creep or change orders hit. Compared to some industry practices that rush numbers for management, this structured approach supports better system-level cost control across the EPC lifecycle. I can see this being useful in long-term project work.
Coming into this course, I had some prior exposure to the subject, mainly from working alongside cost and planning teams on oil & gas EPC projects, but I never had formal training in cost estimation itself. This course helped close that gap, especially around how estimates are structured across different project phases like FEED and detailed engineering. The sections on CAPEX vs OPEX breakdowns and contingency estimation were particularly useful. I’ve seen these numbers in project reviews before, but understanding how they’re actually built up—from equipment take-offs to labor productivity assumptions—made a big difference. The discussion around estimating for upstream facilities versus downstream plants also reflected real-world differences I’ve encountered. One challenge was getting used to the terminology early on, especially the various estimate classes and accuracy ranges. It took some effort to connect the theory with how estimates evolve as scope matures. That said, working through examples helped anchor it. A practical takeaway was learning a basic framework for checking estimate sanity, which I’ve already applied when reviewing a contractor’s proposal. It’s not about building perfect estimates, but knowing what questions to ask. Overall, it felt grounded in real engineering practice.
Initially, I wasn’t sure what to expect from this course. Coming from a senior role in oil & gas EPC work, a “beginner” tag usually means oversimplification. That said, the way the course walked through early-stage CAPEX estimation was closer to how things actually start on real projects than I expected. The sections on equipment cost estimation and piping take-offs were grounded enough to resemble FEED-level work, especially the discussion around vendor budgetary quotes versus factored estimates. In practice, that distinction matters a lot when estimating process units like compressors or heat exchangers, where data quality varies wildly. One challenge was translating the simplified examples to brownfield projects; edge cases like tie-ins, demolition, and constrained layouts weren’t deeply covered, and those often skew costs more than expected. A practical takeaway was the emphasis on structuring estimates using a clear WBS tied to scope definition. That’s something many junior estimators miss, and it has real system-level implications when estimates roll up into overall project economics and approvals. Compared with industry practices, contingency handling was conservative but reasonable for early phases. The content felt aligned with practical engineering demands.