Admin
Develop practical Microsoft Excel skills through a structured four-week learning programme. This course takes learners through essential spreadsheet operations, formatting, formulas, functions, data management, analysis and reporting.
With 66 guided video lessons, weekly learning activities, knowledge assessments and a final examination, learners progressively build the confidence to use Excel in business, administration, accounting, education and everyday professional work.
Learn at your own pace while following a structured weekly learning schedule. Successfully complete the lessons and assessments to qualify for an AcademyLab course completion certificate.
Lessons follow the original order of the source Excel Training playlist on YouTube. Each week includes a short assessment covering that week's material, followed by a final competency assessment covering all 66 lessons. The passing mark for all assessments is 70%.
An AcademyLab Certificate of Completion is awarded automatically when the student has a valid paid enrolment, all 66 lessons are marked complete, all four weekly quizzes are passed, and the final examination is passed.
Level: Beginner to Intermediate. Language: English. Duration: 4 weeks (28 days) of guided study. Total lessons: 66.
This course includes 4 modules, 71 lessons, and 0 hours of materials.
Lesson 2 of 66. Verified source video: https://www.youtube.com/watch?v=Yo7ellmlH4Q
Lesson 3 of 66. Verified source video: https://www.youtube.com/watch?v=gsAVUCXMQSI
Lesson 4 of 66. Verified source video: https://www.youtube.com/watch?v=rro5t8eHXaY
Lesson 5 of 66. Verified source video: https://www.youtube.com/watch?v=YE1HBEY2upg
Lesson 6 of 66. Verified source video: https://www.youtube.com/watch?v=kSNxzoe9RcM
Lesson 7 of 66. Verified source video: https://www.youtube.com/watch?v=Fr0nM_-jpjc
Lesson 8 of 66. Verified source video: https://www.youtube.com/watch?v=x98qOYt_NCQ
Lesson 9 of 66. Verified source video: https://www.youtube.com/watch?v=qrbf9DtR3_c
Lesson 10 of 66. Verified source video: https://www.youtube.com/watch?v=v4i-2VffVZQ
Lesson 11 of 66. Verified source video: https://www.youtube.com/watch?v=U_uUkTP5_os
Lesson 12 of 66. Verified source video: https://www.youtube.com/watch?v=zRAXnvTFA_w
Lesson 13 of 66. Verified source video: https://www.youtube.com/watch?v=hkybRW7Z3Yk
Lesson 14 of 66. Verified source video: https://www.youtube.com/watch?v=LiWMgC2ICDg
Lesson 15 of 66. Verified source video: https://www.youtube.com/watch?v=bF31VEFvMmY
Lesson 16 of 66. Verified source video: https://www.youtube.com/watch?v=y4bA2CNScg8
Lesson 17 of 66. Verified source video: https://www.youtube.com/watch?v=nOS2jBSnIVE
Assessment covering lessons 1-17: Excel fundamentals, worksheets, formatting, formulas, functions and PivotTables.
Lesson 18 of 66. Verified source video: https://www.youtube.com/watch?v=7tx1H7sxSL0
Lesson 19 of 66. Verified source video: https://www.youtube.com/watch?v=8u1PnceNoG4
Lesson 20 of 66. Verified source video: https://www.youtube.com/watch?v=jbno1SwmIFE
Lesson 21 of 66. Verified source video: https://www.youtube.com/watch?v=UeJWCqJysKI
Lesson 22 of 66. Verified source video: https://www.youtube.com/watch?v=WvYP4--CCc8
Lesson 23 of 66. Verified source video: https://www.youtube.com/watch?v=4qq2wPifUms
Lesson 24 of 66. Verified source video: https://www.youtube.com/watch?v=dLDUE-s8lzc
Lesson 25 of 66. Verified source video: https://www.youtube.com/watch?v=tCVNiIvHqZM
Lesson 26 of 66. Verified source video: https://www.youtube.com/watch?v=6JnEYGxxd8w
Lesson 27 of 66. Verified source video: https://www.youtube.com/watch?v=bezV5U0dlbo
Lesson 28 of 66. Verified source video: https://www.youtube.com/watch?v=sm9rSD8IXgM
Lesson 29 of 66. Verified source video: https://www.youtube.com/watch?v=Q1UzraY0yXg
Lesson 30 of 66. Verified source video: https://www.youtube.com/watch?v=wUO6PhnzcBQ
Lesson 31 of 66. Verified source video: https://www.youtube.com/watch?v=M6miEypg6Mo
Lesson 32 of 66. Verified source video: https://www.youtube.com/watch?v=WZnRDPFz75U
Lesson 33 of 66. Verified source video: https://www.youtube.com/watch?v=19sVNOmE93k
Lesson 34 of 66. Verified source video: https://www.youtube.com/watch?v=No3oudCEdls
Assessment covering lessons 18-34: Excel formulas, functions, XLOOKUP, PivotTables, productivity tools and VBA foundations.
Lesson 35 of 66. Verified source video: https://www.youtube.com/watch?v=ezHWpbeq-gc
Lesson 36 of 66. Verified source video: https://www.youtube.com/watch?v=JZ4pBe_MHQ8
Lesson 37 of 66. Verified source video: https://www.youtube.com/watch?v=G05TrN7nt6k
Lesson 38 of 66. Verified source video: https://www.youtube.com/watch?v=MeKL_n6SiYY
Lesson 39 of 66. Verified source video: https://www.youtube.com/watch?v=tGHLa1TnhLc
Lesson 40 of 66. Verified source video: https://www.youtube.com/watch?v=14XqlLOCojg
Lesson 41 of 66. Verified source video: https://www.youtube.com/watch?v=NpO5RCFLdl0
Lesson 42 of 66. Verified source video: https://www.youtube.com/watch?v=tuk99Sgc6Fw
Lesson 43 of 66. Verified source video: https://www.youtube.com/watch?v=NvBPFwYq3I4
Lesson 44 of 66. Verified source video: https://www.youtube.com/watch?v=F4b-GnvRN4k
Lesson 45 of 66. Verified source video: https://www.youtube.com/watch?v=y1Z2NHNJnkY
Lesson 46 of 66. Verified source video: https://www.youtube.com/watch?v=gMyfHDt_uJI
Lesson 47 of 66. Verified source video: https://www.youtube.com/watch?v=PwVQl_tEnpE
Lesson 48 of 66. Verified source video: https://www.youtube.com/watch?v=-8nD5HRNDjE
Lesson 49 of 66. Verified source video: https://www.youtube.com/watch?v=Onb16yzQKbA
Lesson 50 of 66. Verified source video: https://www.youtube.com/watch?v=iI60fsZT6wI
Assessment covering lessons 35-50: advanced VBA, XLOOKUP, data analysis, charts, Flash Fill, PivotTables and PowerPivot.
Lesson 51 of 66. Verified source video: https://www.youtube.com/watch?v=nYKOuUgeuRo
Lesson 52 of 66. Verified source video: https://www.youtube.com/watch?v=hRO6Ej_I29E
Lesson 53 of 66. Verified source video: https://www.youtube.com/watch?v=xKJ0v6qFeaU
Lesson 54 of 66. Verified source video: https://www.youtube.com/watch?v=GrKuFdN1mo0
Lesson 55 of 66. Verified source video: https://www.youtube.com/watch?v=tbueWDkj5ow
Lesson 56 of 66. Verified source video: https://www.youtube.com/watch?v=kWAXMkOB6Ag
Lesson 57 of 66. Verified source video: https://www.youtube.com/watch?v=XGqz1NPCas0
Lesson 58 of 66. Verified source video: https://www.youtube.com/watch?v=TVcp9hBUAwk
Lesson 59 of 66. Verified source video: https://www.youtube.com/watch?v=xnOh1clJwnU
Lesson 60 of 66. Verified source video: https://www.youtube.com/watch?v=DgNNjJ2IwMs
Lesson 61 of 66. Verified source video: https://www.youtube.com/watch?v=AXk5kHqOs1Y
Lesson 62 of 66. Verified source video: https://www.youtube.com/watch?v=SmVAawPU6c8
Lesson 63 of 66. Verified source video: https://www.youtube.com/watch?v=xTaUvknBjZU
Lesson 64 of 66. Verified source video: https://www.youtube.com/watch?v=mzwElTeSdEI
Lesson 65 of 66. Verified source video: https://www.youtube.com/watch?v=JJGE2UN8NdU
Lesson 66 of 66. Verified source video: https://www.youtube.com/watch?v=wzWqH9RFbBo
Assessment covering lessons 51-66: merging spreadsheets, printing, online surveys, import from web, pivot templates and reporting.
Twenty-question question bank covering all 66 lessons; used by the Microsoft Excel Final Competency Assessment examination.
Key details about this course at a glance.
This course has no frequently asked questions at the moment.
Reply to Comment