Basic Microsoft Excel WORKSHOP

INTRODUCTION

With the advancement of Information Technology, it is now a must for all who are working to know some basic computer knowledge.  Spreadsheets knowledge has become so important as it helps in increasing productivity.

There are a variety of spreadsheets available currently, with Microsoft’s Excel leading the market share. Based on Microsoft website report on the 20th May 1996, there is an average of more than five new users of Microsoft Excel per minute since the product’s introduction in September 1985.  If the rate is pro-rated to current time, the total number of Microsoft Excel will be more than 900 millions users.

A survey done by UpskillHub shows that someone who has taken the time to do an Excel Tutorial will generally be able to do things a lot faster than someone who has not.  Reports will be produced faster (it takes less than 1 minute to set up a PivotTable report which would take anything over 10 minutes to do with formulas), shortcuts will be used, and less time will be wasted trying to work things out for themselves.

 

Training Date :
Call our office at +60355231819 for assistant

 

 

PROGRAMME OBJECTIVE     

This course will enable participants to gain a good general understanding of the main features of Excel, giving them the ability to produce standard spreadsheets, creating simple formula, formatting and printing spreadsheets.

 

PRE-REQUISITES

Participants should be familiar with using computers and have used a mouse and keyboard. Participants should be comfortable in the Windows environment and be able to use Windows to manage information on their computer

To get the most out of this course, we recommend completion of one of the following courses, or equivalent knowledge from another source: Windows 2003 / Windows 7 / Windows 10

 

DELIVERY METHOD

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

 

COURSE OUTLINE

  1. Introduction to Excel 2016 Interface
    • Starting Excel
    • The Excel Interface
    • Changing Excel’s View
    • Working with Existing Workbook
  2. Working with Microsoft Excel 2016
    • Creating Workbooks
    • Saving Workbooks
    • Input Basic Data
    • Using Data Types
    • Cutting, Copying and Pasting Data
    • Editing Workbook’s Properties
  3. Using Basic Formulas
    • Building Basic Formulas
    • Using Cell References
    • Using Cell Ranges
  4. Formatting Cells and Ranges
    • Inserting and Deleting Cells
    • Manually Formatting Cell Contents
    • Using Format Painter
    • Paste Special Options
    • Formatting Cells with Styles
  5. Formatting Worksheets
    • Working with Rows and Columns
    • Using Themes
    • Modifying Worksheet’s Appearance
    • Inserting Headers and Footers
  6. Adding Pictures and Shapes to a Worksheet
    • Inserting Pictures
    • Adding Shapes and WordArt
    • Deleting, Copying and Moving Graphics
    • Formatting Graphics
    • Using SmartArt Graphics
  7. Creating Charts
    • Building Charts
    • Formatting a Chart
    • Modifying a Chart
  8. Printing Worksheets
    • Preparing a Document for Printing
    • Print Formats

 

FACILITATOR

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

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

 

 

 

 

 

 

Sonia Ram is an Associate  Member (ACMA) 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 prizewinner– 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 today – 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  & leading her team  into the  new MRP migration. Recently she had single-handedly completed the W-desk Setup for Sox Compliance in her company.

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.

She  is also an HRDF Certified Trainer  having obtained the certification in June 2018.