Hidden Secrets of Data Analysis in Excel

Who Should Attend

Managers and Executives who have to manage, analyse and prepare reports using data downloaded from systems. They must have some basic to intermediate knowledge of Excel i.e. navigate around a worksheet, format cells, auto-filter, sorting, create a simple template and enter simple formulas (e.g. SUM) into the worksheet.

Learning Objectives

Upon completion of the course, participants will be able to:

  • Apply useful built-in functions in Excel to process data and enhance the usefulness of the data.
  • Apply the function learnt to consolidate records.
  • Acquire skills to analyse the records for operations and reporting purposes.
  • Employ new ways of tabulating and managing data

Course Outline

  • Manage The Use of Dates
    >>MONTH, YEAR, DAY, DATE, COUNTIF, SUBTOTAL, DATEDIF formula, Advanced Auto-Filter Function, Absolute and relative reference
  • Quick and Accurate Way to Select Records
    >>GOTO function
  • Building Complex formulas
  • Merging 2 worksheets into One
    >>VLOOKUP formula
  • Unleashing The Power of Formulas
    >>Power Query - The new way of working with data
  • Analyzing Business Data in Double Quick Time
    >>PIVOT TABLE function
  • Making Your Report Update Automatically
  • Consolidate Data From Multiple Workbooks
    >>Power Query - Append Function
  • Tapping the Power of Pivot Chart
  • ‚Äč

Program Dates

Face to Face Workshops

  • 18-19 Mar 21 (Thu and Fri) 
  • 10-11 May 21 ((Mon and Tue) 
  • 8 -9 Jul 21 (Thu and Fri)
  • 7-8 Oct 21 (Thu and Fri)

Online Workshops

  • 28-29 Jan 21 (Thu and Fri)
  • 25-26 Feb 21 (Thu and Fri)
  • 11-12 Mar 21 (Thu and Fri) 
  • 15-16 Apr 21 (Thu and Fri) 
  • 27-28 May 21 (Thu and Fri) 
  • 01-02 Jul 21 (Thu and Fri) 
  • 12-13 Aug 21 (Thu and Fri)
  • 23-24 Sep 21 (Thu and Fri)
  • 28-29 Oct 21 (Thu and Fri)
  • 11-12 Nov 21 (Tu and Fri)


2 days program (7 hours each day) -9am to 5pm


S$600 per pax