Start learning
My learning

The Complete Excel Course with AI Integration

Excel course for industrial engineers

Industrial engineers analysing time studies, line data and loss records can use this selection from The Complete Excel Course with AI Integration, which contains no factory data. It covers arithmetic and fixed references for standard times, conditional totals for line balancing and capacity, routing lookups, the full chart section, loss analysis with PivotTables and variance for before and after comparisons.

See the plans Watch free lessons

Taught by Sagnik Bhattacharya and Virginia Thorn

The Complete Excel Course with AI Integration: Sagnik Bhattacharya and Virginia Thorn

What you will be able to do

At work, you will be able to:

  • Calculate standard times from time study readings using AVERAGE, with the rating and allowance stored in fixed cells.
  • Use SUMIFS to total each station's work content, divide available time by demand for takt time, and apply IF to flag stations above takt when balancing a line.
  • Show station times alongside takt in a combo chart, then use a Pareto or waterfall chart to explain time losses.
  • Break down output and losses by line, shift and cause using PivotTables, with slicers and PivotCharts for comparison.
  • Measure before and after differences with variance and percent variance, and display changes in spread through histograms and box and whisker charts.
  • Retrieve routing table standard times with XLOOKUP, then use FILTER and SORTBY to produce station lists ordered by load.

Projects

What you will build.

The course has 14 projects. These four matter most here.

  • Nine Excel chart types from the Marketing Engagement Dashboard: combo, bar, funnel, Pareto, waterfall, histogram, box and whisker, sunburst and treemap.

    Project 04

    Marketing Engagement Dashboard

    Nine charts, each picked for the question it answers.

    Apply the charts to station times relative to takt, time losses arranged in Pareto order, and the spread of cycle times before and after a change.

  • Excel PivotTables and a PivotChart of sales data (SalesPlusPerformance): net sales by product category as a column chart, with State, Region and City filters.

    Project 05

    SalesPlusPerformance

    A sales question answered in seconds, straight from the order data.

    Start with a single records table to examine losses by line, shift and cause. Group records by date and compare shifts through slicers.

  • Budget vs actual dashboard in Excel (FinanceGuard): total budget, actuals and variance cards above a monthly line chart and a column chart by department.

    Project 09

    FinanceGuard

    The budget vs actual report finance teams send every month.

    This selection uses only the variance lessons: calculate before and after changes and percentage changes, with colour determined by the sign.

  • XLOOKUP formula in Excel (PeopleInsight): each employee row looks up its location from another sheet.

    Project 06

    PeopleInsight HR workbook

    Employee data joined across sheets with one formula.

    Adapt the employee lookups to operation codes, retrieving each step's standard time from a routing table in place of employee details.

Lessons

The lessons that matter, in course order.

The Complete Excel Course with AI Integration has 186 lessons. This page picks out 45 of them, 3 h 21 min of video. Each lesson keeps its number in the course.

Where to start

Lesson 8 Basic maths in Excel

If entering data and navigating a sheet are already familiar, start with Lesson 8: arithmetic and fixed references underpin standard times. Beginners should start with Lesson 1. If you already use SUMIFS and PivotTables, choose Lesson 48 for study charts or Lesson 118 for before and after comparisons.

45 of 186 lessons · 3 h 21 min

01 Microsoft Excel fundamentals: building a foundation from scratch 5 of 13 lessons · 19 min The personal budget exercises supply arithmetic for time standards: multiply observed time by a rating, keep an allowance in a fixed cell using an absolute reference, calculate percentages and handle failed division with IFERROR.
  1. 8 Start here Basic maths in Excel Add, subtract, multiply and divide with formulas 3 min
  2. 9 SUM and AutoSum in Excel Total income, expenses and savings with MAX 6 min
  3. 10 Relative vs absolute references in Excel Dollar signs and mixed references 3 min
  4. 11 Calculating percentages in Excel Each expense as a percentage of income 2 min
  5. 12 Common Excel errors and how to fix them DIV0, NAME, VALUE errors and IFERROR 4 min
