On course for success

Intermediate MS Excel

Programme Overview

In the Intermediate Microsoft Excel programme, participants will build upon their understanding of Microsoft Excel 2016. They will learn how to adjust the way cells are
displayed in Excel for maximum efficiency and sort & filter lists of data based on desired criteria.

During the programme, participants will also learn important Excel functions which allows a higher-level view such as – goal seeking from an existing dataset and the use of Charts and Pivot Tables to display and extract further information. Participants will also have the opportunity to learn and polish new skills in Lookup, Logical, Financial and Database functions.

Programme Objectives

By the end of the Intermediate Microsoft Excel training course, participants will be able to use Microsoft Excel’s in-built features for more efficient data collection, better data management and basic data analysis.

Programme Outline

  • Freezing Panes and View Options – learn how to use Excel’s in-built functions to manage spreadsheets with many rows and/or columns
  • Filtering Data – find data that match the criteria you set to reveal patterns in your data.
  • Subtotals – a quick way to summarize your data using a subset of Excel functions.
  • Relative and Absolute Cell References – mastering relative and absolute cell references are the basis for creating powerful Excel formulas in your spreadsheet.
  • Subtotals – a quick way to summarize your data using a subset of Excel functions.
  • Filtering Data – find data that match the criteria you set to reveal patterns in your data.
  • Relative and Absolute Cell References – mastering relative and absolute cell references are the basis for creating powerful Excel formulas in your spreadsheet.
  • Lookup functions – learn to use VLOOKUP() and HLOOKUP() to locate data from a cell range.
  • Logical Functions – learn to use IF(), OR() and AND() to create functions that return different results depending on the conditions of your data.
  • Tables – learn how using Tables gives you more control over the data you collect in Excel including using Calculated Columns, Slicers and Dynamic Data Validation.
  • Charts – visualize your data using Excel’s powerful charting functions.
  • Introduction to Pivot Tables – learn to use one of Excel’s most famous and powerful tools to view your data across different dimensions and extract hidden information
  • Macros – save time by learning how to automate common routine tasks.
  • Protecting Data – learn the different ways Excel can protect the data in your spreadsheet including allowing only certain members to edit specific parts of your spreadsheet.
  • Copying Excel data to Microsoft Word – learn the different ways you can copy data to Microsoft Word and the benefits/drawbacks with each. The principles apply to other Microsoft Office applications.

Who should attend

  • Progressively trying to improve their MS Excel skills set;
  • Learning new functions;
  • Exploring features that are available in MS Excel that can help in their daily work tasks;
  • Enhancing their portfolio to include an intermediate level proficiency of Excel skills

Pre – requisite

  • Understand the concept of spreadsheets and what they are used for.
  • Familiar with the Microsoft Excel default interface including the Ribbon, Tabs, Groups,
  • Commands ad Quick Access Toolbar.
  • Understand the concept of Excel Workbooks and Worksheets.
  • Managing Workbooks: creating, opening, saving, closing.
  • Managing Worksheets: adding, deleting, renaming, copying, moving, grouping, ungrouping, colouring tabs
  • Understand the concept of Cells and Cell References
  • Managing Cells: adding (single, rows, columns), deleting (single, rows, columns), merging, selecting rows & columns (both adjacent and non-adjacent), setting row height & column width, hiding/unhiding rows and columns.
  • The Name Box: identifying the currently active cell, jumping directly to a cell
  • Entering data into cells
  • Managing Data: Find & Replace, Copy, Cut, Move
  • Good practices when entering data

Your Investment

Stakeholder *

  • Normal Price: BND 390 (SBS: 10%)

Non-Stakeholder

  • Normal Price: BND 490

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

Download Brochure here
▲ Top