{"id":"1d500891-d2b7-466f-abd3-483751fae6b3","title":"Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work","description":"The course Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work 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-complete-impl-f0db2ca0-cfb.webp","createdAt":"2026-05-26T07:46:12.204Z","updatedAt":"2026-05-26T07:51:40.456Z","durationSeconds":86400,"authorId":"19777a55-1598-40bf-867f-c9fb0b0bb2b8","rating":4.642857142857143,"reviewCount":56,"expectedLessonsCount":9,"trailerUrl":null,"faq":[{"answer":"Basic spreadsheet skills are recommended. The course starts with a clear ramp-up and then moves into implementation at work.","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 24 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":119,"features":[],"highlighted":true}],"minPricingTierPrice":119,"bonuses":[],"status":"READY","archivedAt":null,"categoryId":"8426e212-0e70-4365-981a-f375e42464f6","lessons":[{"id":"d2599a17-0499-4895-9568-8f6f2ff9ede2","title":"Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work — course orientation and outcomes","description":"Lesson 1 of 9 in Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work: 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":9600,"position":0,"createdAt":"2026-05-26T07:46:12.204Z","updatedAt":"2026-05-26T07:46:12.204Z","courseId":"1d500891-d2b7-466f-abd3-483751fae6b3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"b300e1fd-ce18-4632-afef-35f5b122f29d","title":"Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work — data handling and preparation","description":"Lesson 2 of 9 in Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work: 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":9600,"position":1,"createdAt":"2026-05-26T07:46:12.204Z","updatedAt":"2026-05-26T07:46:12.204Z","courseId":"1d500891-d2b7-466f-abd3-483751fae6b3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"2f23d719-743f-48f5-b021-0a654ca29456","title":"Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work — tools, setup, and learning environment","description":"Lesson 3 of 9 in Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work: 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":9600,"position":2,"createdAt":"2026-05-26T07:46:12.204Z","updatedAt":"2026-05-26T07:46:12.204Z","courseId":"1d500891-d2b7-466f-abd3-483751fae6b3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"de557333-16c7-4be5-b056-0d1551491aaa","title":"Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work — queries, models, and structure","description":"Lesson 4 of 9 in Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work: 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":9600,"position":3,"createdAt":"2026-05-26T07:46:12.204Z","updatedAt":"2026-05-26T07:46:12.204Z","courseId":"1d500891-d2b7-466f-abd3-483751fae6b3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"0784dec1-c364-4505-8654-d7c99a01fb21","title":"Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work — visualization and dashboards","description":"Lesson 5 of 9 in Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work: 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":9600,"position":4,"createdAt":"2026-05-26T07:46:12.204Z","updatedAt":"2026-05-26T07:46:12.204Z","courseId":"1d500891-d2b7-466f-abd3-483751fae6b3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"ab8898e4-a5bc-427c-beb4-52506517ce80","title":"Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work — communication and stakeholder alignment","description":"Lesson 6 of 9 in Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work: 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":9600,"position":5,"createdAt":"2026-05-26T07:46:12.204Z","updatedAt":"2026-05-26T07:46:12.204Z","courseId":"1d500891-d2b7-466f-abd3-483751fae6b3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"8d6a5aae-b2de-4488-815a-45b1abc70487","title":"Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work — project build and review","description":"Lesson 7 of 9 in Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work: 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":9600,"position":6,"createdAt":"2026-05-26T07:46:12.204Z","updatedAt":"2026-05-26T07:46:12.204Z","courseId":"1d500891-d2b7-466f-abd3-483751fae6b3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"f3f28877-ef1c-4cd3-80a5-67597c080955","title":"Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work — metrics, quality, and decision criteria","description":"Lesson 8 of 9 in Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work: 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":9600,"position":7,"createdAt":"2026-05-26T07:46:12.204Z","updatedAt":"2026-05-26T07:46:12.204Z","courseId":"1d500891-d2b7-466f-abd3-483751fae6b3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"8e0098ee-cd4f-49f8-a557-cd35e3111001","title":"Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work — implementation, handoff, and next steps","description":"Lesson 9 of 9 in Advanced Excel: Formulas and Dashboards — Complete — Implementation at Work: 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":9600,"position":8,"createdAt":"2026-05-26T07:46:12.204Z","updatedAt":"2026-05-26T07:46:12.204Z","courseId":"1d500891-d2b7-466f-abd3-483751fae6b3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"19777a55-1598-40bf-867f-c9fb0b0bb2b8","name":"James Fisher","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/273151b6-348c-49df-b70f-4f6514993d31.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}