Program Overview
Mission
Equip learners with job-ready office automation skills that boost productivity, analytical thinking, and career mobility across industries.
Target Audience
University students, administrative professionals, business owners, data enthusiasts, and anyone seeking verified Microsoft Office competencies.
Industry Alignment
Mapped to ICDL and Microsoft Office Specialist (MOS) standards — globally recognized credentials employers trust.
Learning Approach
40% theory | 60% hands-on labs | Project-based learning | Portfolio development | Career support
Course Modules
- Workbooks, Worksheets & Cell Referencing
- Data Entry, Validation & Conditional Formatting
- Formulas & Functions (VLOOKUP, IF, SUMIFS, TEXT)
- Pivot Tables, Pivot Charts & Dashboards
- Charts, Graphs & Data Visualization
- Printing, Page Setup & Macros Basics
- Slides, Layouts & Master Slides
- Text Slides, Bullet Points & Typography
- Inserting Charts, Tables & Multimedia
- Drawing Tools, SmartArt & Shapes
- Animations, Transitions & Timing
- Slide Show Config & Presenter View
- Launching Access & Database Environment
- Table Design, Data Types & Primary Keys
- Relationships & Referential Integrity
- Sorting, Filtering & Managing Records
- Creating Queries (Select, Parameter, Action)
- Forms, Reports & Printing Options
- Launching Publisher & Interface Navigation
- Menus, Toolbars & Design Sets
- Designing Publications for Print (Flyers, Brochures)
- Business Cards, Letterheads & Branding
- Developing Simple Websites with Publisher
- Commercial Printing (CMYK, Bleed)
What to Expect
Build a portfolio of 5 real-world projects
Coursework (10%) | Tests (10%) | Participation (10%) | Final Capstone (70%)
Small classes, individual feedback, peer collaboration
Optional MOS exam preparation included
Recorded sessions available for review
Portfolio review, LinkedIn optimization, interview prep
Learner Resources and Support
Video Tutorial Library
Step-by-step recordings of every lab session
Exercise Files
Downloadable datasets, templates & starter files
24/7 Query Support
Quick responses via WhatsApp & email
Reference Materials
Curated reading list & MOS study guides
Cloud Lab Access
Remote practice environment
Weekly Office Hours
Live Q&A with the instructor
Peer Learning Groups
Collaborative study sessions
MOS Practice Exams
Mock tests for certification prep
Your Facilitator
MobNet Africa Education Team
MobNet Africa Education Team of 2014 — Over a decade of experience in corporate training, database systems, and office automation. Certified Microsoft Office Specialists. Collectively trained over 1,500 professionals and students across East Africa. Passionate about using technology as a tool for economic empowerment.
Quick Links and Resources
Are you ready to advance your career | education skills?
Join hundreds of professionals who have transformed their careers with our industry-aligned training.