On course for success

Technical

Advanced MS Excel

Programme Overview

This course introduces Microsoft Excel users to the advanced features of the software application, in addition to the usual features such as creating and editing charts; modifying chart options; working with multiple worksheets and workbooks, and use financial and logical functions.

Participants will earn how to sort and manage data in lists; filter and query data; lookup and database functions, and PivotTables. In-class exercises will involve the use of data tables and scenarios to make projections about data and use Goal Seek and Solver to analyze data. Participants will also learn how to audit worksheets, protect worksheets and workbooks, create and use macros, and import and export information and documents.

Programme Outline

  • Introduction to Power Query;
  • Data Tools;
  • Data Analysis with Pivot Tables;
  • Logical Functions;
  • Text functions;
  • Formula Auditing;
  • Nested Functions;
  • Conditional Formatting;
  • Goal Seek & Scenarios;
  • Forecast Sheet;

Who Should Attend

Anyone whose chosen field of work requires the involvement of extensive and detailed use of the more complex MS Excel skills and functions.

Your Investment

Stakeholder*: BND $ 490.00
Non-Stakeholder: BND $ 590.00

* Stakeholders are participants from MOFE, AMBD and all domestic banks in Brunei Darussalam.

Download Brochure here

▲ Top