DigiOffice Advanced

Develop stronger Excel lookups, reporting, Power Query and Google Sheets skills. Apply AI with evidence checks, build controlled automation and deliver a repeatable reporting project through expert videos and guided practice.

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