Digital Tools from Zero
Mentor-led by Ibrahim Foday and Mohamed Dyphan- Modules
- 14 modules
- Length
- 3 Months
- Level
- Beginner
Certificate on completion
About this programme
What you'll learn
- Find your way around Microsoft 365, learning what Word, Excel, PowerPoint, Outlook, Teams and OneDrive each do and how they work together.
- Create and format Word documents with styles, lists, tables, pictures, headers, page numbers and section breaks, then save them in the right file type.
- Produce long reports in Word with captions, cross-references, footnotes, citations, a reference list, a table of contents and a bookmarked PDF.
- Review, share and protect documents with Track Changes, comments, mail merge, restricted editing, accessibility checks and co-authoring on OneDrive.
- Enter, format and calculate data in Excel with formulas, SUM and AVERAGE, absolute references, sorting, filtering and print-ready page setup.
- Analyse data in Excel with IF, COUNTIFS, XLOOKUP, Tables, conditional formatting, data validation, charts, PivotTables and data cleaning.
- Automate Excel work with dynamic arrays, LET and LAMBDA, Power Query, the Data Model, Solver, dashboards with slicers and recorded macros.
- Design clear PowerPoint slides with themes, pictures, icons, SmartArt and linked Excel charts, then present them with speaker notes and Presenter View.
- Work in Google Workspace, sharing files in Drive, organising Gmail with labels and search, and converting Office files in Docs, Sheets and Slides.
Skills you'll gain
- Document formatting
- Report writing
- Referencing and citation
- Document review
- Mail merge
- Spreadsheet formulas
- Data cleaning
- Data analysis
- Data visualisation
- Dashboard design
- Task automation
- Presentation design
- Presenting to an audience
- Digital accessibility
- File management
- Online collaboration
Tools you'll use
- Microsoft 365
- Microsoft Word
- Microsoft Excel
- Microsoft PowerPoint
- OneDrive
- Power Query
- Power Pivot
- Google Drive
- Gmail
- Google Docs
- Google Sheets
- Google Slides
Curriculum
14 modules274 lessons72h 55m total11 knowledge checks
Parts of this programme
Part I: Microsoft Word
Module 1Start Here: Microsoft 365
Recognise the main Microsoft 365 apps, know what each one is for, and see how they pass work between each other.
- A guided tour of ten Microsoft 365 apps
- The story of Office since 1983
- How the apps share your work
Module 2Microsoft Word: Foundation
Start, type, edit and save Word documents with confidence, find any command on the ribbon, and recover work you forgot to save.
- Saving as .docx, PDF or older .doc
- Fast selecting, moving and undoing of text
- A community notice as your first exam
Module 3Microsoft Word: Formatting
Give documents a professional finish with fonts, paragraph spacing, lists, heading styles, themes, page layout, section breaks and page numbers.
- Every heading changed through one style
- Landscape pages inside portrait documents
- A polished event programme as your exam
Module 4Microsoft Word: Intermediate
Add tables, pictures and diagrams to reports, proofread in UK English, number figures, cite sources and reuse a letterhead template.
- Reference lists Word builds for you
- Captions and cross-references that stay correct
- A field report with table and sources
Module 5Microsoft Word: Advanced
Review, mail merge, protect and share documents, make them accessible to every reader, and take a long report from draft to bookmarked PDF.
- Personalised letters from an Excel list
- Co-authoring and version history on OneDrive
- A full district report as final project
Before you start
- Prior knowledge
No prior experience needed.
Every lesson starts from the first click, with the real screen shown at each step.
- Device and software
A laptop or desktop: Word, Excel and PowerPoint are followed along on a computer.
- Microsoft 365Free option: Google Docs, Sheets and Slides
- Google WorkspaceFree
- Internet
None of the 274 lessons needs video.
- Time commitment
3 months, with 72 hours of guided lessons: about 6 hours a week, plus your own practice and project time.
Meet your mentor-instructors
Ibrahim George Foday
Mohamed Dyphan Massaquoi
Frequently asked questions
How long is Digital Tools from Zero?
Digital Tools from Zero runs over 3 Months and covers 14 modules. Lessons open as soon as you are accepted, so you work through them at your own pace inside that window.
What will I be able to do after Digital Tools from Zero?
By the end you will be able to: Find your way around Microsoft 365, learning what Word, Excel, PowerPoint, Outlook, Teams and OneDrive each do and how they work together.; Create and format Word documents with styles, lists, tables, pictures, headers, page numbers and section breaks, then save them in the right file type.; Produce long reports in Word with captions, cross-references, footnotes, citations, a reference list, a table of contents and a bookmarked PDF.; Review, share and protect documents with Track Changes, comments, mail merge, restricted editing, accessibility checks and co-authoring on OneDrive.; Enter, format and calculate data in Excel with formulas, SUM and AVERAGE, absolute references, sorting, filtering and print-ready page setup.; Analyse data in Excel with IF, COUNTIFS, XLOOKUP, Tables, conditional formatting, data validation, charts, PivotTables and data cleaning.; Automate Excel work with dynamic arrays, LET and LAMBDA, Power Query, the Data Model, Solver, dashboards with slicers and recorded macros.; Design clear PowerPoint slides with themes, pictures, icons, SmartArt and linked Excel charts, then present them with speaker notes and Presenter View.; and Work in Google Workspace, sharing files in Drive, organising Gmail with labels and search, and converting Office files in Docs, Sheets and Slides.. Every module is built around work you can show, not recall alone.
Do I need any experience to start?
No. Digital Tools from Zero runs from beginner to advanced: it starts at the basics and builds to advanced work, so you can join with no background in the subject and still finish with something to show.
Will I earn a certificate?
Yes. Complete every required lesson and you earn a verifiable Teki-SL certificate of completion, with a link anyone can check.
How much does it cost, and what is the scholarship?
Teki-SL runs these programmes on scholarship. Applying costs nothing, and a learner we accept pays no tuition and signs no income-share agreement. Places are limited, so not every applicant is awarded one; if you are not selected you can apply again for the next intake, and the free guides, cheatsheets and practice tools stay open to you either way.