Physics of Magnetism, EMI, and AC with Excel Modeling

Understanding electromagnetism is essential for modern physics and engineering, but visualizing these dynamic forces can be a challenge. This text-only course bridges the gap by showing you how to model complex magnetic fields, electromagnetic induction (EMI), and alternating current (AC) circuits using the analytical power of Excel. You will start with the core foundational definitions of magnetic fields, moving charges, and Faraday's laws before translating these principles into practical, interactive spreadsheets. By working through structured text explanations and step-by-step formula construction, you will learn to build functional simulations that bring abstract physics equations to life. You will develop a deep intuitive grasp of how changing parameters impacts physical systems without needing expensive simulation software. What you'll learn: - Understand the foundational laws of magnetism, moving charges, and electromagnetic induction - Build Excel models to calculate and plot magnetic fields around conductors - Simulate alternating current circuits and analyze impedance, resonance, and phase relationships using spreadsheet formulas - Apply modern Excel dynamic arrays and advanced formulas to solve complex physics equations - Analyze transient behaviors in inductive circuits through step-by-step numerical approximations This course begins with a thorough introduction to electromagnetic theory and basic spreadsheet setup, gradually advancing to complex AC circuit analysis and dynamic data modeling. It is designed for students, educators, and science enthusiasts who want to deepen their physics knowledge through hands-on computational modeling. No advanced programming or prior Excel experience is required to begin. Start exploring the powerful intersection of physics and spreadsheet modeling today.