Microsoft Excel is suitable for solving various tasks related to storing, processing, and analyzing data sets. The program offers modern tools for creating simple and pivot tables, importing information, performing calculations using complex mathematical formulas, analyzing statistics, and visualizing it in graphs and charts. It also allows you to automate repetitive operations and calculations using VBS scripts. It is possible to create spreadsheets in Excel from templates or from scratch. The program contains many ready-made document templates, including various invoices, reports, journals, expense sheets, and invoices. Users can design the required Excel diagrams themselves and save them in XLTX format. Microsoft Excel has the necessary set of tools for analyzing large amounts of data imported into the application from various external sources: databases, web services, CSV files, and XML.
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. Microsoft Office Excel provides economic and statistical calculations, graphics tools, and macro programming language Visual Basic for Applications (VBA). Closely integrated with Office Online and Microsoft OneDrive, Excel offers advanced spreadsheet collaboration and real-time data editing. It becomes possible to work with Excel files both on a computer and from a mobile device.
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. Moreover, I learned how to create my own VBA macros, add controls to worksheets, and tried working with Excel events. To gain the necessary skills, I worked with sample workbook files that can be downloaded from the Microsoft website.