hidden secrets of data analysis in excel course

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
    »MID, SEARCH
  • Merging 2 Lists into One
    »VLOOKUP formula, SUBTOTAL, REPLACE ALL function
  • Unleashing The Power of Formulas
    »SUMIF Formula, TEXT TO COLUMN Function
  • Analyzing Business Data in Double Quick Time
    »PIVOT TABLE function
  • Making Your Report Update Automatically
    »MS Query Function
  • Consolidate Data From Multiple Workbooks
    »MS Query Function
  • Tapping the Power of Pivot Chart
  • Recording Macros to Speed Up Repetitive Tasks
Dates:
Excel 2007/2010/2013
12 & 13 Jan 2017Confirmed
23 & 24 Mar 2017Confirmed
04 & 05 May 2017Confirmed
06 & 07 Jul 2017Confirmed
24 & 25 Aug 2017Confirmed
12 & 13 Oct 2017Confirmed

Time: 9am - 5pm
Duration: 14 Hours (2 days)

Venue: International Plaza
10 Anson Road #26-02A

Course Fees: S$600 per pax

Price and Duration

S$600 per pax for this 2 days course.

Our Trainers

EverydayExcel' trainers are all experts in spreadsheets and databases. They are specially hand-picked by the Chief Trainer, Jason Khoo, based on their experiences in training and the business knowledge they possess. Jason has worked in local listed companies and foreign MNCs managing the companies' budgeting process and developed business models for forecasting. He was also a financial counsel for a Fortune 500 company's business unit which generated a total revenue of more than S$100 million per annum.

EverydayExcel has helped many companies save thousands of dollars by providing simple and yet powerful business solutions through the use of Microsoft® Excel. Examples of such solutions include budget planning and forecasting, customer segmentation program, personalized email broadcast to targeted customers, and sales lead generation program (mini CRM), etc.

Download Excel course Registration Form

« Back to Excel courses