{"id":"d468d50d-f1d1-4ced-98e5-fcaa9304edc3","title":"Excel for Data Analysis: Lab — Step-by-Step Cases","description":"Excel for Data Analysis: Lab — Step-by-Step Cases is a lab-based course for career starters and switchers aged 25–34. Across 9 lessons and about 23 hours, the curriculum focuses on data handling and preparation, tools, setup, and learning environment and queries, models, and structure. The final output is a reusable dashboard pack built with Excel, pivot tables and Power Query.","contentLanguage":"en","coverUrl":"/course-covers/excel-for-data-analysis-lab-step-by-step-cases-6df41657-3f7.webp","createdAt":"2026-05-26T07:45:54.434Z","updatedAt":"2026-05-26T07:51:43.389Z","durationSeconds":82800,"authorId":"359f56fc-1e01-4de5-a9b2-5b57fab2b097","rating":4.923076923076923,"reviewCount":13,"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 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 Power Query.","question":"What will I finish the course with?"}],"learningOutcomes":null,"requirements":null,"levels":["intermediate"],"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":"8b63b4bd-c362-4c6f-a4bc-29f03711df9d","title":"Excel for Data Analysis: Lab — Step-by-Step Cases — course orientation and outcomes","description":"Lesson 1 of 9 in Excel for Data Analysis: Lab — Step-by-Step Cases: work through course orientation and outcomes in the context of Excel for Data Analysis, 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:54.434Z","updatedAt":"2026-05-26T07:45:54.434Z","courseId":"d468d50d-f1d1-4ced-98e5-fcaa9304edc3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"327e011a-3ac6-422f-b20c-b118eec07e70","title":"Excel for Data Analysis: Lab — Step-by-Step Cases — data handling and preparation","description":"Lesson 2 of 9 in Excel for Data Analysis: Lab — Step-by-Step Cases: work through data handling and preparation in the context of Excel for Data Analysis, 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:54.434Z","updatedAt":"2026-05-26T07:45:54.434Z","courseId":"d468d50d-f1d1-4ced-98e5-fcaa9304edc3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"1e48483a-c604-4a21-9ec5-a403cac5578a","title":"Excel for Data Analysis: Lab — Step-by-Step Cases — tools, setup, and learning environment","description":"Lesson 3 of 9 in Excel for Data Analysis: Lab — Step-by-Step Cases: work through tools, setup, and learning environment in the context of Excel for Data Analysis, 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:54.434Z","updatedAt":"2026-05-26T07:45:54.434Z","courseId":"d468d50d-f1d1-4ced-98e5-fcaa9304edc3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"01b3aabd-0072-4a53-9351-bb0ea7ee1c58","title":"Excel for Data Analysis: Lab — Step-by-Step Cases — queries, models, and structure","description":"Lesson 4 of 9 in Excel for Data Analysis: Lab — Step-by-Step Cases: work through queries, models, and structure in the context of Excel for Data Analysis, 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:54.434Z","updatedAt":"2026-05-26T07:45:54.434Z","courseId":"d468d50d-f1d1-4ced-98e5-fcaa9304edc3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"c1eacb90-d3c3-430f-8377-32927da7c26b","title":"Excel for Data Analysis: Lab — Step-by-Step Cases — visualization and dashboards","description":"Lesson 5 of 9 in Excel for Data Analysis: Lab — Step-by-Step Cases: work through visualization and dashboards in the context of Excel for Data Analysis, 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:54.434Z","updatedAt":"2026-05-26T07:45:54.434Z","courseId":"d468d50d-f1d1-4ced-98e5-fcaa9304edc3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"a15650b0-6f82-4e4a-a514-ab3e27619279","title":"Excel for Data Analysis: Lab — Step-by-Step Cases — communication and stakeholder alignment","description":"Lesson 6 of 9 in Excel for Data Analysis: Lab — Step-by-Step Cases: work through communication and stakeholder alignment in the context of Excel for Data Analysis, 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:54.434Z","updatedAt":"2026-05-26T07:45:54.434Z","courseId":"d468d50d-f1d1-4ced-98e5-fcaa9304edc3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"01e5136e-d2ff-46e6-ad79-0bd1c16d10ab","title":"Excel for Data Analysis: Lab — Step-by-Step Cases — project build and review","description":"Lesson 7 of 9 in Excel for Data Analysis: Lab — Step-by-Step Cases: work through project build and review in the context of Excel for Data Analysis, 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:54.434Z","updatedAt":"2026-05-26T07:45:54.434Z","courseId":"d468d50d-f1d1-4ced-98e5-fcaa9304edc3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"74b51d12-e1ec-4625-b060-c94d869df2fd","title":"Excel for Data Analysis: Lab — Step-by-Step Cases — metrics, quality, and decision criteria","description":"Lesson 8 of 9 in Excel for Data Analysis: Lab — Step-by-Step Cases: work through metrics, quality, and decision criteria in the context of Excel for Data Analysis, 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:54.434Z","updatedAt":"2026-05-26T07:45:54.434Z","courseId":"d468d50d-f1d1-4ced-98e5-fcaa9304edc3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"242bf3c9-ea96-49ca-815f-24d973e31ac5","title":"Excel for Data Analysis: Lab — Step-by-Step Cases — implementation, handoff, and next steps","description":"Lesson 9 of 9 in Excel for Data Analysis: Lab — Step-by-Step Cases: work through implementation, handoff, and next steps in the context of Excel for Data Analysis, 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:54.434Z","updatedAt":"2026-05-26T07:45:54.434Z","courseId":"d468d50d-f1d1-4ced-98e5-fcaa9304edc3","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"359f56fc-1e01-4de5-a9b2-5b57fab2b097","name":"Charles Carter","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/496a159f-1284-4edb-bc0d-0133e8baf409.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}