{"id":"76b8a8b5-4317-4030-aa85-5a5a40549416","title":"Advanced Excel: Formulas and Dashboards — Intensive — System and Results","description":"The course Advanced Excel: Formulas and Dashboards — Intensive — System and Results is designed for career starters and switchers aged 25–34 and turns the topic into a practical result instead of abstract theory. The program includes 9 lessons, applied work with Excel, pivot tables and XLOOKUP, and a final dashboard pack; the focus is data handling and preparation, tools, setup, and learning environment and queries, models, and structure.","contentLanguage":"en","coverUrl":"/course-covers/advanced-excel-formulas-and-dashboards-intensive-sys-8b9a07e4-0ad.webp","createdAt":"2026-05-26T07:46:42.906Z","updatedAt":"2026-05-26T07:51:40.470Z","durationSeconds":75600,"authorId":"88ffa8c4-bd76-4669-9a02-53aa9c8d8a49","rating":4.216666666666667,"reviewCount":60,"expectedLessonsCount":9,"trailerUrl":null,"faq":[{"answer":"Basic spreadsheet skills are recommended. The course starts with a clear ramp-up and then moves into system and results.","question":"Do I need prior experience?"},{"answer":"A comfortable pace is 4–6 hours per week. In total, the course includes 9 lessons and about 21 hours of guided study.","question":"How much time should I set aside each week?"},{"answer":"You will finish with a dashboard pack plus reusable materials built around Excel, pivot tables and XLOOKUP.","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":99,"features":[],"highlighted":true}],"minPricingTierPrice":99,"bonuses":[],"status":"READY","archivedAt":null,"categoryId":"8426e212-0e70-4365-981a-f375e42464f6","lessons":[{"id":"579f360c-d010-4a8b-b52a-663083172df3","title":"Advanced Excel: Formulas and Dashboards — Intensive — System and Results — course orientation and outcomes","description":"Lesson 1 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — System and Results: work through course orientation and outcomes in the context of Advanced Excel, and turn the result into a reusable part of the final dashboard pack using Excel and pivot tables.","videoUrl":null,"videoFileName":null,"duration":8400,"position":0,"createdAt":"2026-05-26T07:46:42.906Z","updatedAt":"2026-05-26T07:46:42.906Z","courseId":"76b8a8b5-4317-4030-aa85-5a5a40549416","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"e427db7c-fbe1-43e3-8c18-f07d157d4b22","title":"Advanced Excel: Formulas and Dashboards — Intensive — System and Results — data handling and preparation","description":"Lesson 2 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — System and Results: work through data handling and preparation in the context of Advanced Excel, and turn the result into a reusable part of the final dashboard pack using Excel and pivot tables.","videoUrl":null,"videoFileName":null,"duration":8400,"position":1,"createdAt":"2026-05-26T07:46:42.906Z","updatedAt":"2026-05-26T07:46:42.906Z","courseId":"76b8a8b5-4317-4030-aa85-5a5a40549416","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"9fe49ed1-8678-4e2b-a4e9-c15d9ffb650c","title":"Advanced Excel: Formulas and Dashboards — Intensive — System and Results — tools, setup, and learning environment","description":"Lesson 3 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — System and Results: work through tools, setup, and learning environment in the context of Advanced Excel, and turn the result into a reusable part of the final dashboard pack using Excel and pivot tables.","videoUrl":null,"videoFileName":null,"duration":8400,"position":2,"createdAt":"2026-05-26T07:46:42.906Z","updatedAt":"2026-05-26T07:46:42.906Z","courseId":"76b8a8b5-4317-4030-aa85-5a5a40549416","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"bfc19116-c6ac-4547-8c8b-d7dace17cbf3","title":"Advanced Excel: Formulas and Dashboards — Intensive — System and Results — queries, models, and structure","description":"Lesson 4 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — System and Results: work through queries, models, and structure in the context of Advanced Excel, and turn the result into a reusable part of the final dashboard pack using Excel and pivot tables.","videoUrl":null,"videoFileName":null,"duration":8400,"position":3,"createdAt":"2026-05-26T07:46:42.906Z","updatedAt":"2026-05-26T07:46:42.906Z","courseId":"76b8a8b5-4317-4030-aa85-5a5a40549416","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"101c48ab-a9e0-45bb-9ab4-ccd41acc6cb7","title":"Advanced Excel: Formulas and Dashboards — Intensive — System and Results — visualization and dashboards","description":"Lesson 5 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — System and Results: work through visualization and dashboards in the context of Advanced Excel, and turn the result into a reusable part of the final dashboard pack using Excel and pivot tables.","videoUrl":null,"videoFileName":null,"duration":8400,"position":4,"createdAt":"2026-05-26T07:46:42.906Z","updatedAt":"2026-05-26T07:46:42.906Z","courseId":"76b8a8b5-4317-4030-aa85-5a5a40549416","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"ecb966ab-e126-4ca8-8014-52ef385a5bc7","title":"Advanced Excel: Formulas and Dashboards — Intensive — System and Results — communication and stakeholder alignment","description":"Lesson 6 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — System and Results: work through communication and stakeholder alignment in the context of Advanced Excel, and turn the result into a reusable part of the final dashboard pack using Excel and pivot tables.","videoUrl":null,"videoFileName":null,"duration":8400,"position":5,"createdAt":"2026-05-26T07:46:42.906Z","updatedAt":"2026-05-26T07:46:42.906Z","courseId":"76b8a8b5-4317-4030-aa85-5a5a40549416","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"4159d526-3d5c-4166-a62a-ca72c479ba02","title":"Advanced Excel: Formulas and Dashboards — Intensive — System and Results — project build and review","description":"Lesson 7 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — System and Results: work through project build and review in the context of Advanced Excel, and turn the result into a reusable part of the final dashboard pack using Excel and pivot tables.","videoUrl":null,"videoFileName":null,"duration":8400,"position":6,"createdAt":"2026-05-26T07:46:42.906Z","updatedAt":"2026-05-26T07:46:42.906Z","courseId":"76b8a8b5-4317-4030-aa85-5a5a40549416","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"95ee6ee4-f8f7-4ee4-af9e-5c3033828116","title":"Advanced Excel: Formulas and Dashboards — Intensive — System and Results — metrics, quality, and decision criteria","description":"Lesson 8 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — System and Results: work through metrics, quality, and decision criteria in the context of Advanced Excel, and turn the result into a reusable part of the final dashboard pack using Excel and pivot tables.","videoUrl":null,"videoFileName":null,"duration":8400,"position":7,"createdAt":"2026-05-26T07:46:42.906Z","updatedAt":"2026-05-26T07:46:42.906Z","courseId":"76b8a8b5-4317-4030-aa85-5a5a40549416","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"7c22ee7a-d70b-4042-b8be-adede60bbf26","title":"Advanced Excel: Formulas and Dashboards — Intensive — System and Results — implementation, handoff, and next steps","description":"Lesson 9 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — System and Results: work through implementation, handoff, and next steps in the context of Advanced Excel, and turn the result into a reusable part of the final dashboard pack using Excel and pivot tables.","videoUrl":null,"videoFileName":null,"duration":8400,"position":8,"createdAt":"2026-05-26T07:46:42.906Z","updatedAt":"2026-05-26T07:46:42.906Z","courseId":"76b8a8b5-4317-4030-aa85-5a5a40549416","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"88ffa8c4-bd76-4669-9a02-53aa9c8d8a49","name":"Matthew Simmons","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/14d3d6f7-8699-4759-ad8b-3ef81d902107.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}