{"id":"8fe33d9f-43b9-4bd8-aa17-d3ba701c4980","title":"Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools","description":"The course Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools 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-bootcamp-foun-517b6e0e-ea8.webp","createdAt":"2026-05-26T07:45:42.043Z","updatedAt":"2026-05-26T07:51:40.447Z","durationSeconds":82800,"authorId":"fd6a8ff8-c940-41c9-b2cb-c1d102c29feb","rating":4.622448979591836,"reviewCount":98,"expectedLessonsCount":9,"trailerUrl":null,"faq":[{"answer":"Basic spreadsheet skills are recommended. The course starts with a clear ramp-up and then moves into foundations and tools.","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":"bd89bc9c-cec6-4b9a-b87b-df9c2fb0aa88","title":"Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools — course orientation and outcomes","description":"Lesson 1 of 9 in Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools: 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:45:42.043Z","updatedAt":"2026-05-26T07:45:42.043Z","courseId":"8fe33d9f-43b9-4bd8-aa17-d3ba701c4980","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"6a32697f-67ea-4380-a50f-6e87ae1b837e","title":"Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools — data handling and preparation","description":"Lesson 2 of 9 in Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools: 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:45:42.043Z","updatedAt":"2026-05-26T07:45:42.043Z","courseId":"8fe33d9f-43b9-4bd8-aa17-d3ba701c4980","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"2e90b9fd-5896-449b-8834-f611911f3eda","title":"Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools — tools, setup, and learning environment","description":"Lesson 3 of 9 in Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools: 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:45:42.043Z","updatedAt":"2026-05-26T07:45:42.043Z","courseId":"8fe33d9f-43b9-4bd8-aa17-d3ba701c4980","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"e4a52d3b-0c6f-4dd5-9799-71e1cec73d44","title":"Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools — queries, models, and structure","description":"Lesson 4 of 9 in Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools: 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:45:42.043Z","updatedAt":"2026-05-26T07:45:42.043Z","courseId":"8fe33d9f-43b9-4bd8-aa17-d3ba701c4980","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"cc59494f-1553-4e31-b89c-64aebc3920d0","title":"Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools — visualization and dashboards","description":"Lesson 5 of 9 in Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools: 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:45:42.043Z","updatedAt":"2026-05-26T07:45:42.043Z","courseId":"8fe33d9f-43b9-4bd8-aa17-d3ba701c4980","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"75fd872e-b896-4cfd-96d9-d98c0f38a7dd","title":"Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools — communication and stakeholder alignment","description":"Lesson 6 of 9 in Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools: 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:45:42.043Z","updatedAt":"2026-05-26T07:45:42.043Z","courseId":"8fe33d9f-43b9-4bd8-aa17-d3ba701c4980","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"5d198ad0-707c-493e-bb47-5604ca05e334","title":"Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools — project build and review","description":"Lesson 7 of 9 in Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools: 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:45:42.043Z","updatedAt":"2026-05-26T07:45:42.043Z","courseId":"8fe33d9f-43b9-4bd8-aa17-d3ba701c4980","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"736f935e-7db4-402a-b828-81ccdfa705eb","title":"Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools — metrics, quality, and decision criteria","description":"Lesson 8 of 9 in Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools: 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:45:42.043Z","updatedAt":"2026-05-26T07:45:42.043Z","courseId":"8fe33d9f-43b9-4bd8-aa17-d3ba701c4980","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"a2718e7e-cce1-4c07-8a48-d4c94e2cd8aa","title":"Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools — implementation, handoff, and next steps","description":"Lesson 9 of 9 in Advanced Excel: Formulas and Dashboards — Bootcamp — Foundations and Tools: 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:45:42.043Z","updatedAt":"2026-05-26T07:45:42.043Z","courseId":"8fe33d9f-43b9-4bd8-aa17-d3ba701c4980","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"fd6a8ff8-c940-41c9-b2cb-c1d102c29feb","name":"William Bell","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/6e1ba224-9a9a-4c03-a8dc-f6af4b6e5854.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}