Excel courses and tutorials
Excel is a software from Microsoft Office that allows you to create and edit spreadsheets for the following purposes:
- Data storage and organization. The main use of this tool is to be able to store data in bulk and organize it using rows, columns, filters, etc.
- Simple and complex calculations using formulas. Formulas not only allow simple arithmetic operations such as addition or subtraction, they also allow more complex operations such as searching for data within a range, logical operations, text manipulation, conditional sums, etc.
- Massive data import and export through formats such as .csv. Through different formats we can import to Excel or export data to external computer systems.
- Processing and manipulating complex data using pivot tables. Pivot tables allow us to organize, present, and summarize data through multiple methods.
- Visualization and presentation of data through dynamic graphics. These, in turn, are based on pivot tables and allow us to visualise data in various ways.
- Programming with macros for the development of complex tasks and the automation of repetitive tasks using the VBA language.
- Cloud collaboration using as a base OneDrive.
- Online access to the complete Office suite through Microsoft 365.
