AssistantPRO Academy

One-week professional technical training

ONE TARGETED PROFESSIONAL SKILL IN ONE WEEK

AssistantPRO Academy’s one-week professional technical training courses are short, intensive and 100% practical, designed to quickly strengthen a skill useful for work, your CV, professional activity or employability.

Each training course is autonomous and independent. It can be taken separately without having completed another course in the same theme.

1 training course = 1 complete professional need = 3 practical sessions.

Theme 01

Introduction to Computing – Windows, Word, Excel & PowerPoint

01

Practical computer skills for beginners in the office – Windows, Word, Excel & PowerPoint

You will learn: Windows and File Explorer: create and organize folders/files; Word: typing and page layout; Excel: tables, SUM and basic calculations; PowerPoint: slides with text, images and layout.

02

Essential office skills for assistants, secretaries and administrative staff

You will learn: Word: styles, tables, headers/footers and templates; Excel: lists, filters, basic formulas and tracking; PowerPoint: structured presentations; Windows: filing and backup of administrative folders.

03

Practical office skills for entrepreneurs and small businesses

You will learn: Word: quotations, letters and simple business documents; Excel: sales/expense/stock tracking with formulas; PowerPoint: business presentation; Internet/email: search, send and archive documents.

04

Office tools and Internet for job seekers – CVs, documents, tables & presentations

You will learn: Word: CV and cover letter; Internet/Google: job search; Gmail/Outlook: applications and attachments; Excel: application tracking table; PowerPoint: short professional presentation.

Theme 02

Advanced Office Skills – Advanced Word, Excel & PowerPoint

01

Advanced office skills for administrative assistants

You will learn: Word: styles, templates, tables, mail merge and long documents; Excel: structured tables, filters and formulas; PowerPoint: slide masters, alignment and professional presentation design.

02

Advanced office skills for managers and team leaders

You will learn: Excel: activity tracking, indicators, charts and PivotTables; Word: notes/reports; PowerPoint: management summaries and decision-support presentations.

03

Advanced office skills for reports, dashboards & presentations

You will learn: Word: styles, automatic table of contents and structured reports; Excel: PivotTables, charts and dashboards; PowerPoint: visual presentation of results and indicators.

04

Advanced office skills for projects, companies & organizations

You will learn: Word: project templates and reports; Excel: budgets, schedules and activity tracking; PowerPoint: project presentation; file organization and sharing with OneDrive/Google Drive.

Theme 03

Advanced Microsoft Excel for Work

01

Advanced Excel for administrative tracking & reporting

You will learn: Excel: IF, SUMIFS, COUNTIFS, XLOOKUP/VLOOKUP, filters, data validation, conditional formatting, PivotTables and charts for administrative reporting.

02

Advanced Excel for accounting, cash management & financial tracking

You will learn: Excel: cashbook, SUMIFS, balance checks, reconciliation, data validation, PivotTables and charts to track income, expenses and cash position.

03

Advanced Excel for HR, personnel & dashboards

You will learn: Excel: personnel database, date functions, COUNTIFS, drop-down lists, conditional formatting, PivotTables and charts for attendance, leave and HR indicators.

04

Advanced Excel for sales tracking, customers & sales

You will learn: Excel: prospect/customer database, XLOOKUP, SUMIFS, filters, PivotTables, charts and dashboards for pipeline, sales, follow-ups and commercial performance.

Theme 04

Artificial Intelligence Applied to Work

01

AI for administrative assistants & office work

You will learn: Generative AI (e.g. ChatGPT) + Word/Gmail: prompts for emails, minutes, summaries and documents; Microsoft To Do/Calendar: task preparation; checking and correcting AI outputs.

02

AI for writing, research, summarizing & presentations

You will learn: Generative AI + web research: research prompts, source comparison, summarizing and rewriting; Word: briefing note; PowerPoint: AI-assisted outline, content and presentation.

03

AI for Excel, data analysis & reporting

You will learn: Generative AI + Excel: create/explain formulas, guided data cleaning, table analysis, indicator interpretation and reporting commentary; manually verify calculations.

04

AI for communication, marketing & professional productivity

