Tag: EXCEL

Using Excel to Solve Statistical Problems A Practical Guide to the Book Statistics for Chemical and Process Engineers


Free Download Using Excel to Solve Statistical Problems: A Practical Guide to the Book "Statistics for Chemical and Process Engineers" by Yuri A.W. Shardt
English | PDF EPUB (True) | 2024 | 84 Pages | ISBN : 303165448X | 21.4 MB
This book provides a complete overview of how to use Excel to solve typical statistical problems in engineering. In addition to short sections on the required theory, the focus of the book is on detailed Excel examples for solving specific problems. Furthermore, solutions are provided for standard problems that can then be re-used and modified as necessary. End-of-chapter questions allow the reader to independently test the knowledge acquired.

(more…)

Data Validation Techniques in Microsoft Excel


Free Download Data Validation Techniques in Microsoft Excel
Released 9/2024
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Intermediate | Genre: eLearning | Language: English + subtitle | Duration: 24m | Size: 60 MB
In this course, you will learn how to effectively set up data validation rules for text, numeric, and date data, and configure static and dynamic drop-down lists, helping to maintain accurate and reliable employee and organizational databases.

(more…)

Python and Excel Integration – Essentials for Data Analytics


Free Download Python and Excel Integration – Essentials for Data Analytics
Published 9/2024
Created by Manan Khaneja
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 34 Lectures ( 9h 35m ) | Size: 8.41 GB
Master the synergy between Python and Excel, using some powerful libraries like OpenPyXL, XlsxWriter, and Pandas

(more…)