{"id":"fac8bab3-aa22-4b78-aa8d-b774f2f18acf","title":"Microsoft Excel: Advanced Excel Formulas & Functions","description":"Microsoft Excel: Advanced Excel Formulas & Functions helps learners move from understanding to execution through 8 lessons (~19 hours). It is aimed at career starters and switchers aged 25–34, with emphasis on data handling and preparation, tools, setup, and learning environment and queries, models, and structure, and ends with a dashboard pack that can be used in work or in a portfolio.","contentLanguage":"en","coverUrl":"/course-covers/microsoft-excel-advanced-excel-formulas-functions-f0c74990-104.webp","createdAt":"2026-05-26T07:45:29.271Z","updatedAt":"2026-05-26T07:51:44.894Z","durationSeconds":68400,"authorId":"b60bc179-167d-4ec2-a0f3-d820f1b862df","rating":4.712643678160919,"reviewCount":87,"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":"ec2380d9-35a3-4a6c-af95-ab745744d738","title":"Microsoft Excel: Advanced Excel Formulas & Functions — course orientation and outcomes","description":"Lesson 1 of 8 in Microsoft Excel: Advanced Excel Formulas & Functions: work through course orientation and outcomes in the context of Microsoft Excel: Advanced Excel Formulas & Functions, 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:45:29.271Z","updatedAt":"2026-05-26T07:45:29.271Z","courseId":"fac8bab3-aa22-4b78-aa8d-b774f2f18acf","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"710ea77f-77b2-44b2-95b4-5f9fe85aea15","title":"Microsoft Excel: Advanced Excel Formulas & Functions — data handling and preparation","description":"Lesson 2 of 8 in Microsoft Excel: Advanced Excel Formulas & Functions: work through data handling and preparation in the context of Microsoft Excel: Advanced Excel Formulas & Functions, 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:45:29.271Z","updatedAt":"2026-05-26T07:45:29.271Z","courseId":"fac8bab3-aa22-4b78-aa8d-b774f2f18acf","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"742a7aea-c1f2-4f04-a032-63e290cb5002","title":"Microsoft Excel: Advanced Excel Formulas & Functions — tools, setup, and learning environment","description":"Lesson 3 of 8 in Microsoft Excel: Advanced Excel Formulas & Functions: work through tools, setup, and learning environment in the context of Microsoft Excel: Advanced Excel Formulas & Functions, 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:45:29.271Z","updatedAt":"2026-05-26T07:45:29.271Z","courseId":"fac8bab3-aa22-4b78-aa8d-b774f2f18acf","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"331532a8-9743-4c63-b8c1-a9b19b5ff390","title":"Microsoft Excel: Advanced Excel Formulas & Functions — queries, models, and structure","description":"Lesson 4 of 8 in Microsoft Excel: Advanced Excel Formulas & Functions: work through queries, models, and structure in the context of Microsoft Excel: Advanced Excel Formulas & Functions, 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:45:29.271Z","updatedAt":"2026-05-26T07:45:29.271Z","courseId":"fac8bab3-aa22-4b78-aa8d-b774f2f18acf","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"93d4acf1-b06e-41f5-8c31-9af04946ab26","title":"Microsoft Excel: Advanced Excel Formulas & Functions — visualization and dashboards","description":"Lesson 5 of 8 in Microsoft Excel: Advanced Excel Formulas & Functions: work through visualization and dashboards in the context of Microsoft Excel: Advanced Excel Formulas & Functions, 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:45:29.271Z","updatedAt":"2026-05-26T07:45:29.271Z","courseId":"fac8bab3-aa22-4b78-aa8d-b774f2f18acf","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"77317cfa-64f0-40c0-b2b0-46db465579ed","title":"Microsoft Excel: Advanced Excel Formulas & Functions — communication and stakeholder alignment","description":"Lesson 6 of 8 in Microsoft Excel: Advanced Excel Formulas & Functions: work through communication and stakeholder alignment in the context of Microsoft Excel: Advanced Excel Formulas & Functions, 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:45:29.271Z","updatedAt":"2026-05-26T07:45:29.271Z","courseId":"fac8bab3-aa22-4b78-aa8d-b774f2f18acf","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"f623ce01-948b-4e31-b233-d0d3110adf83","title":"Microsoft Excel: Advanced Excel Formulas & Functions — project build and review","description":"Lesson 7 of 8 in Microsoft Excel: Advanced Excel Formulas & Functions: work through project build and review in the context of Microsoft Excel: Advanced Excel Formulas & Functions, 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:45:29.271Z","updatedAt":"2026-05-26T07:45:29.271Z","courseId":"fac8bab3-aa22-4b78-aa8d-b774f2f18acf","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"b8ad1159-a4eb-4054-804b-2a791bd9f963","title":"Microsoft Excel: Advanced Excel Formulas & Functions — implementation, handoff, and next steps","description":"Lesson 8 of 8 in Microsoft Excel: Advanced Excel Formulas & Functions: work through implementation, handoff, and next steps in the context of Microsoft Excel: Advanced Excel Formulas & Functions, 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:45:29.271Z","updatedAt":"2026-05-26T07:45:29.271Z","courseId":"fac8bab3-aa22-4b78-aa8d-b774f2f18acf","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"b60bc179-167d-4ec2-a0f3-d820f1b862df","name":"James Bailey","avatarUrl":null,"bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}