You will learn: Generative AI + Canva/PowerPoint + Excel/Sheets: campaign ideas, personas, messages, content calendar, post copy and variants; check tone, facts and brand consistency.

Theme 05

Administrative Writing & Professional Correspondence

01

Writing letters, notes, memos & administrative correspondence

You will learn: Word: margins, styles, references, subject, body, signature and layout for letters/notes/memos; PDF export and preparation for approval and signature.

02

Professional emails, replies, follow-ups & digital correspondence

You will learn: Gmail/Outlook: subject lines, recipients, CC/BCC, signatures, attachments, replies and follow-ups; email templates, response deadlines and message filing.

03

Administrative writing for companies, NGOs & projects

You will learn: Word/Google Docs: letters, notes and project correspondence; Google Drive: approval workflow and sharing; PDF: merge, convert, scan and prepare the final file for transmission.

04

Professional writing with Word, PDF, Gmail/Outlook & AI

You will learn: Word: drafting and formatting; Adobe/PDF: conversion and checks; Gmail/Outlook: transmission; generative AI: prompts for drafting, rewriting and review before sending.

Theme 06

Front Desk Management, Reception & Customer Service

01

Physical reception, telephone & visitor orientation

You will learn: Telephone + Excel/Google Sheets register: reception, visitor identification, message taking, orientation, request logging and follow-up until transfer to the correct department.

02

Front desk for companies, hotels, clinics & institutions

You will learn: Google Calendar/Outlook + Excel/Sheets: appointments, visitor log, badges/contacts and request tracking; telephone/email: confirmation and routing according to front-desk procedures.

03

Customer service, complaints & difficult situations

You will learn: Excel/Sheets: complaint record and status tracking; Gmail/WhatsApp: response and follow-up; active listening, reframing, de-escalation, internal escalation and case closure.

04

Multichannel reception – telephone, email, WhatsApp & customer service

You will learn: WhatsApp Business: profile, labels, quick replies and catalogue; Gmail/Outlook: email; Excel/Sheets: request log; consistent customer follow-up across phone, email and WhatsApp.

Theme 07

Document Management, Filing & Digital Archiving

01

Physical and digital filing of office documents

You will learn: Windows File Explorer: folder tree and naming standards; Excel: correspondence/file register; physical filing: indexes, codes and chronology; exercises in quick document retrieval.

02

Document management with Google Drive, PDF & scanning tools

You will learn: Google Drive: folders, sharing and permissions; Adobe Scan/CamScanner: scanning; PDF: merge, split, rotate and compress; file-naming conventions and digital archiving.

03

Professional archiving for administrative & HR departments

You will learn: Google Drive/OneDrive: HR/administrative folders and access rights; Excel/Sheets: archive register; PDF/scan: digitized records; confidentiality, retention and traceability rules.

04

Document organization, sharing, security & quick retrieval

You will learn: Google Drive: advanced search, version history and permissions; OneDrive/Drive: backup/sync; PDF: protection; access control, duplicate management and document recovery.

Theme 08

Quick Video Editing for Work – CapCut & PowerPoint

01

Quick professional video editing for social media

You will learn: Smartphone + CapCut: import footage, trim, pace, text, subtitles, music/voice, transitions, 9:16/1:1 formats and optimized export for social media.

02

Corporate video – interviews, activities & institutional presentation

You will learn: Smartphone/camera + microphone: framing, interviews and B-roll; CapCut: footage review, editing, titles, logo, voice/music and export of a corporate video.

03

Event video – film, edit & publish quickly

You will learn: Smartphone/camera: shooting plan and capture of key moments; CapCut: footage selection, quick edit, sound, titles, transitions and export of an event video ready to publish.

04

Promotional video with smartphone, CapCut & PowerPoint

You will learn: Smartphone + CapCut + PowerPoint: storyboard, product/service shooting, call to action, editing, text/element animation, voice or music and export of a promotional video.

Theme 09

Quick Graphic Design for Work – Canva, PowerPoint & Photoshop

01

Quick creation of professional flyers, posters & visuals

