What is Excel?
Microsoft Excel is a spreadsheet program used for handling
and manipulating numbers & data.
Spreadsheet is a table used to store various types of data.
The data is arranged in rows and columns to make it easier to store,
organize, and analyze the information.
Why Excel?
Using Excel as a calculator to explore what mathematical
equations can tell us about how the real world works for specific input
conditions or for a range of possible values.
- Graphically displaying equations (analytical models) and real data.
- Obtaining numerical solutions to more mathematically complex models.
- Graphically comparing results from a model and observations.
- Statistical analysis including mean, standard deviation, error bars on graphs, linear and polynomial fits, multivariate analysis, etc.
- Spectral analysis (Fast Fourier Transforms).
- Displaying histograms of students’ results or student response to exams or questions.
Using Microsoft Excel and VBA, a professional can accomplish
important tasks like:
- Rapid analysis and charting
- Advanced modeling including numerical simulation
- Automated report generation
- Problem optimization using Solver and Crystal Ball
- Software design
- Team and model integration
- Database communication and control
- Project command and control
- Project constraint monitoring
- Information command and control
- Multi-language programming with FORTRAN and C code (DLL's)
- Real time integration with other applications
- Data sorting and analysis
