Data
Microsoft Office Productivity & AI Tools Mastery
Be equiped with modern workplace productivity skills using Microsoft Office applications (MS Word, Excel, and PowerPoint) combined with Artificial Intelligence productivity tools.
8 weeks Beginner to Job-ready Online, live + self-paced
Enrol now
Course overview
The course focuses on practical workplace applications including document creation, data analysis, professional presentations, automation, AI-assisted research, content generation, and visual design. It aligns with current Microsoft 365 productivity training trends where AI assistants are integrated into Word, Excel, and PowerPoint workflows.
Learning outcomes
- Create professional documents using Microsoft Word.
- Use advanced formatting, templates, tables, references, and collaboration tools.
- Analyze and visualize business data using Microsoft Excel.
- Create professional presentations using Microsoft PowerPoint.
- Apply AI tools to improve productivity and creativity.
- Write effective AI prompts for ChatGPT, Claude, Gemini, and Copilot.
- Generate AI images and designs using Midjourney-style AI design workflows.
- Apply AI responsibly in workplace environments.
Career opportunities
Administrative & Office roles Microsoft Office & Business Productivity roles Excel & Data-Related Opportunities AI & Digital Productivity Content & Presentation Opportunities Entrepreneurship/Freelancing & Remote Work
Career pathway
- Administrative & Executive Support
- Excel & Data
- AI & Productivity
- Content & AI Design
Course modules
1 Introduction to Digital Productivity & Microsoft Office Fundamentals
Introduction to Workplace Productivity Tools
• Understanding modern digital workplace tools
• Overview of Microsoft Office / Microsoft 365 ecosystem
• Word, Excel, PowerPoint use cases
• Introduction to cloud productivity:
o OneDrive
o Microsoft 365
o File sharing and collaboration
• Keyboard shortcuts and productivity tips
Microsoft Word Fundamentals
• Word interface and navigation
• Creating and saving documents
• Text formatting
• Fonts, styles, themes
• Paragraph formatting
• Page setup:
o Margins
o Orientation
o Page breaks
• Headers and footers
• Document printing and export
• Understanding modern digital workplace tools
• Overview of Microsoft Office / Microsoft 365 ecosystem
• Word, Excel, PowerPoint use cases
• Introduction to cloud productivity:
o OneDrive
o Microsoft 365
o File sharing and collaboration
• Keyboard shortcuts and productivity tips
Microsoft Word Fundamentals
• Word interface and navigation
• Creating and saving documents
• Text formatting
• Fonts, styles, themes
• Paragraph formatting
• Page setup:
o Margins
o Orientation
o Page breaks
• Headers and footers
• Document printing and export
2 Microsoft Word Professional Document Creation
Advanced Microsoft Word
• Professional document structures
• Tables and formatting
• Images and graphics
• SmartArt diagrams
• Shapes and icons
• Hyperlinks
• Document templates
Workplace Applications:
• Reports
• Proposals
• CVs/Resumes
• Business documents
Word Advanced Features & Collaboration
• Table of contents
• References and citations
• Track Changes
• Comments and collaboration
• Mail Merge:
o Letters
o Certificates
o Labels
• Document protection
• Professional document structures
• Tables and formatting
• Images and graphics
• SmartArt diagrams
• Shapes and icons
• Hyperlinks
• Document templates
Workplace Applications:
• Reports
• Proposals
• CVs/Resumes
• Business documents
Word Advanced Features & Collaboration
• Table of contents
• References and citations
• Track Changes
• Comments and collaboration
• Mail Merge:
o Letters
o Certificates
o Labels
• Document protection
3 Microsoft Excel Fundamentals
Introduction to Excel
• Excel interface
• Worksheets and workbooks
• Data entry techniques
• Formatting cells
• Rows and columns management
• Data types
• Basic formulas:
Examples:
• SUM
• AVERAGE
• COUNT
• MIN/MAX
Excel Functions & Data Management
Advanced formulas:
• IF statements
• Nested IF
• COUNTIF
• SUMIF
• VLOOKUP/XLOOKUP
• INDEX & MATCH
Data management:
• Sorting
• Filtering
• Data validation
• Conditional formatting
• Excel interface
• Worksheets and workbooks
• Data entry techniques
• Formatting cells
• Rows and columns management
• Data types
• Basic formulas:
Examples:
• SUM
• AVERAGE
• COUNT
• MIN/MAX
Excel Functions & Data Management
Advanced formulas:
• IF statements
• Nested IF
• COUNTIF
• SUMIF
• VLOOKUP/XLOOKUP
• INDEX & MATCH
Data management:
• Sorting
• Filtering
• Data validation
• Conditional formatting
4 Excel Advanced Data Analysis
Data Visualization & Reporting
• Creating charts:
o Bar charts
o Line charts
o Pie charts
o Area charts
• Dashboard design principles
• Pivot Tables
• Pivot Charts
• Data summaries
Excel Automation & AI-Assisted Analysis
• Excel productivity shortcuts
• Introduction to Power Query
• Cleaning datasets
• Importing external data
• Spreadsheet best practices
AI Integration:
• Using AI to generate formulas
• Explaining complex Excel functions
• Data analysis assistance using AI
Microsoft's current productivity training increasingly emphasizes AI-assisted Excel analysis and workflow improvement.
• Creating charts:
o Bar charts
o Line charts
o Pie charts
o Area charts
• Dashboard design principles
• Pivot Tables
• Pivot Charts
• Data summaries
Excel Automation & AI-Assisted Analysis
• Excel productivity shortcuts
• Introduction to Power Query
• Cleaning datasets
• Importing external data
• Spreadsheet best practices
AI Integration:
• Using AI to generate formulas
• Explaining complex Excel functions
• Data analysis assistance using AI
Microsoft's current productivity training increasingly emphasizes AI-assisted Excel analysis and workflow improvement.
5 Microsoft PowerPoint Professional Presentation Design
PowerPoint Fundamentals
• Presentation principles
• Creating slides
• Themes and layouts
• Text formatting
• Images and icons
• Slide transitions
• Animations
Advanced PowerPoint Design
• Professional presentation structure
• Storytelling techniques
• Visual hierarchy
• Infographics
• Charts and graphs
• Speaker notes
• Presentation delivery skills
• Presentation principles
• Creating slides
• Themes and layouts
• Text formatting
• Images and icons
• Slide transitions
• Animations
Advanced PowerPoint Design
• Professional presentation structure
• Storytelling techniques
• Visual hierarchy
• Infographics
• Charts and graphs
• Speaker notes
• Presentation delivery skills
6 Introduction to Artificial Intelligence & Generative AI Tools
Understanding Artificial Intelligence
• What is Artificial Intelligence?
• Machine Learning vs Generative AI
• AI applications in business
• AI ethics and responsible use
• AI limitations and fact-checking
Introduction to:
• ChatGPT
• Claude
• Google Gemini
• Microsoft Copilot
Prompt Engineering Fundamentals
• Understanding AI prompts
• Prompt structure:
Role + Task + Context + Format + Constraints
Examples:
• Business writing prompts
• Research prompts
• Marketing prompts
• Data analysis prompts
• What is Artificial Intelligence?
• Machine Learning vs Generative AI
• AI applications in business
• AI ethics and responsible use
• AI limitations and fact-checking
Introduction to:
• ChatGPT
• Claude
• Google Gemini
• Microsoft Copilot
Prompt Engineering Fundamentals
• Understanding AI prompts
• Prompt structure:
Role + Task + Context + Format + Constraints
Examples:
• Business writing prompts
• Research prompts
• Marketing prompts
• Data analysis prompts
7 AI Productivity Applications
ChatGPT, Claude & Gemini for Work
Using AI for:
• Writing professional documents
• Email drafting
• Research assistance
• Summarization
• Brainstorming
• Business planning
• Learning assistance
• Content creation
AI with Microsoft Office
AI-assisted productivity:
• AI in Word:
o Drafting documents
o Summarizing content
o Editing documents
• AI in Excel:
o Formula assistance
o Data analysis
o Insights generation
• AI in PowerPoint:
o Presentation creation
o Slide improvement
Using AI for:
• Writing professional documents
• Email drafting
• Research assistance
• Summarization
• Brainstorming
• Business planning
• Learning assistance
• Content creation
AI with Microsoft Office
AI-assisted productivity:
• AI in Word:
o Drafting documents
o Summarizing content
o Editing documents
• AI in Excel:
o Formula assistance
o Data analysis
o Insights generation
• AI in PowerPoint:
o Presentation creation
o Slide improvement
8 AI Design, Midjourney & Final Project
AI Image Generation & Design
Introduction to AI Design Tools:
• Midjourney concepts
• AI image generation workflow
• Prompt writing for images
• Design styles:
o Corporate
o Realistic
o 3D
o Illustration
o Marketing graphics
Applications:
• Social media graphics
• Business flyers
• Website images
• Presentation visuals
• Branding materials
Final Capstone Project & Assessment.
Introduction to AI Design Tools:
• Midjourney concepts
• AI image generation workflow
• Prompt writing for images
• Design styles:
o Corporate
o Realistic
o 3D
o Illustration
o Marketing graphics
Applications:
• Social media graphics
• Business flyers
• Website images
• Presentation visuals
• Branding materials
Final Capstone Project & Assessment.
Salary trend
Entry level₦80k–₦200k/mo or more
Mid level₦200k–₦400k/mo or above
Senior level₦400k+/mo or above
Estimated Nigerian market ranges; varies by role, company, and experience.
Ready to start your Microsoft Office Productivity & AI Tools Mastery journey?
Seats for the next cohort are limited. Secure yours today or talk to an advisor first.
This cohort is full
Join the waitlist and we'll contact you first when a seat opens or the next cohort is scheduled.