Register your interest

MICROSOFT EXCEL FOR PUBLIC SECTOR DATA & FINANCIAL ANALYSIS

A Practical 3-Day Programme — Beginner to Advanced

Date, Time & Venue to be informed soon about the next session

Registering your interest costs you nothing and commits you to nothing — it simply let's us know you'd like to be part of this training. We'll follow up separately to confirm your enrolment, so feel free to register today with complete peace of mind. (We accept LPO). Seats are now full for 8-10 September 2026 session. Leave your interest below and we will contact you for the next session.

Microsoft Excel Training
3-Day Programme — Course Content

Day 1 — Foundations

  • Navigating Excel with confidence: interface, worksheets, and data entry

  • Formatting for clarity: number formats, styling, and clean layouts

  • Building reliable formulas with correct cell referencing

  • Sorting, filtering, and structuring data using Excel Tables

Day 2 — Intermediate Skills

  • Visualising data with column, line, and pie charts

  • Automating decisions with IF, AND, OR, and COUNTIF/SUMIF

  • Cross-referencing data using VLOOKUP, INDEX/MATCH, and XLOOKUP

  • Applying conditional formatting and data validation to reduce errors

Day 3 — Advanced Tools & Reporting

  • Data tables and data validation

  • What-if/Goal Seek/ Scenarios

  • Summarising large datasets with PivotTables and PivotCharts

  • Building a print-ready, one-page management dashboard

Our next training sessions are coming soon to a location near you. Stay tuned for dates, venues, and
PACS

© 2026 Pacific Assurance & Consultancy Services. All rights reserved.

Let's transform your financial vision into results.

Contact

Email

info@pacs-pacific.com

Location

Port Vila, Vanuatu

Phone

+678 593 6610