Office Automation & AI Productivity

What you will be able to do

• Build clean spreadsheets with lookups, logic and validation
• Produce pivot-table dashboards management can read at a glance
• Format long documents professionally with styles and references
• Design presentations that support rather than distract
• Use AI assistants safely to cut routine work

1. 01

   Microsoft Word

   • Styles, headings and long-document structure
   • Tables, references and table of contents
   • Mail merge and templates
   • Professional business correspondence
2. 02

   Excel Core

   • Cell references, named ranges and formatting
   • Essential formulas and logical functions
   • XLOOKUP, INDEX/MATCH and data validation
   • Sorting, filtering and conditional formatting
3. 03

   Excel Advanced

   • Pivot tables and pivot charts
   • Dashboards and slicers
   • Power Query basics for messy data
   • Common spreadsheet mistakes and how to audit
4. 04

   PowerPoint & Workspace

   • Slide masters, layouts and consistency
   • Charts that communicate honestly
   • Google Sheets/Docs collaboration workflow
   • Sharing, permissions and version control
5. 05

   AI Productivity

   • Drafting, summarising and formatting with AI
   • Formula generation and troubleshooting
   • What to never paste into an AI tool
   • Capstone: departmental reporting dashboard

Projects you will build

Every one of these goes into your portfolio with your name on it.

• Project 1

  Automated attendance and payroll sheet

• Project 2

  Sales dashboard with pivot tables and slicers

• Project 3

  Formatted 30-page company report

• Project 4

  Executive presentation deck

Where this leads

Typical roles and market rates for graduates of this track in Pakistan.

Ranges reflect market observations from our graduate tracking and hiring-partner network. They are indicative, not a guarantee.