Moreover, I learned how to create my own VBA macros, add controls to worksheets, and tried working with Excel events. While working with these applications, I learned Excel skills such as conditional formatting, sparklines, autocomplete, analysis pack, and Power Query add-in, and discovered the analytical power of PivotTables and Power Pivot Data Models. It becomes possible to work with Excel files both on a computer and from a mobile device. Closely integrated with Office Online and Microsoft OneDrive, Excel offers advanced spreadsheet collaboration and real-time data editing. Microsoft Office Excel provides economic and statistical calculations, graphics tools, and macro programming language Visual Basic for Applications (VBA).
The program provides data visualization tools in charts of multiple types: line tables, bar graphs, pie, scatter, block, and more complex schemes for in-depth analysis.