• Spreadsheet Thinking and Principles of Effective Data Organization
• The application interface MS Excel: ribbon, tabs, quick access toolbar.
• Essential concepts: cells, worksheets, workbooks.
• Quick navigation methods and using shortcuts.
• Organizing data for efficiency: grouping and multiple copying.

• Entering data from various sources.
• Custom lists and series.
• Numeric, stylistic, and conditional formatting.
• Setting up data validation to prevent errors.
• Practical exercise: creating an organized workbook to track a project.

• Basic functions: SUM, AVERAGE, COUNT, MIN, MAX.
• Conditional functions: IF, AND, OR.
• Text functions: TRIM, CONCATENATE, UPPER, LOWER.
• Introduction to date functions: TODAY, NETWORKDAYS, DAYS.
• Practical exercise: using functions to generate reports.

• Creating and configuring pivot tables.
• Advanced sorting and filtering of data.
• Creating simple and interactive charts: bar, line, pie.
• Customizing charts for professional reports.
• Practical exercise: analyzing monthly sales and graphical visualization.

• Automatic highlighting of information (advanced conditional formatting).
• Creating templates for repetitive tasks.
• Using the VLOOKUP and XLOOKUP functions to retrieve information.
• Practical exercise: automating human resources records.
• Protecting Worksheets and Cells with Passwords and Editing Restrictions
• Protecting Workbooks and Managing Access with Passwords and Permissions

Topic 1: Introduction to Google Sheets

• Introduction to Google Sheets
• Interface and key tools
• Basic concepts: cells, sheets, and spreadsheets
• Creating and managing documents
• Differences and similarities between Microsoft Excel and Google Sheets

Topic 2: Working with Data in Google Sheets

• Entering and organizing data
• Data formatting
• Series and lists
• Sorting and filtering data
• Data validation

Topic 3: Formulas and Functions

• Using formulas in Google Sheets
• Common functions for calculations and data analysis
• Using functions to automate tasks
• Working with data to create reports

Topic 4: Collaboration in Google Sheets

• Sharing documents
• Working simultaneously with multiple users
• Managing access permissions
• Comments and collaborative editing
• Tracking and managing changes

Topic 5: Integrating Excel and Google Sheets

• Importing Excel files into Google Sheets
• Exporting Google Sheets documents
• Working with documents in different formats
• Practical use of Excel and Google Sheets

Topic 6: Review and Updates