← All courses
Microsoft Office Suite
Build practical Microsoft Office Specialist skills in Word, Excel, PowerPoint and Outlook. Create professional reports, analyse business data, deliver clear presentations and manage workplace communication through hands-on Office 2019 training.
4 weeks8 lessonsBeginner4.7★ (3,020 students)
Certification vendors:MicrosoftMOSICDL
One-off payment, lifetime access
₦30,000
- Free intro and overview lessons
- Mentor support throughout
- Certificate on completion
Welcome and course goals
3:55
What you'll be able to do
- ✓Produce polished reports and proposals in Word
- ✓Build formulas, pivot tables and dashboards in Excel
- ✓Design presentations that hold attention
- ✓Manage mail and calendars efficiently in Outlook
Course content
Intro and overview lessons are free to watch.
Getting started
Lesson topics
- Training goals and the workplace project
- How Word, Excel, PowerPoint and Outlook connect
Lesson topics
- Choose the right application for each task
- Find Ribbon commands and navigate the Office workspace
Lesson topics
- Create, save, organise and export Office files
- Use OneDrive to share files and manage access
- Collaborate using comments and document review tools
- Practice: organise workplace documents and share a file securely
Documents and spreadsheets
Lesson topics
- Format professional letters, reports and proposals
- Apply styles, headings, lists and page layouts
- Insert tables, pictures, headers and page numbers
- Create a table of contents and review changes
- Practice: produce a formatted business report
Lesson topics
- Enter, format, sort and filter data
- Use relative and absolute cell references
- Apply SUM, AVERAGE, COUNT, IF and exact-match lookup functions
- Prepare worksheets for printing and sharing
- Practice: build an expense workbook with formulas
Lesson topics
- Organise data into tables
- Summarise information with PivotTables
- Create charts and a simple dashboard
- Practice: explain findings from an expense workbook
Presenting and communicating
Lesson topics
- Use themes, layouts and consistent formatting
- Add pictures, charts, tables and media
- Apply restrained transitions and animations
- Prepare speaker notes and deliver a presentation
- Practice: create a five-slide workplace presentation
Lesson topics
- Write professional emails and manage attachments
- Organise messages using folders, rules and categories
- Manage contacts, appointments and meeting invitations
- Track tasks and follow-ups
- Practice: organise a meeting invitation and follow-up tasks
Assessment and completion
- Complete practical exercises in Word, Excel, PowerPoint and Outlook
- Submit a final project combining a Word report, Excel analysis, PowerPoint presentation and Outlook communication
- Receive a DLAN Academy certificate on completion
Official Microsoft Office Specialist certification requires passing the relevant Microsoft exams. This course supports preparation; official exam fees and Microsoft certification are not stated as included.
DA
Ask our admissions assistant
Instant answers about courses, prices and enrolment.
Sign in to ask the assistant your questions.
AI answers can be wrong — confirm important details with our team.
