Excel Programming Weekend Crash Course

Thirty clearly defined lessons take the reader from understanding the parts of an Excel application into building applications to work with data, formulas, charts, and the enhanced XML capabilities of the new Excel "X". The book is designed to teach the core concepts of Excel over a weekend or in just fifteen hours, with each session being thirty minutes. It is applicable to Excel 2000, Excel 2002, and the latest release, Excel 2003. It helps Excel power users in fields, such as accounting, finance, operations management, and market research to begin automating data manipulation in Excel quickly, so they can handle real-world projects. It is a how-to guide to using Excel's programmability to create custom data-processing and analysis solutions. It covers security, debugging, and error handling. The companion Web site includes sample files, projects, and test enginewith self-assessment exam.