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.