DigiOffice Pro

Build complete workplace confidence: digital foundations, Excel, Word, PowerPoint, Outlook, collaboration, advanced reporting, Power Query, automation and responsible AI in one practical programme.

Digital Foundations

  • Computers, devices and operating systems
  • Files, folders and naming
  • Keyboard shortcuts and navigation
  • Install, update and remove applications safely
  • Digital security and phishing
  • Cloud storage and permissions
  • Google Drive, OneDrive and Dropbox: sync, sharing and recovery

Cyber Hygiene & Privacy

  • Passwords, multifactor authentication and recovery
  • Phishing, social media privacy and reporting cybercrime

Excel Essentials

  • Spreadsheet fundamentals
  • Data entry and formatting
  • References and core formulas
  • Sorting filtering and tables
  • Charts and print-ready worksheets
  • SUM, AVERAGE, COUNT, COUNTA, MIN and MAX
  • IF, AND, OR and handling formula errors
  • Conditional formatting and data validation
  • Text cleanup, dates, percentages and rounding

Professional Excel Reporting

  • Clean source data
  • VLOOKUP: exact matches and missing values
  • HLOOKUP: horizontal tables and lookup direction
  • XLOOKUP and lookup concepts
  • PivotTables and slicers
  • Communicating KPIs

Microsoft Word

  • Styles and document structure
  • Page layout tables and images
  • Professional reports and resumes
  • Track Changes and mail merge
  • Word review, page layout, images and accessible PDF export

PowerPoint

  • Presentation structure and visual hierarchy
  • Layouts typography and alignment
  • Charts and visual storytelling
  • Presenter view and delivery
  • Canva presentations and responsible visual design

Outlook & Professional Email

  • Professional email and etiquette
  • Inbox organisation and rules
  • Calendar meetings and tasks
  • Attachments cloud links and phishing

Cloud Collaboration

  • OneDrive sharing and version history
  • Co-authoring and permission checks
  • Teams meetings chat and channels

Google Workspace

  • Google Docs: letters, reports and collaborative review
  • Google Sheets: budgets, charts and shared data
  • Gmail: professional messages, labels and search
  • Google Calendar, Meet and Zoom: effective meetings

Task & Project Management

  • Trello boards, cards and practical task planning
  • Notion pages, task databases and meeting notes

Digital Finance & Government Services

  • UPI, wallets and net banking: transaction safety
  • Payment receipts, expense records and reconciliation
  • DigiLocker and UMANG: using official digital services

Career & Freelancing Readiness

  • Resumes and cover letters with Word or Canva
  • LinkedIn, Naukri, Indeed and Internshala: a focused job search
  • Fiverr and Upwork: scoping a first freelance project
  • Workplace communication, interviews and a portfolio walkthrough

Practical Generative AI

  • Prompt structure and iteration
  • Emails summaries and presentation outlines
  • Excel formula explanations
  • Verification privacy and responsible use
  • Microsoft Copilot: prompts, access and practical limits
  • Gemini and Google Workspace: choosing the right AI workspace

The Office Workflow

  • Organise and analyse a business dataset
  • Create a report and presentation
  • Communicate and share the result

Data Quality

  • Good data versus bad data
  • Tabular structure and raw data preservation
  • Duplicates types blanks and validation

Advanced Excel Functions

  • XLOOKUP INDEX and MATCH
  • SUMIFS COUNTIFS and business logic
  • Dynamic arrays FILTER SORT UNIQUE
  • LET and formula auditing
  • INDEX and MATCH: left lookups and two-way lookup tables
  • Approximate lookups, duplicate keys and IFNA controls
  • SUMIFS, COUNTIFS and AVERAGEIFS with dates and criteria

Advanced Reporting

  • Advanced PivotTables and grouping
  • Slicers timelines and KPI dashboards
  • Business data storytelling
  • PivotTable calculations, percentages and date grouping

Power Query

  • Get Data and query editor
  • Types trim clean and errors
  • Append merge and folder imports
  • Pivot unpivot and conditional columns
  • Repeatable refresh workflows
  • Power Query merges, join types and unmatched records
  • Power Query conditional columns, types and error handling

Advanced Data Cleaning

  • Diagnose and standardise dirty data
  • Reconcile and validate results
  • Document assumptions and quality checks

Advanced Google Sheets

  • Google Sheets QUERY: filter, group and aggregate
  • IMPORTRANGE, shared-sheet permissions and dependable handovers

Advanced PowerPoint

  • Slide Master and reusable visual systems
  • Executive presentations
  • Simplifying complex insights

Advanced Word

  • Templates styles and long documents
  • References and tables of contents
  • Advanced mail merge and collaboration

Advanced Outlook

  • Rules categories and delegation
  • Calendar and task workflows
  • Meeting and communication systems
  • Outlook task delegation and accountable follow-up

Advanced AI

  • Multi-step prompting and structured outputs
  • Safe analysis and formula reasoning
  • Meeting actions and executive summaries
  • Verification and AI governance
  • AI-assisted Excel analysis with independent control totals
  • Copilot in Excel: formulas, insights and review
  • Claude prompting: examples, constraints and structured outputs
  • AI in Word and PowerPoint: from source notes to a checked deliverable
  • Source-grounded AI research with NotebookLM and citation checks
  • Copilot work planning, document comparison and meeting preparation

Automation Mindset

  • Identify and standardise repetitive work
  • Power Query refresh and Microsoft automation
  • Human review and safe automation
  • Power Automate: triggers, approvals and failure handling
  • Office Scripts and safe Excel automation

Advanced Capstone

  • Build a repeatable monthly reporting pipeline
  • Present insights and document controls