Working with External Data Master Class

A master class from the Financial Analysis VBA Certificate Master Class series

An Extension of Australia’s premier Excel VBA course for finance professionals

This two-day master class focuses on issues around working with external data sources in Excel-based VBA applications. It covers report updating processes, linking to external data sources, working with stored queries and generating inline SQL queries.

Course Content

Downloadable master class brochure with detailed course outline in PDF format (97kb).

Modes of Study

  • In class mode: 16 hours over two days.
  • Public offerings starting in Sydney in 2016.
  • Private offerings also available.

Key Outcomes

  • Gain advanced skills in key subject areas, such as working with other external data;
  • Efficiently working with external Excel data, database and web sources;
  • Utilising built-in data management tools, such as Pivot Tables, Tables, linked Tables;
  • Automating PivotTable construction and refresh;
  • Working with building and amending slicers and timelines in code;
  • Working with embedded controls and events to simplify user interaction;
  • Up to 16 hours of continuing professional education.

Each Master Class Delivers

  • Core knowledge for the specialised subject area;
  • Re-usable examples demonstrating proven methodologies;
  • Guidance on how to avoid real-world issues and problems; and
  • Advanced techniques to build powerful and robust solutions without needless complexity.

Who Benefits

Those who have previously completed the Financial Analysis VBA Certificate or Financial Analysis Systems Certificate looking for support & guidance to extend their knowledge in building robust reports that will significantly reduce effort at key points in the reporting cycle.

Benefits for the Employer

  • A reduction in the effort required by staff to expand into key advanced topics;
  • Access to proven and effective strategies for advanced application and code building; and
  • A development path for key staff involved in creation of regularly generated performance and analytical reports.

Detailed Course Outline & Other Information

Downloadable master class brochure with detailed course outline in PDF format (97kb).

Downloadable course brochure with detailed course outline in PDF format (93kb).

Find a suitable course by reviewing the article Which Course Would Best Suit me?

Find an offering in the Course Calendar.