You will learn: Canva/PowerPoint: grid, alignment, hierarchy, typography and colour; Photoshop: crop, cut-out and image correction; export PNG/JPG/PDF for a flyer or poster.

02

Graphic design for social media & digital communication

You will learn: Canva: Facebook/Instagram/LinkedIn sizes, templates and Brand Kit; Photoshop: retouch/cut-out; PowerPoint: quick compositions; web and social-media export.

03

Visual identity, logo & graphic charter for small organizations

You will learn: Canva + Photoshop: concept development, logo construction, HEX/RGB palette, typography choices and variants; create a mini brand guideline with usage rules.

04

Professional materials – presentations, brochures, invitations & visual content

You will learn: PowerPoint/Publisher/Canva: presentations, brochures and invitations; Photoshop: image processing; margins, alignment, simple bleed setup and PDF/PNG export ready for distribution.

Theme 10

Front-End Web Development

01

Creating a professional showcase website – HTML, CSS & JavaScript

You will learn: VS Code: HTML5 structure, CSS (Flexbox/Grid, responsive) and basic JavaScript; Chrome DevTools: testing/fixes; GitHub Pages/Netlify: publish a showcase website.

02

Creating a responsive professional portfolio

You will learn: VS Code: HTML/CSS/JavaScript portfolio, navigation, project/skills sections, Flexbox/Grid and media queries; Git/GitHub: version control; GitHub Pages/Netlify: deployment.

03

Creating a responsive commercial landing page

You will learn: VS Code: responsive HTML/CSS landing page, CTA, visual form and JavaScript interactions; Chrome DevTools: mobile testing; Netlify/GitHub Pages: online publication.

04

Creating and deploying a professional web interface

You will learn: VS Code + HTML/CSS/JavaScript: responsive interface and interactions; Git/GitHub: repository and versions; Chrome DevTools: quality checks; Netlify/GitHub Pages: deployment and updates.

Theme 11

Back-End Web Development

01

Back-End for forms, data & users

You will learn: VS Code + PHP/MySQL: receive and validate forms; XAMPP: local server; phpMyAdmin: tables and data; create a user record and display the result.

02

Back-End for a company website with database

You will learn: PHP/MySQL + XAMPP/phpMyAdmin: database connection, INSERT/SELECT/UPDATE/DELETE queries and dynamic display of information for a company website.

03

Server-side content and data management

You will learn: PHP/MySQL: content CRUD; phpMyAdmin: table structure; sessions and input validation; local testing with XAMPP and data exchange between pages, server and database.

04

Back-End for a web application with deployment

You will learn: VS Code + PHP/MySQL: Back-End logic, basic authentication, CRUD and database connection; XAMPP: testing; Git/GitHub + compatible hosting: application deployment preparation.

Theme 12

Practical Accounting & Financial Management

01

Practical accounting for small businesses & entrepreneurs

You will learn: Excel/Google Sheets: simple transaction journal, income/expense categories and totals; file invoices/receipts in PDF/Drive; daily checks and basic management summary.

02

Cash, income, expenses, supporting documents & daily controls

You will learn: Excel: cashbook, opening/closing balance, income, expenses and reconciliation; calculator + scanned supporting documents: cash control and filing.

03

Customer, supplier, invoice & cash-flow tracking

You will learn: Excel/Sheets: customer/supplier file, invoices, due dates, payments, receivables/payables and cash flow; filters and simple alerts for amounts to collect or pay.

04

Budgeting, financial monitoring & reporting for projects and organizations

You will learn: Excel: budget, actual expenses, variances and execution rate; simple PivotTables/charts: reporting; Google Drive/PDF: supporting documents and project finance file.

Theme 13

Sales Prospecting, Customer Follow-Up & WhatsApp Business

01

Field and telephone prospecting & customer portfolio development

You will learn: Google Maps/directory + Excel/Sheets: build a prospect list; telephone: call script and qualification; field work: visit sheet; follow-up schedule and prospect status tracking.

02

Digital prospecting with WhatsApp Business, email & social media

You will learn: WhatsApp Business: profile, catalogue, labels and quick replies; Gmail: outreach emails; social media/Google: prospect research; Excel/Sheets: response and follow-up tracking.

03

