Job Summary: We are seeking an expert instructor in EXCEL ADVANCED LEVEL to deliver a highly practical virtual course, integrating active pedagogical strategies and interactive tools. Key Highlights: 1. Expert Excel Advanced Instructor 2. Focus on active pedagogical strategies and gamification 3. Collaboration in training and educational innovation projects **Course Objective:** Deliver a course in which participants will develop and optimize advanced Microsoft Excel solutions using complex functions, data analysis tools, macro automation, and dynamic models to enhance decision-making, operational efficiency, and strategic information analysis within their workplace. **Job Description** We are seeking an experienced **expert instructor in EXCEL ADVANCED LEVEL**. The selected candidate will be responsible for delivering a 16-hour virtual course targeted at education professionals. The course will be highly practical (70%) with a theoretical component (30%), delivered virtually via **Microsoft Teams**. **Responsibilities** * Deliver a **16-hour** virtual course. * Prepare instructional materials (presentations, guides, hands-on exercises, gamified resources, and assessment tools). * Apply **active pedagogical strategies** and foster participation in a virtual environment. * Integrate activities using **interactive tools** (Mentimeter, Kahoot!, Wordwall, Blooket, among others). * Explain technical concepts of **EXCEL ADVANCED** clearly and accessibly to participants. * Prepare a final course report including evidence and academic documentation. **Proficiency in session-engagement tools such as:** * Mentimeter * Kahoot! * Wordwall * Blooket * Among others **Requirements** **Education:** * Completed bachelor’s degree or engineering degree in fields such as Computer Science, Systems, Administration, Accounting, Information Technologies, or related disciplines. **Experience and Knowledge:** * Proven experience as an instructor in advanced Excel topics. * Proficiency in **gamification and engagement platforms** (Kahoot!, Mentimeter, Wordwall, Blooket). * Knowledge of active methodologies and a focus on **practical learning**. * Demonstrated intermediate-level proficiency in Microsoft Excel, including logical and lookup functions, database management, pivot tables, and charts. * Minimum **2 years** of Excel experience in professional, academic, or business contexts. * Prior experience delivering training courses, workshops, or instruction online or in person. * Ability to teach synchronously using digital platforms such as Microsoft Teams. * Capacity to explain technical concepts clearly, practically, and results-oriented. * Communication skills, group facilitation, and real-time doubt resolution. * Emphasis on practical learning and immediate application of knowledge. **Skills:** * Clear communication and ability to adapt to non-technical audiences. * Creativity in designing interactive resources. * Leadership in virtual environments. * Results orientation and commitment to continuous improvement. **Position Details:** * **Modality:** Virtual (Microsoft Teams). * **Dates:** To be determined. * **Schedule:** To be determined. * **Duration:** 16 hours. * **Honorarium:** $6,000 MXN * **Preferred Age Range:** 30 to 50 years. **We Offer:** * Collaboration in **training and educational innovation projects**. * Opportunity to participate in future courses. * Potential for **continuity in national virtual training projects**. **Selection Process** * Review of CV and relevant course experience. * Presentation of a brief **sample lesson (10 minutes)** on a course topic (e.g., Macros or another advanced Excel topic). **Course Content:** **Module 1\. Review and Foundations for Advanced Level (2 hours)** * Best practices in Excel usage * Relative, absolute, and mixed references * Named ranges and their application * Advanced data validation **Module 2\. Advanced Functions (4 hours)** * Nested logical functions (IF, AND, OR, IFERROR) * Lookup and reference functions (XLOOKUP, INDEX, MATCH) * Advanced text functions * Date and time functions * Mathematical and statistical functions * Combined function usage **Module 3\. Data Analysis and Management (4 hours)** * Advanced pivot tables * Data slicers and timelines * Calculated fields and calculated items * Advanced sorting and filtering * Subtotals and outlines * Data consolidation **Module 4\. Information Visualization (2 hours)** * Advanced and customized charts * Dynamic charts * Advanced conditional formatting * Use of icons, color scales, and custom rules **Module 5\. Automation and Productivity (3 hours)** * Introduction to macros * Macro recorder * Basic macro editing in VBA * Automation of repetitive tasks * Macro security and best practices **Module 6\. Advanced Decision-Making Tools (1 hour)** * What-If Analysis * Goal Seek * Data tables * Scenario Manager * Introduction to Power Query and Power Pivot * Relative, absolute, and mixed references * Named ranges and their application * Advanced data validation Employment Type: Project-based or fixed-term contract Contract Duration: 2 days Salary: $375.00 per hour Application Question(s): * Are you registered as an external STPS training agent? * Do you agree with the economic offer published in this job posting? * Do you possess certificates, letters of recommendation, or other documents verifying your experience teaching this or related topics? Education: * Completed bachelor’s degree (Mandatory) Experience: * Microsoft Teams: 1 year (Mandatory) * Delivering courses virtually: 1 year (Mandatory) * Microsoft Excel Advanced: 2 years (Mandatory) Work Location: Remote