{"id":"b1477a5a-745c-400f-816d-deeb0dd889a4","title":"Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments","description":"The course Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments 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 8 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-starter-proje-5e64a39a-d52.webp","createdAt":"2026-05-26T07:45:57.809Z","updatedAt":"2026-05-26T07:51:40.488Z","durationSeconds":72000,"authorId":"69470c9f-9eab-4214-a8d4-cefbceefe5a5","rating":4.810810810810811,"reviewCount":37,"expectedLessonsCount":8,"trailerUrl":null,"faq":[{"answer":"Basic spreadsheet skills are recommended. The course starts with a clear ramp-up and then moves into projects and assignments.","question":"Do I need prior experience?"},{"answer":"A comfortable pace is 4–6 hours per week. In total, the course includes 8 lessons and about 20 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":79,"features":[],"highlighted":true}],"minPricingTierPrice":79,"bonuses":[],"status":"READY","archivedAt":null,"categoryId":"8426e212-0e70-4365-981a-f375e42464f6","lessons":[{"id":"2870f0ed-2fc1-4188-b9ca-72dfcdc69956","title":"Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments — course orientation and outcomes","description":"Lesson 1 of 8 in Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments: 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":9000,"position":0,"createdAt":"2026-05-26T07:45:57.809Z","updatedAt":"2026-05-26T07:45:57.809Z","courseId":"b1477a5a-745c-400f-816d-deeb0dd889a4","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"37dd85de-4be1-4387-a414-3e1c2b1c9958","title":"Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments — data handling and preparation","description":"Lesson 2 of 8 in Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments: 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":9000,"position":1,"createdAt":"2026-05-26T07:45:57.809Z","updatedAt":"2026-05-26T07:45:57.809Z","courseId":"b1477a5a-745c-400f-816d-deeb0dd889a4","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"9a3291ff-b3fe-4a60-a196-150a3a50eca6","title":"Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments — tools, setup, and learning environment","description":"Lesson 3 of 8 in Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments: 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":9000,"position":2,"createdAt":"2026-05-26T07:45:57.809Z","updatedAt":"2026-05-26T07:45:57.809Z","courseId":"b1477a5a-745c-400f-816d-deeb0dd889a4","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"1e8ae05a-0919-44d5-9d16-267ed590219d","title":"Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments — queries, models, and structure","description":"Lesson 4 of 8 in Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments: 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":9000,"position":3,"createdAt":"2026-05-26T07:45:57.809Z","updatedAt":"2026-05-26T07:45:57.809Z","courseId":"b1477a5a-745c-400f-816d-deeb0dd889a4","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"85fab13e-724a-4c5e-bfd7-dbe62291d422","title":"Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments — visualization and dashboards","description":"Lesson 5 of 8 in Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments: 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":9000,"position":4,"createdAt":"2026-05-26T07:45:57.809Z","updatedAt":"2026-05-26T07:45:57.809Z","courseId":"b1477a5a-745c-400f-816d-deeb0dd889a4","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"e30c1baf-9415-477f-ace6-080f84623818","title":"Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments — communication and stakeholder alignment","description":"Lesson 6 of 8 in Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments: 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":9000,"position":5,"createdAt":"2026-05-26T07:45:57.809Z","updatedAt":"2026-05-26T07:45:57.809Z","courseId":"b1477a5a-745c-400f-816d-deeb0dd889a4","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"9d7277af-f06e-4bae-81c9-d53c236c9d48","title":"Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments — project build and review","description":"Lesson 7 of 8 in Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments: 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":9000,"position":6,"createdAt":"2026-05-26T07:45:57.809Z","updatedAt":"2026-05-26T07:45:57.809Z","courseId":"b1477a5a-745c-400f-816d-deeb0dd889a4","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"cd06a56f-cea9-4e89-ba23-839ca59136e5","title":"Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments — implementation, handoff, and next steps","description":"Lesson 8 of 8 in Advanced Excel: Formulas and Dashboards — Starter — Projects and Assignments: 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":9000,"position":7,"createdAt":"2026-05-26T07:45:57.809Z","updatedAt":"2026-05-26T07:45:57.809Z","courseId":"b1477a5a-745c-400f-816d-deeb0dd889a4","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"69470c9f-9eab-4214-a8d4-cefbceefe5a5","name":"Noah Carter","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/62a904f1-e9b5-474e-b17c-e5f6177b2bb3.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}