{"id":"bcaeb23d-e12b-4c7d-bbac-12dcb9624cdd","title":"Advanced Excel: Formulas and Dashboards — Complete — Confident Applied Level","description":"The course Advanced Excel: Formulas and Dashboards — Complete — 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 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-conf-f3c52fa7-6c5.webp","createdAt":"2026-05-26T07:46:35.455Z","updatedAt":"2026-05-26T07:51:40.454Z","durationSeconds":82800,"authorId":"f753da72-d809-49f8-8aee-dd2ec4f7f8f2","rating":4.7,"reviewCount":10,"expectedLessonsCount":9,"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 9 lessons and about 23 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":"62021c80-74cb-4809-bfc7-d7dff9409a7e","title":"Advanced Excel: Formulas and Dashboards — Complete — Confident Applied Level — course orientation and outcomes","description":"Lesson 1 of 9 in Advanced Excel: Formulas and Dashboards — Complete — 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":9200,"position":0,"createdAt":"2026-05-26T07:46:35.455Z","updatedAt":"2026-05-26T07:46:35.455Z","courseId":"bcaeb23d-e12b-4c7d-bbac-12dcb9624cdd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"6afd9b0b-f3a4-48d5-86fe-ed34c1b953ca","title":"Advanced Excel: Formulas and Dashboards — Complete — Confident Applied Level — data handling and preparation","description":"Lesson 2 of 9 in Advanced Excel: Formulas and Dashboards — Complete — 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":9200,"position":1,"createdAt":"2026-05-26T07:46:35.455Z","updatedAt":"2026-05-26T07:46:35.455Z","courseId":"bcaeb23d-e12b-4c7d-bbac-12dcb9624cdd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"4f05f283-842e-4514-ad3e-15e61836475e","title":"Advanced Excel: Formulas and Dashboards — Complete — Confident Applied Level — tools, setup, and learning environment","description":"Lesson 3 of 9 in Advanced Excel: Formulas and Dashboards — Complete — 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":9200,"position":2,"createdAt":"2026-05-26T07:46:35.455Z","updatedAt":"2026-05-26T07:46:35.455Z","courseId":"bcaeb23d-e12b-4c7d-bbac-12dcb9624cdd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"b29c41c6-926c-4e40-a0c0-bba0ce495b62","title":"Advanced Excel: Formulas and Dashboards — Complete — Confident Applied Level — queries, models, and structure","description":"Lesson 4 of 9 in Advanced Excel: Formulas and Dashboards — Complete — 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":9200,"position":3,"createdAt":"2026-05-26T07:46:35.455Z","updatedAt":"2026-05-26T07:46:35.455Z","courseId":"bcaeb23d-e12b-4c7d-bbac-12dcb9624cdd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"8f340694-3121-485d-914e-80eaaad790ea","title":"Advanced Excel: Formulas and Dashboards — Complete — Confident Applied Level — visualization and dashboards","description":"Lesson 5 of 9 in Advanced Excel: Formulas and Dashboards — Complete — 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":9200,"position":4,"createdAt":"2026-05-26T07:46:35.455Z","updatedAt":"2026-05-26T07:46:35.455Z","courseId":"bcaeb23d-e12b-4c7d-bbac-12dcb9624cdd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"c1e210c0-43df-427a-adfb-083c5bb00eba","title":"Advanced Excel: Formulas and Dashboards — Complete — Confident Applied Level — communication and stakeholder alignment","description":"Lesson 6 of 9 in Advanced Excel: Formulas and Dashboards — Complete — 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":9200,"position":5,"createdAt":"2026-05-26T07:46:35.455Z","updatedAt":"2026-05-26T07:46:35.455Z","courseId":"bcaeb23d-e12b-4c7d-bbac-12dcb9624cdd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"a04615e1-887a-4979-b457-2f58a118d02e","title":"Advanced Excel: Formulas and Dashboards — Complete — Confident Applied Level — project build and review","description":"Lesson 7 of 9 in Advanced Excel: Formulas and Dashboards — Complete — 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":9200,"position":6,"createdAt":"2026-05-26T07:46:35.455Z","updatedAt":"2026-05-26T07:46:35.455Z","courseId":"bcaeb23d-e12b-4c7d-bbac-12dcb9624cdd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"21f89bb1-79da-4a4f-ac0c-06be6eaa0e36","title":"Advanced Excel: Formulas and Dashboards — Complete — Confident Applied Level — metrics, quality, and decision criteria","description":"Lesson 8 of 9 in Advanced Excel: Formulas and Dashboards — Complete — Confident Applied Level: 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":9200,"position":7,"createdAt":"2026-05-26T07:46:35.455Z","updatedAt":"2026-05-26T07:46:35.455Z","courseId":"bcaeb23d-e12b-4c7d-bbac-12dcb9624cdd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"0473098c-4f8a-45e0-9fc9-e7711daed5a6","title":"Advanced Excel: Formulas and Dashboards — Complete — Confident Applied Level — implementation, handoff, and next steps","description":"Lesson 9 of 9 in Advanced Excel: Formulas and Dashboards — Complete — 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":9200,"position":8,"createdAt":"2026-05-26T07:46:35.455Z","updatedAt":"2026-05-26T07:46:35.455Z","courseId":"bcaeb23d-e12b-4c7d-bbac-12dcb9624cdd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"f753da72-d809-49f8-8aee-dd2ec4f7f8f2","name":"Brian Ramsey","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/5f2bef23-17b8-4dad-b8b6-4348a3d1d3e5.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}