02 Project: personal budget tracker 1 of 5 lessons · 4 min Practise SUM and AVERAGE, then apply the mean to a series of observed cycles as the starting point for calculating a standard time.
  1. 14 SUM and AVERAGE in Excel Personal budget tracker totals and average expense 4 min
04 Essential formulas and functions (IF, SUMIF and more) 10 of 13 lessons · 59 min Sales examples teach functions for engineering analysis: COUNT counts readings, SUMIF and SUMIFS total station work content or hours by machine and shift, and IF and IFS flag stations above takt or label results. AND and OR combine two conditions.
  1. 28 Logical functions in Excel TRUE and FALSE comparisons for beginners 5 min
  2. 29 The IF function in Excel Pass or fail results with a single condition 3 min
  3. 30 IF function practice in Excel Categorise sales data with IF formulas 6 min
  4. 31 Nested IF and IFS in Excel Customer value tiers with nested IF 6 min
  5. 32 Nested IF and IFS in Excel Sales performance labels with the IFS function 5 min
  6. 33 AND and OR with IF in Excel Flag high-value deals with multiple conditions 8 min
  7. 34 SUM, COUNT and COUNTA in Excel SUM with FILTER and counting numbers with COUNT 7 min
  8. 35 SUM, COUNT and COUNTA in Excel COUNTA, unique counts and completeness checks 4 min
  9. 36 SUMIF and COUNTIF in Excel Conditional sum and count with one criterion 8 min
  10. 37 SUMIFS and COUNTIFS in Excel Sum and count with multiple criteria 7 min
06 Data visualisation: charts and graphs 9 lessons · 45 min Work through the full chart section to compare station times with takt using column and combo charts, follow trends with line charts, and use sparklines. Pareto and waterfall charts explain losses; histograms and box and whisker charts describe cycle time spread.
  1. 48 Choosing the right Excel chart Column, line, pie, combo and modern chart types 4 min
  2. 49 Column charts in Excel Insert, format and label a column chart 5 min
  3. 50 Line charts in Excel Show trends over time with a line chart 4 min
  4. 51 Pie charts in Excel Show proportions and parts of a whole 4 min
  5. 52 Combo charts in Excel Column and line chart with a secondary axis 4 min
  6. 53 Formatting charts in Excel Titles, data labels, colours and chart styles 7 min
  7. 54 Sparklines in Excel Line, column and win-loss mini charts in cells 5 min
  8. 55 Funnel, Pareto and waterfall charts in Excel Modern charts for business data 5 min
  9. 56 Histogram, box and whisker, treemap and sunburst Advanced Excel chart types 6 min
07 PivotTables and PivotCharts: data analysis made easy 10 lessons · 33 min Apply the sales order lessons to production or study records: summarise output and losses by line, shift and cause in PivotTables, group by date, and explore the results with slicers and PivotCharts.
  1. 57 PivotTables 101 in Excel What a PivotTable does and the sales dataset 5 min
  2. 58 Preparing data for PivotTables Clean data with TRIM, PROPER, find and replace 5 min
  3. 59 Create your first PivotTable in Excel Insert a PivotTable from a sales table 1 min
  4. 60 PivotTable fields in Excel Rows, values, columns and Value Field Settings 2 min
  5. 61 PivotTable summaries in Excel Sales by product category and grouping by date 4 min
  6. 62 Slicers in Excel Filter PivotTables with clickable buttons 3 min
  7. 63 PivotCharts in Excel Create interactive charts from a PivotTable 5 min
  8. 64 PivotTable design Tab Report layouts, PivotTable styles and number formats 5 min
  9. 65 Refresh a PivotTable in Excel Update pivots when source data changes 2 min
  10. 66 Excel Ninja Challenge PivotTable sales by region, category and monthly trend 1 min
08 Advanced Excel functions: lookups, text and arrays 5 of 12 lessons · 21 min Transfer the employee lookup examples to routing tables. XLOOKUP, VLOOKUP and INDEX and MATCH can retrieve standard times using operation or product codes, while IFERROR handles a missing code.
  1. 67 Lookup functions in Excel The PeopleInsight HR dataset and why lookups matter 2 min
  2. 68 VLOOKUP in Excel Find employee data across sheets with exact match 4 min
  3. 69 XLOOKUP in Excel Exact match, if not found and two-way lookup 6 min
  4. 70 IFERROR in Excel Handle lookup errors in VLOOKUP and XLOOKUP formulas 3 min
  5. 71 INDEX and MATCH in Excel A flexible alternative to VLOOKUP 6 min
