Welcome to my repository of exercises completed during the Advanced Course in Excel, organized by the Confederació Empresarial Comarcal de Terrassa (CECOT). In this repository, you'll find various Excel programs and exercises designed to enhance data analysis and spreadsheet skills.
This advanced Excel course focused on improving skills related to data manipulation, analysis, and visualization. Throughout the course, we worked on practical exercises that involved real-world data scenarios, empowering us to use Excel as a powerful tool for decision-making.
In this exercise, we learned how to analyze large datasets using functions like VLOOKUP, INDEX, and MATCH. We practiced cleaning data and extracting meaningful insights through various analytical techniques.
This exercise covered the creation and manipulation of Pivot Tables to summarize and analyze data efficiently. We learned how to group data, filter information, and present our findings in a visually appealing format.
We explored complex formulas and nested functions to perform advanced calculations. This exercise emphasized using logical functions like IF, AND, and OR to create dynamic spreadsheets.
In this exercise, we delved into automation by creating and recording macros to streamline repetitive tasks. We learned how to use VBA (Visual Basic for Applications) to enhance our Excel applications.
We designed interactive dashboards to visualize key metrics and performance indicators. This exercise focused on using charts, slicers, and conditional formatting to create dynamic and user-friendly dashboards.
To use the exercises in this repository:
- Clone the repository to your local machine:
git clone https://github.com/Tutusaus/Excel.git
- Open the Excel files using Microsoft Excel or any compatible spreadsheet software.
- Follow the instructions provided in each exercise to replicate the work or build upon it for your own projects.
This project is licensed under the MIT License - see the LICENSE file for details.
Feel free to reach out if you have any questions or need further clarification on any of the exercises!