Sales follow-up – prospects, follow-ups, sales & customer retention

You will learn: Excel/Sheets: prospect pipeline, stages, next actions and sales; WhatsApp Business/Gmail: follow-ups; Calendar: reminders; simple conversion and retention indicators.

04

Practical sales support – customer database, prospecting, follow-up & reporting

You will learn: Excel/Sheets: customer file and prospecting tracker; WhatsApp Business/telephone/email: contacts and follow-ups; weekly reporting of activities, opportunities and sales results.

Theme 14

Personnel Administrative Follow-Up – HR

01

Practical management of employee administrative files

You will learn: Word: contracts, HR forms and letters; Excel/Sheets: personnel register; Google Drive: individual digital employee files and access rights; file-completeness checklist and confidentiality.

02

Attendance, absences, leave, contracts & HR deadlines

You will learn: Excel/Sheets: attendance, absences, leave, probation and contract deadlines; date functions, drop-down lists, conditional formatting and follow-up alerts.

03

Social declarations, employee obligations & online platforms

You will learn: Excel: prepare social-declaration data; applicable CNPS/tax online platforms: entry and declaration follow-up; PDF/Drive: archive slips, proof of submission and supporting documents.

04

HR dashboards, personnel files & administrative tracking with Excel

You will learn: Excel: personnel database, IF/COUNTIFS and date functions, PivotTables and charts; Google Drive: HR records; dashboard for headcount, absences, leave and administrative deadlines.

Theme 15

Meetings, Videoconferencing & Professional Calendar Management

01

Professional calendar, appointments & priority management

You will learn: Google Calendar/Outlook Calendar: create, share and edit calendars; invitations, reminders, availability, priorities, schedule conflicts and last-minute rescheduling.

02

Complete meeting organization – before, during & after

You will learn: Google Calendar/Outlook + Word: invitations, agenda, participant list and minutes; Excel/Sheets: action tracker; follow-up before, during and after the meeting.

03

Online meetings – Zoom, Google Meet, invitations & follow-up

You will learn: Zoom/Google Meet: links, settings, waiting room, screen sharing and recording; Calendar/Gmail: invitations; Word/Sheets: attendance, notes and decision follow-up.

04

Executive support – calendar, meetings, missions & decision follow-up

You will learn: Outlook/Google Calendar + Microsoft To Do: calendar, tasks and priorities; Word/Excel: meeting/mission files; Gmail: coordination; tracker for decisions, owners and deadlines.

Organization

How does each training course work?

SESSION 1 – PRACTICAL CLASS

All key aspects of the selected training course are covered through demonstrations, guided practical exercises, essential concepts and Q&A.

SESSION 2 – PROFESSIONAL SIMULATION

Skills are applied to concrete workplace situations and professional scenarios. Learners practise and prepare for the knowledge assessment.

SESSION 3 – PROJECT & PRACTICAL ASSESSMENT

Learners complete a practical assignment under supervision, receive corrections, publish the work online where required and present their work before certification.

AssistantPRO Academy

Practical information

  • Format: 1 week – 3 practical sessions
  • Duration: 8 hours of training
  • Training fees: 25,000 XAF
  • Registration fee: 5,000 XAF
  • Intake: Every Tuesday
  • Class days: Tuesday, Wednesday and Friday
  • Day classes: 8:30 AM – 12:00 PM
  • Evening classes: 5:30 PM – 9:00 PM
  • Study modes: In-person or online
  • Training language: English or French
  • Learning platform: Course materials, assignments and selected activities are available online.
  • Online quizzes: Knowledge quizzes are completed through the Academy platform where applicable.
  • Certificate: Issued after successful completion of the practical assessment.

Equipment

Computer and equipment requirements

Learners are strongly encouraged to bring their own laptop for courses requiring computer-based practical work.

Learners without a laptop may rent one from AssistantPRO Academy for on-site use, subject to availability.

Laptop rental: 5,000 XAF per week.

Need the detailed program?

Each training course has its own detailed practical program.

Write to us on WhatsApp or by email and indicate the exact training course you are interested in. We will send you the corresponding detailed program.

Logo Whatsapp