Skip to main contentEngineering Courses, Mentoring & Jobs | EveryEng
Excel Intermediate: Enhance Productivity with Excel banner
Preview this course
Excel Intermediate: Enhance Productivity with Excel banner
Preview this course
Self-paced Intermediate

Excel Intermediate: Enhance Productivity with Excel

4(1584)
3 enrolled
96 views
FREE
69 min
Anytime
English
96 views
Team EveryEng
Team EveryEngMechanical Engineering
  • Lifetime access
  • Interactive Video Lessons
  • Learn from Industry Expert

Why enroll

  • Master intermediate Excel skills to supercharge productivity—sorting/filtering for quick data management, PivotTables for dynamic summaries.

  • Hands-on modules teach conditional formatting to spot trends/duplicates, charts for compelling visuals, data validation for error-proof inputs.

  • Perfect for professionals/students seeking Excel course, Excel dashboards, PivotTables tutorial, data analysis Excel.

  • Transform datasets into insights with practical YouTube-guided projects—no prior advanced knowledge needed.

  • Elevate your resume with skills employers demand: faster analysis, better presentations.

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

Learn to manage and analyze data effectively, create visuals, and improve data presentation.

Course suitable for

Key topics covered

Data Sorting and Filtering

  • Sorting data alphabetically or numerically. 

  • Using filters to display specific information. 

Conditional Formatting

  • Applying formatting rules based on cell values. 

  • Highlighting duplicates or outliers. 

Creating and Customizing Charts

  • Inserting bar, pie, and line charts. 

  • Customizing chart layouts, styles, and colors. 

Introduction to Pivot Tables

  • Summarizing data using Pivot Tables. 

  • Creating and filtering Pivot Charts. 

Data Validation

  • Setting rules for data entry (drop-down lists, error alerts). 

  • Ensuring consistency in large datasets. 

Course content

The course is readily available, allowing learners to start and complete it at their own pace.

5 modules6 lectures1 hr 9 min
  1. Data Sorting and Filtering
    17 min
  1. Conditional Formatting
    11 min
  2. Conditional Formatting 2
    6 min
  1. Creating and Customizing Charts
    9 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

Madhushree
Madhushree
Feb 25, 2026

Initially, I wasn’t sure what to expect from this course. Coming from a project engineering role in oil & gas, I had worked around estimates but never owned one end‑to‑end. The course helped close that gap, especially around EPC cost structure and how estimates are actually built during FEED versus detailed engineering. Specific sections on piping take‑offs and mechanical equipment costing were useful. Seeing how line lists, P&IDs, and basic equipment data feed into material quantities made things click. The breakdown of CAPEX into direct costs, indirects, contingency, and escalation was also relevant to upstream oil & gas projects I’ve supported, particularly for onshore facilities. One challenge was wrapping my head around indirect costs and how EPC contractors load engineering hours and construction management into the estimate. That part took a bit of rewatching and some trial and error applying it to a past project. A practical takeaway was learning a simple, repeatable way to build a cost estimate spreadsheet tied to a WBS. I’ve already started using that structure to sanity‑check contractor numbers on a small brownfield job. Overall, it felt grounded in real engineering practice.

Santosh Kumar vishwkarma
Santosh Kumar vishwkarma Student
Feb 25, 2026

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.

Avatar icon
Alireza Jannat
Feb 25, 2026

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.

EZHILARASAN K
EZHILARASAN K B.tech Chemical engineering
Feb 25, 2026

This course turned out to be more technical than I anticipated. Even though it’s marked beginner, it dives straight into how EPC cost estimation actually works in oil & gas projects. The sections on quantity take-offs and BOQ preparation were especially useful, along with breaking down CAPEX across piping, equipment, and bulk materials. Cost build-up for a typical refinery or gas processing unit felt close to what we see on live jobs. One challenge was getting comfortable with reading P&IDs and linking them to material take-offs. That took some rewinding, since my background is more on execution than front-end estimating. The explanation of contingency, escalation, and how EPC contractors price risk helped close a knowledge gap I’ve had for a while. A practical takeaway was learning a structured approach to building an estimate from FEED-level information, not just rough guessing. Parts of the course already helped while reviewing a budgetary estimate for a brownfield modification project. Some examples could have gone deeper, but overall it translated well to real project work. The content felt aligned with practical engineering demands.

FREE

Access anytime

Questions and Answers

Empty state icon

No questions yet - Be the first one to ask!