Introductory Excel for Scientists and Engineers
- 7 hours on-demand video
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- Differential Equations and applications
- Numerical Methods for solving differential equations in realistic circumstances
- Statistics for the Sciences with only simple spreadsheet software
- Good knowledge of basic algebra
- Some experience with calculus is helpful but not essential
- Excel or any equivalent spreadsheet software
This course is designed to teach you the broad outlines of modern computational physics using no programming or coding whatsoever. To do this, we'll use the sort of tool almost everyone has installed on their machines: spreadsheet software. Excel, WPS, Libreoffice, any will do. We're going to see that just the capacity to add in formulas and iteratively calculate across your worksheet is enough to achieve spectacular things.
This course is split into two sections, representing the most common uses of computing for students of the sciences and engineering:
We're going to use modern techniques, especially variants of the finite difference method, to find solutions to differential equations numerically without any expensive or complicated specialist software.
Higher Order Equations
While for advanced applications like fluid dynamics this must be extended, these topics provide a good grounding of the fundamentals for all modern methods.
If you have experimental data, interpreting its meaning can be complicated and prone to mistakes that can destroy the validity of your whole experiment! We're going to look at the tools common spreadsheet software has available to us to fit distributions, extract statistical details and test hypotheses.
The Mean and Standard Deviation
The Weibull Distribution
This course is not a substitute for a degree in applied mathematics or specialist consultancy, by purchasing this course you agree that the course instructor is in no way liable for any disputes, claims, losses, injuries, or damage of any kind that might arise out of or relate to the content of this course or any supporting communications between instructor and student.
- Scientists and Engineers looking to learn the power of computational physics using only simple spreadsheet software