Excel for Engineers: Formulas, Data and Dashboards

Engineers, technicians, engineering students and job seekers who work with readings, test results, downtime logs or exports from PLC and SCADA systems. No Excel experience is assumed.

The lessons come from well-known Excel teachers, but every worked problem, practice task and question uses engineering data: tolerances, calibration points, tag paths, shift logs, downtime reasons and CSV exports from control systems. There are no invoices or sales figures.

No. Excel for the web is free with a Microsoft account and covers most modules; Excel 2021 or 2024 covers almost everything. Power Query folder imports and the shift-report project are written for Excel for Windows. Mac has fewer Power Query features, and macros do not run in Excel for the web. Copilot in Excel needs a Microsoft 365 plan that includes Copilot, and nothing in the course depends on it.

No. It is a practical course for engineering work, not preparation for a Microsoft exam, and EDWartens is not affiliated with Microsoft.

Yes. Every module, the notes, the project and the final assessment. The only paid item is the certificate, if you want it.

An EDWartens Certificate of Completion, issued when you pass the final assessment, with a number anyone can verify on our site. It is not a Microsoft certification.

About 12 hours of video lessons, notes and practice, taken at your own pace; the videos alone are about 9 hours. The optional project takes about 10 hours more.

You build the shift-report workbook for a packaging line. It imports a folder of daily SCADA exports with Power Query. It calculates downtime, stops, MTBF, MTTR and temperature excursions. It shows them on a dashboard with slicers, and refreshes and exports the report with one button. A complete sample pack shows the specification, tag list, calculation register, test record, procedure and a finished report.

No. The lab is optional practice. You can skip it whenever you like, and it never blocks your progress, the final assessment or your certificate.

Yes. Every lab level for this course opens in your browser, free, with nothing to install.

The Excel for Engineers: Formulas, Data and Dashboards course has 13 modules. It opens with "The Excel workspace, clean data entry and Tables", goes through "Cell references and core formulas", "Cleaning text, dates and times", "Conditional formatting and data validation" and "Macros, and the shift-report workbook" and ends with "Final Assessment". The full list with minutes is under "What you learn" on this page.

After the Excel for Engineers: Formulas, Data and Dashboards course: Lay out readings, tags and logs as tidy Excel Tables with named limits; Write formulas with relative, absolute and mixed references, ROUND and unit conversions; Check measurements against tolerances with IF and count them with COUNTIFS and SUMIFS. These are the practical outcomes the course is written around, and the final assessment of 15 questions checks them.

For the Excel for Engineers: Formulas, Data and Dashboards course, software: Microsoft Excel for Windows or Mac from Microsoft 365, or Excel 2021 or 2024. Excel for the web (free with a Microsoft account) covers most modules. Dynamic arrays need Microsoft 365, Excel 2021 or later; LAMBDA and TEXTSPLIT need Microsoft 365 or Excel 2024; Power Query folder imports and the shift-report project are written for Excel for Windows; Mac has fewer Power Query features, and macros do not run in Excel for the web. Copilot is not needed for any part of the course. Hardware: A Windows or Mac computer. A second monitor helps but is not needed. The course itself is free.

Excel for Engineers: Formulas, Data and Dashboards is rated beginner. Beginner to intermediate. For engineers, technicians, students and job seekers. You need to be able to use a computer and do basic arithmetic; no Excel experience is assumed, and experienced users can move quickly through the first modules. It is written for engineers, technicians and job seekers who work with readings, logs and plant data, and takes about 12.1 hours at your own pace.

Skills from the Excel for Engineers: Formulas, Data and Dashboards course (for example: lay out readings, tags and logs as tidy Excel Tables with named limits) are used in roles such as data analyst, data engineer, reporting analyst and business intelligence developer, and in engineer work. The course gives you practical evidence of the skill; it does not promise a job, and employers decide on experience and interview.