08 Advanced Excel functions: lookups, text and arrays 3 of 12 lessons · 15 min Build station or machine lists with UNIQUE, select entries above a limit with FILTER, and arrange them by load using SORT and SORTBY.
  1. 75 UNIQUE function in Excel Extract a distinct list with dynamic arrays 6 min
  2. 76 FILTER function in Excel Dynamic array filtering with AND and OR criteria 5 min
  3. 77 SORT and SORTBY in Excel Sort data dynamically with formulas 4 min
12 Project: FinanceGuard budget variance analyser (budget vs actual Excel dashboard) 2 of 10 lessons · 6 min Use the budget versus actual comparisons to understand variance and percent variance for an improvement's before and after results. Custom number formats colour each change according to its sign.
  1. 118 Budget variance in Excel Calculate variance and percent variance 4 min
  2. 119 Custom number formats in Excel Show budget variances with colours and signs 2 min

Instructors

Who teaches it.

Virginia Thorn smiling at the camera, dark hair tied back, wearing a navy top.

Instructor, Excel with AI

Virginia Thorn

Emmy Award winner. Teaches Excel with AI at Coding Liquids.

Questions

Asked before starting.

Which Excel course should an industrial engineer choose?

The Complete Excel Course with AI Integration from Coding Liquids covers spreadsheet skills that industrial engineers can apply at work. Use AVERAGE and fixed allowances for time study standard times, SUMIFS for station work content, and combo charts to compare station times with takt. PivotTables and Pareto charts support loss analysis, while variance, histograms and box and whisker charts support before and after comparisons. This page selects 45 lessons, taking 3 hours 21 minutes.

Can industrial engineers use this course for time studies and line balancing in Excel?

The Complete Excel Course with AI Integration supplies the formulas; industrial engineers must supply the method, as no lesson specifically teaches time study. Average observed cycles with AVERAGE and hold a rating or allowance in a fixed cell through an absolute reference. For line balancing, SUMIFS totals work content by station, division calculates takt time, IF identifies stations above takt, and a combo chart compares station times with a takt line.

Does this course cover simulation, Solver or MTM for industrial engineers?

No. Industrial engineering methods are outside the scope of The Complete Excel Course with AI Integration, which teaches Excel. It does not teach simulation, Solver optimisation, layout software or predetermined time standards such as MTM. Its formulas, PivotTables and built-in Excel chart types support the analysis and charts that accompany those methods.

How can an industrial engineer present the results of an improvement project?

Place the before and after results alongside each other and apply the techniques in The Complete Excel Course with AI Integration. FinanceGuard teaches variance and percent variance, with custom number formats to colour gains and losses. Use a histogram or box and whisker chart to show changes in cycle time spread, and a waterfall chart to show where time now goes. The teaching examples use budgets and sales figures.

Can an industrial engineer model machine and shift capacity with this course?

Yes. Apply the lookups and conditional totals taught in The Complete Excel Course with AI Integration: retrieve each product's standard time from a routing table with XLOOKUP, then multiply by planned quantity to calculate the hours required for each job. Total those hours by machine and shift with SUMIFS and divide by available hours to express load as a percentage. A PivotTable can also present that view by machine.

Excel with AI

See the whole course.

The Complete Excel Course with AI Integration: 16 hours of video in 186 lessons, built around 14 projects, with lifetime access, a Certificate of Completion and a 14-day money-back guarantee.

See the plans Watch free lessons

The same course

For another job, level or topic.

By job

Finance and accounting
HR and office administration
Operations and supply chain
Data and reporting
Sales, marketing and customer service
Business and management
Engineering, construction and manufacturing
Retail, property and hospitality
Healthcare and life sciences
Education and careers
Public sector, non-profit and legal
Technology

By level and topic