{"id":"f7025f64-1958-4caf-85d4-6b9221af5fbd","title":"Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases","description":"The course Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases 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-ste-4a302966-8d5.webp","createdAt":"2026-05-26T07:45:50.002Z","updatedAt":"2026-05-26T07:51:40.468Z","durationSeconds":75600,"authorId":"86165a36-0cec-4b92-ab3f-936c7b0d3851","rating":4.866666666666667,"reviewCount":15,"expectedLessonsCount":9,"trailerUrl":null,"faq":[{"answer":"Basic spreadsheet skills are recommended. The course starts with a clear ramp-up and then moves into step-by-step cases.","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":"fb51e0d2-f61a-44ed-9239-7f0e6308734f","title":"Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases — course orientation and outcomes","description":"Lesson 1 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases: 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:45:50.002Z","updatedAt":"2026-05-26T07:45:50.002Z","courseId":"f7025f64-1958-4caf-85d4-6b9221af5fbd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"bfd79986-265e-4969-a6dc-8ba022f0e97d","title":"Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases — data handling and preparation","description":"Lesson 2 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases: 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:45:50.002Z","updatedAt":"2026-05-26T07:45:50.002Z","courseId":"f7025f64-1958-4caf-85d4-6b9221af5fbd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"72fa4302-98e9-48e4-8012-b0b0fab82b72","title":"Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases — tools, setup, and learning environment","description":"Lesson 3 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases: 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:45:50.002Z","updatedAt":"2026-05-26T07:45:50.002Z","courseId":"f7025f64-1958-4caf-85d4-6b9221af5fbd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"6adb6655-9c41-4741-b592-5ad308012992","title":"Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases — queries, models, and structure","description":"Lesson 4 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases: 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:45:50.002Z","updatedAt":"2026-05-26T07:45:50.002Z","courseId":"f7025f64-1958-4caf-85d4-6b9221af5fbd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"00b010c7-79f6-4fc4-ae60-e2f9fd4f6576","title":"Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases — visualization and dashboards","description":"Lesson 5 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases: 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:45:50.002Z","updatedAt":"2026-05-26T07:45:50.002Z","courseId":"f7025f64-1958-4caf-85d4-6b9221af5fbd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"d31142c1-8dd2-4f11-936c-9171e87bcfe4","title":"Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases — communication and stakeholder alignment","description":"Lesson 6 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases: 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:45:50.002Z","updatedAt":"2026-05-26T07:45:50.002Z","courseId":"f7025f64-1958-4caf-85d4-6b9221af5fbd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"b5e6f7d2-94d3-401e-8b39-b04902d4ac1f","title":"Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases — project build and review","description":"Lesson 7 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases: 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:45:50.002Z","updatedAt":"2026-05-26T07:45:50.002Z","courseId":"f7025f64-1958-4caf-85d4-6b9221af5fbd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"a67d95a4-329f-4152-935e-8a111294d703","title":"Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases — metrics, quality, and decision criteria","description":"Lesson 8 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases: 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:45:50.002Z","updatedAt":"2026-05-26T07:45:50.002Z","courseId":"f7025f64-1958-4caf-85d4-6b9221af5fbd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"f4549ddf-60fe-4e84-ab99-db4dcfa358e1","title":"Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases — implementation, handoff, and next steps","description":"Lesson 9 of 9 in Advanced Excel: Formulas and Dashboards — Intensive — Step-by-Step Cases: 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:45:50.002Z","updatedAt":"2026-05-26T07:45:50.002Z","courseId":"f7025f64-1958-4caf-85d4-6b9221af5fbd","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"86165a36-0cec-4b92-ab3f-936c7b0d3851","name":"Henry Brooks","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/940d372e-d1e1-4f58-96f4-ac37d1585d56.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}