{"id":"597057b1-2015-41fc-a107-c9540bdc7602","title":"Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level","description":"The course Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level 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-applied-confi-ad3c4826-7e8.webp","createdAt":"2026-05-26T07:46:30.237Z","updatedAt":"2026-05-26T07:51:40.433Z","durationSeconds":68400,"authorId":"d921770b-dfb9-4eff-aea9-7ea124c63f29","rating":4.6,"reviewCount":5,"expectedLessonsCount":8,"trailerUrl":null,"faq":[{"answer":"Basic spreadsheet skills are recommended. The course starts with a clear ramp-up and then moves into confident applied level.","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 19 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":"9fe2330c-f507-4f73-9786-cd0da84c7dba","title":"Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level — course orientation and outcomes","description":"Lesson 1 of 8 in Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level: 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":8550,"position":0,"createdAt":"2026-05-26T07:46:30.237Z","updatedAt":"2026-05-26T07:46:30.237Z","courseId":"597057b1-2015-41fc-a107-c9540bdc7602","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"20cf891a-cb75-46d5-967d-d0bbe77e07c3","title":"Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level — data handling and preparation","description":"Lesson 2 of 8 in Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level: 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":8550,"position":1,"createdAt":"2026-05-26T07:46:30.237Z","updatedAt":"2026-05-26T07:46:30.237Z","courseId":"597057b1-2015-41fc-a107-c9540bdc7602","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"eb8441b5-f842-4d90-afb9-403800f31c5a","title":"Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level — tools, setup, and learning environment","description":"Lesson 3 of 8 in Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level: 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":8550,"position":2,"createdAt":"2026-05-26T07:46:30.237Z","updatedAt":"2026-05-26T07:46:30.237Z","courseId":"597057b1-2015-41fc-a107-c9540bdc7602","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"0bf120e7-aba8-476f-b265-68f523f358d7","title":"Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level — queries, models, and structure","description":"Lesson 4 of 8 in Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level: 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":8550,"position":3,"createdAt":"2026-05-26T07:46:30.237Z","updatedAt":"2026-05-26T07:46:30.237Z","courseId":"597057b1-2015-41fc-a107-c9540bdc7602","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"6ee0f153-1d1e-4606-8ec8-8b5a8861c5bc","title":"Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level — visualization and dashboards","description":"Lesson 5 of 8 in Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level: 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":8550,"position":4,"createdAt":"2026-05-26T07:46:30.237Z","updatedAt":"2026-05-26T07:46:30.237Z","courseId":"597057b1-2015-41fc-a107-c9540bdc7602","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"aca574c9-5fad-45c6-a3c8-1f164ac03555","title":"Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level — communication and stakeholder alignment","description":"Lesson 6 of 8 in Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level: 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":8550,"position":5,"createdAt":"2026-05-26T07:46:30.237Z","updatedAt":"2026-05-26T07:46:30.237Z","courseId":"597057b1-2015-41fc-a107-c9540bdc7602","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"b77bd727-c817-4c3c-85e2-fc875810cfc3","title":"Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level — project build and review","description":"Lesson 7 of 8 in Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level: 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":8550,"position":6,"createdAt":"2026-05-26T07:46:30.237Z","updatedAt":"2026-05-26T07:46:30.237Z","courseId":"597057b1-2015-41fc-a107-c9540bdc7602","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"908a2876-9ebb-4a10-a85c-7bbd263f5876","title":"Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level — implementation, handoff, and next steps","description":"Lesson 8 of 8 in Advanced Excel: Formulas and Dashboards — Applied — Confident Applied Level: 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":8550,"position":7,"createdAt":"2026-05-26T07:46:30.237Z","updatedAt":"2026-05-26T07:46:30.237Z","courseId":"597057b1-2015-41fc-a107-c9540bdc7602","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"d921770b-dfb9-4eff-aea9-7ea124c63f29","name":"Adam Parker","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/c8ac5215-7a5e-4fbc-ba06-e46c57e9a979.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}