Physics: a workshop in Excel

In the workshop, the program codes of user-defined VBA Excel functions are presented; it is shown how these functions are used to solve typical problems of elementary physics on a computer. The textbook includes problems in kinematics, dynamics, statics, molecular kinetic theory, thermal phenomena and electrodynamics. Each chapter includes: brief information on physics; code for one or more user functions and their description; step-by-step solutions to typical problems using user functions, illustrated with drawings of dialog boxes, fragments of worksheets, etc., made using screenshots. Meets the requirements of the federal state educational standards of secondary vocational education of the latest generation. It is intended for students of secondary vocational education institutions studying physics, but it will be useful for anyone who wants to learn how to solve problems in elementary physics at a modern level — on a computer using Excel.