Demonstrated the broad capabilities of Microsoft Office Excel 2010 for creating applications using VBA, working with macros, OOP technology, designing the user interface and forms. The issues of automation of operations with a worksheet and a diagram are considered, including when processing and analyzing data and making decisions. Describes methods for integrating office applications, working with the Internet and databases, and using XML. The book contains more than 300 examples of carefully designed applications: from creating custom functions to building information systems for collecting and processing data, the program code of which can be directly used by the reader when developing their own projects.