MICROSOFT EXCEL – INTERMEDIATE, DATA ANALYSIS & DASHBOARD

Day one – Intermediate Excel course

Students will be able to apply basic-intermediate features of Microsoft Excel to improve their work quality and productivity.

With this 1-day hands-on Microsoft Excel Training under the guidance of an experienced trainer, students can pick-up more easily than going for trial-and-error basis all by themselves in a time consuming manner. By completing this intermediate level of Microsoft Excel course, students will also be able to proceed to the 2nd day of the course i.e. Excel Dashboards

Day Two – Dashboard Storytelling with KPI for Corporate Data

The student will learn hands on with an example database , on how to create a dynamic & interactive Dashboard in their own presentation style.

Click HERE to Download Brochure and Registration Form

Training Dates :
6th – 7th January 2025 (Dorsett Grand Subang, SUBANG JAYA, Selangor, Malaysia)

Requirements

Participants should have a copy of Excel 2016 onwards already installed in their laptops & be familiar with working with files: opening, closing and saving files.To ensure success, each student is expected to have a general knowledge of Microsoft Windows and Microsoft Office concepts & Basic Excel.

LEARNING OUTCOME :

By the end of this training, the participants should be able to

  1. Customise and Enhance Workbooks in the Excel Environment
  2. Use common Functions and Formulas
  3. Work with Pivot Tables
  4. Present Data Using Charts
  5. Apply Conditional Formatting
  6. Create Dashboards

WHO SHOULD ATTEND

  • User of Excel, who would like to improve their application of Excel, and how to analyze data, prepare powerful presentations, monitor KPI.
  • Managers and Executives who have subordinates using Excel
  • Employees who wish to improve Efficiency

METHODOLODY

This “MICROSOFT EXCEL – INTERMEDIATE, DATA ANALYSIS & DASHBOARD” workshop’s methodology is a combination of expert input, examples & hands-on practical exercises.

COURSE CONTENT

DAY 1

MODULE 1: CREATING & CUSTOMISING WORKBOOKS , FORMATTING DATA

  • Create & customizing an excel workbook
  • Linking Tabs
  • Formatting data & Tables;
  • Conditional Formatting
  • Managing Rules
  • Formulas
  • Converting text to numbers
  • Templates & practical uses and etc

MODULE 2: ANALYSING DATA IN THE TABLE

  • Filtering data, Custom Auto filter
  • Sorting data
  • Logical functions IF, AND , OR
  • Sumif, Countif, Nested ifs, Average A,
  • Grouping, subtotals
  • Sparklines
  • Pivot Tables
  • Vlookup, Hlookup
  • Range Names

MODULE 3: OTHER FEATURES OF EXCEL

  • Printing & Formatting
  • Header & Footers
  • Grouping Tabs
  • Hyperlinks in the workbooks & outlook email
  • Save an Excel workbook in earlier versions of Excel
  • Worksheet & workbook protection

DAY 2

MODULE 4: CREATING & MODIFYING CHARTS

  • Creating various charts
  • Formatting charts
  • Modifying charts & adding elements
  • Additional Data series
  • Changing Chart types
  • Using Quick Analysis Tools

MODULE 5 : PREPARATION OF WORKBOOK FOR DASHBOARD

  • Pivot table
  • Charts

MODULE 6: CREATING THE DASHBOARD

  • Linking dashboard information to workings
  • Presenting Data using Dashboard

Q&A & Closure

END OF WORKSHOP

Download the programme outline in pdf from HERE

FACILITATOR

Ms. Sonia Ram CA(M), ACMA, CGMA, AAIA

PSMB Train-The-Trainer certificate no: TTT/20697

Click HERE to download Sonia Ram profile in PDF format

Sonia Ram is a Fellow Member (FCMA) of the Chartered Institute of Management Accountants – CIMA since 2004, and a member of Malaysian Institute of Accountants, MIA since 2005.

Sonia has had a long and distinguished career as a Management Accountant in a number of well- known Malaysian and International Companies.

She started her career in Finance as an auditor. Among her achievements are winning awards as a student , CIMA– 4th Place worldwide prize winner– Financial Reporting (IAS) Paper, & for AIA – Bronze Medal Winner – Statistics & Data Processing Paper.

From 1996-2002 she worked as a Lecturer in a Local College lecturing in Accounting, Statistics for Diploma & Undergraduate students of various disciplines.

Subsequently, from 2002 till 2019 – she has worked for various Electronics Manufacturing MNCs in Managerial positions handling a wide range of portfolios from Corporate Reporting , Costing, Budgeting & Forecasting , Performance improvement . She had also actively led her team into the new MRP migration & W-desk Setup for Sox Compliance in her company conducting in-house training for the same.

She has hands on experience on MS Office Suite & is a Certified MS office specialist for MS Excel 2016 & is always working to update herself with the latest requirements of the profession.

Sonia is an HRD Corp Certified Trainer having obtained this certification in June 2018.

Course Fees & Registration
FEE PAYABLE PER PARTICIPANT :

Normal Price                                          : RM2,288

Early Bird (15 days before event)       : RM2,089

Group Fee (>2 participants)                : RM1,888

Fee includes course materials, lunch, 2 tea breaks per day and Certificate of Attendance (upon completion of the training).

Download our Registration form Here and sent it to us by

Email : sales@wanfahprosper.com

WhatsApp : +60162634929

CANCELLATION / TRANSFER

Upon registering, participant(s) are considered successfully enrolled in the event.  Written cancellations / transfer notice (substitution or to later dates)  received :

  • More than ten (10) working days before the event, a refund (less administrative charge of 15%) will be made.
  • Ten (10) working days or less before the event, no refund will be made.
  • For no show on the day of the event, full payment is required. If you cannot attend the event, you can nominate a substitute at any time without payment of an administration fee.
  • A full (100%) refund may be granted if the course is cancelled by Wanfah Prosper PLT (WFP). WFP reserves the right to postpone or cancel the event and / or change facilitator at any time should circumstances beyond its control arises. WFP also reserve the right to make alternative arrangements without prior notice should it be necessary to do so.

Payment

Please make cheque payable / direct credit to :WANFAH PROSPER PLT

Accounts Number : 3812930508

Bank : Public IslamBank Berhad

DATA PROTECTION

Personal Data is gathered in accordance with the Personal Data Protection Act 2010 (Act 709)