{"id":"6d0c2e83-3731-46c4-b981-762deb78fdb5","title":"Advanced Excel: Practicum — Tooling and Automation","description":"Advanced Excel: Practicum — Tooling and Automation is designed for career starters and switchers aged 25–34 who need a concrete, portfolio-ready result instead of abstract theory. Across 9 lessons and about 26 hours, the curriculum focuses on course orientation and outcomes, core concepts and mental models, and tools, setup, and learning environment; the final deliverable is a SQL query pack assembled with Jupyter, pandas and SQL.","contentLanguage":"en","coverUrl":"/course-covers/advanced-excel-practicum-tooling-and-automation-6200f651-bda.webp","createdAt":"2026-05-26T07:47:27.247Z","updatedAt":"2026-05-26T07:51:40.504Z","durationSeconds":93600,"authorId":"74dc022e-141c-487d-9730-f83c2103ab53","rating":4.4,"reviewCount":5,"expectedLessonsCount":9,"trailerUrl":null,"faq":[{"answer":"Basic familiarity is recommended. The opening block quickly aligns terminology and tools, then moves straight into hands-on implementation.","question":"Do I need prior experience?"},{"answer":"A comfortable pace is 3–5 hours per week. In total, the course includes 9 lessons and about 26 hours of guided work.","question":"How much time should I set aside each week?"},{"answer":"You will finish with a SQL query pack plus reusable materials built around Jupyter and pandas.","question":"What will I finish the course with?"}],"learningOutcomes":null,"requirements":null,"levels":["advanced"],"firstLessonFreePreviewEnabled":false,"certificateEnabled":true,"isPlatformCourse":false,"pricingTiers":[{"id":"standard","name":"Standard","price":119,"features":[],"highlighted":true}],"minPricingTierPrice":119,"bonuses":[],"status":"READY","archivedAt":null,"categoryId":"8426e212-0e70-4365-981a-f375e42464f6","lessons":[{"id":"ff627822-415b-4c86-9967-f36e414b2c93","title":"Advanced Excel: Practicum — Tooling and Automation — course orientation and outcomes","description":"Lesson 1 of 9 in Advanced Excel: Practicum — Tooling and Automation: work through course orientation and outcomes and turn the result into a reusable part of the final SQL query pack using Jupyter and pandas.","videoUrl":null,"videoFileName":null,"duration":10400,"position":0,"createdAt":"2026-05-26T07:47:27.247Z","updatedAt":"2026-05-26T07:47:27.247Z","courseId":"6d0c2e83-3731-46c4-b981-762deb78fdb5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"c2f2e706-acc1-47bf-92a0-16ce1c26cdb8","title":"Advanced Excel: Practicum — Tooling and Automation — core concepts and mental models","description":"Lesson 2 of 9 in Advanced Excel: Practicum — Tooling and Automation: work through core concepts and mental models and turn the result into a reusable part of the final SQL query pack using Jupyter and pandas.","videoUrl":null,"videoFileName":null,"duration":10400,"position":1,"createdAt":"2026-05-26T07:47:27.247Z","updatedAt":"2026-05-26T07:47:27.247Z","courseId":"6d0c2e83-3731-46c4-b981-762deb78fdb5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"e4c58c64-af00-4861-a83b-b118df564b6b","title":"Advanced Excel: Practicum — Tooling and Automation — tools, setup, and learning environment","description":"Lesson 3 of 9 in Advanced Excel: Practicum — Tooling and Automation: work through tools, setup, and learning environment and turn the result into a reusable part of the final SQL query pack using Jupyter and pandas.","videoUrl":null,"videoFileName":null,"duration":10400,"position":2,"createdAt":"2026-05-26T07:47:27.247Z","updatedAt":"2026-05-26T07:47:27.247Z","courseId":"6d0c2e83-3731-46c4-b981-762deb78fdb5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"52df45b0-10db-4cd2-9ee4-6762d9fe6549","title":"Advanced Excel: Practicum — Tooling and Automation — practical workflows and process design","description":"Lesson 4 of 9 in Advanced Excel: Practicum — Tooling and Automation: work through practical workflows and process design and turn the result into a reusable part of the final SQL query pack using Jupyter and pandas.","videoUrl":null,"videoFileName":null,"duration":10400,"position":3,"createdAt":"2026-05-26T07:47:27.247Z","updatedAt":"2026-05-26T07:47:27.247Z","courseId":"6d0c2e83-3731-46c4-b981-762deb78fdb5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"4cd1a773-5b37-4901-b1c9-be9c651b0422","title":"Advanced Excel: Practicum — Tooling and Automation — real cases and guided practice","description":"Lesson 5 of 9 in Advanced Excel: Practicum — Tooling and Automation: work through real cases and guided practice and turn the result into a reusable part of the final SQL query pack using Jupyter and pandas.","videoUrl":null,"videoFileName":null,"duration":10400,"position":4,"createdAt":"2026-05-26T07:47:27.247Z","updatedAt":"2026-05-26T07:47:27.247Z","courseId":"6d0c2e83-3731-46c4-b981-762deb78fdb5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"251d66ef-b13a-40ee-b170-e9462911b714","title":"Advanced Excel: Practicum — Tooling and Automation — project build and review","description":"Lesson 6 of 9 in Advanced Excel: Practicum — Tooling and Automation: work through project build and review and turn the result into a reusable part of the final SQL query pack using Jupyter and pandas.","videoUrl":null,"videoFileName":null,"duration":10400,"position":5,"createdAt":"2026-05-26T07:47:27.247Z","updatedAt":"2026-05-26T07:47:27.247Z","courseId":"6d0c2e83-3731-46c4-b981-762deb78fdb5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"2c126c8a-49b0-4500-b6d1-ac360a28eb86","title":"Advanced Excel: Practicum — Tooling and Automation — implementation, handoff, and next steps","description":"Lesson 7 of 9 in Advanced Excel: Practicum — Tooling and Automation: work through implementation, handoff, and next steps and turn the result into a reusable part of the final SQL query pack using Jupyter and pandas.","videoUrl":null,"videoFileName":null,"duration":10400,"position":6,"createdAt":"2026-05-26T07:47:27.247Z","updatedAt":"2026-05-26T07:47:27.247Z","courseId":"6d0c2e83-3731-46c4-b981-762deb78fdb5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"512a23b6-3cc9-42f1-b4a6-34f53eec5c0f","title":"Advanced Excel: Practicum — Tooling and Automation — troubleshooting and common pitfalls","description":"Lesson 8 of 9 in Advanced Excel: Practicum — Tooling and Automation: work through troubleshooting and common pitfalls and turn the result into a reusable part of the final SQL query pack using Jupyter and pandas.","videoUrl":null,"videoFileName":null,"duration":10400,"position":7,"createdAt":"2026-05-26T07:47:27.247Z","updatedAt":"2026-05-26T07:47:27.247Z","courseId":"6d0c2e83-3731-46c4-b981-762deb78fdb5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"193dafc3-212f-4b1e-bd1b-055bc146dcfe","title":"Advanced Excel: Practicum — Tooling and Automation — visualization and dashboards","description":"Lesson 9 of 9 in Advanced Excel: Practicum — Tooling and Automation: work through visualization and dashboards and turn the result into a reusable part of the final SQL query pack using Jupyter and pandas.","videoUrl":null,"videoFileName":null,"duration":10400,"position":8,"createdAt":"2026-05-26T07:47:27.247Z","updatedAt":"2026-05-26T07:47:27.247Z","courseId":"6d0c2e83-3731-46c4-b981-762deb78fdb5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"74dc022e-141c-487d-9730-f83c2103ab53","name":"Edward Holland","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/f5e415e5-96b4-4c5c-9e67-074de181eba2.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}