Excel and Google Sheets Training in Madrid, Spain

This training provides an in-depth guide to using Excel and Google Sheets for effective data analysis, management, and reporting. Participants will learn how to use advanced features of both tools for creating complex spreadsheets, automating tasks, analyzing data, and collaborating in real-time.

Day 1: Advanced Data Manipulation and Analysis

• Session 1: Advanced Functions and Formulas

  • Using VLOOKUP, HLOOKUP, INDEX/MATCH, and nested formulas.
  • Conditional functions: IF, SUMIF, COUNTIF, etc.
  • Text and date functions for data cleaning.

• Session 2: Data Validation and Conditional Formatting

  • Setting up data validation rules (dropdowns, date ranges, etc.).
  • Implementing conditional formatting to highlight trends and anomalies.
  • Creating custom rules for data integrity.

• Session 3: PivotTables and Data Summarization

  • Introduction to PivotTables for data summarization.
  • Grouping data and creating calculated fields.
  • Creating PivotCharts for visual data representation.

• Hands-On Lab:

  • Participants practice using advanced formulas, data validation, and PivotTables with real datasets.

Day 2: Automation, Visualization, and Collaboration

• Session 4: Creating Dashboards and Visualizations

  • Designing interactive charts and graphs.
  • Best practices for creating dynamic dashboards in both Excel and Google Sheets.
  • Using sparklines and advanced chart types for better insights.

• Session 5: Automating Tasks with Macros (Excel) and Google Apps Script (Google Sheets)

  • Introduction to recording macros in Excel.
  • Writing custom VBA code for task automation.
  • Using Google Apps Script to automate tasks in Google Sheets.

• Session 6: Collaboration and Sharing

  • Sharing and commenting on Google Sheets documents in real time.
  • Protecting data and managing permissions in both platforms.
  • Version history and collaboration best practices.

• Final Hands-On Lab:

  • Participants work on a final project, creating a dashboard, automating a task, and collaborating on a shared document.

This training equips participants with the advanced skills necessary to leverage Excel and Google Sheets for efficient data analysis, reporting, and collaboration in their daily tasks.